Hi, All.
I'm running cf2021. Our application has been running smoothly during development for months, but we suddently got the following error message in the browser when accessing the site:
After that, everyone else accssing the site got the same message.
I'm seeing the following in the application log for the same times as the user attempts (URL changed for privacy purposes):
"The prepared statement handle 1 is not valid in this context. Please verify that current database, user default schema, and ANSI_NULLS and QUOTED_IDENTIFIER set options are not changed since the handle is prepared. The specific sequence of files included or processed is: C:\inetpub\wwwroot\blabla\index.cfm, line: 55"
I found comments at https://community.progress.com/s/article/Queries-with-ANSI-NULLS-ON-OFF-fails-with-SQL-Server-JDBC-D... about this error, and it said it is related to SQL pooling. I looked at the advanced settings for my datasource (out of the box settings) and the look like this:
As a test, I changed the "Max Pooled Statements" to 1000, and everyone was then able to get to the site. I changed the value back to 100 and I was STILL able to get to load the site successfully.
Can anyone tell me more clearly what this error means, and how to make sure it doesn't occur again?
AdChoices