HomePowerBuilderAppeon Documentation Center

PowerBuilder using ADO.NET causing System.InvalidOperationException: This SQLTransaction has completed, it is no longer usable

Symptom

When running an application in PowerBuilder and connecting to MS SQL Server 2008 using ADO.NET, getting the following error: 

 System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.
   at Sybase.PowerBuilder.Db.Block.SqlBlock.ProcessError(Exception ee)
   at Sybase.PowerBuilder.Db.Data.DbBlock.DoTransaction(PbTrans oper)
   at Sybase.PowerBuilder.Db.DbRoutine.DoTransaction(PbTrans oper)

Environment

  • PowerBuilder

  • Microsoft SQL Server

  • ADO.NET

Cause

In the PowerBuilder database trace log, for every Begin Transaction there should be a Commit statement.    At some point in the log file, you no longer can pair the Begin Transaction and Commit statements.

Solution

In one of the ancestor windows, there were these statements: 

string ls_sql
ls_sql = "commit"
execute immediate ls_sql;

It caused an extra commit to be issued and that was causing the error.

Prev  Up  Next
Updating contents of blob  Home  Calling a Stored Procedure in PowerBuilder results in 'Invalid character value for cast specification' error