6 Replies Latest reply on Mar 1, 2011 7:07 PM by David Heisler-Oracle

    Techstack validation utility

    jclifton
      Below is a snippet of log from the techstack validation utility. This project is a "Maintenance Pack Assistant for 11.5.10" iand the errors come from the "Pre-Update Tasks" - "Install and run the Release 11.5.10 technology stack validation utility" section. Does anyone have any idea why it wouldn't run the scripts properly? I'm confused why it says "The unique list of nodes is: ******** forms db" Is the ******** actually supposed to be a node name?

      Completed execution of ad1485e.sh.
      ========================================================
      Determining the list of unique applications nodes...

      ========================================================
      ===============================================================
      Running the Technology Validation Utility on the ******** node...
      Using the command:
      ======================================
      rsh beta.sunnen.com -l oracle EOF_IV/REMOTE115_APP.env perl /r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/TXKScript.pl \
      -script=/r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl \
      -txktop=/ropt/app/oracle/rexcomn/temp \
      -********pass=[your passwd] \
           -outfile=/ropt/app/oracle/rexcomn/temp/txkVal11510MP.html \
           -reporttype=text \
      -contextfile=/r01/oracle/rexappl/admin/REX.xml
      ======================================
      ==============================================================
      ********
      ERROR!!!
      ********
      The Technology Validation Utility failed to produce a log file on the ******** node.
      Please run the utility manually on this node.
      ========================================================
        • 1. Re: Techstack validation utility
          Srini Chavali-Oracle
          Is this a multi-node install ? The utility is trying to rsh to another node to execute the TXKScript.pl script. Can you rsh manually using the command "rsh beta.sunnen.com -l oracle" without errors ?

          Does the path "/ropt/app/oracle/rexcomn/temp/txkVal11510MP.html" exist on this node ?

          Alternatively you can run the command manually on the node as suggested.

          Srini
          • 2. Re: Techstack validation utility
            jclifton
            Is this a multi-node install ? - Yes, though MW happens to be running on beta

            Can you rsh manually using the command "rsh beta.sunnen.com -l oracle" without errors ? - Yes

            Does the path "/ropt/app/oracle/rexcomn/temp/txkVal11510MP.html" exist on this node ? - No the directory does though I wouldn't expect to find txkVal11510MP.html yet since it is the output file.

            Alternatively you can run the command manually on the node as suggested. - Thanks this is what I'm trying to do now. I just didn't know if this was some type of known MW bug.

            Thanks for the help,

            Jason
            • 3. Re: Techstack validation utility
              Hussein Sawwan-Oracle
              ======================================
              rsh beta.sunnen.com -l oracle EOF_IV/REMOTE115_APP.env perl /r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/TXKScript.pl \
              -script=/r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl \
              -txktop=/ropt/app/oracle/rexcomn/temp \
              -********pass=[your passwd] \
                   -outfile=/ropt/app/oracle/rexcomn/temp/txkVal11510MP.html \
              Please make sure that oracle user has write permission on /ropt/app/oracle/rexcomn/temp (on the remote node).

              Thanks,
              Hussein
              • 4. Re: Techstack validation utility
                jclifton
                Thanks for the suggestion Hussein but oracle does have write permission to /ropt/app/oracle/rexcomn/temp.

                When I run the TXKScript.pl manually and check the stdout.log I get the following results(below). It seems to run fine until it runs txkVal11510MP.pl. I'm off to see what txkVal11510MP.pl is exactly doing.

                Jason



                Program : /r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl started @ Thu Feb 24 09:48:25 2011

                *** STDOUT = /ropt/app/oracle/rexcomn/rgf/REX/TXK/txkVal11510MP_Thu_Feb_24_09_48_25_2011_stdout.log

                TXK::Validate:loadDocuments loading xml documents and creating action list
                TXK::Validate:loadDocuments loading of xml document files completed successfully.
                TXK:Validate:ProcessActions: Executing action method - txkGetContextVar
                TXK:Validate:ProcessActions: Action method - txkGetContextVar completed successfully.

                TXK:Validate:ProcessActions: Executing action method - txkCheckDisplay
                TXK:Validate:ProcessActions: Action method - txkCheckDisplay completed successfully.

                TXK:Validate:ProcessActions: Executing action method - getPerlVersion
                TXK:Validate:ProcessActions: Action method - getPerlVersion completed successfully.

                TXK:Validate:ProcessActions: Executing action method - getPerlVersion
                TXK:Validate:ProcessActions: Action method - getPerlVersion completed successfully.

                TXK:Validate:ProcessActions: Executing action method - txkGetJDKVersion
                TXK:Validate:ProcessActions: Action method - txkGetJDKVersion completed successfully.

                TXK:Validate:ProcessActions: Executing conditional method - txkIsCPJDKVersion14
                TXK:Validate:ProcessActions: Conditional method - txkIsCPJDKVersion14 completed successfully.

                TXK:Validate:ProcessActions: Executing action method - txkGetPortalVersion
                TXK:Validate:ProcessActions: Action method - txkGetPortalVersion completed successfully.

                TXK:Validate:ProcessActions: Executing action method - txkGetLoginServerVersion
                TXK:Validate:ProcessActions: Action method - txkGetLoginServerVersion completed successfully.

                TXK:Validate:ProcessActions: Executing action method - txkGetJDKVersion
                TXK:Validate:ProcessActions: Action method - txkGetJDKVersion completed successfully.

                *** Inside Validate::_getDBHosts()...
                Checking the OS...
                OS is UNIX based platform...
                SQL Command: SELECT lower(node_name)||'.'||lower(domain)||',' FROM fnd_nodes WHERE UPPER(support_db) = 'Y'
                Setting TXK_TOP...

                Errors encountered running /r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl

                *******FATAL ERROR*******
                PROGRAM : /r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl(./TXKScript.pl)
                TIME : Thu Feb 24 09:49:32 2011
                FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
                MESSAGES:
                SQLPLUS error: buffer=

                SQL*Plus: Release 8.0.6.0.0 - Production on Thu Feb 24 09:49:32 2011

                (c) Copyright 1999 Oracle Corporation. All rights reserved.

                SQL> SQL> Connected.
                SQL> SELECT lower(node_name)||'.'||lower(domain)||',' FROM fnd_nodes WHERE UPPER(support_db) = 'Y'
                *
                ERROR at line 1:
                ORA-00904: invalid column name


                Disconnected from Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
                With the Partitioning option
                JServer Release 8.1.7.3.0 - Production



                STACK TRACE
                TXK::Error::abort('TXK::Error', 'HASH(0x1d03f0)') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/Common.pm line 299
                TXK::Common::doError('TXK::SQLPLUS=HASH(0x100c09c)', 'SQLPLUS error: buffer=^J^JSQL*Plus: Release 8.0.6.0.0 - Production...', undef) called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/Common.pm line 314
                TXK::Common::setError('TXK::SQLPLUS=HASH(0x100c09c)', 'SQLPLUS error: buffer=^J^JSQL*Plus: Release 8.0.6.0.0 - Production...') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/SQLPLUS.pm line 832
                TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x100c09c)', 0) called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/SQLPLUS.pm line 234
                TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x100c09c)', 'HASH(0xce257c)') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/TechstackDB.pm line 599
                TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0xc6cc14)', 'SELECT lower(node_name)||\'.\'||lower(domain)||\',\' FROM fnd_no...') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/TechstackDB.pm line 563
                TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0xc6cc14)', 'SELECT lower(node_name)||\'.\'||lower(domain)||\',\' FROM fnd_no...') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/Validate.pm line 3235
                TXK::Validate::_getDBHosts('TXK::Validate=HASH(0xbd2f48)') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/Validate.pm line 1391
                TXK::Validate::_instantiateReportDefaults('TXK::Validate=HASH(0xbd2f48)') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/Validate.pm line 1734
                TXK::Validate::generateReport('TXK::Validate=HASH(0xbd2f48)', 'HASH(0x801718)') called at /r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl line 208
                require /r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/RunScript.pm line 105
                TXK::RunScript::require('TXK::RunScript', '/r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl') called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/Script.pm line 177
                eval {...} called at /r01/oracle/rexappl/au/11.5.0/perl/TXK/Script.pm line 177
                TXK::Script::run('TXK::Script=HASH(0x1340b4)', '/ropt/app/oracle/rexcomn/temp', '/r01/oracle/rexappl/fnd/11.5.0/patch/115/bin/txkVal11510MP.pl') called at ./TXKScript.pl line 106
                • 5. Re: Techstack validation utility
                  Hussein Sawwan-Oracle
                  SQL> SELECT lower(node_name)||'.'||lower(domain)||',' FROM fnd_nodes WHERE UPPER(support_db) = 'Y'
                  *
                  ERROR at line 1:
                  ORA-00904: invalid column name
                  Does this query run with no error?

                  SQL> SELECT lower(node_name)||'.'||lower(domain)||','
                  FROM fnd_nodes;

                  Can you find the two columns (node_name and domain) in the table?

                  Thanks,
                  Hussein
                  • 6. Re: Techstack validation utility
                    David Heisler-Oracle
                    Please look at the following not efor your issue - Technology Stack Validation Utility Error: ORA-00904: "SUPPORT_DB": invalid identifier (Doc ID 454448.1)

                    When the MW tool displays ******* it is a filter that converts "apps" to stars to prevent displaying passwords or other key information