Topics

91

Report Indexing / Unable to read from offset 0 for length 26118 from the file

« on: May 29, 2013, 07:52:14 AM »

I'm receiving the above error when attempting to load a txt file...The setup is using ACIF indexer..What's interesting is, I can load the initial file successfully..The error started appearing AFTER the added a new line at the top of the file...To define the setups, I'm using the REPORT WIZARD..I run both file types through the wizard..They added the new line in order to pull a specific date..Everything points to how this new line was added..I initially thought that maybe the line that was added didn't have a NEW LINE character at the end X'0A' since the error indicated offset 0 which would indicate the first line on the file...When I run both files through the wizard I just specify DATA CONVERSION=NO, File Format=STREAM, CC=No and the CODE PAGE=1252 (German Data)..I leave the NEW LINE box blank...After running through the wizard and check the APPLICATION, it's specifying RECFM=Stream and Delimiter is 0A.  The user indicated his new line is ending in 0A...I don't have any type of editor myself...He is emailing both files to us and we save them to our desktop..When opening them, they open in NOTEPAD...I have no way of determining how this new line is formattted...Anyone have an ideas what could be different with this new line that would cause the error in the subject line?...

92

Report Indexing / Mainframe to Server data

« on: May 07, 2013, 03:32:26 AM »

MOST of our reports currently loading to CMOD are run on the mainframe and then are sent to CMOD server using ARSLOAD....The reports use ACIF indexing...I've attached an example of a file name when it comes to the CMOD server...As indicated, they use ACIF indexer and the data file has mainframe carriage control..We are using Channel 1 (top of page) for Trigger 1 to go off of for indexing...The user is now asking of they can send the file from server to server and bypass the mainframe...My question is, what file format would they need to use so we can keep the same indexing (ie Recognize channel 1 carriage control?...Currently the only files we are indexing that come server to server or PDF's where we first run them through the "wizard"...Any ideas?

93

WEBI interface / Do a "Find" across multiple versions at one time

« on: April 30, 2013, 06:55:58 AM »

I had posted this question in another topic but thought maybe would be better to start a new topic...We have a user loading multiple .txt documents to CMOD..These aren't mainframe text files (with page breaks) but true .txt files (ex test.txt)...We are using a generic indexer to load the documents..The only field the user has on their index file (.ind) is for Posting Date...We have the versions in CMOD open up in WORD (view information on application set to DOC)..What the user would like to do is be able to do "FIND" across multiple versions...The way the Find works now is it only looks at the current version that is opened..I tried select multiple versions in Webi but it only allows you to view on version at a time so when doing the "FIND" it only searches in that version...Does anyone know how to do a FIND across multiple versions at one time using this type of data?...The way they do their searches we don't think indexing will work...

94

Report Indexing / Indexing a .txt file

« on: March 27, 2013, 03:16:37 AM »

Does anyone know how to index a .txt or .csv file when using the Generic indexer?...We know they need to send a .ind file where indexing information would be contained...Most of our reports currently come from the mainframe..Which have carriage control F1 (ie 1 in column 1) for each top of page...We set up the indexer based on triggers, fields, indexes..(TRIGGER1=*,1,X'F1',(TYPE=GROUP)...Not sure how to accomplish that when there is no set page breaks if they are sending a .txt, .csv, .xls type file...Currently they only thing the users are overriding on the index file is POSTING DATE..I guess I'm asking if you can somehow define a top of page, or break, on these kinds of files..

CODEPAGE:1252
GROUP_FIELD_NAME:Posting_Date
GROUP_FIELD_VALUE:09/07/09
GROUP_OFFSET:0
GROUP_LENGTH:0
GROUP_FILENAME:/prod/ode/cmod/arsload4/XTS0730A.XTS00001_0000005903.ARD.OUT

95

WEBI interface / Font Mapping (Part 2)

« on: March 15, 2013, 05:32:04 AM »

Hello, I had previously posted about mapping AFP fonts on the webi....We finally were able to get things to work on our DEV environment and the user signed off on our changes..We thought all we had to do is move everything into PROD but for some reason they aren't being picked up...Below is the path on the server for the changes:

/usr/lpp/ars/www/afp2pdf/font

Under the font folder, we updated the coded.fnt and csdef.fnt files with the updates...As stated these changes work perfectly on the DEV server...Both servers are running 8.5.0....Could it be a rights/owner issue on the files?..Does anyone know when these are called in? Is it the time when the report is opened?...We've even tried reloading the data after we made the changes..

The code.fnt contained the "User Coded Fonts"

;USER CODED FONTS
;CODEDFONT=CHARSET,CODEPAGE
X?980130=C?H200A0,T1V10500
X0A0730I=C0A0730I,T1GI0361
X0A0530I=C0A05300,T1GI0361
X050F0=C0540000,T1V10500
X050D8=C0520080,T1V10500
X050F8=C0540080,T1V10500
X0N0D0=C0N20000,T1V10500
X0N0F0=C0N20000,T1V10500
X0N0F0=C0N40000,T1V10500
X0A0530I=C0A05300,T1GI0361
X0A0538I=C0A05300,T1GI0361
X0A073BI=C0A073B0,T1GI0361

For the CSDEF.fnt, we added the following:

;charset = fgid,height,width,strikeover,underline
;***** Put User defined/Custom character sets here *****
C0A0730I=318,80,0
C0A05300=86,80,0
C0540000=86,80,0
C0520080=86,80,0
C0540080=86,80,0
C0N20000=86,80,0
C0N40000=86,80,0
C0A05300=86,80,0
C0A05380=86,80,0
C0A073B0=86,80,0

96

Report Indexing / Bulk loading??

« on: March 13, 2013, 09:42:10 AM »

I know I've been hitting this support forum hard lately and I appreciate all the responses back...I have ANOTHER strange scenerio..We have an user who wants to send archived reports to ERR for storage from another system (TOPAS)...They are txt files...We setup an application using the Generic Indexer..So the Data Type is set as User Defined and the File Extension is set to DOC on the View Information tab in the Application setup...The user than send the 3 needed files (ie Trigger, Index, Data)...The file names are formatted as ApplicationName.ApplicationGroupName.ard (Trigger), ApplicationName.ApplicationGroupName.ard.ind (Index File) and ApplicationName.ApplicationGroupName.ard.out (Data File)..Under "Normal" circumstances the user would  be sending one file at a time...But in one case, they have 20,000+ files they would want to send to ERR at one time..And obviously single threading them one at a time by sending these 3 files for each file isn't feasible..Anyone know of a way to somehow "bulk load" this many files in a more efficient manner?

97

Report Indexing / Applications in Application Groups...

« on: March 13, 2013, 04:01:06 AM »

Question, does anyone know if there's a maximum number of "Applications" that can be defined to one "Application Group"...Currently we define one Application per one Application Group but were told that isn't the most efficient way of doing things...Just curious what what specifics should be taken into account when defining things....From what we are led to believe, you can define many Applications to one Application Group if the indexing and retention are the same...Also, to confirm, is it possible to keep adding new Applications to an existing Application group?..I've attached a screen shot of an 'dummy' Application Group showing multiple Applications defined to it....

98

WEBI interface / Mapping Fonts

« on: March 12, 2013, 03:18:12 AM »

We are attempting to map some AFP fonts in ERR.This is due to the application using certain mainframe fonts that cause the data to overwrite over other data when viewed via the webi client in ERR..What we did was update the coded.fnt and csdef.fnt members under the /usr/lpp/ars/www/afp2pdf/font path with the new "User Defined"mappings..In our DEV environment, it works perfectly..But after moving the same files to PROD and loading the report, it appears the new mapping isn't being used..We're seeing the data being overwritten...Not sure what the issue could be...The files in question are exactly the same size in both DEV and PROD..It would just seem they are not being used...I did notice the RIGHTS are different..Not sure if that could be the problem or not...I've attached a screen shot of both DEV and PROD files...We are running version 1.0.4.0 webi in both PROD and DEV environments...Any ideas?

99

Windows Client / Creating a search via the CMOD ADMIN client

« on: March 05, 2013, 07:41:16 AM »

Does anyone know if it's possible to do a search via the ADMIN client on a particular parameter ?...Basically what we are attempting to do is search across all our defined Application Group for a particular setting (ie Create Table Space Type) to obtain a listing of what definitions are set to "None" on this field..So we'd want to do a search so we receive back a listing on all the current Application Group who have the Create Table Space set "None".. Is there an easy way to do this?..I've attached a screen shot of the field in question....We also have a product called Mobius which allows you to do a FILTER on any field on the definition to gets results...I've found the Summary option in the Admin client but not been able to find a way to a specific search on a particular field or setting....

100

Windows Client / Full Report Browse

« on: February 28, 2013, 10:33:31 AM »

Has anyone utilized the FULL REPORT BROWSE option?..How does it work?...I see there is an option under the FOLDER setup under the PERMISSIONS tab..Is that for each specific user or group?..Also, I see on the USER definition under to FOLDER PERMISSIONS tab there is a FULL REPORT BROWSE check box...Does this need to be checked also?....I can't find any documentation on how exactly this feature work?

101

Other / SYSTEM LOAD issue

« on: February 21, 2013, 10:29:55 AM »

We recently upgraded to CMOD 8.5...We currently load reports from the mainframe using both OS/390 and ACIF indexers...Currently on the mainframe we are running 8.4...Ever since the 8.5 upgrade, our OS/390 loads are not being written to SYSTEM LOAD....ACIF loads are...IBM has indicated this is a 'bug' and should not be happening...Of course they indicate the fix is to upgrade to 8.5 on the mainframe...Our systems people are always hesitant to change anything that previously wasn't broke..Is anyone else aware of this kind of log issue and if  there is a way of correcting it without doing a complete upgrade on the mainframe??

102

Report Indexing / Loading an XLSX document

« on: January 02, 2013, 04:26:43 AM »

Hi,  we have successfully been able to have our users load an XLS document using the generic indexer and setting the File Extension set to XLS on the application....The issue we are having now is the user is attempting to send a XLSX formatted document to OnDemand and is receiving an error when attempting to open it (see attachment)...We tried changing toe File Extension on the application definition to XLSX without any success....Is anyone aware of any issue loading this format of excel into OnDemand?...

103

Report Indexing / No Documents Found bogus message???

« on: November 16, 2012, 07:40:31 AM »

Hi,  we ran into a strange occurence today...We have a report that is using the OD/390 indexer with the index style of DOC...We are running CMOD 8.4.1...The indexer is using a FLOAT trigger...Only indexing off of one field..Today we received an 88 msg saying there were no documents found...But in looking, we had data in the file but the data had changed positions throwing off the indexer....After the indexer was updated to the new positions, the file loaded successfully...Our question is why we received "No Documents Found"...We are thinking we should have gotten as message indicating an issue with the indexer (ie No Triggers found)...We periodically get the No Documents Found error and have always assumed it meant the file was empty....We are no wondering if this isn't always the case....Anyone else run into this kind of thing or know what caused it?

104

Report Indexing / Invalid Character issue

« 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

105

WEBI interface / Password Resets

« on: September 20, 2012, 11:07:36 AM »

Hi, We are currently using RACF validation for CMOD.  This was mainly done because of converting from OnDemand on the mainframe to CMOD 8.4 we wanted to keep the same access groups in place.  The issue is when a users password expires in RACF, they receive an "An error has occurred on  the OnDemand Server"..The message is confusing enough but also with using RACF security, the "Change Password" feature in CMOD doesn't work..We have communicated to internal users they need to log into the mainframe, change their password there, and then log back in CMOD.....Is there anyone else incorporating RACF security with CMOD?  If so, how are password resets handled?..Also, since converting to CMOD and using the Webi client, we wanted to open up it to our external users to be able to log into CMOD..Obviously external users don't have mainframe access directly...What we need is to be able to use the Change Password Function enabled on CMOD with using RACF security...Any ideas?