Search This Blog

Monday, August 24, 2009

Sys.WebForms.PageRequestManagerServerErrorException: an unknow error occured while processing the request on the server. ..status code returned .. 500

My situation:
Environment: ASP.NET, AJAX.NET and MySQL DB

I got error return when using one of the form written in AJAX.NET when calling MySQL Stored Procedure

Sys.WebForms.PageRequestManagerServerErrorException: an unknow error occured while processing the request on the server. the status code returned from the server was: 500



Well, after check around i found out that the problem is in the MySQL Stored Procedure case sensitive issue. Change the case and problem solved!

2 comments:

Andrés said...

hi,

i have the same problem... but, what do you mean with "change the case"...

change the case to upper?? lower??...

in name of columns or resulting rows??

In blues said...

It's case sensitive, in situation, it happen to the MySQL Stored Procedure case. So, i change to exactly the same case that using in Stored Procedure.
For instant, my stored procedure name is "sp_CheckAccessibility", so, i have to use exact case to call this stored procedure. Hope this help.