OnDemand Users Group

On CMOD 9.5 latest fixpack (v9.5.0.10, AIX), I'm facing problem on loading data to CMOD.
In case that load success, it worked fine. But when load failed, arsload command will stuck in line of indexing failed, and command not finish.
If I kill arsload process, CMOD server will be hung and cannot login from Client.

Can you post some more diagnostic information?  The output of the arsload command, the type of data you're loading, the index parameters, etc.? 

Also, what you describe sounds like a pretty serious bug, so it should probably be reported to IBM with a Service Request.

-JD.

Quote from: Justin Derrick on February 21, 2018, 02:32:32 PM
Can you post some more diagnostic information?  The output of the arsload command, the type of data you're loading, the index parameters, etc.? 

Also, what you describe sounds like a pretty serious bug, so it should probably be reported to IBM with a Service Request.

-JD.

The arsload output look like this:

2018-02-20 16:30:01.969352: ARS4315I Processing file >/arsload/myfile<
2018-02-20 16:30:01.969423: ARS4334I Load Version <9.5.0.9>  Operating System <AIX> <7.1>  OS Userid <ADMIN>  Install Location </opt/IBM/ondemand/V9.5/> Data(131072 KB) Stack(32768 KB) Core(unlimited 512-blocks) Cpu(unlimited seconds) File(unlimited 512-blocks) Nofiles(2000) Threads(unlimited) Processes(unlimited)
2018-02-20 16:30:01.969469: ARS4335I Server Version <9.5.0.9>  Operating System <AIX> <7.1>  Database <DB2> <10.05.0003>
2018-02-20 16:30:01.990532: ARS4339I Application Group >LOSDGRP1<
2018-02-20 16:30:01.990581: ARS4340I Application >LOSD006<
2018-02-20 16:30:01.990621: ARS4341I Storage Set >Cache Only - Library Server<
2018-02-20 16:30:01.990660: ARS4342I Storage Node >Cache Only - Library Server<
2018-02-20 16:30:01.990764: ARS4302I Indexing started, 1094 bytes to process
                          : APK415I CC=YES
                          : APK415I CCTYPE=Z
                          : APK415I CONVERT=NO
                          : APK415I CPGID=874
                          : APK415I MCF2REF=CPCS
                          : APK415I TRC=NO
                          : APK415I FILEFORMAT=STREAM,(NEWLINE=X'0A')
                          : APK415I TRIGGER1=*,1,X'31',(TYPE=GROUP)
                          : APK415I TRIGGER2=*,*,X'2020202020203120',(TYPE=GROUP,RECORDRANGE=(2,15))
                          : APK415I FIELD1=0,15,20,(TRIGGER=2,BASE=0)
                          : APK415I FIELD2=5,9,7,(TRIGGER=2,BASE=0)
                          : APK415I FIELD3=2,15,60,(TRIGGER=2,BASE=0)
                          : APK415I FIELD4=0,2,8,(TRIGGER=1,BASE=0)
                          : APK415I INDEX1=X'72705F6964',FIELD1,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX2=X'62725F6E616D65',FIELD2,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX3=X'72705F6E616D65',FIELD3,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX4=X'61735F64617465',FIELD4,(TYPE=GROUP,BREAK=YES)
                          : APK415I DCFPAGENAMES=NO
                          : APK415I UNIQUEBNGS=YES
                          : APK415I IMAGEOUT=ASIS
                          : APK415I INDEXOBJ=GROUP
                          : APK415I INDEXSTARTBY=1
                          : APK415I INSERTIMM=NO
                          : APK415I RESTYPE=NONE
                          : APK415I INPUTDD=/arsload/myfile
                          : APK415I OUTPUTDD=/dev/null
                          : APK415I INDEXDD=/arsload/myfile.ind
                          : APK415I RESOBJDD=/dev/null
                          : APK449S INDEX FIELDS REFERENCE OUTSIDE OF THE RECORD, FIELD# 2 INPUT RECORD# 9.
                          : APK412I MODULE APKIXSAX HAS RETURNED WITH RETURN CODE 16.
                          : APK441I ACIF AT IPTR923 HAS COMPLETED ABNORMALLY WITH RETURN CODE 16.
2018-02-20 16:30:02.048557: ARS4309E Indexing failed
2018-02-20 16:30:02.048689: ARS4318E Processing failed for file >/arsload/myfile<

And , stuck at last line, not exit to command prompt.

I also open PMR to ask IBM, will update when has solution.

My env.:
AIX 7.1 TL4
CMOD 9.5.0.10
DB2 10.5

This error:

  APK449S INDEX FIELDS REFERENCE OUTSIDE OF THE RECORD, FIELD# 2 INPUT RECORD# 9.

...makes it sound like you have a data problem-- that you're trying to capture 20 characters worth of input, but there's less than that inside the file.

-JD.