SMP3.0 SP08 - Offline Store Sync with OData (Limit...

Dear Experts /Claudia Pacheco /Jitendra Kansal/,

I am facing a problem , I have already developed Native Android OnLine/OffLine App on SMP3.0 SP05 . It was working fine in Online and Offline both in SMP SP05. Few days back basis updated the patch from SP05 to SP08. The App is working fine in online Mode but in Offline Store I am getting very limited set of records i.e. 5 or 6 only records on my mobile device, while prior to this in SP05 there was no problem (whatever I was getting in online mode I was able to see them in offline mode). However i have rechecked the code for sync (flush & refresh).

Please Help to resolve this issue.

Thanks & Regards,

Sarvesh

SAP Managed Tags:
SAP Mobile Platform

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

Hi /Claudia Pachecot

Can you please guide .

Regards,

Sarvesh

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sarvesh,

There was a change in compatibility between SMP SP05 and SP06 and it's related to the point mentioned by :

If no maximum length is defined for the key property, you have to define it if the property's data type is string. This change is needed when you are upgrading from sp05. If you go to the metadata of the document you will find whether maxlength is defined for the key attribute.

You are on the right track by upgrading your SDK to SP09.

I believe your key has an Integer type "registration_no", so you should be fine on this front, but this constraint also applies to referential constraint properties, so please confirm your odata service complies with this requirement and let us know.

Another thing... when you open the offline store, please set the options.serviceRoot with the name of the application configuration. I corrected this code in July, because I found out that using the endPointURL can cause problems when using relay server.

In the initialization of the offline store, I replaced

options.serviceRoot= endPointURL;

for

// the serviceRoot is the backend connector name, which is usually the same as the

// application configuration name in the SMP management cockpit
options.serviceRoot= "com.sap.flight";

Best regards,

Claudia

Dear Claudia Pacheco/Midhun VP

Thanks for your time.

On above the "Key" in all the OData service is integer, and there there is no referential key for the same in rest of the OData.

As per your suggestion,

// the serviceRoot is the backend connector name, which is usually the same as the

// application configuration name in the SMP management cockpit
options.serviceRoot= "com.sap.flight"; (My Application Name in SMP management cockpit) --- Is giving ERROR in the app.

After further debugging in the app, I am creating the Offline Store in Online, and than syncing and flushing the same store (Same in SP05/SP09). And in this Sync it only populates 6 entries in corresponding offline store (But in SP05 it was syncing with complete data set i.e. 144 entries), while there are 144 entries their in Online entity set i.e. offlineStore.openStoreSync(options);. However there is no exception, it is successful sync.

After this I go and check in Offline Store is always NULL, so when in Offline I check for the Store==NULL, it always found NULL and Create the store again in Offline mode, but this wasn't the case with SP05. So in SP05 in offline this store is NOT NULL, but with this SP09 it is SP05 NULL and create the store in offline.

And it retrieves very less or few records (i.e. 6 entries, as synced above) in offline, instead of 144 entries and in some cases not populating the data, which it was populating earlier in SP05. So it looks like there is some change in "Sync", which is impacting the behavior of App.

Warm Regards

Sarvesh

Hi Sarvesh,

1. Make sure you are on the latest patch level for your SP releases. The latest for the SDK SP9 is:

EBF 25386: 3.0 SP09 PL08

2. I would like you to confirm, you are not counting the number of entities from a filtered result and that you are comparing online and offline without the filters. In your code, when you get data, you are filtering it by name.

ODataResponseSingle resp = store.executeReadEntitySet("cms_RetailOutletData" + "?$filter=NAME%20eq%20%27" + regCode + "%27", null);

3. Your also mentioned that options.serviceRoot= "com.sap.flight"; (My Application Name in SMP management cockpit) --- Is giving ERROR in the app. what type of error? make sure it matches the application configuration ID in your management cockpit.

Otherwise, I think you should open a ticket. As we mentioned before, there was a break in the backward compatibility from SP05 to SP06. It shouldn't have affected you since your keys are integer type, but there might be another reason why your service is behaving this way.

Best regards

Claudia

Hi Claudia,

As suggested above, I have updated the patch level to PL08 for SDK SP09. But still facing the same issue, but I like to tell you one thing here that I am able to login in offline mode, probably that is because it is handled by MAF, however the same way offline store is created & synced in online for the same (Login). But afterward next level of stores are fetching limited sets of records i.e. 6 records, as mentioned above.

On the filtering part, in both the cases (Online/Offline) I'm using the same filter criterion, because I need the filtered data to be on device. So the count should be same in both the cases.

Now on options.serviceRoot= "com.sap.flight", it is not giving any error, probably I was referring it incorrectly earlier. But now this okay and I keep the code as you suggested.

I have already suggested client to raise the incident. However, I am still confused on the behavior of App, because "Login" offline shows this store is created successfully and synced correctly, but next level of stores are created perfectly but not appropriately synced.

Thanks,

Warm Regards

Sarvesh

Hi Sarvesh,

Please note the below points:

You need to upgrade your app with the updated SDK.
If no maximum length is defined for the key property, you have to define it if the property's data type is string. This change is needed when you are upgrading from sp05. If you go to the metadata of the document you will find whether maxlength is defined for the key attribute.
You don't need to recreate the local db in your device. The new sdk will automatically patches the local db.
Provide the server logs after changing the offline component to debug mode.

Regards, Midhun

SAP Technology RIG

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Midhun,

So I need to upgrade app with SDK SP09, because the SMP3.0 SP is 08.

Thanks

Sarvesh

latest SMP server is SP09 PL02

and SDK is SP10 PL01

Hi Jitendra,

My point was, client has SMP SP08, so my SDK should be SP09. As I remember, somewhere I read that SDK version should be one higher SP of your SMP Service Pack. Please suggest other wise I will request basis to get SDK SP10.

Thanks,

Sarvesh

With server SP08, you can have SDK SP09

Have you not yet troubleshooted what is issue all about (as Midhun mentioned above)? What info do you find in server logs?

Hi Midhun,

Please find the below logs collected from basis Team.

---------------------------------

2015 10 16 16:24:38#+0530#ERROR#com.sap.mobile.platform.server.online.filter.application.ApplicationConnectionHelper###http-bio-8080-exec-1##956e6ab4-7965-4900-9ee5-2f3cb98c8fe3######Application connection is not found::956e6ab4-7965-4900-9ee5-2f3cb98c8fe3 |

2015 10 16 16:25:26#+0530#ERROR#com.sap.mobile.platform.server.online.filter.application.ApplicationConnectionHelper###http-bio-8080-exec-1##956e6ab4-7965-4900-9ee5-2f3cb98c8fe3######Application connection is not found::956e6ab4-7965-4900-9ee5-2f3cb98c8fe3 |

2015 10 16 16:25:35#+0530#ERROR#com.sap.mobile.platform.server.online.filter.application.ApplicationConnectionHelper###http-bio-8080-exec-1##956e6ab4-7965-4900-9ee5-2f3cb98c8fe3######Application connection is not found::956e6ab4-7965-4900-9ee5-2f3cb98c8fe3 |

2015 10 16 16:25:36#+0530#ERROR#com.sap.mobile.platform.server.online.filter.application.SMPApplicationSecurityFilter###http-bio-8080-exec-1##956e6ab4-7965-4900-9ee5-2f3cb98c8fe3######Application connection is not found::956e6ab4-7965-4900-9ee5-2f3cb98c8fe3 |

2015 10 16 16:53:04#+0530#ERROR#com.sap.mobile.platform.server.admin.jaxrs.offlineconfig.impl.OfflineConfigurationImpl##smpAdmin#http-bio-8083-exec-2########Exception while retrieving the configuration file. java.lang.NullPointerException: while trying to invoke the method com.sap.odata.offline.config.MLODataApplicationInfo.getEndpoints() of a null object loaded from local variable 'appInfo'

at com.sap.odata.offline.smp.MLODataSMPConfig.writeEndpointConfigToFile(MLODataSMPConfig.java:793)

at com.sap.mobile.platform.server.admin.jaxrs.offlineconfig.impl.OfflineConfigurationImpl.writeEndpointConfigToFile(OfflineConfigurationImpl.java:331)

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

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

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

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

at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:164)

at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:91)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

at java.util.concurrent.FutureTask.run(FutureTask.java:166)

at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255)

at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113)

at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:102)

at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:464)

at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:149)

at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:148)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:108)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)

at org.springframework.web.servlet.mvc.ServletWrappingController.handleRequestInternal(ServletWrappingController.java:159)

at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

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

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

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

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:319)

at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56)

at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70)

at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)

at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)

at com.sun.proxy.$Proxy84.handleRequest(Unknown Source)

at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)

at com.sap.mobile.platform.server.dispatcher.servlet.DispatcherServlet.service(DispatcherServlet.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:186)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:166)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)