Datadictionary job is failing

vikas.chaudhary@us.pwc.com

Hi,

Datadictionary Publishing job is failing with below error message:

Command Failed: link,s0,09013881801c85e9,'/Temp/Jobs/dm_DataDictionaryPublisher', status: 0, with error message [DM_API_E_QUERY_FAIL]error: "Query failed: select r_object_id from dm_folder where any r_folder_path = '/Temp/Jobs/dm_DataDictionaryPublisher'

DQL query is working but API mentioned in the error message not working.

Job report is getting generated under dba/log/xxxx/sysadmin/

Important and interesting point is that if you have superuser access, you wont be able to navigate through the folders under cabinets. I am able to see on left hand pane, but in right hand side nothing comes. Normal end users are not facing any kind of issue(other than superusers/dmadmin access).

Kindly advise if someone is aware of this.

Thanks in advance.

Find more posts tagged with

Comments

Saswata Mandal

Hi Vikash,

The datadictionary can also be published by the following API Command :-

API> publish_dd,c

Thanks & Regards

saswata mandal.

vikas.chaudhary@us.pwc.com

Thanks Saswata, I did that and its working fine.

But regarding the other issue, in which superusers are not able to navigate folders.

Also, when i tried to see the properties of any user, i am also getting below message:

vikas.chaudhary@us.pwc.com

After investigation, we found that issue is a known oracle bug#9577583.

Need to clear below cache on database server:

Buffer cache

Sharepool

Result cache

After clearing the cache, job completed and we can see the content of cabinets in right hand side.

Thanks all.