topic Re: Error while submitting to a report using Parameter of type string in Application Development and Automation Discussions

Error while submitting to a report using Parameter of type string

Former Member — Fri, 23 Dec 2011 11:02:52 GMT

Requirement: Selection screen has a parameter so as to input the file. under that a checkbox is provided. If this checkbox is checked the program should read the file from desktop and based on that data the report should execute in background mode.

For this i have done in the following way. by comparing the checkbox and sy-batch i read the file contents placed in AL11 and then submitted the report by setting the path in the parameter. Accordingly when sy-batch eq X i read the file from AL11 from the path specified in the parameter.

This is working fine in Dev & Prd. But in Quality system i am facing the error like Wrong type passing parameters P_FILE.

Message No. DB036.

Re: Error while submitting to a report using Parameter of type string

Former Member — Fri, 23 Dec 2011 11:13:01 GMT

Cases can be

1. file name should be in caps (upper case lower case conversion

2. when executing in bg variant not picked

3. collision of file path across servers in a system

In a system there will be servers like in Quality it can have varying servers ex sapqp1 sapqp2 sapqp3

In here qp1 qp2 and qp3 are the servers in quality which can hold the unix data (al11) . If qp2 is directed in your check and if qp2 dosent have the file path it throws error. recently we have faced a similar issue . Problem was solved when basis guys made the setting across all server's to access the path.

Try these options.

Br,

vijay.

Re: Error while submitting to a report using Parameter of type string

Former Member — Fri, 23 Dec 2011 11:26:22 GMT

Dear Vijay,

thanks for your reply..

I confirm that the filename is correct, variant no issue and filepath seems to be correct.

Is it due to the fact that the file is declared as a type 'STRING'. Will it solve if i use a datatype of fixed length ?

br,

Uday

Re: Error while submitting to a report using Parameter of type string

Former Member — Fri, 23 Dec 2011 12:25:20 GMT

May be also .. but you said its working fine in dev and prod .

Change the datatype to appropriate and check . No harm in that .

But can you check with basis guys on this issue ..i have explained the 3 check which is prone..

Br,

Vijay.

Edited by: sniper on Dec 23, 2011 5:55 PM

Re: Error while submitting to a report using Parameter of type string

Former Member — Wed, 25 Jan 2012 09:56:17 GMT

the problem is solved when i used a proper datatype instead of type 'string'.