Report error

[fret_24]

I'm getting the following error when I try to run a report. I'm wondering if it has anything to do with the upgrade issues I had. Any ideas???

Unable to render graph. Error was: Procedure or function ckbx_Image_InsertImage has too many arguments specified.

[pwiesner]

The error message “Procedure or function XXXX has too many arguments specified” occurs when two or more instances of the same object are created in a database. Generally this occurs if the create sql scripts are run multiple times under different credentials.

You can confirm that this is the issue by scrolling through the list of stored procedures in SQL Server Management Studio, you should see at least two instances of ckbx_Image_InsertImage. Stored procedures are listed alphabetically, with the owner name being the first part of the name as a result the stored procedures will not be next to each other.

If this is your issue you will need to delete all of the stored procedures except the ones that Checkbox uses access the database. You can confirm which credentials Checkbox uses to access the database with the connection string located in the web.config file.

[fret_24]

All of the stored procedures exist only once. I ran a trace in SQL Profiler and I don't see the call to that procedure making it to the database. Any thoughts?

[pwiesner]

You are correct this sounds like an upgrade issue. The signature of this stored procedure changed in Checkbox 4.1. How many parameters does your stored procedure expect?
The version in Checkbox 4.1 expects 7 parameters. If yours copy has less than this it seems likely that your database was not updated correctly. If your copy has 7 parameters it seems like one or more dll was not updated.

[fret_24]

It was indeed a problem with the stored procedure. I manually ran the Checkbox_StoredProcedures sql script in the Install\InstallScripts directory on the database and that fixed it. I did get a few messages when I ran it...

I got the following message for both: ckbx_Response_GetRTResponses and ckbx_Response_GetRTAnswers.

Cannot add rows to sysdepends for the current object because it depends on the missing object 'OBJECT'. The object will still be created.

I can't find anywhere where those are created. Any idea what other scripts I may need to run? I'm sort of thinking about just scrapping the whole installation and starting over fresh since we're just getting started and only have test data in the database right now.

[ncushing]

You can safely ignore that warning. SQL server prints that warning when a stored procedure that uses a not-yet-created object is created. In this case, the object is another stored procedure created later in the same script.

[fret_24]

Awesome, thanks for the help guys.