Search Engine: Elastic

Article ID: 133963, created on Apr 25, 2019, last review on Apr 25, 2019

  • Applies to:
  • Business Automation 8.0

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.

198398b282069eaf2d94a6af87dcb3ff 8fc71f07abe5b233fea1ae0377cd5e3d 7a5878a42567edb0161242dfb779bb04 32fa47ebf508ad023157e68950b7e180

Email subscription for changes to this article
Save as PDF