Information For Failed Loads

[rstockton]

Does anyone have a query or some way to automate getting the detail  information for failed loads (rc 88)?  Is the detail information on the syslog or in another file?

When we find a failed load on the syslog we click on it to give the details, but we would like to have an automated way to query the syslog get the rc 88 information and then get the related details. 

Thanks,

Russell

[Alessandro Perucchi]

Hello Russell,

Well you could do a query in the System Log for the message number 88 with a "arsdoc query" and retrieve them with "arsdoc get", then you can parse the output of the error message.

Then you could script that in order to have it automated.

But from what I read, you are interested of a already done script that does it. In that case, I don't... but that shouldn't be too difficult to do...

Sincerely yours,
Alessandro

[pankaj.puranik]

Creating a Named Query is also an option.
The script should be fairly simple to write.
I don't have one right now.

[Justin Derrick]

Using arslog seems like the way to go here.  You can catch the error message when it occurs, and eMail it out immediately for resolution.

[rstockton]

Thanks everyone. 

Let me clarify what we are looking for.  We already have a process to capture the 88 records but what we need is how to get the detail information about the load failure. See the example from the client below.  We want to report all of this information when the load failure happens.

On the client when you double click an item in the hit list it gives the failure details.

88 - Info

01/23/2013 07:43:11   ADMIN       8421685   Error   Yes       88   Application Group Failed Load: Name(FRCURRG) LoadId(5184-2-0-460841FAA-15687-15687) File(/arsacif/load2/FRCURRG/PMCDLN.GI.D0.FRCURRG.D121212.T065437879.ARD)   


Failure Detail Info

arsload: File >/arsacif/load2/FRCURRG/PMCDLN.GI.D0.FRCURRG.D121207.T122746252.ARD< renamed to >/arsacif/load2/FRCURRG/PMCDLN.GI.D0.FRCURRG.D121207.T122746252.ARD.Failed<.  Correct problems and resubmit file.
arsload: Processing file >/arsacif/load2/FRCURRG/PMCDLN.GI.D0.FRCURRG.D121212.T065437879.ARD<
arsload: Load Version <8.5.0.6> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.6> Operating System <AIX> <6.1> Database <DB2> <09.07.0007>
arsload: 01/23/13 07:43:11 -- Loading started, --UNKNOWN-- bytes to process
Row 5:  The string "120000" could not be converted to a date from the format of %y%m%d
OnDemand Load Id = >5184-2-0-460841FAA-15687-15687<
The last row successfully loaded was 4
Loaded 4 rows into the database
arsload: 01/23/13 07:43:11 Loading failed
arsload: Processing failed for file >/arsacif/load2/FRCURRG/PMCDLN.GI.D0.FRCURRG.D121212.T065437879.ARD<
arsload: 01/23/13 07:43:11 -- Unloading started
OnDemand UnLoad Successful - LoadId(5184-2-0-460841FAA-15687-15687) Rows Deleted(4)
 
01/23/13 07:43:11 -- Unloading of data was successful

[Justin Derrick]

What you're asking for can be accomplished with arslog.  One of the parameters passed to arslog is the name of the file containing the information you want.  You can include it in the outgoing eMail.