Error: General ODBC Error: General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]Procedure or function dbo.Gift_PledgeSplitAppAmtOrBalance has too many arguments specified. Native error: 8144 General ODBC Error: [Microsoft][ODBC SQL server

We are trying to run Gift Detail and Summary reports and getting the following error message General ODBC Error: General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]Procedure or function dbo.Gift_PledgeSplitAppAmtOrBalance has too many arguments specified. Native error: 8144 General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]The statement has been terminated. Native error:3621. This happens for all Gift Detail and Summary Reports, even new ones. In further testing we found other types of reports have this issue as well such as the Adjusted Gift Report under Financial Reports and the Donor Category and LYBUNT report under Analytical Reports. The issue is wide spread to many types of reports, but not all reports as the Fund detail and Campaign Detail reports worked when we tried them.

Our Cash Receipts Journal and Annual Statement Report under Financial Reports are returning a different error message of Failed to create command table. ReRep [Table Name].rpt Details: [Database Vendor Code 8144] (997)

We are also seeing a very similar error message when clicking on the prospect tab of any constituent record with proposal information on the record. This error message is Error: General ODBC Error: General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]Procedure or function dbo.Gift_PledgeSplitAppAmtOrBalance has too many arguments specified. Native error: 8144 General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]The cursor was not declared. Native error:16945
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

For Error: General ODBC Error: General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]Procedure or function dbo.Gift_PledgeSplitAppAmtOrBalance has too many arguments specified. Native error: 8144 General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]The statement has been terminated. Native error:3621.
  1. Financial Reports > Gift Detail and Summary Report or Adjusted Gift Report OR Analytical Reports > Donor Category Report or LYBUNT report
  2. Open any report or create a new one and click Preview
  3. Error occurs
For Error: Failed to create command table. ReRep [Table Name].rpt Details: [Database Vendor Code 8144] (997)
  1. Financial Reports > Cash Receipts Journal or Annual Statement Report
  2. Open any report or create a new one and click Preview
  3. Error occurs
For Error: General ODBC Error: General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]Procedure or function dbo.Gift_PledgeSplitAppAmtOrBalance has too many arguments specified. Native error: 8144 General ODBC Error: [Microsoft][ODBC SQL server driver][SQL Server]The cursor was not declared. Native error:16945
  1. Open any constituent record with proposal information
  2. Click on the propect tab
  3. Error occurs

Was this article helpful?