SAP Knowledge Base Article - Preview

2370214 - UnexpectedError opening offline store when upgrading SMP 3.0 Offline OData SDK

Symptom

  • Customer upgraded SMP 3.0 SDK from SP10 PL11 to SP12 PL07 and is seeing errors when trying to open an existing offline store.
  • Android logcat shows:
    09-22 14:30:19.029: E/OfflineManager(28270): (KrollRuntimeThread) [1,912062] Error in openStore function of the OfflineManager class. Class exception:com.sap.smp.client.odata.exception.ODataContractViolationException = class com.sap.smp.client.odata.exception.ODataContractViolationException
    09-22 14:30:19.029: E/OfflineManager(28270): (KrollRuntimeThread) [1,912063] Error in openStore function of the OfflineManager class. Catched exception:
    09-22 14:30:19.029: E/OfflineManager(28270): com.sap.smp.client.odata.exception.ODataContractViolationException: UnexpectedError
    09-22 14:30:19.029: E/OfflineManager(28270): at com.sap.smp.client.odata.offline.ODataOfflineStore.openStoreSync(ODataOfflineStore.java:526)
    09-22 14:30:19.029: E/OfflineManager(28270): at com.propelics.sapsmpodata.offline.OfflineManager.openStore(OfflineManager.java:197)
    09-22 14:30:19.029: E/OfflineManager(28270): at com.propelics.sapsmpodata.ODataOfflineStoreProxy.openStore(ODataOfflineStoreProxy.java:102)
    09-22 14:30:19.029: E/OfflineManager(28270): at org.appcelerator.kroll.runtime.v8.V8Object.nativeFireEvent(Native Method)
    09-22 14:30:19.029: E/OfflineManager(28270): at org.appcelerator.kroll.runtime.v8.V8Object.fireEvent(V8Object.java:62)
    09-22 14:30:19.029: E/OfflineManager(28270): at org.appcelerator.kroll.KrollProxy.doFireEvent(KrollProxy.java:918)
    09-22 14:30:19.029: E/OfflineManager(28270): at org.appcelerator.kroll.KrollProxy.handleMessage(KrollProxy.java:1141)
    09-22 14:30:19.029: E/OfflineManager(28270): at android.os.Handler.dispatchMessage(Handler.java:95)
    09-22 14:30:19.029: E/OfflineManager(28270): at android.os.Looper.loop(Looper.java:137)
    09-22 14:30:19.029: E/OfflineManager(28270): at org.appcelerator.kroll.KrollRuntime$KrollRuntimeThread.run(KrollRuntime.java:118)
    09-22 14:30:19.029: E/OfflineManager(28270): Caused by: com.sap.smp.client.odata.offline.ODataOfflineException: [-10001] An error occurred executing SQL statement: CREATE TABLE IF NOT EXISTS LODATA_SYS_REQUEST_DEPENDENCY( parentReq BIGINT NOT NULL, childReq BIGINT NOT NULL, PRIMARY KEY( parentReq, childReq ), FOREIGN KEY REQID_FKEY_P ( parentReq ) REFERENCES LODATA_SYS_REQUEST_QUEUE(requestID) CHECK ON COMMIT, FOREIGN KEY REQID_FKEY_C ( childReq ) REFERENCES LODATA_SYS_REQUEST_QUEUE(requestID) CHECK ON COMMIT, SYNCHRONIZE ALL ). Reason: -952 (ERROR).


Read more...

Environment

SMP SDK 3.0 SP 12 PL07

Product

SAP Mobile Platform 3.0 ; SAP Mobile Platform SDK 3.0

Keywords

OData LogonCore , KBA , MOB-SDK-OOD , SAP Mobile SDK Offline OData Client , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.