Layer7 Access Management

Expand all | Collapse all

Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

  • 1.  Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    Posted 03-21-2014 04:44 AM

    Our SiteMinder Policy Server have some error message int the smps.log and it will release service.

    [11028/6672][Thu Mar 20 2014 05:41:54][CA.XPS:ODBC0001][ERROR] While calling "SQLConnect(CA SiteMinder DSN)", the following error occurred:

    [11028/6672][Thu Mar 20 2014 05:41:54][CA.XPS:ODBC0002][ERROR] IM005:0 [Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    [11028/6672][Thu Mar 20 2014 05:41:54][CA.XPS:ODBC0032][ERROR] Error obtaining ODBC handle.

    How can find out what problem occurred ?

    Thanks.



  • 2.  RE: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    Posted 03-24-2014 07:04 AM
    yuhung:

    [11028/6672][Thu Mar 20 2014 05:41:54][CA.XPS:ODBC0001][ERROR] While calling "SQLConnect(CA SiteMinder DSN)", the following error occurred:

    [11028/6672][Thu Mar 20 2014 05:41:54][CA.XPS:ODBC0002][ERROR] IM005:0 [Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    [11028/6672][Thu Mar 20 2014 05:41:54][CA.XPS:ODBC0032][ERROR] Error obtaining ODBC handle.



  • 3.  RE: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    Posted 03-24-2014 07:11 AM

    Dear Yuhung,

    the error message comes from the ODBC driver used for the ODBC Datasource "CA Siteminder DSN" and not from Siteminder, the policy server is just reporting the error.  Can you please confirm if that datasource is using the correct driver (it should use the "Siteminder" driver and not the vendor's driver)?

    Has this policy server ever been able to startup properly?

    Have you created this datasource manually or was it created during the setup of the Policy server?

    Which version of the Policy server do you have installed?

    Also, what is the RDBMS you are connecting to?

    Kind Regards,

    Martin Fink

     



  • 4.  RE: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    Posted 03-24-2014 08:18 PM

    Hi Martin

    Thanks for reply.

    We created datasource during the setup of the Policy Server ,we did not set up manually

    I think we should use default driver during the setup of the Policy Server .

    The Policy Server version is R12.5 ,Our Policy Store is MS SQL on Win 2012 server.

    Yes ,the policy server can be able to startup properly. We had installed the Policy Server almost 9 mtonth. Until last week this error occurs twice.

    Regards,

    Yuhung



  • 5.  RE: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    Posted 03-26-2014 08:59 PM

    Looks like Policy Server's ODBC connection to the Policy Store.

    What is PS's OS? Is the MS SQL server 2012 as well?



  • 6.  RE: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    Posted 03-27-2014 02:17 AM

    Policy Server Version is R12.5 on Windows Server 2008R2.

    SQLServer 2008 on Windows Server 2012. Yes , it runs fine.

     



  • 7.  Re: Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    Posted 05-05-2015 09:15 PM

    Hi,

     

    It seems something wrong between the Siteminder SQL driver with database.

    IM005 error as per Microsdoft link:

    SQLConnect Function

     

    IM005

    Driver's SQLAllocHandle on SQL_HANDLE_DBC failed

    (DM) During SQLConnect, the Driver Manager called the driver's SQLAllocHandle function with a HandleType of SQL_HANDLE_DBC and the driver returned an error.

     

    Suggest to enable ODBC tracing in ODBC Data Source administrator -> Tracing tab and also enable policy server tracing to capture database events. Tjhis will give us more hints on why the error happen.

     

    Thank you.

     

    Regards,

    Kar Meng