AutoConfig Fails with status 1, adop_valid_nodes table or view does not exist

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

AutoConfig Fails with status 1, adop_valid_nodes table or view does not exist

Dhanu
We tried creating the " adop_valid_nodes" using below utility but we are not able to create it successfully.

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp applsys apps thin atlantis:1522:atlantis table $FND_TOP/patch/115/xdf/adop_valid_nodes.xdf $FND_TOP/patch/115/xdf/xsl changedb=y logfile=/tmp/log.out

Error message for adjava:
-----------------------------------

                     Copyright (c) 2002, 2012 Oracle Corporation
                        Redwood Shores, California, USA

                                    AD Java

                                 Version 12.2.0

NOTE: You may not use this utility for custom development
      unless you have written permission from Oracle Corporation.

Reading product information from file...

Reading language and territory information from file...

Reading language information from applUS.txt ...
  Temporarily resetting CLASSPATH to:
  "/u02/app/atlantis/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/u02/app/atlantis/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/u02/app/atlantis/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/u02/app/atlantis/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/u02/app/atlantis/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u02/app/atlantis/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/u02/app/atlantis/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u02/app/atlantis/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/u02/app/atlantis/fs1/EBSapps/comn/java/classes:/u02/app/atlantis/fs1/EBSapps/10.1.2/forms/java:/u02/app/atlantis/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/u02/app/atlantis/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/u02/app/atlantis/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"

  Calling /u02/app/atlantis/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...
Exception occured
              Copyright (c) 2003 Oracle Corporation
                 Redwood Shores, California, USA
         XDF(XML Object Description File) Comparison Utility


Invalid JDBC driver type for P5valid values are THIN or OCI8

Usage :
java oracle.apps.fnd.odf2.FndOdfCmp <schemaId> <schemaPassword> <appId> <appPassword><jdbc driver type> <jdbc tns info> <object_type> <xdf file Name> [CLONE_UN=<apps_clone_schema_id> CLONE_PW=<apps_clone_schema_password> SPEC_UN=<table_specs_schema_id> SPEC_PW=<table_specs_schema_password>] <xsl file Dir>[deferred=<list>] [dropCr=<list>] [logfile=<filename>] [changedb=<y/n>] [data_sec_vpd=<y/n>] [parallel_index_threshold=<block count>] [index_category=<small/large/both>] [prompt_password=<yes/no>]

Mandatory Arguments

schema_name : ORACLE schema name in which the object exists or should be created.

schema_Pwd :  ORACLE schema password in which the object exists or should be created.

apps_schema : ORACLE schema name of current APPS schema
-
-
-
-
-

index_category : The default of index_category=both.
The mode of operation of index creation. 'small', 'large', 'both' are the valid modes

prompt_password : Utility should prompt for password rather than expecting passwords in commandline

For more information, refer to Chapter 8, "XML Definition File Utilities" in Oracle E-Business Suite Developer's Guide.
Reply | Threaded
Open this post in threaded view
|

Re: AutoConfig Fails with status 1, adop_valid_nodes table or view does not exist

Dhanu
Dear Erman,

Please help me in fixing this issue. We are not able to fix this.


Regards
Dhanu
Reply | Threaded
Open this post in threaded view
|

Re: AutoConfig Fails with status 1, adop_valid_nodes table or view does not exist

ErmanArslansOracleBlog
Administrator
It seems your syntax is not correct.

It seems you are missing an argument..

Here is the usage:

java oracle.apps.fnd.odf2.FndOdfCmp <schemaId> <schemaPassword> <appId> <appPassword><jdbc driver type> ...............................

Here is an example:

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp applsys APPS apps APPS thin <host>:<PORT>:<SID> table $AD_TOP/patch/115/xdf/ad_adop_session_patches.xdf .........................

So you are missing 2 APPS there.. Check your command ->>>

adjava -mx512m -nojit oracle.apps.fnd.odf2.FndXdfCmp applsys apps "missing arguments here" thin atlantis:1522:atlantis table ............................