Print Page - How can I index file based on the input filenam?

Title: How can I index file based on the input filenam?
Post by: abdeshpa on September 15, 2014, 08:43:11 PM

Hi,

Is there a way in OnDemand where I can index a file with the fields that are in the input filename.
Ex.
BT.REPORT.<REPORTTITLE>.<RPTDATE>.DATE.TIME.ARD

So based on the above filename, the ondemand should be able to index the file based on the information provided in <REPORTTITLE> & <RPTDATE>.

Thanks
Abhi

Title: Re: How can I index file based on the input filenam?
Post by: abdeshpa on September 15, 2014, 08:48:33 PM

Also, 1) if possible what would be the exact filename?
how will ondemand identify which nodes to take as the indexes.

2) Is there a way ondemand can create a .ind file based on the input filename?

Title: Re: How can I index file based on the input filenam?
Post by: rick on September 16, 2014, 08:49:26 AM

This could be accomplished by -b and -B options of arsload command.

Title: Re: How can I index file based on the input filenam?
Post by: abdeshpa on September 17, 2014, 09:07:13 PM

Why am I getting this error.

arsload -b RPTDATE -B APP.AG.IDXDT.IGN.EXT -fnv YYYYYY.XXXXXX.20140916.ARD.Failed
arsload: Processing file >YYYYYY.XXXXXX.20140916.ARD.Failed<
arsload: Load Version <8.5.0.7> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.7> Operating System <AIX> <6.1> Database <DB2> <09.07.0005>
arsload: Unable to add another index field to the data. Data may be fully-composed or otherwise already indexed.
arsload: Processing failed for file >YYYYYY.XXXXXX.20140916.ARD.Failed<
arsload: Processing has stopped. The remaining files will NOT be processed.

Title: Re: How can I index file based on the input filenam?
Post by: Justin Derrick on September 18, 2014, 10:54:46 AM

Are you sure you're using the -B option correctly? I see four 'parameters' in your -B option, and three parameters in your file name.

-JD.

Title: Re: How can I index file based on the input filenam?
Post by: abdeshpa on September 18, 2014, 08:49:43 PM

See below -

While using the Generic indexer.

arsload -b "RPTDATE" -B "APP.AG.IDXDT.IGN.EXT" -fnv XXX.YYY.20140916.ARD.Failed
arsload: Processing file >XXX.YYY.20140916.ARD.Failed<
arsload: Load Version <8.5.0.7> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.7> Operating System <AIX> <6.1> Database <DB2> <09.07.0005>
arsload: Unable to add another index field to the data. Data may be fully-composed or otherwise already indexed.
arsload: Processing failed for file >xxx.yyy.20140916.ARD.Failed<
arsload: Processing has stopped. The remaining files will NOT be processed.

after setting the PDF indexer in app.

arsload -b RPTDATE -B APP.AG.IDX.IGN.EXT -fnv xxx.yyy.20140916.ARD.Failed
arsload: Processing file >xxx.yyy.20140916.ARD.Failed<
arsload: Load Version <8.5.0.7> Operating System <AIX> <6.1>
arsload: Server Version <8.5.0.7> Operating System <AIX> <6.1> Database <DB2> <09.07.0005>
arsload: 09/17/14 17:45:20 -- Indexing started, 48225 bytes to process
ARS4901 FIELD1='Dummy'
ARS4901 INDEX1='DUMMY',FIELD1,(TYPE=GROUP,BREAK=YES)
ARS4905 INDEX1 parameter syntax incorrect
ARS4901 FIELD128 = '20140916'
ARS4901 INDEX128 = 'RPTDATE',FIELD128,(TYPE=GROUP)
ARS4901 parmdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.parm
ARS4901 inputdd=/edms/coolload/XXXXX01.YYYYYYY.20140916.ARD.Failed
ARS4901 outputdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.out
ARS4901 indexdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.ind
ARS4901 resobjdd=./XXXXX01.YYYYYYY.20140916.ARD.Failed.res
ARS4922 ARSPDOCI completed code 1
arsload: 09/17/14 17:45:20 Indexing failed
arsload: Processing failed for file >XXXXX01.YYYYYYY.20140916.ARD.Failed<
arsload: Processing has stopped. The remaining files will NOT be processed.

OnDemand Users Group

Support Forums => Report Indexing => Topic started by: abdeshpa on September 15, 2014, 08:43:11 PM