OnDemand User Group
Support Forums => MP Server => Topic started by: Srinivas on April 24, 2019, 12:46:56 AM
-
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.
-
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.
-
Ref:
https://www.ibm.com/support/knowledgecenter/en/SSEPCD_9.5.0/com.ibm.ondemand.administeringmp.doc/doddo008.htm (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
-
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.
-
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).
-
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,
-
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.
-
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