Cannot Sync Non Empty Blob Datatype If Pubitem Is In Complete Refresh Mode

(Doc ID 1397544.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Database Mobile Server - Version: and later   [Release: 11.1 and later ]
Information in this document applies to any platform.


Cannot sync non empty blob datatype if PubItem is in complete refresh mode :

If the blob field is empty, no problem when you sync.

If blob field is not empty, sync is ok on Mobile Server but client hangs with this error:

-12011 oseException(-12011):Plugin returned error -13000: ospWriteSnap()returns error -13000: "SqliteException:

Sqlite database error (see the cause) <- SqliteException: near" ": syntax error[Diagnostics:

dbName=SQLITE, snapName=SETTING,type=1, recBufLen=180]" <- osePluginError(-13000):
ospWriteSnap() returns error -13000:

If pubitem is in fast refresh mode and blob field is not empty, sync is ok on Mobile Server and client.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms