Symptoms
Transfer rated data to BSS Rating for APS application instance #XX (Amazon Web Services) periodic task fails:
com.parallels.pa.service.aps.exception.APSInvocationException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
_____JobManager_____0
/var/log/pa/core.log on Management node contains the following exception:
Apr 23 03:41:46.289 : DBG [aps-service:28486 aps-service-task-78:903 pau]: c.p.p.s.c.e.EndpointExecutorBean End request: 'POST https://ratingenginepayg:8081/rest/charges-import-manager/dd8823d5-c951-49b3-a668-ab22b702f534/importSessions' '500 Internal Server Error'
Apr 23 03:41:46.289 : DBG [aps-service:28486 aps-service-task-78:903 pau]: c.p.p.tracer exit: com.parallels.pa.service.connectivity.ejb.EndpointExecutorBean.call returning [Connection=[keep-alive],Content-Length=[222],Content-Type=[application/json],Date=[Tue, 23 Apr 2019 07:41:46 GMT],X-Correlation-ID=[aps-service:28486]] correlationId aps-service:28486
...
Apr 23 03:41:46.294 : DBG [task:56930 EJB-default---8:454 pau]: c.p.p.tracer exit by exception: com.parallels.pa.service.usage.ejb.RatedDataExporterBean.exportRatedData correlationId task:56930 javax.ejb.EJBException: Cannot open Import Session
at com.parallels.pa.service.usage.ejb.RatedDataExporterBean.exportRatedData(RatedDataExporterBean.java:85)
at sun.reflect.GeneratedMethodAccessor1006.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
...
Caused by: com.parallels.pa.service.aps.exception.APSInvocationException: com.parallels.pa.service.aps.exception.APSInvocationException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
at com.parallels.pa.service.aps.APSClient.callOperationBare(APSClient.java:495)
at com.parallels.pa.service.aps.APSClient.callOperationBareByAlias(APSClient.java:480)
at com.parallels.pa.service.aps.APSClient.callOperationByAlias(APSClient.java:159)
...
Apr 23 03:41:46.295 : DBG [task:56930 EJB-default---8:454 pau]: c.p.p.tracer exit by exception: com.parallels.pa.service.usage.ejb.job.ExportRatedDataProcessorBean.process correlationId task:56930 javax.ejb.EJBException: Cannot open Import Session
at com.parallels.pa.service.usage.ejb.RatedDataExporterBean.exportRatedData(RatedDataExporterBean.java:85)
at sun.reflect.GeneratedMethodAccessor1006.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)
At the same time on billing database host /var/lib/pgsql/9.6/data/pg_log contains the following events (It could be required to increase PostgreSQL loglevel):
[2019-04-23 15:23:05.707 EDT] p=19375:33@23/101830 c=pba@10.0.0.1/pba:ratingenginepayg LOG: execute S_3: BEGIN
[2019-04-23 15:23:05.707 EDT] p=19375:34@23/101830 c=pba@10.0.0.1/pba:ratingenginepayg LOG: execute S_8: insert into "ChargeBatch" ("DateArc", "ErrorDescription", "Status", "UserArc") values ($1, $2, $3, $4)
[2019-04-23 15:23:05.708 EDT] p=19375:35@23/101830 c=pba@10.0.0.11/pba:ratingenginepayg ERROR: invalid name syntax at character 16
[2019-04-23 15:23:05.708 EDT] p=19375:36@23/101830 c=pba@10.0.0.1/pba:ratingenginepayg STATEMENT: select currval('"ChargeBatch"_"BatchID"_seq')
[2019-04-23 15:23:05.708 EDT] p=19375:37@23/0 c=pba@10.0.0.1/pba:ratingenginepayg LOG: execute S_4: ROLLBACK
Cause
Software-related issue OA-5215: Transfer rated data to BSS Rating fails with invalid name syntax on openSession()
Resolution
The issue will be fixed in future releases. Please contact your Technical Account Manager / pta team to track the status of the issue.