PCG 7.3.2: SQL Compile Fails After Install/Upgrade (Doc ID 1151545.1)

Last updated on NOVEMBER 01, 2024

Applies to:

Symptoms

On : PCG 7.3.2 version, SQL Compilation
After PCG 7.3.2 installation/upgrade, When attempting to compile SQL Rules,
the following error occurs.

ERROR
-----------------------
/d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LAENV_INTERNAL.sh: line 18:
: command not found
/d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LAENV_INTERNAL.sh: line 19:
: command not found
/d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LAENV_INTERNAL.sh: line 57: syntax error near unexpected token `elif'
/d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LAENV_INTERNAL.sh: line 57: `elif [ $product_version -eq 12 ]; then

OR/AND

/d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LAENV_INTERNAL.sh: line 55: [: too many arguments
/d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LAENV_INTERNAL.sh: line 57: [: too many arguments
LAGENLIB: Input parameters are
LAGENLIB: Library name: LABRSQL
LAGENLIB: Connect str : jdbc:oracle:thin:@cosxaorik.amcastle.com:1531:EBS07
LAGENLIB: Library will be : /d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LABRSQL.pld
Exception in thread "main" java.lang.NoClassDefFoundError: LaGenLib
LAGENLIB: Library generation failed
LAGENLIB: Quitting with error...
/d01/oratrn/trnappl/xxlaapps/11.5.0/bin/LAGENLIB
Program exited with status 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade PCG 7.3.1 to PCG 7.3.2
2. Run SQL Compilation
3. Check concurrent log

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use SQL compilation.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.