Hi Ujwol
Running XPSImport gives this error.
[4736/4404][Tue Jul 07 2015 13:24:33][Database.cpp:689][InitDB][INFO][sm-xpsxps-00120] Initializing XPS Version 12.52.0101.640
[4736/4404][Tue Jul 07 2015 13:24:38][SmEventTrap.cpp:388][INFO][sm-Server-02500] Loading event handler 'C:\Apps\CA\siteminder\bin\XPSAudit.dll'
[4736/4404][Tue Jul 07 2015 13:24:38][SmEventTrap.cpp:402][INFO][sm-Server-02510] Initializing event handler 'C:\Apps\CA\siteminder\bin\XPSAudit.dll'
[4736/4732][Tue Jul 07 2015 13:24:39][CSmDbSessionManager.cpp:585][INFO][sm-Server-04350] Using ODBC 'Policy Store' data source 'CA SiteMinder DSNdt'.
[4736/4404][Tue Jul 07 2015 13:24:39][XPSIO.cpp:465][CXPSIO::InitialLoad][INFO][sm-xpsxps-00560] Database Transactions are 1.
[4736/4404][Tue Jul 07 2015 13:24:39][XPSIO.cpp:492][CXPSIO::InitialLoad][INFO][sm-xpsxps-00300] 1 Parameter(s) loaded from Policy Store, 1 total.
[4736/4404][Tue Jul 07 2015 13:24:39][XPSIO.cpp:497][CXPSIO::InitialLoad][INFO][sm-xpsxps-00330] Caching Policy Data...
[4736/4404][Tue Jul 07 2015 13:25:28][XPSIO.cpp:516][CXPSIO::InitialLoad][INFO][sm-xpsxps-00310] 3330 object(s) loaded from the Policy Store.
[4736/4404][Tue Jul 07 2015 13:25:28][XPSIO.cpp:580][CXPSIO::SetPolicyStoreID][INFO][sm-xpsxps-00430] Policy Store ID is "fb69121d-90ae-4b16-b159-a28d7156d505".
[4736/4404][Tue Jul 07 2015 13:25:28][XPSAudit.cpp:719][GetAudit][INFO][sm-xpsxps-06870] XPS Auditing is enabled.
[4736/4404][Tue Jul 07 2015 13:25:28][SmObjProvider.cpp:243][INFO][sm-Server-02830] Initializing policy store provider 'ODBC:'
[4736/4404][Tue Jul 07 2015 13:25:28][SmObjProvider.cpp:282][INFO][sm-Server-02840] Loading of policy store provider extension DLL: 'smobjodbcims' succeeded.
[4736/4404][Tue Jul 07 2015 13:25:31][SmObjCache.cpp:402][INFO][sm-Server-02800] Preloading policy store cache
[4736/4404][Tue Jul 07 2015 13:25:31][SmObjCache.cpp:415][INFO][sm-Server-02860] BulkFetch policy store
[4736/4404][Tue Jul 07 2015 13:27:06][SmAdapterStore.cpp:345][CSmAdapterStore::Init][ERROR][sm-xadobj-00010] Object store initialization failed.
[4736/4404][Tue Jul 07 2015 13:27:06][Database.cpp:513][GetSmInterface][FATAL][sm-xpsxps-03570] SiteMinder interface initialization failed.
[4736/4404][Tue Jul 07 2015 13:27:06][XPSTools.cpp:235][CXPSTools::CXPSTools][FATAL][sm-xpsxps-04120] Unable to initialize the XPS library.
Runinng XPSDDInstall also gives same errors:
[4852/5020][Tue Jul 07 2015 13:30:02][Database.cpp:689][InitDB][INFO][sm-xpsxps-00120] Initializing XPS Version 12.52.0101.640
[4852/5020][Tue Jul 07 2015 13:30:04][SmEventTrap.cpp:388][INFO][sm-Server-02500] Loading event handler 'C:\Apps\CA\siteminder\bin\XPSAudit.dll'
[4852/5020][Tue Jul 07 2015 13:30:04][SmEventTrap.cpp:402][INFO][sm-Server-02510] Initializing event handler 'C:\Apps\CA\siteminder\bin\XPSAudit.dll'
[4852/5004][Tue Jul 07 2015 13:30:04][CSmDbSessionManager.cpp:585][INFO][sm-Server-04350] Using ODBC 'Policy Store' data source 'CA SiteMinder DSNdt'.
[4852/5020][Tue Jul 07 2015 13:30:04][XPSIO.cpp:465][CXPSIO::InitialLoad][INFO][sm-xpsxps-00560] Database Transactions are 1.
[4852/5020][Tue Jul 07 2015 13:30:05][XPSIO.cpp:492][CXPSIO::InitialLoad][INFO][sm-xpsxps-00300] 1 Parameter(s) loaded from Policy Store, 1 total.
[4852/5020][Tue Jul 07 2015 13:30:05][XPSIO.cpp:497][CXPSIO::InitialLoad][INFO][sm-xpsxps-00330] Caching Policy Data...
[4852/5020][Tue Jul 07 2015 13:30:43][XPSIO.cpp:516][CXPSIO::InitialLoad][INFO][sm-xpsxps-00310] 3330 object(s) loaded from the Policy Store.
[4852/5020][Tue Jul 07 2015 13:30:43][XPSIO.cpp:580][CXPSIO::SetPolicyStoreID][INFO][sm-xpsxps-00430] Policy Store ID is "fb69121d-90ae-4b16-b159-a28d7156d505".
[4852/5020][Tue Jul 07 2015 13:30:43][XPSAudit.cpp:719][GetAudit][INFO][sm-xpsxps-06870] XPS Auditing is enabled.
[4852/5020][Tue Jul 07 2015 13:30:43][SmObjProvider.cpp:243][INFO][sm-Server-02830] Initializing policy store provider 'ODBC:'
[4852/5020][Tue Jul 07 2015 13:30:43][SmObjProvider.cpp:282][INFO][sm-Server-02840] Loading of policy store provider extension DLL: 'smobjodbcims' succeeded.
[4852/5020][Tue Jul 07 2015 13:30:45][SmObjCache.cpp:402][INFO][sm-Server-02800] Preloading policy store cache
[4852/5020][Tue Jul 07 2015 13:30:45][SmObjCache.cpp:415][INFO][sm-Server-02860] BulkFetch policy store
[4852/5020][Tue Jul 07 2015 13:32:20][SmAdapterStore.cpp:345][CSmAdapterStore::Init][ERROR][sm-xadobj-00010] Object store initialization failed.
[4852/5020][Tue Jul 07 2015 13:32:20][Database.cpp:513][GetSmInterface][FATAL][sm-xpsxps-03570] SiteMinder interface initialization failed.
[4852/5020][Tue Jul 07 2015 13:32:20][XPSTools.cpp:235][CXPSTools::CXPSTools][FATAL][sm-xpsxps-04120] Unable to initialize the XPS library.
I have not selected separate keystore (marked as ODBC), then also its giving this error.