SUPBigString not updating in backend DB

[Former Member]

Hi

We are facing a problem with using SUPBigString as datatype in Mobile Business object. Our backend DB is a MySQL DB and the attribute which I'm talking about is of type "text" which mapped to "bigString" on SUP server. We could successfully read the string from the mobile device but the problem is that when we update this attribute locally on the device and make a synchronization to  update the backend DB, only this attribute is not updated in the Backend DB while all other attributes are updated during the update operation.

Thank you,

Amr

[midhun_vp]

What type of app you are developing ? Native or hyrbid ?

Have to tried by passing small data from device to DB ?

- Midhun VP

[Former Member]

Hi Midhun

It is a native app.

yes, I have tried to pass data as string and long types and it passed successfully.

[midhun_vp]

My question was on the bigString field. When you are passing small data ex: a word or a small sentence to this field from the device is it reaching backend ?

What is the length of the data you are passing to this field ?

[Former Member]

Hi Midhun,

No, it failed to reach backend even for small data like a word.

The length of data is varying but it is not working  even with test small data.

Note: After writing the string data to the SUPBigString buffer, I test by reading the buffer and I find my data, the problem that after making a sync the data is not updated at the backend.

[Jitendra_Kansal]

Hi Amr,

Test it for just confirmation that data is flowing from sup to backed.

"Test Execute" the update operation from the mbo designing itself.

Right click "update" in mbo screen, test execute , pass all desired parameters.  Click on preview.

Once everything is done, check the data availability at sup and backend level.

Rgrds,

Jitendra

[Former Member]

Hi Jitendra,

It works fine with test Execute from MBO designer. Have tried to enter it as a string and as a file and both updated the data at the backend.

Regards,

[Jitendra_Kansal]

Hi Amr,

It's cool then.

Lets come to the main issue:

When you are making sync while update operation for that particular ATTRIBUTE

What is  its status at sup level ?

Is it reaching at all ? If yes then are you seeing full data length ? Please check it.

Rgrds,

Jitendra

[midhun_vp]

How you are passing this value from the device, is it a PK? Which is the mobile OS ?

According to SAP Personalization key/sync parameter/load argument/object query parameter/client parameter are not allowed to set BigString/BigBinary datatype. Just read in detail about the support for bigstring here, http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01781.0224/doc/html/asc12...

I hope this information helps you. Look at the server logs too after doing an operation from the device, that give more information on the issue. Logs you can find inside the SUP server.

- Midhun VP