txkFrmUTF8.pl and txkGenExtSecConf.pl fail during autoconfig

Recently I got a call from Sesh who said that Autoconfig had errored out on Application tier (Apache, Jserv, Forms). Here are the errors in autoconfig.log:

[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:


[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: $IAS_ORACLE_HOME/Apache/perl/bin/perl -I $IAS_ORACLE_HOME/Apache/perl/lib/5.00503 -I $IAS_ORACLE_HOME/Apache/perl/lib/site_perl/5.
005 -I $APPL_TOP/au/11.5.0/perl $COMMON_TOP/admin/install/$CONTEXT_NAME
txkFrmUTF8.pl INSTE8_SETUP 1

[APPLY PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: $IAS_ORACLE_HOME/Apache/perl/bin/perl -I $IAS_ORACLE_HOME/Apache/perl/lib/5.00503 -I $IAS_ORACLE_HOME/Apache/perl/lib/site_perl/5.
005 -I $APPL_TOP/au/11.5.0/perl $COMMON_TOP/admin/install/$CONTEXT_NAME
txkGenExtSecConf.pl INSTE8_APPLY 1


AutoConfig is exiting with status 2

I ran the file txkFrmUTF8.pl file manually and this is what I got:

SQL Command: SELECT language_code||',' FROM fnd_languages WHERE installed_flag IN ('B','I') AND language_code NOT IN ('US', 'SQ','IS','LT','VN')
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (txkFrmUTF8.pl)
TIME : Tue Sep 2 16:07:34 2008
FUNCTION: TXK::IO::open [ Level 3 ]
MESSAGES:
error = Unable to open file by ref
errorno = Illegal seek

STACK TRACE
TXK::Error::abort('TXK::Error', 'HASH(0x1d01d8)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/Common.pm line 299
TXK::Common::doError('TXK::IO=HASH(0xd625b0)', 'HASH(0x60f7b0)', undef) called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/Common.pm line 314
TXK::Common::setError('TXK::IO=HASH(0xd625b0)', 'HASH(0x60f7b0)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/IO.pm line 302
TXK::IO::open('TXK::IO=HASH(0xd625b0)', 'HASH(0xd63b04)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/SQLPLUS.pm line 601
TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x5794a4)', 'true') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/SQLPLUS.pm line 376
TXK::SQLPLUS::validateConnectInfo('TXK::SQLPLUS=HASH(0x5794a4)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/SQLPLUS.pm line 267
TXK::SQLPLUS::setConnectInfo('TXK::SQLPLUS=HASH(0x5794a4)', 'HASH(0x14d95c)') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/TechstackDB.pm line 588
TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x59cd78)', 'SELECT language_code||\',\' FROM fnd_languages WHERE installed_f...') called at /gpsess76/erpapp/appl/au/11.5.0/perl/TXK/TechstackDB.pm line 563
TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x59cd78)', 'SELECT language_code||\',\' FROM fnd_languages WHERE installed_f...') called at txkFrmUTF8.pl line 147
eval {...} called at txkFrmUTF8.pl line 112
)
ERRORCODE = 1 ERRORCODE_END

There are various metalink notes on errors thrown by txkFrmUTF8.pl. However none of them is having the exact error we faced. I finally tried a workaround of changing the perl version which worked:

$ ADPERLPRG=/opt/VRTSperl/bin/perl
$ export ADPERLPRG

$ PERL5LIB=/opt/VRTSperl/lib/5.8.8:/opt/VRTSperl/lib/site_perl/5.8.8:$AU_TOP/perl
$ export PERL5LIB


$ $ADPERLPRG txkFrmUTF8.pl


Script Name : txkFrmUTF8.pl
Started : Mon Sep 8 13:54:00 EDT 2008


Enter the APPS username: apps

Enter the APPS password:
ORACLE_HOME : $ORACLE_HOME
LD_LIBRARY_PATH : $ORACLE_HOME/network/jre11/lib/sparc/native_threads:$APPL_TOP/cz/11.5.0/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
PATH : $IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$APPL_TOP/ad/11.5.0/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
ORA_NLS :
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_NUMERIC_CHARACTERS : .,
NLS_SORT : binary
CONTEXT_NAME : $CONTEXT_NAME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TXK_TOP :
APPLTMP : $COMMON_TOP/temp
TWO_TASK : $TWO_TASK
ORACLE_LOCALPREFERENCE : $ORACLE_HOME/tools/admin
TNS CONNECT STRING : $TWO_TASK
SQLPLUS : $ORACLE_HOME/bin/sqlplus


After Setting Environment

ORACLE_HOME : $ORACLE_HOME
LD_LIBRARY_PATH : $ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/network/jre11/lib/sparc/native_threads:$APPL_TOP/cz/11.5.0/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
PATH : $ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:$IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$APPL_TOP/ad/11.5.0/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
ORA_NLS : $ORACLE_HOME/ocommon/nls/admin/data
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_NUMERIC_CHARACTERS : .,
NLS_SORT : binary
CONTEXT_NAME : $CONTEXT_NAME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TXK_TOP : $COMMON_TOP/rgf/$CONTEXT_NAME
APPLTMP : $COMMON_TOP/temp
TWO_TASK : $TWO_TASK
ORACLE_LOCALPREFERENCE : $ORACLE_HOME/tools/admin
TNS CONNECT STRING : $TWO_TASK
SQLPLUS : $ORACLE_HOME/bin/sqlplus
Setting of Environment completed.

SQL Command: SELECT language_code||',' FROM fnd_languages WHERE installed_flag IN ('B','I') AND language_code NOT IN ('US', 'SQ','IS','LT','VN')
Installed Languages:
D
F
FRC
HU
I
Successfully Completed the script
ERRORCODE = 0 ERRORCODE_END
$ $ADPERLPRG

$ $ADPERLPRG txkGenExtSecConf.pl

Enter the APPS username: APPS

Enter the APPS password:
SQLPLUS : $ORACLE_HOME/bin/sqlplus
ORACLE_HOME : $ORACLE_HOME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
TWO_TASK : $TWO_TASK
PATH : $IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$AD_TOP/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
TNS CONNECT STRING : $TWO_TASK
LD_LIBRARY_PATH : $ORACLE_HOME/network/jre11/lib/sparc/native_threads:$CZ_TOP/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_SORT : binary
NLS_NUMERIC_CHARACTERS : .,


After Setting Environment

SQLPLUS : $ORACLE_HOME/bin/sqlplus
ORACLE_HOME : $ORACLE_HOME
AD_TOP : $APPL_TOP/ad/11.5.0
FND_TOP : $FND_TOP
TNS_ADMIN : $ORACLE_HOME/network/admin/$CONTEXT_NAME
PATH : $ORACLE_HOME/bin:$IAS_ORACLE_HOME/Apache/perl/bin:$ORACLE_HOME/bin:$FND_TOP/bin:$AD_TOP/bin:$COMMON_TOP/util/jdk1.6.0_05/bin:$COMMON_TOP/util/unzip/unzip::$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/openwin/bin:/usr/dt/bin:/sbin:/usr/sbin:/usr/platform/sun4u/sbin:/usr/ucb:/usr/ccs/bin:/usr/java/bin
LD_LIBRARY_PATH : $ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:$ORACLE_HOME/network/jre11/lib/sparc/native_threads:$CZ_TOP/bin:$ORACLE_HOME/lib:/usr/dt/lib:/usr/openwin/lib:/usr/webmethods/lib
NLS_LANG : American_America.UTF8
NLS_DATE_FORMAT : DD-MON-RR
NLS_SORT : binary
NLS_NUMERIC_CHARACTERS : .,
TXK_TOP : $COMMON_TOP/rgf/$CONTEXT_NAME

Setting of Environment completed.

IAS PatchSet : 5
Uncommenting in $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf :
#ServerHeader Off
Uncommented :
ServerHeader Off


Uncommenting in $IAS_ORACLE_HOME/Apache/Apache/conf/httpd.conf :
#OpmMtxFile $IAS_ORACLE_HOME/Apache/Apache/logs/opm_sys_mtx.pid
Uncommented :
OpmMtxFile $IAS_ORACLE_HOME/Apache/Apache/logs/opm_sys_mtx.pid


Uncommenting in $IAS_ORACLE_HOME/Apache/Apache/conf/httpd_pls.conf :
#ServerHeader Off
Uncommented :
ServerHeader Off


ERRORCODE = 0 ERRORCODE_END

To ensure that this works when you run adconfig.sh, make changes to the value of s_adperlprg and s_perl5lib in the context file:

s_adperlprg = /opt/VRTSperl/bin/perl
s_perl5lib = /opt/VRTSperl/lib/5.8.8:/opt/VRTSperl/lib/site_perl/5.8.8:$AU_TOP/perl