Messages

16

Documentation / Re: Legal hold (ERM)

« on: March 13, 2019, 09:54:36 AM »

Thank you for all the help.

17

Documentation / Re: Legal hold (ERM)

« on: March 13, 2019, 06:21:07 AM »

Do the same for an Application?

18

Documentation / Legal hold (ERM)

« on: March 12, 2019, 11:14:31 AM »

We can place individual documents on legal hold.  How can we place a folder or Application Group on legal hold?

19

z/OS Server / Re: SQLR question

« on: January 03, 2019, 02:33:26 PM »

Started researching and found the SQL statements that were causing the problem.  Corrected and all is good.  Thank you

20

z/OS Server / Re: SQLR question

« on: January 03, 2019, 01:47:59 PM »

Sorry for the ignorance, but where can I find that?

21

z/OS Server / Re: SQLR question

« on: January 03, 2019, 11:37:12 AM »

That is not the error we are receiving.

22

z/OS Server / SQLR question

« on: January 03, 2019, 09:26:35 AM »

I have a folder with 2 different Application Groups associated with the folder.  Both Application Groups have the same fields except one has Amount_Charged as decimal and the other has Amount_Charged as string.  As an Administrator when I use the folder I receive in the system log:

Application Group Query: Name(EOB3) Agid(251885) Count() SegStart(2017-07-02 00:00:00) SegStop(2019-01-02 23:59:59) Sql(2;ODDAT_OD_LOAD_DATE,ODDAT_OD_LOAD_DATE;'2017-07-02 00:00:00','2019-01-02 23:59:59';WHERE ODDAT_OD_LOAD_DATE BETWEEN ? AND ? ) SqlR(ODTBL.OD_APPLICATION IN ('ZF120D01    ')) FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()

The folder pulls up the documents that are desired.

When a user uses the folder they receive in the system log:

Application Group Query: Name(EOB3) Agid(251885) Count(751) SegStart(2014-01-03 10:12:39) SegStop(2019-01-03 10:12:39) Sql(3;ODDAT_OD_LOAD_DATE,ODDAT_OD_LOAD_DATE,CLAIM_NUMBER;'2014-01-03 10:12:39','2019-01-03 10:12:39';WHERE ODDAT_OD_LOAD_DATE BETWEEN ? AND ? ) ) SqlR(AMOUNT_CHARGED>-.01) FullTextSearch() FullTextScore() ServerTextSearch() AnnColor() AnnText() OrderBy()

and DB2 error in system log:

DB Error: {DB2 FOR OS/390}{ODBC DRIVER}{DSN11015}   DSNT408I SQLCODE = -420, ERROR:  THE VALUE OF A STRING ARGUMENT WAS NOT                   ACCEPTABLE TO THE DECFLOAT FUNCTION                                     DSNT418I SQLSTATE   = 22018 SQLSTATE RETURN CODE                                 DSNT415I SQLERRP    = DSNXRNUM SQL PROCEDURE DETECTING ERROR                     DSNT416I SQLERRD    = -230  0  0  -1  0  0 SQL DIAGNOSTIC INFORMATION            DSNT416I SQLERRD    = X'FFFFFF1A'  X'00000000'  X'00000000'  X'FFFFFFFF'                  X'00000000'  X'00000000' SQL DIAGNOSTIC INFORMATION                      ERRLOC=5:10:2 -- SQLSTATE=22018, SQLCODE=-420, File=arsdoc.c, Line=3170

Notice the SQLR in both statements.

Any suggestions for a solution?

23

Report Indexing / Re: Load from ARSDOC GET

« on: September 05, 2018, 11:06:52 AM »

I did default to the current date/time and that did not work.

24

Report Indexing / Re: Load from ARSDOC GET

« on: September 05, 2018, 09:13:27 AM »

I found the problem but I don't have a solution.  I have three date/time indexes.  The last index was added a few weeks ago.  So, the documents I am trying to load do not have a date/time for this last index.  That is why I am getting "" could not be converted to a date from the format of %Y-%m-%d %T.  I changed the Application to accept the current date/time but that did not work.  Any suggestions?

25

Report Indexing / Load from ARSDOC GET

« on: August 22, 2018, 12:23:22 PM »

I did an ARSDOC GET and received a document file and an index file.  They seem to be in binary.  What can I do to get them in a readable format?

Also, when I try to load the files, I am receiving an error "" not in Y-m-d format.  I change the format in the application to m/d/Y and receive "2018-08-20" not in m/d/Y format.  Any suggestions on how I can correct the error?

26

Report Indexing / Transfer documents from one folder to another

« on: August 21, 2018, 05:13:50 AM »

We have documents loaded into a folder with a retention of 3 years.  We need to load these documents into a folder with 10 year retention.  I have over 200,000 documents to move.  Is there an easier way to accomplish this besides ARSDOC Get and then do an ARSLOAD?

27

Report Indexing / Graphical Indexer

« on: March 28, 2018, 11:52:10 AM »

I have a PDF of letters.  I am using graphical indexer to separate the letters into OnDemand.  The first letter is an introduction letter for the PDF.  The second letter is the letter that needs to be indexed.  The third letter is a letter of different language to call our service representatives.  The second and third letters are repeated with different information.  I want to group the second and third letter together.

I have a trigger for the first and second letter.  The third letter I cannot create a trigger.

How can I skip the third letter and have it group with the second letter?

This is in my indexer:

COORDINATES=IN
TRIGGER1=UL(2.39,0.90),LR(4.45,1.34),*,'PEDS aging off letters',(TYPE=GROUP)
TRIGGER2=UL(4.13,3.57),LR(4.70,3.81),1,'Group:',(TYPE=GROUP)
FIELD1=UL(4.65,3.56),LR(5.18,3.78),1,(TRIGGER=2,BASE=0)
FIELD2=UL(0.49,2.04),LR(1.43,2.32),1,(TRIGGER=2,BASE=0)
FIELD3=UL(5.15,3.36),LR(6.04,3.59),1,(TRIGGER=2,BASE=0)
INDEX1='GROUP_NO',FIELD1,(TYPE=GROUP)
INDEXSTARTBY=1
RESTYPE=ALL

This is the error I am receiving:

ARS4902I Number of input pages = 38
ARS4915E Field 1 not found on page 3
ARS4922I ARSPDOCI 9.5.0.5 completed code 1

Thank you for any help.

28

General / Re: PDF Indexer

« on: June 28, 2016, 12:38:50 PM »

OK, thank you

29

General / Re: PDF Indexer

« on: June 28, 2016, 10:43:37 AM »

We have been able to load PDFs through the graphical indexer.  We are trying to load line data through the PDF Indexer.

30

General / Re: PDF Indexer

« on: June 27, 2016, 12:15:21 PM »

OK, how should we define the application?