OnDemand User Group

Support Forums => Report Indexing => Topic started by: DDP021 on November 05, 2012, 04:58:56 AM

Title: Invalid Character issue
Post by: DDP021 on November 05, 2012, 04:58:56 AM
Hi, wondering if anyone has had this issue....We are ingesting mainframe reports into CMOD...We had an instance where a character was used in the data that caused the report to fail when ingesting into ERR...In this case it was an x'47'....Apparently this is an invalid character in CMOD...The actual failure message didn't indicate that...We found it ourselves and after editing out this character, the file ingested successfully....Wondering if there are other characters that CMOD won't recognize and if there's a way to define something to 'bypass' any invalid characters so we don't have any failures?...Any help would be appreciated..Below is the failure message we received....

OnDemand Load Id = >12794-14-0-711FAA-15645-15645<
An error occurred.  Contact your System Administrator and/or consult the System Log.  File=arsadmp.c, Line=1561
Failed while attempting to load the database
Loaded 0 rows into the database
Title: Re: Invalid Character issue
Post by: Justin Derrick on November 05, 2012, 06:28:04 AM
Hi.

The traditional way to deal with this is to create an input exit that detects the 'rogue' character, and convert it to something similar that doesn't cause trouble.  Removing tabs from TLEs, and de-accenting characters during load are two that I've helped write in the past.

-JD.
Title: Re: Invalid Character issue
Post by: DDP021 on November 05, 2012, 07:04:01 AM
Thanks Justin....This seems like something our systems area would need to do...My group supports report definitions/ accesses...No type of coding...I'm HOPING they will know where to put this exit and how it would need to be formated...If you would have any examples of something you did that I could pass along, that would be greatly appreciated...take care...