SAP RETAIL EXECUTION 3.0: NullPointerException Error in SCC

[Former Member]

Hi Everyone,

Here's what we've done so far:

1. Configured the security configuration profile

2. Deployed the REx MBO in SCC with the security configuration profile created

3. Configured the CRM_local connection profile to connect to CRM back-end with the necessary user authorization (CRM user already configured in the back-end)

4. Assigned a REx SUP user

We we're able to successfully set-up and register the SUP connection in the REx mobile app. But when we tried to connect to the CRM system we encountered the server log error below:

2013-10-07 16:29:03.495 WARN Other Thread-165 [SAPRetailEx.server.SAPRetailExDB]{"_op":"C","level":5,"code":500,"eisCode":"","message":"java.lang.NullPointerException:null","component":"SAPRetailExDB","entityKey":null,"operation":"synchronize","requestId":null,"timestamp":"2013-10-07 14:29:03.495","cvpOperationLobsLength":0,"messageId":0,"_rc":0} 

Kindly see details of "ValueOfTextViewer.log" below:

2013-10-07 15:59:00.624  Subsystem=Error  Application ID=retailex, Application Connection ID=5AA87A7BF5E64C0B95B2A623861B9922__retailex, User=<user>, Correlation ID=, Transaction ID=, Root Context ID=, Package=sapretailex:3.0, MBO=LogRecordImpl, Operation=create, Thread ID=231, Node ID=<Server Host>, Error=[-10158] In der Methode 'public java.lang.String com.sybase.djc.mobilink.EventHandler.beginDownloadConnection(java.sql.Timestamp,java.lang.String)' ist eine Ausnahmebedingung generiert worden. Fehlerbeschreibung: 'com.sybase.djc.SystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*'.

Stack Trace: 'com.sybase.djc.SystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

    at com.sybase.djc.mobilink.DownloadHandler.beginDownloadConnection(DownloadHandler.java:205)

    at com.sybase.djc.mobilink.DownloadHandler_DJC.access$001(DownloadHandler_DJC.java:4)

    at com.sybase.djc.mobilink.DownloadHandler_DJC$1.invoke(DownloadHandler_DJC.java:29)

    at com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:682)

    at com.sybase.djc.transaction.TransactionManager.invokeNotSupported(TransactionManager.java:644)

    at com.sybase.djc.mobilink.DownloadHandler_DJC.beginDownloadConnection(DownloadHandler_DJC.java:47)

    at com.sybase.djc.mobilink.EventHandler.beginDownloadConnection(EventHandler.java:749)

    at sun.reflect.GeneratedMethodAccessor544.invoke(Unknown Source)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:597)

    at ianywhere.ml.script.MethodInfo.invoke(MethodInfo.java:11385)

Caused by: com.sybase.djc.SystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

    at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:110)

    at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:127)

    at com.sybase.djc.mobilink.DownloadHandler.beginDownloadConnection(DownloadHandler.java:197)

    ... 10 more

Caused by: com.sybase.djc.transaction.TransactionRolledbackSystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:1023)

    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:759)

    at com.sybase.djc.transaction.TransactionManager.invokeRequired(TransactionManager.java:1090)

    at com.sybase.sup.server.mbs.SUPPackageUtil.invokeStatic(SUPPackageUtil.java:278)

    at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:102)

    ... 12 more

Caused by: com.sybase.djc.SystemException: java.lang.reflect.InvocationTargetException

    at com.sybase.sup.server.mbs.SUPPackageUtil$1.invoke(SUPPackageUtil.java:265)

    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:857)

    ... 16 more

Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException

    at com.sybase.vader.cache.CacheUtil.invokeWithDeadlockRetry(CacheUtil.java:618)

    at com.sybase.vader.cache.SimpleRefreshManager.invokeWithDeadlockRetry(SimpleRefreshManager.java:1319)

    at com.sybase.vader.cache.SimpleRefreshManager.refreshAsNeeded(SimpleRefreshManager.java:378)

    at com.sybase.vader.cache.SimpleRefreshManager.refreshAsNeeded(SimpleRefreshManager.java:1246)

    at com.sybase.vader.cache.CacheStatisticsRefreshManager.refreshAsNeeded(CacheStatisticsRefreshManager.java:204)

    at com.sybase.vader.cache.CompositeRefreshManager.refreshAsNeeded(CompositeRefreshManager.java:138)

    at com.sybase.vader.mms.DataServiceImpl.beforeDownload(DataServiceImpl.java:523)

    at SAPRetailEx.server.SAPRetailExDB.refreshCache(SAPRetailExDB.java:313)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:597)

    at com.sybase.sup.server.mbs.SUPPackageUtil$1.invoke(SUPPackageUtil.java:261)

    ... 17 more

Caused by: java.lang.reflect.InvocationTargetException

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

    at java.lang.reflect.Method.invoke(Method.java:597)

    at com.sybase.vader.cache.CacheUtil.invokeWithDeadlockRetry(CacheUtil.java:558)

    ... 29 more

Caused by: com.sybase.djc.transaction.TransactionRolledbackSystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:1023)

    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:759)

    at com.sybase.vader.djc.environment.MmsDjcTransactionManager.invokeRequiresNew(MmsDjcTransactionManager.java:31)

    at com.sybase.vader.cache.SimpleRefreshManager.internalRefreshAsNeeded(SimpleRefreshManager.java:495)

    ... 34 more

Caused by: java.lang.NullPointerException

    at com.sybase.vader.jca.sap3.connector.cci.SapFunctionModuleDynamicMetadataMappedRecord.getField(SapFunctionModuleDynamicMetadataMappedRecord.java:179)

    at com.sybase.vader.jca.sap3.connector.cci.SapJcoResultSet.getMetaData(SapJcoResultSet.java:474)

    at com.sybase.vader.core.record.MappingDelegatingResultSetRecord.<init>(MappingDelegatingResultSetRecord.java:104)

    at com.sybase.vader.service.interaction.ApplyInteractionMapOperation.execute(ApplyInteractionMapOperation.java:31)

    at com.sybase.vader.service.interaction.PipelineCompositeInteractionOperation.execute(PipelineCompositeInteractionOperation.java:55)

    at com.sybase.vader.service.interaction.BranchingInteractionOperation.getNextResult(BranchingInteractionOperation.java:108)

    at com.sybase.vader.core.vdb.interaction.InteractionQueryOperation.getNextResult(InteractionQueryOperation.java:78)

    at com.sybase.vader.cache.MultiMergeProcessor.internalAccumulateDeltas(MultiMergeProcessor.java:51)

    at com.sybase.vader.cache.MultiMergeProcessor.accumulateDeltas(MultiMergeProcessor.java:27)

    at com.sybase.vader.cache.SimpleRefreshManager.accumulateDeltas(SimpleRefreshManager.java:1118)

    at com.sybase.vader.cache.SimpleRefreshManager.refreshLoadGroup(SimpleRefreshManager.java:930)

    at com.sybase.vader.cache.SimpleRefreshManager.refreshLoadGroups(SimpleRefreshManager.java:898)

    at com.sybase.vader.cache.SimpleRefreshManager.access$600(SimpleRefreshManager.java:32)

    at com.sybase.vader.cache.SimpleRefreshManager$2.invoke(SimpleRefreshManager.java:454)

    at com.sybase.vader.djc.environment.MmsDjcTransactionManager.internalInvoke(MmsDjcTransactionManager.java:52)

    at com.sybase.vader.djc.environment.MmsDjcTransactionManager.access$000(MmsDjcTransactionManager.java:13)

    at com.sybase.vader.djc.environment.MmsDjcTransactionManager$1.invoke(MmsDjcTransactionManager.java:28)

    at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:857)

    ... 37 more

Thanks in advance!

Catherine

[Former Member]

Hi Catherine,

Where you able to solve this issue?

Cheers

Shaun