MFS Multi-Platform Sync Errors: "Exception occured while composing data for upload"
Last updated on MARCH 21, 2017
Applies to:Oracle Mobile Field Service - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
When attempting to use MFS Multi-Platform (MP) the following error occurs.
The sync fails from MP client with error: “Exception occured while composing data for upload.[SQL Error in Compose_lob_data -could not prepare statement (1 no such column: b.ACCESS_ID)]”
A subsequent error is produced when accessing a Task: “bad result on query: could not prepare statement (1 no such column: site.LAT_LONG) let’s try to create the db table”
The issue can be reproduced at will with the following steps:
1. Complete the Setup from Server side including create a valid Mobile User
2. Log in MFS MP
3. Try to sync or access Task
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