By default Unwired WorkSpace runs in chained transaction mode when doing a preview of a mobile business object.
This is so that the transaction can be rolled back after preview so the Enterprise Information System (EIS) data is not affected.
There may be some cases where the EIS operation cannot function in chained transaction mode.
When creating a mobile business object for a stored procedure in ASE 12.x the drop temptable command fails.
Queries that use DDL, for example, a SELECT ... INTO #temptable, that creates a temporary table, and then after processing data in the temp table a DROP TABLE #temptable generally cannot be run in chained mode. You receive this error:
Execution failed: The 'DROP TABLE' command is not allowed within a multi-statement transaction in the 'tempdb' database.
When preview fails because of transaction errors like these: