OnDemand User Group
Support Forums => MP Server => Topic started by: jsquizz 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-
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-
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.
-
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.
-
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
-
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.
-
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