Unable to get records. Could not find stored procedure...

If your application uses stored procedures and your production database server is different from your development database server than it is possible that production database does not have stored procedure loaded.

Solution

Use LoadStoredProcedures.bat file which is located in the StoredProcedures subfolder of the application’s deployment folder, for example in:

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\LAYOUTS\MyApp3\StoredProcedures

See LoadStoredProcedures.bat for details.

See Also

Part IX:  Troubleshooting Applications

SharePoint Application Deployment Error Messages