Home » Developer & Programmer » Reports & Discoverer » Error Running report in 9i
Error Running report in 9i [message #227032] Tue, 27 March 2007 03:15 Go to next message
zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan
Junior Member
Dear All

I receive the following error in 9i report while running the
report on web.

when i run this report having the database on the same machine
it does not show any error. But when i use to connect to the
database which is on the other machine it displays the following error.

REP-50003: Bad command line: userid="scott/tiger@orcl report=dept_hyperlink.rdf destype=cache desformat=html P_deptno=" deptno

This is a hyperlink/drill down report in 9i.

Zafar Iqbal
Karachi
0321-2876518
Re: Error Running report in 9i [message #229373 is a reply to message #227032] Sat, 07 April 2007 01:12 Go to previous messageGo to next message
zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan
Junior Member
I have solved the problem

Thanks

zafar
Re: Error Running report in 9i [message #229393 is a reply to message #229373] Sat, 07 April 2007 05:12 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would you mind to post the solution? I'm glad you made it work, but simply saying "I have solved the problem" will not help other people to solve the same problem when they encounter it.
Re: Error Running report in 9i [message #229582 is a reply to message #229393] Mon, 09 April 2007 04:34 Go to previous messageGo to next message
zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan
Junior Member
Dear Littlefoot

Actually i was supplying variable with the following line.
and as this is a hyperlink report in 9i deptno field is
hyperlinked.

correct syntax :
http://mycomputername:8889/reports/rwservlet?userid="scott/tiger@orcl report=dept_hyperlink.rdf destype=cache desformat=html

I was writing the wrong address like
http://mycomputername:8889/reports/rwservlet?userid="scott/tiger@orcl report=dept_hyperlink.rdf destype=cache desformat=html+dno=&deptno

Thanks
Zafar Iqbal
Re: Error Running report in 9i [message #229703 is a reply to message #229582] Mon, 09 April 2007 15:12 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you!
Re: Error Running report in 9i [message #229784 is a reply to message #229703] Tue, 10 April 2007 01:15 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi,
@LF but how the same report is working in the local databse/local machine and not in the remote machine?
Bye
Ashu
Previous Topic: How to draw lines between the records of report output
Next Topic: Reports source from more than one database
Goto Forum:
  


Current Time: Mon Dec 05 21:33:50 CST 2016

Total time taken to generate the page: 0.08323 seconds