Topics

61

Report Indexing / Blank AFP file

« on: December 01, 2016, 05:37:10 AM »

We're attempting to load an AFP file with TLE records..The file is indexed...It shows its loaded to indexes but when you go to open either, all you see is a blank page for each...Not sure why the data isn't being displayed in the Thick viewer...But when attempting to open it in webi, it defaults to a bookmark and shows all the TLE records...Any idea why this would be happening?..Points to a bad data file but was looking for info to give to programmer who sent the file.

62

WEBI interface / FIND ALL

« on: September 20, 2016, 06:04:19 AM »

We have a user attempting to do a FIND ALL search.  The issue is they aren't getting the "matches" box showing the results of the search.  since she is the only one not getting this, we are assuming its something to do with her browser...Anyone have any suggestions?

63

Report Indexing / AFP with TLE's

« on: September 15, 2016, 03:39:39 AM »

We are having an issue with a true AFP file.  It appears when the input file has multiple TLE's (used for indexing) with same name on the first page group the file fails to load. BUT if they occur AFTER the first page group, the file will load successfully..the 88 msg indicates,.

Here is a screen shot of input file showing where multiple TLE's exist for ACCOUNT. When this occurs at start of file, process fails with 88 msg of  2 fields submitted by the indexer, 5 expected.

 DOC CNTL....NOOP: B0204000001200013247300000003. 
REPORT ID....I203                                 
BANK NUMBER....47086                             
ACCOUNT NUMBER....2000132473                     
ACCOUNT NUMBER....2000132465                      
DUPLICATE FLAG....Y                               
ADDR TYPE IND....D                               
PRINT FLAG....N                                   


Please
see below detailed explanation of the issue from the AFP programmer.

They correctly failed the load when these multiple indexed page groups were the first page group in the AFP file but not when it occurred after the first page group; that is when the indexes were created with incorrect values.

1)   It seems from what we observed that the problem we had with the loads is related to how the index rows appear to be created.
-   The process respects the page groups and the correct pages are always indexed.
o   Though the index values seem to be available across the page groups; i.e. the index values from a previous page group would be used in a subsequent page groups index row.
o   It does not seem to clear out TLE's at the point is moves to a new page group
o   Once it finds a duplicate TLE Name it tries to create a new index row; and with the report requiring a specific set of TLE's the duplicate ACCOUNT on the first page group in the load file the set of TLE's failed as it had not yet found all the required TLE's.
o   When the duplicate ACCOUNT TLE's are encountered after the first account the index row is created with the last value from each of the other required TLE's; and as they are not cleared across a page group then it picked up the previous values of DUPLICATE FLAG and PRINT FLAG (we found specific case for both of these situations)
o   Clearing the TLE's after each page group would have prevented the invalid index row's;  though it would likely have also produced the failed test loads from the start of our testing..
o   It seems as though the load and index process currently does not enforce the integrity if the TLE's to be from the same page group currently being processed

64

MP Server / Folder access query

« on: March 09, 2016, 08:02:13 AM »

Does anyone know the best method to determine if anyone has accessed a particular folder in a specified period of time?  We have an Application that is trying to eliminate some reports..Wanted to see if anyone is actually viewing them to determine if they are still required..

65

WEBI interface / Folder Description

« on: January 28, 2016, 09:39:45 AM »

We are looking to see if the Folder Description field can be added when doing a lookup of folders..Most times the folder name means nothing to users but actual description would be beneficial....Found on IBM's site that you can update the ARSWWW.INI File and under DEFAULT BROWSER can add the following parameter...We done that but doesn't seem to work...Maybe an issue with what Webi version we are running, (IBM Web Interface for Content Management Version 1.0.4.500 - 201-SEP27).  Or maybe something else needs to be done in order for change to take effect..any ideas/suggestions?

;;;;;;;;;;;;;;;;;;;;;;;;;;                             
;;; Default Browser    ;;;                             
;;;;;;;;;;;;;;;;;;;;;;;;;;                             
                                                       
[default browser]                                     
FOLDERDESC=1         (Set to '1' if you want the folder description
                   to be displayed)

66

WEBI interface / Downloading many versions at one time

« on: June 16, 2015, 04:33:20 AM »

Hello, we are running Webi 1.0.4.500...In the past week we've had inquiries from users to be able to download information loaded into CMOD across a years worth of data.  As an example, they want to do a search on a particular account number for the 2014 year. Once the accounts are pulled up, they want to be able to download the data pages themselves for the account the search was performed into an excel spreadsheet..We are not aware of any way to accomplish this via Webi....We  believe it can be done via the thick client but no users have that installed..All are using webi..There is a download option but it does not download the data pages, just the indexes.  you can do a "copy to file" once you are the data, which is fine if you doing only a few, but when you want to do MANY (100's) its not feasible to go into each index and do the "copy to file"...Just curious of anyone knows a way to accomplish what the users are looking for. Appreciate any help...

67

WEBI interface / Folder Description on Webi 1.0.4

« on: February 10, 2015, 06:33:26 AM »

We are being asked by our users if the Folder DESCRIPTIONS can be displayed on CMOD Webi 1.0.4....We found documentation on IBM's website where it indicates to change the FOLDERDESC parameter to 1 from 0...It's under the ARSWWW.INI Folder under the DEFAULT BROWSER section...But when we changed that option, descriptions still aren't being displayed to the right of the folder names...The will be displayed if you hover over the Folder name itself...

Here is what the arswww.ini looks like after change:

;;;;;;;;;;;;;;;;;;;;;;;;;;
;;; Default Browser    ;;;
;;;;;;;;;;;;;;;;;;;;;;;;;;

[default browser]
FolderDesc=1
ODApplet.version=2
AfpViewing=plugin
LineViewing=applet
EmailViewing=html
MetaViewing=native
NoLinks=0
ViewNotes=0
AddNotes=0
ServerPrint=0
ServerPrinters=P
AutoDocRetrieval=0
MaxHits=200
ShowDocLocation=0
EncryptCookies=0
EncryptURL=0

here is what the IBM documentation shows to do

FOLDERDESC

Specifies whether the folder description is displayed to the right of the folder name on the folder selection page. The default value is 0 (zero), meaning that the folder description will not be displayed. Specify 1 (one) to display the folder description. If this parameter is not specified or if the value is not defined or recognized, the folder description will not be displayed.

This parameter has a global scope, unless overridden in a browser section (see [browser]). You specify this parameter only once in the DEFAULT BROWSER section.

This parameter is optional.

Example:

     [DEFAULT BROWSER]
     FOLDERDESC=1

68

Report Indexing / Ingestion a .xls file

« on: January 27, 2015, 08:51:51 AM »

Hi,  Currently we are ingesting files into CMOD that are xls.  We defined the Application to use the GENERIC Indexer...The Application then sends 3 files to an ARSLOAD directory on the CMOD server...Those 3 files are the TRIGGER, INDEX and Data File...The Trigger File is formatted as ApplicationName.ApplicationGroupName.ARD....The Index file is formatted ApplicationName.ApplicationGroupName.ard.ind...And the data file (xls) can be called anything but it always ends in .xls....Within the .ind file, the path to the .xls file to the arsload directory is specified...The issue is, after the file is ingested, the Trigger and Index files are removed BUT the .xls file remains in the ARSLOAD directory...It has to be something on how the ARSLOAD directory is configured...We do have another application that is also sending .xls files to CMOD, but they call their xls files, ApplicationName.ApplicationGroupName.ard.out...It would appear that ARSLOAD4 is configured to remove files with ard as the 3rd delimiter...Does anyone know how to configure the ARSLOAD directory to automatically remove a .xls file after ingestion?

69

MP Server / Access Query

« on: January 21, 2015, 04:27:00 AM »

We have numerous "external" ids on our system (in the range of 1000?...They all begin with the same 3 characters...They are asking us to provide them a listing of which if these ids have access to two particular Application groups and then provide them a listing..We ran a summarize, via the ADMIN Client, checking the USER INFORMATION and APPLICATION GROUP PERMISSIONS boxes..This basically gives us the information we need (plus allot of information from the user setup we DON'T need)...the issue we are running into is, with the amount of user ids, how do we then "Pick out" just the information we need, ie user id, user name that have access to the two application groups they are asking about?...We tried providing them the entire summary of all the ids but with such a huge list of all the ids, they sent back requesting JUST the ID's in question..Anyone know of a way to just pull the information we need from the list?...The summary is generated in a .txt format..Tried saving it as a .xls, .doc to see if there was a way to sort it but couldn't find a way...

70

Windows Client / Application Group changes to query restrictions

« on: January 20, 2015, 08:59:28 AM »

Not sure I'm on the right forum for this question...In any event, we are currently running CMOD 8.5.0...On two of our Application Groups we need to make changes on the PERMISSIONS...Currently we have "Query Restrictions" defined on numerous ids (almost 1000)...We need to make changes to these query restrictions on all of these ids...Currently, the only method we know of is via the CMOD ADMIN client and manually going into the Application Group, highlighting each id (one at a time) and then going under the Query Restriction and clicking EDIT and manually making the change...As you can imagine, this is quite tedious and time consuming with so many ids...Does anyone know of a way to make these kind of changes without doing them in the method I described?...Not sure where in the database these query restrictions are found...Basically if they can be located, we need to replace one word with another...Any help would be greatly appreciated!!!!

71

Report Indexing / Date Format

« on: October 30, 2014, 05:02:04 AM »

We had an odd issue here...A customer was using a generic indexer and send their .ind file to us...They are using a FROM_DATE and To_Date...We had collected well over 100,000 files in groups of 5000...On the last run of 3500 we had a failure on one of the FROM_DATE..I

Row 779:  The string "19280320" could not be converted to a date from the format of %Y%m%d

We believe there is a type in  the .ind file seeing as all the other FROM_DATE fields in previous files are either 2008 or 2009...The issue is, the field itself in the file is formatted correctly..The only difference is the date is 1928...It appears for some reason, CMOD doesn't like that number...Once we removed it, the remaining files in the .ind file loaded successfully...Is anyone aware of this kind of issue...Does something need to  be done on the setup to allow a date of 19##?......

72

MP Server / Mass changes to many apps groups

« on: October 06, 2014, 09:51:42 AM »

We have an issue with how some of our application  groups and how they are configured....Basically we have over 1150 groups that need the same change..The change is on the Advanced Storage Management section..Under Migrate Date from Cache....The setting needs to be changed to "When Data is Loaded"...Rather than make these changes manually, is there a way to systematically make these changes?

73

Report Indexing / Multiple Apps associated with Single APP group issue

« on: September 25, 2014, 05:01:47 AM »

Hi...Wanted to pass on an issue we recently ran into...Most of our reports loaded via the mainframe to CMOD...We ran into an issue where we defined one application group and 5 associated apps back in June...The input datasets that created the reports were all allocated at LRECL of 133...Recently, they wanted to add 2 new applications..Since they were for  the same app and retention was the same, we just added them to the existing application group..The difference being their input datasets LRECL were 80 and 81...Everytime we attempt to load the data to CMOD, the mainframe job we run would abend with a condition code 016..The error indicated, - "INREC  field outside range"...After investigating, we found once we defined a new application group for each new application, the data loaded successfully for each...Even though we saw nothing associated on the application group regarding LRECL (that's setup on the application), it appears that once data was loaded to the original application group who's reports were 133, it didn't like anything else but 133 loaded to it..Apparently you can't mix Applications with different LRECLS using the same Application Group...Not sure if anyone else has run into this issue or not..Just wanted to give the FYI on what we found...

74

Windows Client / Slow Response using CMOD8.5 Viewer

« on: September 04, 2014, 04:42:59 AM »

We recently installed CMOD 8.5 Admin and Viewer clients on one of our Admins PC...It's a straight forward install...After installing, we launched the ADMIN client and then configured a new PROD SERVER...It opened fine and quickly..Was able to access all the App Groups, Apps, Folder and User definitions...The issue is, when we launch the viewer and point to the PROD SERVER, it goes into NOT RESPONDING..After almost a minute it will finally open up to the Folder Search...We can perform search and open up a folder (System log)..Able to search messages just fine...But when we go to close the folder, it again goes into a NOT RESPONDING before finally opening back to the search...Have NO idea why this is...As indicated, the ADMIN client works perfectly..And the Viewer is based on the server definition defined in the ADMIN client...Any thoughts on why this is occurring?...It must be noted that the two PC's this has occurred on were recently re-imaged (which is why the software needed to be reinstalled)...Others in the group who have the same software installed have no issues..Which leads us to believe its PC related....Just not sure where to look...Any input would appreciated!!!

Dave

75

WEBI interface / Index search options not showing

« on: July 23, 2014, 06:55:00 AM »

We have a report that has 30 indexes....For some reason, the last 4 are not showing the search in webi...They are, however, showing in the thick client version of CMOD...Is there a limitation to the number of viewable searches allowed in webi?...This is the version of webi we are running, Version 1.0.4.500 - 201-SEP27