cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Unable to archive repository ?

Former Member

on ‎12-01-2010 6:30 AM

0 Kudos

Hi,

I am unable to archive repository.

While archiving i m checking the repository, there i got 1 non fatal error. I have tried for repair also , but it shows 0 of 1 non fatal error repaired.

I got detail report for that check. But i dont understand where exactly the issue is.

Could any please check and let me know the issue.

4627 2010/12/01 11:46:41.715 Report Info Horizontal@Database XCatDBVerify2.cpp Starting Repository Verify

4627 2010/12/01 11:46:41.722 Report Info Horizontal@Database XCatDBVerify2.cpp Begin verifying repository 'ASIA_MDM_CATALOG' on 'RIA'(Oracle 11.2.0.1.0) --- report only (Check Level=3, Fix Level=0 Keep User Object=1) The schema version of repository 'ASIA_MDM_CATALOG' is 13.013.

4627 2010/12/01 11:46:41.723 Report Info Horizontal@Database XCatDBVerify2.cpp The new schema version of repository 'ASIA_MDM_CATALOG' on 'RIA' is 13.13

4627 2010/12/01 11:46:41.723 Report Info Horizontal@Database XCatDBVerify2.cpp Checking database structure (tables, columns, indexes)...

4627 2010/12/01 11:46:41.730 Report Info Horizontal@Database XCatDBVerify2.cpp Table A2i_xCat_DBs.A2i_Catalogs: (4 records)

4627 2010/12/01 11:46:41.736 Report Info Horizontal@Database XCatDBVerify.cpp Field CATALOG_TAG: NVARCHAR2(128), not null

4627 2010/12/01 11:46:41.737 Report Info Horizontal@Database XCatDBVerify.cpp Field MAINDB: NVARCHAR2(128), not null

4627 2010/12/01 11:46:41.737 Report Info Horizontal@Database XCatDBVerify.cpp Field ORIGDB: NVARCHAR2(128), not null

4627 2010/12/01 11:46:41.737 Report Info Horizontal@Database XCatDBVerify.cpp Field THUMBDB: NVARCHAR2(128), not null

4627 2010/12/01 11:46:41.737 Report Info Horizontal@Database XCatDBVerify.cpp Field VARIANTDB: NVARCHAR2(128), not null

4627 2010/12/01 11:46:41.737 Report Info Horizontal@Database XCatDBVerify.cpp Field STATUS: NUMBER(10), not null, default 0

4627 2010/12/01 11:46:41.737 Report Info Horizontal@Database XCatDBVerify.cpp Field DESCRIPTION: NVARCHAR2(255), null

4627 2010/12/01 11:46:41.744 Report Info Horizontal@Database XCatDBVerify.cpp Index ICAT_CAT_TAG on (CATALOG_TAG), unique

4627 2010/12/01 11:46:41.750 Report Info Horizontal@Database XCatDBVerify2.cpp Table A2i_xCat_DBs.A2i_DB_Settings: (12 records)

4627 2010/12/01 11:46:41.756 Report Info Horizontal@Database XCatDBVerify.cpp Field NAME: NVARCHAR2(128), not null

4627 2010/12/01 11:46:41.756 Report Info Horizontal@Database XCatDBVerify.cpp Field SETTING: NVARCHAR2(255), null

4627 2010/12/01 11:46:41.762 Report Info Horizontal@Database XCatDBVerify.cpp Index IDBSETTINGS_NAME on (NAME), unique

4627 2010/12/01 11:46:41.767 Report Info Horizontal@Database XCatDBVerify2.cpp Table A2i_xCat_DBs.A2i_ServerStatus: (3 records)

4627 2010/12/01 11:46:41.774 Report Info Horizontal@Database XCatDBVerify.cpp Field SERVERNAME: NVARCHAR2(50), not null

4627 2010/12/01 11:46:41.774 Report Info Horizontal@Database XCatDBVerify.cpp Field CATALOG_TAG: NVARCHAR2(128), not null

4627 2010/12/01 11:46:41.774 Report Info Horizontal@Database XCatDBVerify.cpp Field SERVERLOCKMASK: NUMBER(10), not null

4627 2010/12/01 11:46:41.774 Report Info Horizontal@Database XCatDBVerify.cpp Field STARTUPTIME: DATE, not null

4627 2010/12/01 11:46:41.774 Report Info Horizontal@Database XCatDBVerify.cpp Field LASTCHECKIN: DATE, not null

4627 2010/12/01 11:46:41.781 Report Info Horizontal@Database XCatDBVerify.cpp Index ISERVER_SN on (SERVERNAME,CATALOG_TAG), unique

4627 2010/12/01 11:46:41.916 Report Info Horizontal@Database XCatDBVerify2.cpp Table ASIAMDMCATALOG_m000.A2i_CatalogSettings: (35 records)

4627 2010/12/01 11:46:41.923 Report Info Horizontal@Database XCatDBVerify.cpp Field SETTINGID: NUMBER(10), not null

4627 2010/12/01 11:46:41.923 Report Info Horizontal@Database XCatDBVerify.cpp Field SETTINGSTRING: NVARCHAR2(255), not null

4627 2010/12/01 11:46:41.923 Report Info Horizontal@Database XCatDBVerify.cpp Field DESCRIPTION: NVARCHAR2(255), null

4627 2010/12/01 11:46:41.930 Report Info Horizontal@Database XCatDBVerify.cpp Index CCATSETTINGS_ID on (SETTINGID), unique

4627 2010/12/01 11:46:41.936 Report Info Horizontal@Database XCatDBVerify2.cpp Table ASIAMDMCATALOG_m000.A2i_CM_Languages: (1 records)

4627 2010/12/01 11:46:41.942 Report Info Horizontal@Database XCatDBVerify.cpp Field LANGID: NUMBER(10), not null

4627 2010/12/01 11:46:41.942 Report Info Horizontal@Database XCatDBVerify.cpp Field LANGUAGEORDER: NVARCHAR2(255), not null

4627 2010/12/01 11:46:41.943 Report Info Horizontal@Database XCatDBVerify.cpp Field CUTOFFPOS: NUMBER(10), not null

4627 2010/12/01 11:46:41.943 Report Info Horizontal@Database XCatDBVerify.cpp Field POSITION: NUMBER(10), not null

4627 2010/12/01 11:46:41.950 Report Info Horizontal@Database XCatDBVerify.cpp Index ILANGUAGES_POS on (POSITION), unique

4627 2010/12/01 11:46:41.950 Report Info Horizontal@Database XCatDBVerify.cpp Index CLANGUAGES_LID on (LANGID), unique

4627 2010/12/01 11:46:41.956 Report Info Horizontal@Database XCatDBVerify2.cpp Table ASIAMDMCATALOG_m000.A2i_CM_LanguageLookup: (26 records)

4627 2010/12/01 11:46:41.962 Report Info Horizontal@Database XCatDBVerify.cpp Field LANGUAGECODE: NVARCHAR2(3), not null

4627 2010/12/01 11:46:41.963 Report Info Horizontal@Database XCatDBVerify.cpp Field COUNTRYCODE: NVARCHAR2(2), not null

4627 2010/12/01 11:46:41.963 Report Info Horizontal@Database XCatDBVerify.cpp Field REGIONCODE: NVARCHAR2(3), not null

4627 2010/12/01 11:46:41.963 Report Info Horizontal@Database XCatDBVerify.cpp Field REGIONNAME: NVARCHAR2(255), not null

4627 2010/12/01 11:46:41.963 Report Info Horizontal@Database XCatDBVerify.cpp Field LANGUAGECOLLATION: NVARCHAR2(50), null

4627 2010/12/01 11:46:41.963 Report Info Horizontal@Database XCatDBVerify.cpp Field LANGID: NUMBER(10), not null

4627 2010/12/01 11:46:41.970 Report Info Horizontal@Database XCatDBVerify.cpp Index ICLANGL_LANREG on (LANGUAGECODE,REGIONCODE), unique

4627 2010/12/01 11:46:41.971 Report Info Horizontal@Database XCatDBVerify.cpp Index ICLANGL_LID on (LANGID), unique

4627 2010/12/01 11:46:41.976 Report Info Horizontal@Database XCatDBVerify2.cpp Table ASIAMDMCATALOG_m000.A2i_CM_Users: (14 records)

4627 2010/12/01 11:46:41.984 Report Info Horizontal@Database XCatDBVerify.cpp Field USERID: NUMBER(10), not null

4627 2010/12/01 11:46:41.984 Report Info Horizontal@Database XCatDBVerify.cpp Field USERNAME: NVARCHAR2(30), not null

4627 2010/12/01 11:46:41.984 Report Info Horizontal@Database XCatDBVerify.cpp Field PASSWORD: NVARCHAR2(255), not null

4627 2010/12/01 11:46:41.984 Report Info Horizontal@Database XCatDBVerify.cpp Field FULLNAME: NVARCHAR2(255), null

4627 2010/12/01 11:46:41.984 Report Info Horizontal@Database XCatDBVerify.cpp Field DESCRIPTION: NVARCHAR2(255), null

4627 2010/12/01 11:46:41.984 Report Info Horizontal@Database XCatDBVerify.cpp Field USEREMAILS: NVARCHAR2(255), null

4627 2010/12/01 11:46:41.984 Report Info Horizontal@Database XCatDBVerify.cpp Field ACCOUNTLOCKED: NUMBER(10), null

4627 2010/12/01 11:46:41.985 Report Info Horizontal@Database XCatDBVerify.cpp Field FAILEDPASSWORDATTEMPTS: NUMBER(10), null

4627 2010/12/01 11:46:41.985 Report Info Horizontal@Database XCatDBVerify.cpp Field VALIDFROM: DATE, null

4627 2010/12/01 11:46:41.985 Report Info Horizontal@Database XCatDBVerify.cpp Field VALIDTHROUGH: DATE, null

Could any please let me know the issue.

Regards

Venkatesh P

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
‎12-02-2010 5:29 PM
0 Kudos

Hi Venkatesh,

Try Unload - Load with Update Indices option first. Non-fatal error should not stop you in Archiving Repository. If this doesn't work then you may need to restart MDM server once.

Regards,

Jitesh

Show replies
Show replies
Former Member
‎12-03-2010 4:46 AM
0 Kudos

Issue solved.

Error due to out of space in database.

Regards

Venkatesh P

Ask a Question