Hello,
We are integrating Oracle EPM as Target System. Last month, we encountered an issue with OracleEPM reconciliation (in version 24.1). The recon job was erroring, and we got confirmation this was a known issue that will be fixed in 24.3 version.
We upgraded our DEV environment to 24.3, recreated the connection, security system and endpoint, and the recon job, and ran the import.
However, the job fails with the below error:
Logs:
2024-03-21T11:50:57+02:00-connectorms--null-9xn4w--2024-03-21T09:50:57.643904623Z stdout F 2024-03-21 09:50:57.643 ERROR [TENANT_ID=DEFAULT] 7 --- [org.springframework.amqp.rabbit.RabbitListenerEndpointContainer#1-1] com.saviynt.ssm.UserSpecification : Exception occured while calling the notify() method|com.saviynt.ssm.abstractConnector.exceptions.ConnectorException: java.lang.NullPointerException| at com.saviynt.ssm.UserSpecification.runReconcile(UserSpecification.java:761) ~[na:na]| at com.saviynt.ssm.UserSpecification.reconcile(UserSpecification.java:88) ~[na:na]| at com.saviynt.ssm.connectorms.service.MessageReadService.readData(MessageReadService.java:612) ~[classes!/:2021.1.0.0-SNAPSHOT]| at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]| at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]| at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]|Caused by: java.lang.NullPointerException: null| at com.saviynt.ssm.util.CSSRESTHelper.decrementCountofRetry(CSSRESTHelper.java:268) ~[na:na]| at com.saviynt.ssm.util.CSSRESTHelper.callRestApi(CSSRESTHelper.java:121) ~[na:na]| at com.saviynt.ssm.operations.ReportDownloadOperations.generateUserGroupReport(ReportDownloadOperations.java:53) ~[na:na]| at com.saviynt.ssm.service.UserService.downlodUserGroupReport(UserService.java:260) ~[na:na]| at com.saviynt.ssm.UserSpecification.downlodUserGroupReport(UserSpecification.java:730) ~[na:na]| at com.saviynt.ssm.UserSpecification.runReconcile(UserSpecification.java:759) ~[na:na]|
2024-03-21T11:50:57+02:00-connectorms--null-9xn4w--2024-03-21T09:50:57.644879123Z stdout F 2024-03-21 09:50:57.644 ERROR [TENANT_ID=DEFAULT] 7 --- [org.springframework.amqp.rabbit.RabbitListenerEndpointContainer#1-1] c.s.s.c.service.MessageReadService : java.lang.NullPointerException|com.saviynt.ssm.abstractConnector.exceptions.ConnectorException: java.lang.NullPointerException| at com.saviynt.ssm.UserSpecification.reconcile(UserSpecification.java:95) ~[na:na]| at com.saviynt.ssm.connectorms.service.MessageReadService.readData(MessageReadService.java:612) ~[classes!/:2021.1.0.0-SNAPSHOT]| at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:na]| at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:na]| at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:na]| at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[na:na]|
2024-03-21T11:50:57+02:00-connectorms--null-9xn4w--2024-03-21T09:50:57.751260957Z stdout F 2024-03-21 09:50:57.751 DEBUG [TENANT_ID=DEFAULT] 7 --- [org.springframework.amqp.rabbit.RabbitListenerEndpointContainer#1-1] c.s.s.c.s.RepositoryReconServiceImpl : jobSummaryXML :: <filename> Connector MS Job<jobid>238192</jobid><Error-in-readMessage-reconcile>java.lang.NullPointerException</Error-in-readMessage-reconcile><updateDate>1711014655162</updateDate><noOfBatch>0</noOfBatch><id>e323f602-b219-4a8a-9e6d-d25a50514918</id><jobDone>false</jobDone><createDate>1711014655162</createDate></filename>
Nothing changed on Oracle EPM side connection details, what could be causing this error?
Thank you for your support,
Mihaela
