Tag Archives: Compile

FAILED: file OKLTXRBKUG.sql on worker while running patch 9239090

Posted by on January 30, 2012 No comments

Problem:

While running patch 9239090, the following error appears:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file OKLTXRBKUG.sql on worker  1.
           FAILED: file OKLTXRBKUG.sql on worker  2.
           FAILED: file OKLTXRBKUG.sql on worker  3.
           FAILED: file OKLTXRBKUG.sql on worker  4.
           FAILED: file OKLTXRBKUG.sql on worker  5.
           FAILED: file OKLTXRBKUG.sql on worker  6.
           FAILED: file OKLTXRBKUG.sql on worker  7.
           FAILED: file OKLTXRBKUG.sql on worker  8.
           FAILED: file OKLTXRBKUG.sql on worker  9.
           FAILED: file OKLTXRBKUG.sql on worker 10.
           FAILED: file OKLTXRBKUG.sql on worker 11.
           FAILED: file OKLTXRBKUG.sql on worker 12.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Solution:

The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus as sysdba and ran the following commands:

alter package APPS.OKL_TXL_ASSETS_PVT compile;
alter package APPS.OKL_TXL_ASSETS_PVT compile body;
alter package APPS.OKL_TXL_ASSETS_PUB compile;
alter package APPS.OKL_TXL_ASSETS_PUB compile body;
alter package APPS.OKL_SPLIT_ASSET_PVT compile;
alter package APPS.OKL_SPLIT_ASSET_PVT compile body;
alter package APPS.OKL_SECURITIZATION_PVT compile;
alter package APPS.OKL_SECURITIZATION_PVT compile body;
alter package APPS.OKL_TRANSACTION_PVT compile;
alter package APPS.OKL_TRANSACTION_PVT compile body;

OKL_TRANSACTION_PVT now compiles without issue.

To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:

select count(*) from dba_objects where status = ‘INVALID’;

Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.

FAILED: file OKLTXRBKUG.sql on worker 1

Posted by on January 30, 2012 No comments

Problem:

While running patch 9239090, the following error appears:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file OKLTXRBKUG.sql on worker  1.
           FAILED: file OKLTXRBKUG.sql on worker  2.
           FAILED: file OKLTXRBKUG.sql on worker  3.
           FAILED: file OKLTXRBKUG.sql on worker  4.
           FAILED: file OKLTXRBKUG.sql on worker  5.
           FAILED: file OKLTXRBKUG.sql on worker  6.
           FAILED: file OKLTXRBKUG.sql on worker  7.
           FAILED: file OKLTXRBKUG.sql on worker  8.
           FAILED: file OKLTXRBKUG.sql on worker  9.
           FAILED: file OKLTXRBKUG.sql on worker 10.
           FAILED: file OKLTXRBKUG.sql on worker 11.
           FAILED: file OKLTXRBKUG.sql on worker 12.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Solution:

The OKL_TRANSACTION_PVT package was invalid. When this was compiled, the OKL_SECURITIZATION_PVT was invalid. In this way, a number of OKL packages were invalid and the error was cascading. In order to resolve the issue, I logged on to SQL*Plus and ran the following commands:

alter package APPS.OKL_TXL_ASSETS_PVT compile;
alter package APPS.OKL_TXL_ASSETS_PVT compile body;
alter package APPS.OKL_TXL_ASSETS_PUB compile;
alter package APPS.OKL_TXL_ASSETS_PUB compile body;
alter package APPS.OKL_SPLIT_ASSET_PVT compile;
alter package APPS.OKL_SPLIT_ASSET_PVT compile body;
alter package APPS.OKL_SECURITIZATION_PVT compile;
alter package APPS.OKL_SECURITIZATION_PVT compile body;
alter package APPS.OKL_TRANSACTION_PVT compile;
alter package APPS.OKL_TRANSACTION_PVT compile body;

OKL_TRANSACTION_PVT now compiles without issue.

To resolve this in future, use adadmin to compile APPS schema. Afterwards, issue the following SQL statement in SQL*Plus to get the number of invalid objects:

select count(*) from dba_objects where status = ‘INVALID’;

Continue compiling APPS schema with adadmin and checking the number of invalid objects until that number no longer decreases.

Unable to compile WSH_FTE_TP_INTEGRATION, WSH_TRIP_STOPS_GRP Package Bodies

Posted by on September 20, 2011 No comments

Unable to compile WSH_FTE_TP_INTEGRATION, WSH_TRIP_STOPS_GRP Package Bodies

Problem:

While running patch 9239090 (R12.1.3 RUP) on Windows, the following Oracle Forms objects did not generate successfully:

wsh     forms/US        WSHQSSUI.fmx
wsh     forms/US        WSHSTREF.fmx
wsh     forms/US        WSHFSTRX.fmx

To resolve this, the invalid WSH packages were identified and compiled. However, while compiling the invalid WSH package bodies, compilation errors resulted.

Solution: Flush the shared pool before compiling the package bodies.

Read more »

Compiling COBOL Programs using cblbld

Posted by on December 23, 2008 No comments

In Command Prompt, run the following commands:

set PS_HOME=E:PSOFTFS900
set COBROOT=E:cobolBase
cd /d E:PSOFTFS900setup
cblbld E: tempcompile_20081223a

set PS_HOME=E:PSOFTFS900
set COBROOT=”C:Program FilesMicro FocusNet Express 5.0Base”
cd /d E:PSOFTFS900setup
cblbld E: tempcompile_20081223b

Problem:

After compiling, the following is displayed:

File(s) that failed to compile or link:
.
Compile error for FSPCTADJ.obj
Compile error for FSPYCLOG.obj
Compile error for GLPCEARN.obj
Compile error for GLPCIPNL.obj
Compile error for GLPCPROC.obj
Compile error for GLPOELIM.obj
Compile error for GLPPBKCD.obj
Compile error for GLPPINWK.obj
Compile error for GLPPRVRS.obj
Compile error for GLPPUNPS.obj
Compile error for PTPSQLGS.obj
The error list is in E:tempcompileERROR.LIS
.
Aborting this process !!! EXEs/GNTs/INTs are not going to be copied/replaced…
.
Please fix the errors and rerun this batch file !!!!!!!

Solution:

Check the CBLBLD.LOG file for details:

The E:tempcompileERROR.LIS file showed:

Compile error for FSPCTADJ.obj
Compile error for FSPYCLOG.obj
Compile error for GLPCEARN.obj
Compile error for GLPCIPNL.obj
Compile error for GLPCPROC.obj
Compile error for GLPOELIM.obj
Compile error for GLPPBKCD.obj
Compile error for GLPPINWK.obj
Compile error for GLPPRVRS.obj
Compile error for GLPPUNPS.obj
Compile error for PTPSQLGS.obj

Check the list file for the above files:

FSPCTADJ.LIS
FSPYCLOG.LIS
GLPCEARN.LIS
GLPCIPNL.LIS
GLPCPROC.LIS
GLPOELIM.LIS
GLPPBKCD.LIS
GLPPINWK.LIS
GLPPRVRS.LIS
GLPPUNPS.LIS
PTPSQLGS.LIS

The above COBOL programs exceed the 2200-line limit for the free version of Micro Focus Cobol Net Express Edition, and so cannot be compiled.