OnDemand Users Group

Support Forums => CMOD for Multiplatforms => Topic started by: jose.arotinco on March 20, 2014, 10:45:12 PM

Title: Help with reports AFP
Post by: jose.arotinco on March 20, 2014, 10:45:12 PM
Hello,

I loaded line reports type and use resources for the background image. Could someone give me an example of the command to download such reports and the command for reload. That command I use and what parameters to use.

I tried several ways but have not been successful.

arsdoc get -G MEDHA -h server -u admin -p password -i "WHERE anio=2010 " -N -v -a -c -o MEDHA.out -d E:\Temp

outputs:
MEDHA.out.2.MEDHA.MEDHA.out
MEDHA.ind
MEDHA.res

arsadmin load -h server -u admin -p password -g MEDHA -i E:\Temp\MEDHA.ind -s MEDHA.out.2.MEDHA.MEDHA.out
-r E:\Temp\MEDHA.res

ARS1134E Invalid structured field header in the file E:\Temp\MEDHA.ind



Thanks.

Title: Re: Help with reports AFP
Post by: jeffs42885 on March 20, 2014, 10:58:29 PM
Something seems fishy with that output AFP file?
Title: Re: Help with reports AFP
Post by: Justin Derrick on March 21, 2014, 02:23:07 PM
Use arsload, not arsadmin load.

-JD.
Title: Re: Help with reports AFP
Post by: jeffs42885 on March 21, 2014, 03:01:15 PM
Quote from: Justin Derrick on March 21, 2014, 02:23:07 PM
Use arsload, not arsadmin load.

-JD.

How did I miss that  ??? ??? :o :o :o
Title: Re: Help with reports AFP
Post by: jose.arotinco on March 21, 2014, 03:55:48 PM
Justin,

Please could you give me an example of how to load a report AFP with arsload?
Title: Re: Help with reports AFP
Post by: Justin Derrick on March 22, 2014, 05:43:29 PM
Hey Jose.

It would be best if you reviewed the documentation so you can learn what all the options for arsload are, and how to use them in your situation:

http://pic.dhe.ibm.com/infocenter/cmod/v8r5m0/topic/com.ibm.ondemand.administeringmp.doc/dodlo001.htm

Don't hesitate to come back with any questions you have once you've reviewed the documentation.

-JD.
Title: Re: Help with reports AFP
Post by: jose.arotinco on March 23, 2014, 01:01:09 AM
Justin

I have reviewed the documentation several days and can not find how to load the reports correctly, leaving me still the same error with arsload:

Load:
od_inst arsload-h {}-u {user}-p {pass}-vf-XG-g-a {AppGroup} {app} {MyFileName}

Title: Re: Help with reports AFP
Post by: rick on March 24, 2014, 04:33:17 AM
When file is retrieved using arsdoc get, the .ind and .res file names should have same naming convention that of .out file. Are they manually renamed?


rename the files to as below and try loading using arsload

MEDHA.out.2.MEDHA.MEDHA
MEDHA.out.2.MEDHA.MEDHA.out
MEDHA.out.2.MEDHA.MEDHA.ind
MEDHA.out.2.MEDHA.MEDHA.res

arsload -h {}-u {user}-p {pass}-vf-XG-g-a {AppGroup} MEDHA.out.2.MEDHA.MEDHA
Title: Re: Help with reports AFP
Post by: Justin Derrick on March 24, 2014, 10:47:02 AM
I'm not sure if it's how the forum formats text, but it looks like all the options are crammed together -- there needs to be a space between the options (which start with a hyphen ("-")).

Also, it looks like you're specifying the Application rather than the Application Group.  So try this one instead:

arsload -h {} -u {user} -p {pass}-vf -XG -g {AppGroup} -a {Application} MEDHA.out.2.MEDHA.MEDHA

(FYI, I used the 'teletype' button in the message editor to get a fixed-width font.)

-JD.
Title: Re: Help with reports AFP
Post by: jose.arotinco on March 24, 2014, 07:31:47 PM
Frederick,

Thank you very much! the files renamed it as you indicated and it worked fine...seems simple but it took me several days to find the solution, thanks to you guys.

Regards,