• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

"Prepared statement handle 1" error.

Explorer ,
Jun 09, 2024 Jun 09, 2024

Copy link to clipboard


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?






Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation