[nick.polites]

The report server id is not the same. You have

p_reports_server=REP_xxx.COM

Yet I see in the EM manager OAS_HOME at the end. You need to put in the exact string as well as the upper case and lower case.

Also for the future in order for me to help you out fully instead of just guessing, you need to keep the entire screenshots and properties files intact otherwise you won't be getting a lot of help here, just guesswork.

[arunk]

Nick,

I understand Nick, since its contains all those official server informations i just edited it.

And we have now edited the properties file to the same as it is in the em console. Does a server restart neccessary to make these changes take effect?

Regards
Arun

[nick.polites]

Yes it will.

[arunk]

Nick,

We have changed the properties file and made a server restart.

Now iam able to view the scheduled jobs , but when i try to run any reports it shows a different error that it cant able to open the file.

REP-110: Unable to open file 'orders_by_pickup_stop'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'orders_by_pickup_stop'.

I had attached the screenshot.

Any advice/ help?

Regds--

[nick.polites]

You'll need to refer to the admin guide section about installing and configuring Oracle reports. You haven't configured the location for where the the reports are located in your reports.conf file. You also need to create a new entry in your cgicmd.dat file. After you change these you'll need to do a restart of your opmnctl for the changes to take.

[arunk]

Nick,

We had checked all those files you had mentioned. Everything looks to be perfect.

reports.conf file,

<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="10" maxEngine="50" minEngine="10" engLife="50" maxIdle="30" callbackTimeOut="90000">
<!--property name="sourceDir" value="/otm55/glog/reports"/-->
<!--property name="tempDir" value="your reports temp directory"/-->
<!--property name="keepConnection" value="yes"/-->

And this was added in the cgicmd.dat file too,

all=: %*
hide_pass_key: userid=glogdba/glogdba@TEST %*

It just run perfectly when i try running that test.rdf report but otherwise not with anyother PUBLIC reports.

Regds--

[nick.polites]

It's commented out:

Change it to this:
<property name="sourceDir" value="/otm55/glog/reports"/>

also be sure you have a space between each line and also at the end of the file in your cgicmd.dat file

all=: %*

hide_pass_key: userid=glogdba/glogdba@TEST %*

[rj5316]

Hi Nick,

We are getting a new error now, upon trying to view an invoice ...

REP-110: Unable to open file 'commercial_invoice'.
REP-1070: Error while opening or saving a document.
REP-0110: Unable to open file 'commercial_invoice'

pls advice

Rgds--

[nick.polites]

Are you running Oracle reports as a different user than who is running otm? Check the permissions and see if that could be the problem. Your issue either lies in the reports configuration or permissions. It's the same error as before.

[arunk]

Nick,

Many thanks for your reply...

I have edited the reports.conf and cgicmd.dat file as per your instructions. And a server restart is planned on Monday. We will let you know the results once it is done.

Regds--
Arun