Hi All,
CMOD version: 10.1.0.3
DB2: 11.1.0.0"
OS: Linux (RHEL)
We must migrate our CMOD from version 8.5 to 10.1.
I am testing different scenarios and every time I try loading documents (arsload), I get this error:
ARS1107E An error occurred. Contact your system administrator and/or consult the System Log. File=assailed. c, Line=16362
ARS4323E Unable to log load information.
All documents are loaded (I can open different documents (XML, PDF, ZIP...) and I see entries in SYSTEM LOG and SYSTEM LOAD tables.
command:
/opt/ibm/ondemand/V10.1/bin/arsload -v -u xxxxxx -p xxxxxxx -h cmodp2 -1 /cmodtmp/trace.log -2 ALL=15 -g "ZpizDokumentRT" -a RTXML /import_test/Testni_izvoz7.0.ZpizDokumentRT.RTXML
2018-05-11 12:07:56.521273: ARS4315I Processing file >/import_test/Testni_izvoz7.0.ZpizDokumentRT.RTXML<
2018-05-11 12:07:56.521321: ARS4334I Load Version <10.1.0.0> Operating System <Linux> <#1 SMP Sun Jan 14 10:36:03 EST 2018.3.10.0-693.17.1.el7.x86_64> OS Userid <ADMIN> Install Location </opt/ibm/ondemand/V10.1/> Data(unlimited KB) Stack(8192 KB) Core(0 512-blocks) Cpu(unlimited seconds) File(unlimited 512-blocks) Nofiles(65536) Threads(0) Processes(4096)
2018-05-11 12:07:56.521344: ARS4335I Server Version <10.1.0.3> Operating System <Linux> <#1 SMP Sun Jan 14 10:36:03 EST 2018.3.10.0-693.17.1.el7.x86_64> Database <DB2> <11.01.0000>
2018-05-11 12:07:56.525749: ARS4339I Application Group >ZpizDokumentRT<
2018-05-11 12:07:56.525779: ARS4340I Application >RTXML<
2018-05-11 12:07:56.525799: ARS4341I Storage Set >CMOD0<
2018-05-11 12:07:56.525819: ARS4342I Storage Node >CMOD0<
2018-05-11 12:07:56.525836: ARS4347I Encryption >None<
2018-05-11 12:07:56.525926: ARS4312I Loading started, 5367 bytes to process
2018-05-11 12:07:56.536276: ARS1144I OnDemand Load Id = >5014-3-0-9FAA-20130422152329-20130422152329-5015<
2018-05-11 12:07:56.550977: ARS1146I Loaded 1 rows into the database
2018-05-11 12:07:56.553200: ARS1175I Document compression type used - OD77. Bytes Stored = >3183< Rows = >1<
2018-05-11 12:07:56.553245: ARS4310I Loading completed
2018-05-11 12:07:56.557393: ARS4317I Processing successful for file >/import_test/Testni_izvoz7.0.ZpizDokumentRT.RTXML<
2018-05-11 12:07:56.557481: ARS4349I Load Statistics: Index In >5,367< Load In >5,367< Load Out >3,183< Rows >1< Pages >0< Time >0.0373<
ARS1107E An error occurred. Contact your system administrator and/or consult the System Log. File=arsload.c, Line=16362
ARS4323E Unable to log load information
I have checked and re-checked all configuration files, dropped and recreated database. Today I have installed latest fix pack.
Does anyone have an idea what else can I do?
Kind regards,
Rok Brnot
Check the troubleshooting page on the CMOD wiki, and report back with your findings! https://cmod.wiki/index.php?title=Troubleshooting_Content_Manager_OnDemand
You'll want to focus on the DB2 part, since the error message relates to the System Log, which is stored in the database.
-JD.
Thank you Justin, but I still can't see where is the problem - there is no indication of an error in db2diag.log, CMOD can insert records in the system log and in the system load table, all documents were successfully loaded... I'll have to open a PMR...
arsload:
-------------
[cmodp2@TVLCMOD4 import_test]$ /opt/ibm/ondemand/V10.1/bin/arsload -v -u xxxxxx -p xxxxxx -h cmodp2 -1 /cmodtmp/trace.log -2 ALL=15 -g "ZpizDokumentRT" -a RTPDF /import_test/Testni_izvoz1.0.ZpizDokumentRT.RTPDF
ARS1609W Specifying passwords on the command line is in-secure due to the text being visible. See the Installation and Configuration Guide for your platform for information about the arsstash command or using Unified Login.
2018-05-11 15:27:42.254472: ARS4315I Processing file >/import_test/Testni_izvoz1.0.ZpizDokumentRT.RTPDF<
2018-05-11 15:27:42.254546: ARS4334I Load Version <10.1.0.0> Operating System <Linux> <#1 SMP Sun Jan 14 10:36:03 EST 2018.3.10.0-693.17.1.el7.x86_64> OS Userid <ADMIN> Install Location </opt/ibm/ondemand/V10.1/> Data(unlimited KB) Stack(8192 KB) Core(0 512-blocks) Cpu(unlimited seconds) File(unlimited 512-blocks) Nofiles(65536) Threads(0) Processes(4096)
2018-05-11 15:27:42.254574: ARS4335I Server Version <10.1.0.3> Operating System <Linux> <#1 SMP Sun Jan 14 10:36:03 EST 2018.3.10.0-693.17.1.el7.x86_64> Database <DB2> <11.01.0000>
2018-05-11 15:27:42.260578: ARS4339I Application Group >ZpizDokumentRT<
2018-05-11 15:27:42.260607: ARS4340I Application >RTPDF<
2018-05-11 15:27:42.260622: ARS4341I Storage Set >CMOD0<
2018-05-11 15:27:42.260634: ARS4342I Storage Node >CMOD0<
2018-05-11 15:27:42.260647: ARS4347I Encryption >None<
2018-05-11 15:27:42.260695: ARS4312I Loading started, 2895463 bytes to process
2018-05-11 15:27:42.382179: ARS1144I OnDemand Load Id = >5014-3-0-10FAA-20130419132931-20140224084025-5016<
2018-05-11 15:27:42.415117: ARS1146I Loaded 40 rows into the database
2018-05-11 15:27:42.416948: ARS1175I Document compression type used - OD77. Bytes Stored = >2492720< Rows = >40<
2018-05-11 15:27:42.416990: ARS4310I Loading completed
2018-05-11 15:27:42.423074: ARS4317I Processing successful for file >/import_test/Testni_izvoz1.0.ZpizDokumentRT.RTPDF<
2018-05-11 15:27:42.423165: ARS4349I Load Statistics: Index In >2,895,463< Load In >2,895,463< Load Out >2,492,720< Rows >40< Pages >0< Time >0.1701<
ARS1107E An error occurred. Contact your system administrator and/or consult the System Log. File=arsload.c, Line=16362
ARS4323E Unable to log load information
db2diag:
-----------
2018-05-11-15.08.03.677593+120 I1727E391 LEVEL: Event
PID : 31316 TID : 140067696723840 PROC : db2diag
INSTANCE: cmodp2 NODE : 000
HOSTNAME: TVLCMOD4
FUNCTION: DB2 UDB, RAS/PD component, pdDiagArchiveDiagnosticLog, probe:88
CREATE : DB2DIAG.LOG ARCHIVE : /home/cmodp2/sqllib/db2dump/db2diag.log_2018-05-11-15.08.03 : success
IMPACT : Potential
2018-05-11-15.33.36.094960+120 E2119E429 LEVEL: Info
PID : 12488 TID : 139962292889344 PROC : db2sysc 0
INSTANCE: cmodp2 NODE : 000 DB : CMODP2
HOSTNAME: TVLCMOD4
EDUID : 293 EDUNAME: db2logmgr (CMODP2) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
DATA #1 : <preformatted>
Started archive for log file S0000047.LOG.
2018-05-11-15.33.36.158678+120 I2549E548 LEVEL: Info
PID : 12488 TID : 139962292889344 PROC : db2sysc 0
INSTANCE: cmodp2 NODE : 000 DB : CMODP2
HOSTNAME: TVLCMOD4
EDUID : 293 EDUNAME: db2logmgr (CMODP2) 0
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
DATA #1 : <preformatted>
Completed archive for log file S0000047.LOG to /cmoddb_archivelog/cmodp2/cmodp2/CMODP2/NODE0000/LOGSTREAM0000/C0000000/ from /cmoddb_log/NODE0000/LOGSTREAM0000/.
Best Regards,
Rok Brnot
many moons ago, 8.4, ive seen a "bad" file cause this.