Messages

61

Report Indexing / RC 0 with ACIF/Line - File still fails

« on: September 27, 2022, 09:33:26 AM »

We're trying to load a line data file, V10.5, loading from RHEL into Z/OS, db2 of course. Anyone have thoughts.

Code: [Select]

2022-09-27 10:30:02.385741: ARS4302I Indexing started, 5738 bytes to process
                          : APK415I CC=YES
                          : APK415I CCTYPE=A
                          : APK415I CONVERT=NO
                          : APK415I CPGID=500
                          : APK415I MCF2REF=CPCS
                          : APK415I TRC=NO
                          : APK415I FILEFORMAT=RECORD
                          : APK415I TRIGGER1=*,100,X'D9E4D540C4C1E3C5',(TYPE=GROUP)
                          : APK415I FIELD1=0,110,10,(TRIGGER=1,BASE=0)
                          : APK415I FIELD2=4,67,10,(TRIGGER=1,BASE=0)
                          : APK415I INDEX1=X'D9C481A385',FIELD1,(TYPE=GROUP,BREAK=YES)
                          : APK415I INDEX2=X'C5C481A385',FIELD2,(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=/file.ARD
                          : APK415I OUTPUTDD=/dev/null
                          : APK415I INDEXDD=/file.ind
                          : APK415I RESOBJDD=/dev/null
                          : APK440I ACIF AT PH34181 HAS COMPLETED NORMALLY WITH RETURN CODE 0.
2022-09-27 10:30:02.410835: ARS4308I Indexing completed
2022-09-27 10:30:02.410931: ARS4312I Loading started, 5738 bytes to process
2022-09-27 10:30:02.417521: ARS1146I Loaded 0 rows into the database
2022-09-27 10:30:02.417560: ARS4311E Loading failed
2022-09-27 10:30:02.418853: ARS4318E Processing failed for file >file.ARD<
2022-09-27 10:30:02.568891: ARS4327E Processing has stopped.  The remaining files will NOT be processed.
I still get a return code 0, but the file fails, from a trace (ALL=15)

Code: [Select]

193386:140103472973632 09/27/2022 10:22:13:537542 ERROR arsloadc.c(1187)ArcLOADCP_Stash:Current state msg_id=641
193386:140103472973632 09/27/2022 10:22:13:669974 ERROR arsload.c(12188)ArcLOADP_LoadArchive:Current state msg_id=1161
193386:140103472973632 09/27/2022 10:22:13:671257 ERROR arsload.c(18112)ArcLOAD_ProcessFile:Current state msg_id=1168
193386:140103472973632 09/27/2022 10:22:13:828007 ERROR (null)(0)(null):Sending message to library server msg timestamp=2022-09-27 10:22:13.671384 msg userid=ADMIN msg severity=2 msg num=88 msg text=ARS0088E Application Group Failed Load: Name(AG) LoadId(--INDEXING ONLY--) File(file.ARD) msg appl=T msg logid=164557526
193386:140103472973632 09/27/2022 10:22:13:828016 ERROR (null)(0)(null):CONSOLE message msg num=88
193386:140103472973632 09/27/2022 10:22:13:828035 ERROR (null)(0)(null):ARSLOG message msg num=88
193386:140103472973632 09/27/2022 10:22:13:831973 ERROR arsloadc.c(4486)ArcLOADC_Main:Current state msg_id=1177

62

z/OS Server / Re: move a part of a CMOD installation to another LPAR

« on: September 12, 2022, 09:33:14 AM »

I am new to the Z/OS world but I think that an extract, reload, then unload when said reload is done - is the best way to do it.

63

MP Server / Re: [BUG] Error while removing app from folder causing crash of CMOD frequently

« on: September 01, 2022, 08:16:47 AM »

Since you're out of support, I suggest you just do a new application group with a field named something like- report name

Then do-

database value 1, <AG Description..I usually do like - PDF>
database value 2, <AG Description..I usually do like - XLS>

Then, APP1-PDF mapped to AG, and APP1-XLS mapped to AG. That's how I've always done it.

Might be a pain on the folks who are sending, but the only other option would be to probably extend your support contract with IBM for 10.1, or upgrade to 10.5

Or, a single app group for each app

Or, extend your support contract for 10.1

Or, goto 10.5

64

Tips and Tricks / Re: ARSXML - Some tips and info

« on: August 31, 2022, 02:17:39 PM »

I ALWAYS refer to this-

https://www.ibm.com/docs/en/cmofm/10.1.0?topic=file-application-group-object

65

MP Server / Re: [BUG] Error while removing app from folder causing crash of CMOD frequently

« on: August 31, 2022, 10:41:42 AM »

Trying to understand this.

So when you add applications to an existing app group - by creating a new field and defining it as the application Identifier - with type PDF , you're getting a segmentation fault?

66

Report Indexing / Re: Best Practice - Index vs Filter

« on: August 16, 2022, 02:31:41 PM »

Space isn't so much a concern I dont think but who knows.

thank you for this!

67

Report Indexing / Best Practice - Index vs Filter

« on: August 12, 2022, 08:48:36 AM »

It's been a long time since I've done report development, but Im trying to come up with some standards. Also, I am not a DBA by any stretch of the imagination

Wondering about AG fields - Here are my below assumptions I'd assume are correct.

1) Is there any reason why I would not always use an index as field type?
2) Referring to question 1 - Would I only use an index on fields that are searched commonly, AKA - Account, SSN, Name, ETC.
3) Dates- Should they be filters?
4) "Dropdown Boxes" - should they be filters?

Wondering how everyone does it and if i can get some tips. In the mean time, I'll be hitting up mr google. Thanks

68

MP Server / Re: Arsmaint TSM Error

« on: August 09, 2022, 08:00:21 AM »

Plenty of space in database, might be some problem with cloudobjpool, but retrievals are ok, so something with loading then.
Passwords are ok to nodes. Guess i'll have to ask that reason code 1 by apar ticket to ibm

I only ask because I saw something similar a few years ago, but it was an older version of TSM, and a somewhat small CMOD system.

Loads would fail, but retrievals would work. Had to increase the space, then re-run arsmaint (i forget the flags..)

69

MP Server / Re: Arsmaint TSM Error

« on: August 08, 2022, 07:28:40 AM »

Is the TSM database full?

70

MP Server / Re: log4j question within jars dir

« on: August 03, 2022, 10:19:46 AM »

The answer is - that the jar file is only used by ODWEK/FTI service.

71

MP Server / log4j question within jars dir

« on: August 02, 2022, 06:24:02 PM »

Not a java dev, just wondering if the log4j, or anything within /opt/ibm/xx/ondemand/jars is used for anything, other than ODWEK?

Do any other binaries use it?

Thanks

72

z/OS Server / Re: Decoding the "perms" column?

« on: August 02, 2022, 10:18:21 AM »

What I personally do for these "cryptic" fields- is pick one row, make a change in the admin, then see what changes..via query. and note it.

73

Announcements & News / Re: SECURITY - IBM FLASH update on Log4j

« on: July 21, 2022, 10:03:59 AM »

Hi Michelle,

based on this - is 10.5.0.4 impacted?

74

MP Server / Encryption failing - Best way to troubleshoot

« on: June 10, 2022, 08:55:32 AM »

Hi All,

In one of our pre-go live systems that I am using to check out files before they are ready for production, encryption is all of a sudden failing. This is just one of our loading servers that we call ARSLOAD on.

2022-06-01 15:54:01.176976: ARS4308I Indexing completed
2022-06-01 15:54:01.177053: ARS4312I Loading started, --UNKNOWN-- bytes to process
2022-06-01 15:54:01.177553: ARS1420E Encryption failed.  File=arsload.c, Line=6085
2022-06-01 15:54:01.177588: ARS4311E Loading failed
2022-06-01 15:54:01.180539: ARS4318E Processing failed for file >FILE.ARD<

2022-05-24 16:37:49.523903, File Loaded
2022-06-01 16:54:01.182788, File Failed

I am guessing that some type of certificate or something possibly failed. All of our other servers - Development, UAT, Production, work fine.

We recently did a migration from AIX-ZOS for our library server.

This is the only troublesome box. Any issues?

75

MP Server / Re: Field maximum length issue

« on: June 08, 2022, 09:55:11 AM »

Reach out to me if you haven't solved this problem yet.

-Rob

Hello Rob,
I have still same issue , do you have any solution for this

I just had a requirement to do this, I did the exact steps I gave on 2/3. Zero issues.