ERPstuff - Oracle EBS Community

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

Hi Iqbal,

If you are trying to connect to the database which is in other machine, then make sure following points :
1. Both the machines are connected together (i mean in the
same LAN connection).
2. You have made the new entry of the SID, which you are using to connect to other database is set in your Tnsnames.ora file.

If the above setting is already made then try connecting to sqlplus first by using the connection string which you are using to connect to the other database.

Once you successfully established the connection with the server you are trying to connect, then your report will run.

Please check the settings first.

Thanks,
Yogi.

Thanks

I have solved the problem.

That was a proxy problem as we have a domain here

Zafar Iqbal

[quote]Hi Iqbal,

If you are trying to connect to the database which is in other machine, then make sure following points :
1. Both the machines are connected together (i mean in the
same LAN connection).
2. You have made the new entry of the SID, which you are using to connect to other database is set in your Tnsnames.ora file.

If the above setting is already made then try connecting to sqlplus first by using the connection string which you are using to connect to the other database.

Once you successfully established the connection with the server you are trying to connect, then your report will run.

Please check the settings first.

Thanks,
Yogi.

<i><div align="right">Originally posted by yphakatkar