Error SQL0204 after Kernel Upgrade 720_EXT

[cedillof]

Hi Everyone,

Host Sandbox

We are in a project in which we have to Upgrade Kernel from 7.00 to 7.20_EXT over AS400 7.1

First IBM Support prepare a host with a Copy of Production (Sandbox) in which they upgrade AS400 from V5R4 to V7R1 and install al PTF. Afterwards we Upgrade Kernel from 7.00 to 7.20 EXT p700 UC. Everyhing worked fine in that host, SAP is working without any problem.

Host DEV/QAS

Last Friday IBM Support upgrade AS400 from v5.4 to v7.1 plus applied al PTFs on host DEV/QAS. Then on Saturday we started to work in the Kernel Upgrade.

The Kernel Upgrade process was executed without any incident. SAP Instances DEV and QAS are ONLINE with Kernel 720_EXT sp 700 UC.

But when starting a SAP GUI Session there is an error RABAX.

I copy a part of the dev_w1 log file whic reflects the error  ERROR => SQL-Error -204 in function db_open  and then the error

ERROR => dbdynpdb2: dbdd_dbtab_columns (DYNPSOURCE) failed with rc = 4 [dbdynpdb2.c  2506]

We had tried and read a lot of notes, but no one seems to work for us.

---dev_w1--

N  SignInit: Security Session Management cannot be used (ABAP parts are missing, note 1477428)

N  VSI: WP init in ABAP VM completed with rc=0

E  EnqLockTableAttach2: attach to lock table (size = 33554432)

E  EnqLockTableMapToLocalContext: enque/use_pfclock2 = FALSE

E  EnqId_Initialize: local EnqId initialization o.k.

A

A Sun Mar 22 21:45:23 2015

A  UpdateProfile (new settings): off,krn_impl,(no dyn check),(no logging),(no stat err),(local generation),(no commit)

A  UpdateProfile (new exceptions): (tmp_err),(home_err),(local_err)

A  UpdateProfile (new version): 0

C

C Sun Mar 22 21:45:24 2015

C  *** ERROR => SQL-Error -204 in function db_open

[dbsldb4.cpp  11173]

C  {root-id=550FF7B77E420AFBE1008002C0A800E4}_{conn-id=00000000000000000000000000000000}_0

C  Reopen: FALSE

B  *** ERROR => dbdynpdb2: dbdd_dbtab_columns (DYNPSOURCE) failed with rc = 4

[dbdynpdb2.c  2506]

B  {root-id=550FF7B77E420AFBE1008002C0A800E4}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BZY=> unexpected return code 4          calling dbdd_dbtab [dbdynpdb    2508]

A  TH VERBOSE LEVEL FULL

A  ** RABAX: level LEV_RX_PXA_RELEASE_MTX entered.

A  ** RABAX: level LEV_RX_PXA_RELEASE_MTX completed.

A  ** RABAX: level LEV_RX_COVERAGE_ANALYSER entered.

A  ** RABAX: level LEV_RX_COVERAGE_ANALYSER completed.

A  ** RABAX: level LEV_RX_HOTSPOT_TRACE entered.

A  ** RABAX: level LEV_RX_HOTSPOT_TRACE completed.

A  ** RABAX: level LEV_RX_SAVE_SHMLOCKS entered.

Regards,

Franklin Manuel Cedillo

SAP BASIS CONSULTANT

franklin.cedillo@bbpconsultants.net

dev_icm.txt.zip

dev_w1.txt.zip

[cedillof · Accepted solution]

Hi everyone,

We opened a Incident with SAP Support.

I share  the Solution with you:

Then the error is solved.

Message . . . . :   SYSCOLUMNS in R3<SID>DATA type *FILE not found.

Please login with DRPADM and

1. stop <SID>, and then run

2. CALL QSYS2/QSQXRLF PARM(DLT R3<SID>DATA)

3. CALL QSYS2/QSQXRLF PARM(CRT R3<SID>DATA)

and finally

4. start <SID>.

[Sriram2009 · Accepted solution]

Hi Franklin

I think its related to IBM-i 7.1 PTF could you check this SAP Note for error message"function db_open"

1432783 - IBM i: Known Issues with OS Release IBM i 7.1

BR

SS