[SOLVED] Error in Reports Generation

[naveengupta4s]

Hi,

When I'm trying to generate a report from OTM using Oracle Reports I'm getting the following error:

REP-52005: The specified key hide_pass_key does not exist in key map file.

The same can be seen in the attachment. We are using OTM 5.5 CU3 running in Linux RHEL ES4 environment. Oracle Forms & Reports Server 10g is also installed on Linux.

Appreciate your comments.

Thanks in advance.

Regards,
Naveen

[chrisplough]

Re: Error in Reports Generation

Naveen,

This error occurs when the cgicmd.dat file hasn't been modified (or is incorrectly modified) on the Oracle Reports server. The process for completing this is in section 3, Installing OTM, of the Administration Guide, under the Installing OTM on the Reports Server section. In the most recent version of the v5.5 Guide, this is step #28:

Edit or create the cgicmd.dat file on the Reports Server (under reports10g/reports/conf). The
file should look like the following. Keep in mind that the format of this file is important and
spaces and blank lines should be just as they are below. Replace <db_connect_string> with
the connect string for your OTM database, as configured in your TNSNAMES.ORA file.

all=: %*  
hide_pass_key: userid=glogdba/[email protected]<db_connect_string> %*

Note: Everything from hide_pass_key to %* should be on one line.

Also - ensure that you restart your Oracle Reports server after making this update.

Hope this helps!
--Chris

[naveengupta4s]

Re: Error in Reports Generation

Hi Chris,

Thanks very much fro your solution. That really helped a lot. Further to that I noted that certain reports are not being generated by OTM.
For Eg. Planned vs Actual Arrival.

Upon triggering this report from the Order Base Actions, following message is displayed:
REP-110: Unable to open file 'planned_vs_actual_eta'

Your comments.

Regards,
Naveen

[chrisplough]

Re: Error in Reports Generation

Naveen,

The first think I would check that you've configured the Oracle Reports server conf file correctly. The process for completing this is in section 3, Installing OTM, of the Administration Guide, under the Installing OTM on the Reports Server section. In the most recent version of the v5.5 Guide, this is step #27:

Go to the Oracle Reports HOME directory. Change to the reports/conf/ directory and edit the rep_<REPORTS_SERVERNAME>.conf file. This is an XML file. Make the following changes:
• Change the “engine id” property as follows:
<engine id=”rwEng” class=”oracle.reports.engine.EngineImpl” initEngine=”10”
maxEngine=”20” minEngine=”10” engLife=”50” maxIdle=”30” callbackTimeOut=”90000”>
• Modify the “SourceDir” property
<property name=”sourceDir” value=”<otm_install_path>/glog/reports”/>

You'll need to restart your Oracle Reports instance after making this change.

Next, check the file and directory permissions for your OTM Reports server installation. If you're running on any type of Unix, the file and directory permissions don't get setup correctly to allow this to work. Use the following commands to get things setup correctly, assuming you have your OTM_HOME variable set (or just replace it in the commands):

chmod -R 755 $OTM_HOME
chmod -R 777 $OTM_HOME/rptapache/htdocs

If you're running on Windows -- then we may have to go back to the drawing board.

--Chris

[[email protected]]

Re: Error in Reports Generation

Hi Chris,

With reference to the original issue mention in http://www.otmfaq.com/forums/f28/err...eneration-518/, we have a specific issue related to same problem mentioned in this link.

The configuration we have is a single report server have two report service instance running (Instance) for e.g. rep_server1 and rep_server2. Things are working perfectly from Standalone report as per OTM administration guide (Running test.rdf on these report instances), however the only additional thing we did apart from OTM admin guide is in CGICMD.dat file, we declared the variable as hide_pass_key_rep_server1 and hide_pass_key_rep_server2 and their respective values. I hope you understand this config we did till now.

Now when I restart all the respective servers of OTM, on running the report I receive the same error "REP-52005: The specified key hide_pass_key does not exist in key map file." on OTM UI.

Now yes your are right that you are thinking that hide_pass_key is not present in this configuration. However I tried looking on OTM app, web, report config properties files. There is a mention in glog.common.properties for variable "p_rep_userid=hide_pass_key". Do you think by modifying this to respective values in same file or overriding this variable in glog.properties should resolve this issue on running the report?

Appreciate your help if you can get me your suggest or any link which can help me out.

Thanks and regards,
Suresh

[chrisplough]

Re: Error in Reports Generation

Suresh,

You're definitely on the right track -- however, you'll want to put the updated property into the "Custom Properties" section of your glog.properties file, so that it will override the default setting in glog.common.properties. You always want to make your changes in glog.properties, rather than the other files, as they will often get replaced during patches, upgrades, etc.

So in glog.properties, you'd have one of the following (depending on your OTM instance):

p_rep_userid=hide_pass_key_rep_server1

or

p_rep_userid=hide_pass_key_rep_server2

Also - make sure the web and app servers each have the same respective property defined.

Thanks,
Chris

[[email protected]]

Re: Error in Reports Generation

Thanks Chris very much.

We would be doing this configuration and verify if we get rid of this error.

Thanks and regards,
Suresh

[[email protected]]

Re: Error in Reports Generation

Hi Chris,

This solution resolved our issue. Thanks very much for the solution confirmation.

Regards,
Suresh