Error when Unarchive sap supplied Repository

[Former Member]

I am try to unarchive the SP3_ARTICLE repository supplied SAP, however this is not working and i get the following errors.

We are on MDM 5.5 SP3 and SQL 2005. The database, MDM Server and MDM console are all on different servers.

The errors we get are as follows.

2616 2006/08/04 16:33:47.622 GMT OLEDB error on ustcas112/ from statement: SetDatabase to 'A2i_xCat_DBs'

2616 2006/08/04 16:33:47.622 GMT ErrorRecord->HResult/NativeErr: 0x80040e21/0

Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

Source/File/Line: Microsoft OLE DB Provider for SQL Server/.\OLEDB_DBConnection.cpp/1078

2616 2006/08/04 16:33:47.622 GMT ErrorRecord->HResult/NativeErr: 0x80004005/0

Description: Could not locate entry in sysdatabases for database 'A2i_xCat_DBs'. No entry found with that name. Make sure that the name is entered correctly.

Source/File/Line: Microsoft OLE DB Provider for SQL Server/.\OLEDB_DBConnection.cpp/1078

2616 2006/08/04 16:35:18.201 GMT OLEDB error on ustcas112/A2i_xCat_DBs from statement: SELECT Setting FROM A2i_CM_Settings WHERE Name='DataPath'

2616 2006/08/04 16:35:18.201 GMT OLEDB error on ustcas112/A2i_xCat_DBs from statement: SELECT Setting FROM A2i_CM_Settings WHERE Name='LogPath'

2616 2006/08/04 16:35:18.216 GMT OLEDB error on ustcas112/A2i_xCat_DBs from statement: SELECT Setting FROM A2i_CM_Settings WHERE Name='DefaultPartitions'

2616 2006/08/04 16:38:07.826 GMT Creating Repository: WAYNE_TEST, on DBMS Server: ustcas112

2616 2006/08/04 16:38:17.669 GMT OLEDB error on ustcas112/WAYNETEST_m000 from statement: SELECT TableId FROM A2i_CM_Tables WHERE TableType=0

2616 2006/08/04 16:38:17.685 GMT OLEDB error on ustcas112/WAYNETEST_m000 from statement: SELECT DataTableId FROM A2i_CM_Data_Tables WHERE DataTableType=6

2616 2006/08/04 16:38:18.685 GMT OLEDB error on ustcas112/WAYNETEST_m000 from statement: SELECT DataTableId FROM A2i_CM_Data_Tables WHERE DataTableType=6

2616 2006/08/04 16:38:19.482 GMT OLEDB error on ustcas112/WAYNETEST_m000 from statement: SELECT DataTableId FROM A2i_CM_Data_Tables WHERE DataTableType=6

2616 2006/08/04 16:38:22.029 GMT OLEDB error on ustcas112/WAYNETEST_m000 from statement: SELECT DataTableId FROM A2i_CM_Data_Tables WHERE DataTableType=6

2616 2006/08/04 16:38:22.716 GMT OLEDB error on ustcas112/WAYNETEST_m000 from statement: SELECT DataTableId FROM A2i_CM_Data_Tables WHERE DataTableType=6

2616 2006/08/04 16:38:35.326 GMT Init Database Tag: WAYNE_TESTUSTCAS112MSQL_10_9_4_3

2616 2006/08/04 16:38:35.826 GMT Repository WAYNE_TEST creation completed OK

2616 2006/08/04 16:38:39.247 GMT UnArchive starting to server: ustcas112, target Repository: WAYNE_TEST, archivePath: D:\SAP_MDM\Server\Archives\SP3_ARTICLE.a2a

2616 2006/08/04 16:38:45.372 GMT OLEDB error on ustcas112/WAYNETEST_m000 from statement: DROP TABLE user_token

2616 2006/08/04 16:38:45.372 GMT ErrorRecord->HResult/NativeErr: 0x80040e37/0

Description: Cannot drop the table 'user_token', because it does not exist or you do not have permission.

Source/File/Line: Microsoft OLE DB Provider for SQL Server/.\OLEDB_DBConnection.cpp/1668

2616 2006/08/04 16:38:45.372 GMT UnArchive to server: ustcas112, target Repository: WAYNE_TEST, archivePath: D:\SAP_MDM\Server\Archives\SP3_ARTICLE.a2a ended in error

I have read some of the forums that have had the same problems but this has not helped.

[Former Member]

Yes the log and data paths have been set correctly in the dbms settings.

[Former Member]

Hi Wayne,

Have you mentiond the data path and log path correctly?

Are u able to do the reamining repository operations.

Also go through the link

http://help.sap.com/saphelp_mdmgds55/helpdata/EN/42/fb48b0481e1a61e10000000a422035/content.htm

Hope that helps!

Regards,

Tanveer.

<b>Please mark helpful answers</b>