Error upgrading AWA 11.2.5 to 12.2.3 on AIX

[Thierry Tarrason]

Hi,
We are testing the upgarde from 11.2.5 to 12.2.3 on our test environement. We are running on AIX with an Oracle DB. Tried with Oracle Client version 12.1 and 12.2.
When doing the DB Load we get following error message:

20190722/101911.626 - U00038091 Change application directory to '../db/'.
20190722/101911.626 - U00038091 Change application directory to '../db/'.
20190722/101911.626 - U00038091 Change application directory to '/opt/uc4/utility/bin/'.
20190722/101911.627 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.a' error '  0509-022 Cannot load module /opt/uc4/utility/bin/ucuoci.a.
        0509-150   Dependent module /oracle/app/oracle/product/client_12.2.0/lib/libclntsh.a could not be loaded.
        0509-022 Cannot load module /oracle/app/oracle/product/client_12.2.0/lib/libclntsh.a.
        '.
20190722/101911.628 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20190722/101911.628 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
Application return code = 1
​

I don't understand why it's not working as it's working fine when upgrading from 11.2.5 to 12.2.2.HF2.
If anyone has an idea, i'll be glad to hear about it.

------------------------------
Best regards,
Thierry

Banque de Luxembourg
------------------------------

[Frank Muffke]

Hi

ENV parameters are set correctly?

the environment variables in $HOME/.profile.

• Oracle:

  • Sample for AIX:

    ORACLE_HOME=/usr/oracle; export ORACLE_HOME
    AUTOMIC=/opt/automic/utility; export AUTOMIC
    PATH=.:$ORACLE_HOME/bin[:$PATH]; export PATH
    LIBPATH=.:$AUTOMIC/bin:$ORACLE_HOME/lib:/usr/lib:/lib[:$LIBPATH]; export LIBPATH

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Installation_Manual/AE/InstalltheUtilities_UNIX.htm%3FTocPath%3DInstalling%7CManual%2520Installation%7CInstalling%2520the%2520Automation%2520Engine%2520(AE)%7CInstalling%2520the%2520Utilities%2520%7C_____1



I had a similar issue yesterday using Db unload - cause was that 2 lines scldriverconnect=.... were active - oops....


cheers, Wolfgang

------------------------------
I know I do really know it!
------------------------------

[Thierry Tarrason]

Hi Wolfgang,
Thanks for the input. My '.profile' seems correct and works fine with 12.2.2. Just not with 12.2.3.

LIBPATH=/opt/uc4/utility/bin:/oracle/app/oracle/product/client_12.1.0/lib:/usr/lib:/lib:/opt/uc4/server/bin:/opt/uc4/smgr/bin

------------------------------
Best regards,
Thierry

Banque de Luxembourg
------------------------------

[Carsten Schmitz]

> LIBPATH=/opt/uc4/utility/bin

Once more: This is dangerous!

If you start server components, they will pick up shared objects from the utilities, and this can lead to very hard to debug bugs in the long run. I strongly recommend you do NOT set any LD_LIBRARY_PATH (or LIBPATH) for Automic core components!

​Background

[Thierry Tarrason]

Hi Carsten,
Thanks for the update and the interesting link to your previous message. I'm not sure i understood everything as my unix knowledge is not that high but i'll keep it in my mind if i come accross some kind of 'B.E.S.T' bugs.
What i do know, is that 'LIBPATH=/opt/uc4/utility/bin' is only used when we execute the utilities, not when starting the server so we are safe from this point of view.

------------------------------
Best regards,
Thierry

Banque de Luxembourg
------------------------------

[Carsten Schmitz]

Hi Thierry,​

You're welcome. As long as you have this LIBPATH only in your personal .profile (or similar) file, this should be fine. It's indeed only when this LIBPATH is in the environment whenever server components (worker processes etc.) are started that this causes issues. So best not to set it system-wide as part of a /etc/init.d or /etc/profile chain.

Best regards,
Carsten

[Thierry Tarrason]

Hi,
Just a follow-up in case someone else runs into this problem.
Broadcom support finally confirmed that there is a know bug in version 12.2.3 and that it's corrected in 12.2.4 and 12.3.1.

Best regards,
Thierry

------------------------------
Best regards,
Thierry

Banque de Luxembourg
------------------------------

[Hartwig Esch]

Hi Thierry,
we ran into same problem while updating from V11.2 to V12.3 on AIX and the support confirmed it as a known bug. Yesterday we have got a dev-build from support. The initial load works now, but we ran into next problem: the wp's abort after start with error: ​U00005132 No matching entry found in table UC_ZDU for this version of the automation. Please update initial data.
I would be interested, if you ran into same error. I raised a case for this.

Kind regards
Hartwig



------------------------------
Systemadministrator
VW Financial Services Digital Solutions GmbH
------------------------------

[Hartwig Esch]

Hi all.
V12.3 HF2 solved this problem.​

------------------------------
Systemadministrator
VW Financial Services Digital Solutions GmbH
------------------------------