We have an App Engine that executes a couple of stored procedures. We are running MS SQL Server and the process has run successfully in the past but has been failing for some time.
Is there some restriction on executing stored procedures from within the PeopleCode Action? Any clues?
Here is the section of the log that seems most relevant.
SQL error. Function: SQLExec
Error Position: 0
Return: 8601 - [Microsoft][SQL Native Client][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Native Client][SQL Server]Process Started
[Microsoft][SQL Native Client][SQL Server]Creating daily backup of PS_B_EMP_SCHED_DEN table
[Microsoft][SQL Native Clie
Statement: EXEC B_SP_RB_CREATE_IND :1
Original Statement: EXEC B_SP_RB_CREATE_IND :1
2011-02-21-15.26.00.999369 AePcdExecutePeopleCode  Exception logged: RC=100.
SQL error in Exec. (2,280) B_RB_LVRUPD.DmmyCrt.GBL.default.1900-01-01.Create.OnExecute PCPC:3039 Statement:32
2011-02-21-15.26.00.999369 DoStepActions  Exception logged: RC=100.