Workflow Configuration completes with error for OWF 2.6.4 on 11g DB as below
WorkflowCA: default_temp TEMP
WorkflowCA: default_tablespace USERS
WorkflowCA: SQLPLUS:SYS/ /nolog @/orasw/app/oracle/product/11.1.0.6/owb/wf/sql/wfsysgnt.sql OWFMGR
WorkflowCA: ORA-01775: looping chain of synonyms
WorkflowCA: WorkflowCA: SQLException during execution: java.sql.SQLException: ORA-01775: looping chain of synonyms
: grant execute on xmldom to OWFMGR
WorkflowCA: File: /orasw/app/oracle/product/11.1.0.6/owb/wf/sql/wfsysgnt.sql.
WorkflowCA: oracle.apps.fnd.wf.install.utils.sql.SQLProcessorException: SQLException during execution: java.sql.SQLException: ORA-01775: looping chain of synonyms
: grant execute on xmldom to OWFMGR
oracle.apps.fnd.wf.install.utils.sql.SQLProcessorException: SQLException during execution: java.sql.SQLException: ORA-01775: looping chain of synonyms
: grant execute on xmldom to OWFMGR
at oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.processLine(SQLProcessor.java:2115)
at oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.executeSQLFile(SQLProcessor.java:2298)
at oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.runSQLFile(SQLProcessor.java:359)
at oracle.apps.fnd.wf.install.utils.sql.SQLProcessor.runSQLFile(SQLProcessor.java:329)
at oracle.apps.fnd.wf.install.db.WorkflowCA.handleSQL(WorkflowCA.java:5541)
at oracle.apps.fnd.wf.install.db.WorkflowCA.executeProcess(WorkflowCA.java:3498)
at oracle.apps.fnd.wf.install.db.WorkflowCA.grantPrivilege(WorkflowCA.java:5315)
at oracle.apps.fnd.wf.install.db.WorkflowCA.schemaCreation(WorkflowCA.java:1401)
at oracle.apps.fnd.wf.install.db.WfFrame.actionPerformed(WfFrame.java:2051)
at oracle.ewt.button.PushButton.processActionEvent(Unknown Source)
at oracle.ewt.lwAWT.LWButton.processActionEvent(Unknown Source)
at oracle.ewt.button.PushButton.processEventImpl(Unknown Source)
Solution:
This was caused as Oracle XML DB is not installed. Follow the below steps to solve this.
1.First check whetehr Oracle XML DB is installed or not. you can check this as below
SQL> select comp_name "Component" from dba_registry;
Component
--------------------------------------------------------------------------------
Oracle Enterprise Manager
Oracle Database Catalog Views
Oracle Database Packages and Types
JServer JAVA Virtual Machine
SQL> select * from dba_synonyms where SYNONYM_NAME like '%XMLDOM%';
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------------------------------------------------------
PUBLIC /118a4e7f_XMLDOMImplementation SYS /118a4e7f_XMLDOMImplementation
PUBLIC /2137556a_XMLDOMEvent SYS /2137556a_XMLDOMEvent
PUBLIC /64bcbda7_XMLDOMUserData SYS /64bcbda7_XMLDOMUserData
PUBLIC /7113b128_XMLDOMConfiguration SYS /7113b128_XMLDOMConfiguration
PUBLIC /765a7982_XMLDOMStringList SYS /765a7982_XMLDOMStringList
PUBLIC /79e741b8_XMLDOMImplementation SYS /79e741b8_XMLDOMImplementation
PUBLIC /de3a73b0_XMLDOMMutationEvent SYS /de3a73b0_XMLDOMMutationEvent
PUBLIC /e537a441_XMLDOMException SYS /e537a441_XMLDOMException
PUBLIC XMLDOM SYS XMLDOM
2.Install the Oracle XML db as mentioned in the below link.
Installing Oracle XML DB manually
3.Then check the installation using below commands.
SQL> select comp_name "Component" from dba_registry;
Component
--------------------------------------------------------------------------------
Oracle Enterprise Manager
Oracle Database Catalog Views
Oracle Database Packages and Types
JServer JAVA Virtual Machine
Oracle XDK
SQL> select * from dba_synonyms where SYNONYM_NAME like '%XMLDOM%';
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------------------------------------------------------
SYS XMLDOM XDB DBMS_XMLDOM
PUBLIC /118a4e7f_XMLDOMImplementation SYS /118a4e7f_XMLDOMImplementation
PUBLIC /2137556a_XMLDOMEvent SYS /2137556a_XMLDOMEvent
PUBLIC /64bcbda7_XMLDOMUserData SYS /64bcbda7_XMLDOMUserData
PUBLIC /7113b128_XMLDOMConfiguration SYS /7113b128_XMLDOMConfiguration
PUBLIC /765a7982_XMLDOMStringList SYS /765a7982_XMLDOMStringList
PUBLIC /79e741b8_XMLDOMImplementation SYS /79e741b8_XMLDOMImplementation
PUBLIC /de3a73b0_XMLDOMMutationEvent SYS /de3a73b0_XMLDOMMutationEvent
PUBLIC /e537a441_XMLDOMException SYS /e537a441_XMLDOMException
PUBLIC DBMS_XMLDOM XDB DBMS_XMLDOM
PUBLIC XMLDOM XDB DBMS_XMLDOM
11 rows selected.
4.Drop the workflow user as below
SQL> drop user OWFMGR cascade;
User dropped.
5.Start the workflow installation again using below command
$ORACLE_HOME/owb/wf/install/wfinstall.csh
No comments:
Post a Comment