Topics

31

Report Indexing / Break=YES vs Break=NO

« on: October 09, 2018, 02:44:51 AM »

We have a report where the application has 26 (yes 26) indexes.  This is a text report.  When we run it through the Report Wizard it sets all the indexes to BREAK=YES.  We have many reports that are generated from the mainframe and sent to CMOD.  When these reports were initially converted to CMOD years ago, we've noticed, on their indexing, some fields are set to BREAK=YES while others are set to BREAK=NO...We know there has to be a rational for doing this but never really understood what that is.  Looking for any explanation....;-)

32

Report Indexing / Indexing issues

« on: September 26, 2018, 04:17:27 AM »

Hi,  We have an app that wants to start sending a mainframe file directly to our server.  Currently its run though a mainframe job that creates the output and sends it CMOD.  So the file they send us shows carriage control characters (1) at top of every page.  We ran the file through the report wizard to get the indexing values.  When we ingest the file, it APPEARS to be indexing correctly but when you open up each index itself, they contain ALL the pages in the file...I've attached the indexer and also screen shot of the results when we pull up the version.  I also attached a screen shot of the VIEW INFORMATION tab on the Application definition...As indicated, when you click on each of the indexes, they all show the same thing.  The full file itself.  we can't figured out what the issue is.  any ideas??

33

MP Server / Unable to store object Failure

« on: August 14, 2018, 03:05:03 AM »

Over the past month or so we've been getting intermittent failures.  They all receive the same EXACT msg number 429 (full message below).  It appears to be related to TSM but no one from our TSM area seems to know what the issue is.  What we've noticed is the failures ALWAYS occur on the quarter of the hour.  So as an example, errors occur at top of hour, 15 mins past, 30 mins past or 45 mins past.  Someone from Centera noticed a drive was kicking out errors.  They took that drive offline and we were good the rest of that day (Friday) and all of Saturday.  Saw one failure Sunday but then received 6 yesterday (Monday 8/13).  Failures occur on both OS390 and ACIF reports.  Its not related to size of the data because in some cases, failures are on 1 page reports.  I've also included below a sample if the actual 88 message.  Appreciate any info anyone may have regarding this.

2018-08-13 20:31:10.884452   ADMIN         21593   Error   No      429   TSM Error: ANS0266I (RC2302) The dsmEndTxn vote is ABORT, so check the reason field., Return Code=2302, Reason=15, File=arssmsms.cpp, Line=2695  Srvr->xsa00e70.example.com 999.999.49.139 non-SSL<-   

88msg info

2018-08-13 15:15:18.181784: ARS1144I OnDemand Load Id = >12118-14-0-342766FAA-20180813000000-20180813000000-14419<
2018-08-13 15:15:19.743461: ARS1146I Loaded 1 rows into the database
2018-08-13 15:15:25.974051: ARS1107E An error occurred.  Contact your system administrator and/or consult the System Log.  File=SYS17006.T095915.RA000.ARNLOAD.SRCCMS.H01(ARNLOAD), Line=6314
2018-08-13 15:15:25.975433: ARS1157E Unable to store the object >342766FAA1<.  Object size 151
2018-08-13 15:15:25.975447: ARS4311E Loading failed
2018-08-13 15:15:25.975455: ARS4320I Unloading started
2018-08-13 15:15:26.963835: ARS4321I Unloading of data was successful

34

MP Server / Sending Stats

« on: August 08, 2018, 06:36:11 AM »

Apologies if this is the wrong forum for this question.  We had a user come to us asking if there was a way to automatically send their numbers for a report the send to CMOD to feed a dashboard application.  I know this information can be 'manually' gathered as far as getting a total, which we would not want to do.  But they are looking for something automated.  Not sure if anyone else has had this question posed to them.  But in thinking, even it its possible, don't think we want to get involved with something like this.  Can foresee many others looking for something like this....Below is what was asked:

When CMOD receives the file , does the it know how many individual account records were present in the file? And how many reports were archived? Does CMOD know how many individual reports are archived per day for a specific report name?
If so, is there a way for this information to feed to a ‘dashboard application’ or to be picked up by another application (e.g. via an API)?
If not, is there a way for an automated ‘positive acknowledgement’ to be sent or picked up when the big statement file is received and archived successfully on ERR’s side?

35

Report Indexing / PDF issue

« on: May 17, 2018, 08:44:20 AM »

I created a PDF and attempted to load into CMOD 9.5.0.9.  Keeps failing with below message.  I was able to successfully run same PDF through the Report Wizard..Had no issues...Any clues?..Tried to google things but came up empty

ARS4901I INDEXDD=/prod/ode/cmod/arstmp4/ERRAPPS.ERRAPPS.pdf.ind
ARS4901I RESOBJDD=/prod/ode/cmod/arstmp4/ERRAPPS.ERRAPPS.pdf.res
ARS4923E PDDocOpen error code 1073807365 The file is damaged and could not be repaired.
ARS4912E Error opening Input file /prod/ode/cmod/arsload4/ERRAPPS.ERRAPPS.pdf
ARS4922I ARSPDOCI 9.5.0.9 completed code 1
ARS4309E Indexing failed

36

Content Navigator / AFP Document

« on: May 11, 2018, 05:56:30 AM »

Hi, we ran into an issue with viewing an AFP document that has an index over 100 pages....For some reason, if the index is over 100 pages, it only shows the first 100...The PAGE DOWN shows 1/100 and the BOOKMARK ribbons only go to 100...Cant seem to find a way to view pages over 100....Not seeing this issue on the same report using WEBI...Only Content Navigator...Anyone else seeing this issue?

37

Report Indexing / INDEX vs Filter

« on: May 10, 2018, 04:35:17 AM »

Hi...We have a HUGE report we load daily to CMOD9.5 (96000+ documents daily)....It has over 20 searches defined...Users were having issues timing out (using CONTENT NAVIGATOR) when they were doing a search on one of the particular search fields...In researching, we found this field was defined as a FILTER rather than an INDEX on the App Grp...We did manage to update this on the Application Group to change it to a FILTER..This corrected the timeout issue...But we fear we may run into the same timeout issue if someone else attempts to use another Search Field that is also defined as a FILTER...We are understanding if you have TOO many set to INDEX is can have a negative impact..Is this correct?  With a total of 20 searches, how many is TOO many set as INDEX?..Should we try and determine which fields, out of the 20, are used most often and change only those? 

38

Windows Client / Searching using OnDemand Admistrator

« on: May 01, 2018, 08:59:38 AM »

Just have an off the wall question...We have over 33,000 applications defined...Currently we are running Version 9.5.0.8 CMOD Administrator...The issue is with doing searches...The default view shows the names in alphabetical order and also lists the associated App Grp, Description, Modified and Modified By columns...I realize you can change the sort order manually on each of these columns...But the only way to do any kind of search is to high anything in that column and start typing what you want to find...The problem is, if you're not quick enough or mistype, it can start searching on another character...For instance, say you want to search on ABCDEF...You start typing and pause between C and D...It will start searching on D....Not sure if there's a way to increase the time it allows between what you are typing OR a way to be able to bring up a search box?...I realize this is a minor thing...Just curious of I was missing something....

39

Windows Client / Loading a mainframe file as txt

« on: April 20, 2018, 07:13:22 AM »

Hello, First thing, apologize for the long post...wanted to give as much detail as I could

We have an application that is sending a mainframe file directly from server to server.  They are uploading this file to their server and then transmitting it directly to our server for ingestion.  When you view the file, its showing carriage control (1 in column 1)...We defined the report in CMOD with a DataType as LINE.  Then run it through the report wizard using the carriage control as the trigger and then highlighting the fields needed for indexing...First issue we found is running it through the report wizard, we had to set the carriage  control to NO on the Indexer Properties box in order to see the carriage control so we could use it as a trigger.  We were able to successfully load the file and at first glance at the indexing, it seemed to work.  But upon opening any specific index, it showed the entire file in each index and we were seeing the carriage control character (1) We then changed the CARRIAGE CONTROL on the application (under view information tab) to YES which automatically changed the CCTYPE to ANSI.  When reloading, each index showed only the pages it should AND the carriage control character was gone.  The REALLY strange thing is , and only on the thick client, when we go in, we see the carriage control and the indexing isn't working.  But if we go out of the report, back in, the carriage control character is once again, not seen and indexing is once again working.  Very strange...We use ICN and haven't seen this issue...Which is good due to that is what the clients are using.  Just curious if anyone else is loading a mainframe file and had any issues?  I've attached the current indexer properties showing the change of the CC=YES..We are running CMOD9.5

40

Windows Client / Copy Query Restrictions

« on: April 19, 2018, 09:40:31 AM »

We have an app group that contains numerous user ids that each have their own unique query restrictions.  We now have another existing app group we need to "copy" that access to.  Does anyone know of a way to accomplish this?..I know you can 'export' permissions of an app group using the Administrator Client to you desktop.  But not sure how to go about doing an import back to another app group to copy the parameters.  Hoping there is a way due to there being so many different user ids each having their own unique query restrictions.  It would be a monumental task to attempt to manually retype everything.

41

Report Indexing / XLS to XLSX conflict

« on: April 04, 2018, 06:40:41 AM »

Hello, we have a application defined with the VIEW set to User Defined and the file extension as XLS...The application is now in the process of converting their data to XLSX...The issue now is, after updating the application to now have XLSX as the file extension and attempting to open an existing version that was created as an XLS on their side, we get the error "Excel cannot open the .XLSX because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file' ....And if we change the application definition back to XLS, then anything loaded that was created as an XLSX gets the same type of error message.  Anyone know of a workaround?...I tried to do a 'wildcard' on the file extension on the application definition by using XLS* but after doing so, NOTHING would open...lol......

42

Report Indexing / Updating multiple Indexs

« on: March 26, 2018, 07:10:57 AM »

Hi....We have been given the task of updating over 12,000 Application indexes...They all contain a line referencing and exit that is no longer needed...Our only means we know of to do this is open the ADMINISTRATOR thick client and going into each Application and then the INDEXER INFORMATION tab and manually removing this one line.  Its the same for each one.  Does anyone know if a way to somehow do this systematically or is this the only way?...Again, our group only has access to do this  via the ADMIN client...Appreciate any info.  Take care...DAVE

43

Report Indexing / Defining an index

« on: March 22, 2018, 03:22:26 AM »

Currently, when we defined an indexer in the Application definition, we define a Trigger, Field and the index(s)...For the Index, we've always used the hex representation of the specific index defined...Ex

TRIGGER1=*,1,X'F1',(TYPE=GROUP)                                    /* 1  */     
FIELD1=3,20,8,(TRIGGER=1,BASE=0)                                   /* PARTICIPANT */
FIELD2=1,38,8,(TRIGGER=1,BASE=0)                                   /* POSTIN_DATE    */
INDEX1=X'D7C1D9E3C9C3C9D7C1D5E3',FIELD1,(TYPE=GROUP,BREAK=YES)     /* PARTICIPANT    */
INDEX2=X'D7D6E2E3C9D5C76DC4C1E3C5',FIELD2,(TYPE=GROUP,BREAK=NO)    /* POSTING_DATE   */

We were told that we don't have to use the hex representation.  We can just use the name itself.  So for example, INDEX1 we would just use the word PARTICIPENT instead of the hex representation.  When I tried that, first putting PARTICIPENT in quotes, INDEX1=X'PARTICIPENT',FIELD1,(TYPE=GROUP,BREAK=YES) it error indicating, The field name '& êèñäñ& +è' found in the index file does not match any expected fields.  The field will be ignored....When I removed the quotes, then I received this error, PARTICIPANT WAS SPECIFIED WHEN QUOTED STRING EXPECTED. , WAS SPECIFIED WHEN = EXPECTED.


A side note, this data is coming from the MAINFRAME which I believe is in EBCIDIC and we're using F1 for our trigger.  This maybe why the indexes are using HEX.  I assumed that the parameter specified on the Indexer just had to match the name on the LOAD INFORMATION tab

Does anyone know what I'm missing or if you HAVE to use HEX?

Appreciate any input!

Take care

Dave

44

Windows Client / Folder update

« on: March 14, 2018, 08:24:47 AM »

Hi,  We found a need to make changes to an existing folder...What we NEED to do is update an existing Folder Field Definition and modify it from a Mapping Type of Single to Operator Or...This was to allow the same folder field definition to be mapped to 2 different application Group Fields...But when I highlight the desired folder field in the FOLDER FIELDS box, the REMOVE option remains grayed out...I even ensure it wasn't mapped to anything in Field Mapping...Does anyone know of a way to "Update" an existing FOLDER FIELD on the Folder definition?

45

Windows Client / Error updating Application group

« on: March 13, 2018, 05:41:42 AM »

We're attempting to add a new field to an existing application group...after adding field and updating the parameters, after clicking on OK, the Admin Client hangs and then we received the message, "The server failed while accessing application group data. Contact your system administrator"...Could it be database related?  As a test, when we did a COPY of the same application group and added the same new field, it was successful.  We are running CMOD9.5