Author Topic: Unable to start CMOD V10.5 after upgrade from V9.5  (Read 1684 times)

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Unable to start CMOD V10.5 after upgrade from V9.5
« on: April 27, 2021, 01:45:37 PM »
We just upgraded from CMOD V9.5 to V10.5.0.2 Our environment is redhat, with db2 v11.1.4.5, redhat linux

I ran all the upgrade steps-

arsdb -I archive -evf, select yes
arsdb -I archive -uv
arsdb -I archive -rfv
arsdb -I archive -rfv

I updated all the configuration files. Verified everything looks good, and we are seeing this error. I attempt to start arssockd, and it gets to the "initializing phase" and then dies out.

From the trace file-

Code: [Select]
55663:47042139134656 04/27/2021 15:34:21:755929 ERROR arssys.c(3949)ArcDB_SystemGetConfig:Unable to execute sql db hstmt=65538 db sql str=SELECT keystore_type, keystore_location, keystore_mkl, keystore_mkl_dt, data_ekey FROM archive.ARSSYS FETCH FIRST 1 ROW ONLY OPTIMIZE FOR 1 ROW FOR READ ONLY db sql rc=-1,SQL_ERROR
55663:47042139134656 04/27/2021 15:34:21:861056 ERROR arssys.c(3950)ArcDB_SystemGetConfig:Server message msg timestamp=2021-04-27 15:34:21.757220 msg userid=ARSSOCKD msg severity=2 msg num=13 msg text=ARS0013E DB Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0206N  "KEYSTORE_TYPE" is not valid in the context where it is used.  SQLSTATE=42703  -- SQLSTATE=42S22, SQLCODE=-206, File=arssys.c, Line=3950 msg appl=N msg logid=0
55663:47042139134656 04/27/2021 15:34:21:861061 ERROR arssys.c(3950)ArcDB_SystemGetConfig:ARSLOG message msg num=13
55663:47042139134656 04/27/2021 15:34:21:861318 ERROR arssys.c(3950)ArcDB_SystemGetConfig:CONSOLE message msg num=13
55663:47042139134656 04/27/2021 15:34:21:861586 ERROR arssrvr.c(3168)ArcSERVP_GetSystemInfo:TTY message msg num=151 msg text=ARS0151E Unable to initialize server database system parameters.  Contact your system administrator.
55663:47042139134656 04/27/2021 15:34:21:861631 ERROR arssrvr.c(3168)ArcSERVP_GetSystemInfo:CONSOLE message msg num=151 msg timestamp=2021-04-27 15:34:21.861591 msg userid=ARSMSG msg severity=2 msg text=ARS0151E Unable to initialize server database system parameters.  Contact your system administrator. msg appl=N msg logid=0
55663:47042139134656 04/27/2021 15:34:21:861647 ERROR arssrvr.c(3168)ArcSERVP_GetSystemInfo:ARSLOG message msg num=151

Found an earlier post, mentions this-

Code: [Select]
EXPORT
DROP
CREATE
IMPORT
 
Run "arsdb <-I instance_name> -vx ARSSYS"
Run "arsdb <-I instance_name> -vd ARSSYS"
Run "arsdb <-I instance_name> -vc ARSSYS"
Run "arsdb <-I instance_name> -vi ARSSYS"

Before I do that, just wondering if anyone on here has seen this error message as well.
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Unable to start CMOD V10.5 after upgrade from V9.5
« Reply #1 on: April 27, 2021, 02:21:25 PM »
Yeah, it looks like there's some missing fields from your ARSSYS table - specifically ones related to data encryption.

Your commands will export, drop, create, and import the data for that table, so should help.

Please open a Service Request and report it as a bug.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

jsquizz

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 573
    • View Profile
Re: Unable to start CMOD V10.5 after upgrade from V9.5
« Reply #2 on: April 27, 2021, 05:28:50 PM »
Yeah, it looks like there's some missing fields from your ARSSYS table - specifically ones related to data encryption.

Your commands will export, drop, create, and import the data for that table, so should help.

Please open a Service Request and report it as a bug.

-JD.

I did that per dba suggestion.

We also didn't want to wait. Ha! We re-ran all four steps to "remassage" the 9.5 tables.

It magically worked. Not sure what happened there.. strange
#CMOD #DB2 #AFP2PDF #TSM #AIX #RHEL #AWS #AZURE #GCP #EVERYTHING

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2228
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Unable to start CMOD V10.5 after upgrade from V9.5
« Reply #3 on: April 28, 2021, 10:30:24 AM »
Likely a bug in code that updates the ars* tables in v10.5.  It's happened before...  So it's good to report it so it gets fixed.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

Ed_Arnold

  • Hero Member
  • *****
  • Posts: 1199
    • View Profile
Re: Unable to start CMOD V10.5 after upgrade from V9.5
« Reply #4 on: June 02, 2021, 02:42:51 PM »

We also didn't want to wait. Ha! We re-ran all four steps to "remassage" the 9.5 tables.

It magically worked. Not sure what happened there.. strange

If you want a possible explanation I'd wager that the arsdb command used was the 9.5 version, not the 10.5 version.

Ed
#zOS #ODF