MFS Multi-Platform Sync Errors: "Exception occured while composing data for upload" (Doc ID 1947325.1)

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.

Symptoms

When attempting to use MFS Multi-Platform (MP) the following error occurs.

ERROR
-----------------------
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”

STEPS
-----------------------
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

Cause

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