I have completed the steps for 5G Guilin as listed in
https://www.aarnanetworks.com/post/step-by-step-5g-network-slicing-using-onap 
<https://www.aarnanetworks.com/post/step-by-step-5g-network-slicing-using-onap>

Create 5G Create Communication Service Fails in UUI.
Logs are attached.

Any suggestions?




-- 




This message and any attachments are
intended only for the use of the 
addressee and may contain information that is
privileged and confidential. 
If you are not an intended recipient, you are
hereby notified that any 
dissemination of this communication is strictly
prohibited. If you have 
received this communication in error, please do not
read, copy or forward 
this message. Please notify the sender immediately by
return email and 
delete the message and any attachments from your system.



-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#23385): https://lists.onap.org/g/onap-discuss/message/23385
Mute This Topic: https://lists.onap.org/mt/84096447/21656
Group Owner: [email protected]
Unsubscribe: https://lists.onap.org/g/onap-discuss/unsub 
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-


  Position: 189
2021-07-09 17:12:50.121 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.129  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.129 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.130 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.138  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.139 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.139 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.145  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.145 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.145 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.153  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.153 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.153 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.161  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.161 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.161 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.171  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.171 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.171 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.179  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.180 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.180 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.188  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.188 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.189 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.196  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.196 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.196 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.205  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.206 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.206 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.214  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.214 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.214 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.257  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.257 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.257 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.266  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.266 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.266 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
Hibernate: select count(*) as col_0_0_ from alarms_commoneventheader 
alarmshead0_ where 1=1 and alarmshead0_.source_name=? and alarmshead0_.status=? 
and (case when alarmshead0_.start_epoch_microsec=0 then 
alarmshead0_.last_epoch_microsec else alarmshead0_.start_epoch_microsec end 
between ? and ?)
2021-07-09 17:12:50.275  WARN 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : SQL Error: 0, SQLState: 42883
2021-07-09 17:12:50.275 ERROR 77 --- [nio-8082-exec-6] 
o.h.engine.jdbc.spi.SqlExceptionHelper   : ERROR: operator does not exist: 
character varying = integer
  Hint: No operator matches the given name and argument type(s). You might need 
to add explicit type casts.
  Position: 189
2021-07-09 17:12:50.275 ERROR 77 --- [nio-8082-exec-6] 
o.o.u.s.s.i.AlarmsInformationServiceImpl : exception occurred while performing 
PerformanceInformationServiceImpl queryDateBetween. 
Details:org.hibernate.exception.SQLGrammarException: could not extract ResultSet
2021-07-09 17:12:53.365  INFO 77 --- [nio-8082-exec-8] 
.u.s.s.l.i.DefaultServiceInstanceService : Can not get service 
instances[code=404, message=Not Found]
2021-07-09 17:12:53.665  INFO 77 --- [nio-8082-exec-4] 
.u.s.s.l.i.DefaultServiceInstanceService : Can not get service 
instances[code=404, message=Not Found]
2021-07-09 17:12:56.769 ERROR 77 --- [nio-8082-exec-3] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : querySlicingOrderList: Can not get 
listOrders[code={}, message={}]
2021-07-09 17:12:56.770 ERROR 77 --- [nio-8082-exec-3] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : addProgressToOrder: 
responseOrderList.getSlicing_order_list() is null or 
responseOrderList.getSlicing_order_list() size is 0.
2021-07-09 17:12:56.770  INFO 77 --- [nio-8082-exec-3] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : "5G slicing order query failed!
2021-07-09 17:12:56.770  INFO 77 --- [nio-8082-exec-3] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : querySlicingOrderList: 5G slicing 
order query has been finished.
2021-07-09 17:13:23.843  INFO 77 --- [io-8082-exec-10] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : serviceInvariantUuid is 
87f73e63-fbff-4300-bce4-b4c510a9d192, serviceUuid is 
9a4f3dea-dafa-44fb-97fb-aecb099a3ff2.
2021-07-09 17:13:28.909 ERROR 77 --- [io-8082-exec-10] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : createSlicingService: Can not 
submitOrders [code={}, message={}]
2021-07-09 17:13:28.909  INFO 77 --- [io-8082-exec-10] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : 5G slicing order created failed.
2021-07-09 17:13:28.909  INFO 77 --- [io-8082-exec-10] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : createSlicingService: 5G slicing 
order creation has been finished.
2021-07-09 17:13:29.367 ERROR 77 --- [nio-8082-exec-7] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : querySlicingOrderList: Can not get 
listOrders[code={}, message={}]
2021-07-09 17:13:29.367 ERROR 77 --- [nio-8082-exec-7] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : addProgressToOrder: 
responseOrderList.getSlicing_order_list() is null or 
responseOrderList.getSlicing_order_list() size is 0.
2021-07-09 17:13:29.368  INFO 77 --- [nio-8082-exec-7] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : "5G slicing order query failed!
2021-07-09 17:13:29.368  INFO 77 --- [nio-8082-exec-7] 
o.o.u.s.s.csmf.impl.SlicingServiceImpl   : querySlicingOrderList: 5G slicing 
order query has been finished.
Logs from Jul 9, 2021 to Jul 9, 2021 UTC

Reply via email to