Preview Errors in Unwired WorkSpace

Problem: Preview fails due to transaction errors.

Explanation: By default, Unwired WorkSpace runs in chained transaction mode when you select the preview option for a mobile business object. This lets the transaction roll back after preview so the enterprise information system (EIS) data is not affected.

In some cases, the EIS operation cannot function in chained transaction mode. For example, in these two typical scenarios:

A stored procedure was created in autocommit mode, and sp_procxmode anymode, <procedure name> has not been run to allow chained transaction mode.
When creating a mobile business object for a stored procedure in Adaptive Server® Enterprise 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.

Solution:

Use a text editor to open%SUP_HOME%\Eclipse\UnwiredWorkSpace.bat.
Locate -vmargs in the script and add the following after the argument (with a space between the argument and this entry): -DautocommitPreviewTransaction=true
Save and close the file.
Restart your workspace.