Reports Download Failure - Load Id

[Srinivas]

Dear All,

Im not able to download the reports from CMOD using load id. But manually i can able to download reports( decollated ) from folder.

And each report size min. 2GB or above. Any other way to download a reports ?

Get Query : /apps/ibm/ondemand/V9.5/bin/arsdoc get -h xxxxxx -u admin -G xxxxxxxx -d . -o A -acgN -X 6072-1-0-60932FAA-0-0 -v
Result : ARS6117I Querying database with SQL string '2;doc_name,pri_nid;'60932FAA%',1;WHERE  doc_name  LIKE  ?  AND  pri_nid  =  ?'

      ARS6084I Search successful

      ARS6107I 3032 document(s) have been queried. Retrieving 1 document(s).
   
      ARS2094E The server failed while retrieving a document

      ARS6026I arsdoc completed.

[jsquizz]

What else is in your system log around the time you ran the retrieval command?

I have seen things like this happen using arsdoc, arsxml, arsload, etc.. When ulimits are not right. It could be a ton of things, but maybe first make sure they are good per the documentation.

[Ed_Arnold]

Ref:

https://www.ibm.com/support/knowledgecenter/en/SSEPCD_9.5.0/com.ibm.ondemand.administeringmp.doc/doddo008.htm

Try using -n

For the GET function, use to retrieve items one at a time from the server. By default, the ARSDOC GET function uses a bulk retrieval method for high-speed retrieval of items from the server.

Ed

[Justin Derrick]

ARS6107I 3032 document(s) have been queried. Retrieving 1 document(s).

Anyone else think this is weird?  3032 *found*, but only 1 to be *retrieved*.

-JD.

[jsquizz]

ARS6107I 3032 document(s) have been queried. Retrieving 1 document(s).

Anyone else think this is weird?  3032 *found*, but only 1 to be *retrieved*.

-JD.

Very..just ran a retrieval script and got this.

04/25/19 12:40:19 : /usr/lpp/ars/bin/arsdoc get -u admin -h archive -a -c -g -N -v -G AG-i where doc_name like '1000FAAA%' -o /transfer_mount/extract/output/AG/1000FAAA

04/25/19 12:40:19 : Attempting login for userid 'admin' on server 'archive' ...

04/25/19 12:40:19 : Login successful

04/25/19 12:40:19 : Querying for application group 'AG' on server 'archive' ...

04/25/19 12:40:19 : Query successful

04/25/19 12:40:19 : Searching for documents in 'AG' ...

04/25/19 12:40:19 : Querying database with SQL string 'where doc_name like '1000FAAA%''

04/25/19 12:40:19 : Search successful

04/25/19 12:40:19 : 2785 document(s) have been queried. Retrieving 2785 document(s).

[Stephen McNulty]

ARS6107I 3032 document(s) have been queried. Retrieving 1 document(s).

Anyone else think this is weird?  3032 *found*, but only 1 to be *retrieved*.

-JD.

JD - I wonder if the message is worded wrong,   -c  should concatenate all documents into a single output file,

[Justin Derrick]

Yup, the -c option is fine -- but it should still say that it's retrieving the same number of documents that it found in the query.  That's odd.

-JD.

[Srinivas]

i tried to download another doc from same folder.

2019-04-17 19:39:26.037544: ARS6108I Starting arsdoc.  Version:  9.5.0.6

2019-04-17 19:39:26.038422: ARS6165I /apps/ibm/ondemand/V9.5/bin/arsdoc get -h XXXXXX -u admin -G BD-eBBS-EODStatementRequestBanGrp -d . -o A -a -c -g -N -X 6402-1-0-10015FAA-0-0 -v

2019-04-17 19:39:26.038543: ARS1609W Specifying passwords on the command line is in-secure due to the text being visible. See the Installation and Configuration Guide for your platfor
m for information about the arsstash command or using Unified Login.

2019-04-17 19:39:26.038616: ARS6822I Attempting login for userid 'admin' on server 'XXXXX' ...

2019-04-17 19:39:26.736457: ARS6080I Login successful

2019-04-17 19:39:26.736522: ARS6836I Querying for application group 'BD-eBBS-EODStatementRequestBanGrp' on server '10.156.3.144' ...

2019-04-17 19:39:27.040667: ARS6082I Query successful

2019-04-17 19:39:27.040759: ARS7013I Building hit list for 'BD-eBBS-EODStatementRequestBanGrp' ...

2019-04-17 19:39:28.078069: ARS7015E Hit list unsuccessful

2019-04-17 19:39:28.078132: ARS6123E The index file doesn't exist or an error occurred during the retrieval of the index file.

2019-04-17 19:39:28.078159: ARS6117I Querying database with SQL string '2;doc_name,pri_nid;'10015FAA%',1;WHERE  doc_name  LIKE  ?  AND  pri_nid  =  ?'

2019-04-17 19:39:34.002976: ARS6084I Search successful

2019-04-17 19:39:34.003029: ARS6107I 656 document(s) have been queried. Retrieving 656 document(s).

2019-04-17 19:39:35.509288: ARS2094E The server failed while retrieving a document

2019-04-17 19:39:35.791740: ARS6026I arsdoc completed.


Is there any way to download  ? Could you please help

Thanks!
SR