Describes database mobile business object (MBO) related errors and solutions.
During MBO development, by default, preview of a database MBO uses SQL in chained transaction mode, so any changes made to the datasource are rolled-back to avoid permanently changing data. The result is the MBO behaves as expected when previewed, but fails when a device application attempts to synchronize the MBO, and an error is logged in Unwired Server's uep.log file.
Solution: If you see chained transaction mode related errors in the uep.log file, run sp_procxmode procname, anymode, where procname is the name of the stored procedure, so the stored procedure runs in autocommit mode.