Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Custom report could not find stored procedure.

I made stored proedure to pull out appliation summary data, then use Crystal Report to generate the report templates (both table and chart) all work well, I can get data from this template. However, I followed the procedures to add report template into IPCC Historial report client, it does show in report client, but it can't generate report, the error in log is:

Could not find the stored procedure.

I suspect this is database user priviledge issue, the user ID for Historical report client is authenticated by IPCC server, and doesn't have access to database, so there must be another user provided by IPCC that could run stored procedure in DB. I compared this stored procedure with others, didn't find the difference.

What else could I look to?

Wei

1 REPLY
Bronze

Re: Custom report could not find stored procedure.

The only solution for this issue is to re-install CRS to replace stored procedures in the database.

202
Views
0
Helpful
1
Replies
CreatePlease to create content