My Oracle Support Banner

Best Practices To Delete LSH Or DMW Objects (Doc ID 2400342.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.7 and later
Oracle Life Sciences Data Hub - Version 2.4.5 and later
Information in this document applies to any platform.

Goal

What are the best practices to delete DMW and LSH objects?

DMW


For example, if you are using a Template for your Study, and you need to delete some models/objects from there, you may hit unexpected errors like:

1. DMW-<NNN>: ERROR: An unexpected error occurred while processing the data. Please try again. If the error persists please contact the system administrator.


2. DMW-<NNN>: Returned Status: U Msg:null. DB-API must return exception


3. DMW-<NNN>: Multiple Exceptions thrown
DMW-<NNN>: ORA-01403: no data found in Package doOperation Procedure DME_DF_XFORM_MAP

DMW-<NNN>: SQL Error Occurred ORA-ERR No : ORA-01403: no data found, Function Name : doOperation, Package Name : DME_DF_XFORM_MAP. Please contact your System Administrator.

LSH

When you delete some objects on LSH, you may hit errors as below:

XFM_INSTALL:15-JAN-18 22:03:51:Object Name cannot begin with a TILDE (~).
Please remove the TILDE character and proceed.
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin
CDR_WE19_1B5E41_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;"
caught:java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined
exception
ORA-06512: at "APPS.DME_INST_XFORM_MAP", line 10070
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 19965
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 12504
ORA-06512: at "CDR_WE19_1B5E41_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

  

Other symptom you may notice is some object names will include a tilde at the beginning (~). This tilde is harmless, but it can help you to detect if an object was deleted. For example, you may see tildes in front of the Tables name in Production lifecycle.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
 DMW
 LSH
Solution
 Workaround if you are already hitting these errors
 Best practices to avoid them
 LSH
 Workarounds
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.