Unable to initialize the XPS library - XPSDDInstall

[Anon Anon]

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

[wonsa03]

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

[Anon Anon]

Hi wonsa03,

 

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

 

Best regards,

Andrés-J.

[Anon Anon]

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