Symantec Access Management

Expand all | Collapse all

Unable to initialize the XPS library - XPSDDInstall

Jump to Best Answer
  • 1.  Unable to initialize the XPS library - XPSDDInstall

    Posted 01-14-2016 06:12 AM

    Hi guys,

     

    on section "How to Configure a SQL Server Policy Store: Import the Policy Store Data Definitions" from the wiki.ca I came across with this error after executing

     

    CA\SiteMinder\xps\dd>  XPSInstall SmMaster.xdd

    [XPSDDInstall - XPS Version 12.52.0100.499]

    Log output: C:\CA\siteminder/log/XPSDDInstall.2016-01-14_115312.log

    Initializing database, please wait...

    (ERROR) : [sm-xpsxps-00870] An error occurred when calling "SQLExecDirect" for "Read Parameters" query

    (ERROR) : [sm-xpsxps-00810] Native Diagnostic: 42S02:208 [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'xpsParameterSetting'.

    (ERROR) : [sm-xpsxps-00870] An error occurred when calling "SQLExecDirect" for "Initial Policy Data Read" query

    (ERROR) : [sm-xpsxps-00810] Native Diagnostic: 42S02:208 [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'xpsObject'.

    (ERROR) : [sm-xpsxps-00870] An error occurred when calling "SQLExecDirect" for "Update Parameter Setting" query

    (ERROR) : [sm-xpsxps-00810] Native Diagnostic: 42S02:208 [DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'xpsParameterSetting'.

    (ERROR) : [sm-xpsxps-00410] Save Policy Store ID failed.

    (FATAL) : [sm-xpsxps-04120] Unable to initialize the XPS library.

     

    Connection between Policy Store and Policy Server works fine.

     

     

     

    smreg -su ******* also worked fine.

     

    What can it be?

     

    Thanks and kind regards.

     

    Andrés-J. Cremades



  • 2.  Re: Unable to initialize the XPS library - XPSDDInstall

    Posted 01-15-2016 05:24 AM

    Hi ajcremades,

     

    Was there error creating the policy store schema -- executing sm_mssql_ps.sql (under <siteminder>\db\SQL) an SQLServer.sql (under <siteminder>\xps\db)?

     

    Best regards,

    Kelly



  • 3.  Re: Unable to initialize the XPS library - XPSDDInstall

    Posted 01-20-2016 04:12 AM

    Hi wonsa03,

     

    I've just could read your question. I'll check it ASAP. Thanks for helping.

     

    Best regards,

    Andrés-J.



  • 4.  Re: Unable to initialize the XPS library - XPSDDInstall
    Best Answer

    Posted 02-16-2016 11:29 AM

    Hi wonsa03,

     

    finally I discover my mistake. I forgot to execute SQLServer.sql. Thanks to your post, it helped me to notice about it. After executing the sql file, executing "XPSDDINstall SmMaster.xdd" ran with no problem

     

    Thanks and best regards.

    Andrés-J. Cremades