Thursday, January 27, 2011

Delete Discoverer Workbook from backend

Hi,
I was facing couple of issues while deleting the Discoverere 10g workbook from front end.
I successfully deleted the same from backend.
Please find the scripts to delete particular workbook (select sql - to retrive and confim the workbook name ) and delete sql (pass the parameters as per the outcome/requirement of select statement.

eg:-
1)select * from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
2)select .DOC_NAME,d.DOC_DEVELOPER_KEY,p.notm,d.notm,d.DOC_DESCRIPTION,p.AP_ID,p.AP_TYPE,p.AP_EU_ID, p.GD_DOC_ID,d.doc_id from eul5_access_privs p, eul5_documents d where p.gd_doc_id=d.doc_id and d.doc_id=121412;
3)select * from eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
4)DELETE FROM eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';

5)delete from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
6)commit;

Hope this helps.
Don't forget to give your feedback. :-)
Regards
Guru

Error connecting to database ORA--1

While viewing log and ouput files I am getting below error in log/output window.
Error connecting to database (**** DB NAME****): ORA--1
I did lot of troubleshooting to find the cause of this error. Finally came across that APPLSYSPUP is in EXPIRED (GRACE) status . you can check this under dba_users cloumn account_status.
I changed the status to open using
Alter user APPLSYSPUB identified by PUB;
This resolved my issue.
Regards
Guru