Troubleshooting Preview Errors in Unwired WorkSpace

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.

Two typical scenarios are:
  • A stored procedure that was created in autocommit mode and sp_procxmode anymode, <procedure name> has not been run to allow chained transaction mode as well.

  • 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:


  1. Go to %SUP_HOME%\Eclipse and open the UnwiredWorkSpace.bat file with a text editor.
  2. Locate -vmargs in the script and add the following after the argument (with a space between the argument and this entry) : -DautocommitPreviewTransaction=true
  3. Save and close the file.
  4. Restart your WorkSpace.
Parent topic: Troubleshoot

Created September 17, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com