1204790 - Error: "DA0005 Exception: DBD, ct_results(): user api layer: external error: This routine cannot be called until all fetchable results have been completely processed. State: 21000"

In BusinessObjects XI Release 2, the data provider uses two Stored Procedures in ASE (Adaptive Server Enterprise) to generate the report. Stored Procedure 1 is calling Stored Procedure 2 which uses the Insert, Select and Create commands to create temporary tables and insert values into the temporary tables. When opening the report, the following error message appears:

"DA0005 Exception: DBD, ct_results(): user api layer: external error: This routine cannot be called until all fetchable results have been completely processed. State: 21000"

The same documents do not generate errors in Business Objects 5.

DA0005, CT_Result , 7937416 , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , Bug Filed