Question Re: Problem with startup synchronization in Technology Q&A

Problem with startup synchronization

Former Member — Thu, 17 Oct 2013 07:41:51 GMT

Hello Friends,

In my sample program getting the customer list, I am synchronizing the data base at the application startup. below is the code.

try {

Log.d(TAG, "Synchronizing..");

// Set synchronization profile

ConnectionProfile cp = SampleOneDB.getSynchronizationProfile();

cp.setServerName(SERVER);

cp.setPortNumber(SYNC_PORT);

cp.setNetworkProtocol(PROTOCOL);

cp.setAsyncReplay(true);

cp.setDomainName(DOMAIN);

cp.save();

} catch (Exception e) {

e.printStackTrace();

Log.d(TAG, e.getMessage());

}

try {

SampleOneDB.subscribe();

SynchronizationGroup sg = SampleOneDB

.getSynchronizationGroup("default");

sg.setEnableSIS(true);

sg.save();

SampleOneDB.synchronize();

} catch (Exception e) {

e.printStackTrace();

Log.d(TAG, e.getMessage());

}

after this code execution i m getting my initial screen with a button. if i click on the button i should get the customers list. below is the code.

GenericList<customer> customerIds = Customer.findAll();

here Customer is my MBO. after execution of this statement i am getting the size of list is 0. but i have the customers in my database. Can some body help me in this.

thanks,

Re: Problem with startup synchronization

midhun_vp — Mon, 21 Oct 2013 09:04:43 GMT

Your codes looks fine. Use the below code for findall and check

for (Customer production : Customer.findAll()) {

String Name = production.getName;

}

Re: Problem with startup synchronization

Former Member — Mon, 21 Oct 2013 11:33:52 GMT

Hello Midhun,

I think there is no difference in this code. When ever I call "Customer.findAll()" i m getting the result size 0. So obviously its not going inside the for stmt.

As an alternative I tried with below code at the time of start up instead of the code which i sent in my first post.

CustomerSynchronizationParameters syncParameter = Customer

.getSynchronizationParameters();

syncParameter.delete();

syncParameter = Customer.getSynchronizationParameters();

syncParameter.setState_sp("MN");

syncParameter.save();

SampleOneDB.synchronize();

after this if i were call Customer.findAll() i am getting the result set size as 4, but those 4 are of state "MN". But here i want to synchronize the complete package not just with the state param.

Can you plz help me.

Thanks

Re: Problem with startup synchronization

midhun_vp — Tue, 22 Oct 2013 07:03:03 GMT

The MBO is having mandatory load parameter and you created sync parameter for it. Hence when you are passing load sync parameter only you will get the data. Findall will not fetch all the data since mandatory load parameters are present. If the the load parameter is nullable / there is no load parameter only you will get all the data using findall.

- Midhun VP

Re: Problem with startup synchronization

Former Member — Tue, 22 Oct 2013 11:06:27 GMT

1. By making the sync parameter as nullable also i got the same result size as 0.

2. Also tried by removing the sync parameter, but unable to deploy the MBO.

what could be the problem in both the cases?

thanks,

Re: Problem with startup synchronization

midhun_vp — Tue, 22 Oct 2013 11:32:09 GMT

My point is that the MBO has a load parameter. If you fill this value only you will get the data. Thats why you are getting "0" for the findall query. Since you have a load parameter you will not get the data for findall. Is the customer MBO associated with any RFC ? The cache DB is not filled while you are making a sync call without any input. if you pass input only the cache will be filled and you will be able to query.

- Midhun VP

Re: Problem with startup synchronization

Former Member — Wed, 23 Oct 2013 10:41:55 GMT

Thanks Midhun,

My Customer MBO does not associated with any RFC in this sample.

I have only one sync parameter in my customer table. Now I want to retrieve the complete customer list into the Android UI. To get this I am trying to do the synchronize at start up. But as you said I made the sync parameter as nullable and now what should I do to get this?

Thanks,

Re: Problem with startup synchronization

midhun_vp — Wed, 23 Oct 2013 10:54:22 GMT

Are using the customer table available in the sampleDB ? In that case I believe that there is no load parameter for it, then where you are using the sync parameter ? Give a screen of the MBO design and attributes.

Re: Problem with startup synchronization

Former Member — Wed, 23 Oct 2013 11:20:31 GMT

Thanks Midhun,

For a quick reply.

here are the attachments what you asked. plz let me know if u need any more information.

Thanks

Re: Problem with startup synchronization

midhun_vp — Wed, 23 Oct 2013 12:30:35 GMT

In this case you don't have to maintain a sync key.Delete the sync key. In queries you will be having a findall query. In the properties of MBO click on query and check it is present. After synchronize call from device you should be able to use findall and it should get you all the data.

- Midhun VP

Re: Problem with startup synchronization

Former Member — Wed, 23 Oct 2013 17:35:30 GMT

After removing the sync key while deploying i am getting an exception as shown in attachment.

Thanks

Re: Problem with startup synchronization

Jitendra_Kansal — Wed, 23 Oct 2013 18:06:48 GMT

Once check in server logs what error you are seeing?

Please share server logs fo that particular incident.

Rgrds,

Jitendra

Re: Problem with startup synchronization

midhun_vp — Thu, 24 Oct 2013 05:20:53 GMT

In the MBO properties click on refresh. If there is any query delete it and create it again. Uncheck and check primary keys if any and deploy.

Re: Problem with startup synchronization

Former Member — Thu, 24 Oct 2013 06:22:04 GMT

Still I am getting the same problem. Can you please tell me where can I see the server log?

Re: Problem with startup synchronization

Jitendra_Kansal — Thu, 24 Oct 2013 06:28:17 GMT

C:\Sybase\UnwiredPlatform\Servers\UnwiredServer\logs

then check servername.log file