Open Forum

Expand all | Collapse all

SQL Error " Could Not find Prepared Statement with Handle 12511"

  • 1.  SQL Error " Could Not find Prepared Statement with Handle 12511"

    Posted Aug 08, 2019 08:26 AM
    Edited by Guy Famelart Aug 08, 2019 03:46 PM

    It looks like it is coming from Web services
    SQL is setup with unlimited connections
    Anybody got this error and a solution to fix it.

    We are on NAV 2017

    ------------------------------
    Guy Famelart
    Senior Manager of IT
    Skyfold inc.
    Baie d'Urfé QC
    ------------------------------
    Conference-BCNAVUG_200x200


  • 2.  RE: SQL Error " Could Not find Prepared Statement with Handle 12511"

    Posted Aug 22, 2019 08:30 AM
    Hi Guy,

    I am not sure, if this is still an issue. Since I am not sure what SQL version you are using, it could be a lot of things. There are different topics around that when you search for the error message, but they are all pointing to different things. One of the main things seems to be that, if you are running on an older SQL Server and the version is not supported, it can throw errors like that. Another topic points to some possible issue in the NAV server, but this is for an older version.

    So, what version of SQL are you using?
    Does this happen all the time (as soon as you start and work in NAV) or only once in a while?
    Do you have a way to replicate this behavior?

    ------------------------------
    Peter Zentner
    Director of Product Management
    NAV-X
    Holmdel NJ
    ------------------------------

    Conference-BCNAVUG_200x200


  • 3.  RE: SQL Error " Could Not find Prepared Statement with Handle 12511"

    GOLD CONTRIBUTOR
    Posted Aug 23, 2019 07:35 AM
    Need more information. What is a user trying to do when the error message happens? Where are you seeing the error message - in a client? In SQL logs? In the server event viewer?

    ------------------------------
    Kyle Hardin
    NAV Developer
    ArcherPoint Inc.
    Duluth GA
    ------------------------------

    Conference-BCNAVUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role