WebReports: REP-51018 / REP-50004 errors

Printable View

11-19-2004, 06:46 PM
ptreves

WebReports: REP-51018 / REP-50004 errors

Hello everyone,

When deploying my Forms/Reports 9i application over the Web with my Linux server, I get REP-51018 and REP-50004 errors when I try to call WebReports from WebForms.

1) Any anyone ran into this problem before ?

2) Would reinstalling Forms/Reports 10g without any SSO (Single Sign ON) feature resolve this matter ?

I have read that I should use the SYNCHRONIZE keyword before the call to Web.Show_document + make changes to my (report server).conf file + make changes to my rwservlet.properties file.

3) Any insight into this issue ?

Regards,

PT
11-19-2004, 07:09 PM
davey23uk

in the previous thread you say you are already re-installing - so what exactly are you doing (apart from not reading the manuals)
11-19-2004, 07:57 PM
ptreves

Comments

Hello,

I have not reinstalled anything.
I doubt if this is related to my installation.

Do not judge me in such a way. I am working very hard to resolve this issue. I have read many Oracle documents on doing a Migration from 6i to 9i. I have also read many articles on metalink and Oracle Posts. They have been a good source of information.

I have not been able to resolve this issue so far

Any suggestions ?

PT
11-19-2004, 08:30 PM
davey23uk

Re: Comments

Quote:

Originally posted by ptreves
Hello,

I have not reinstalled anything.
I doubt if this is related to my installation.

Do not judge me in such a way. I am working very hard to resolve this issue. I have read many Oracle documents on doing a Migration from 6i to 9i. I have also read many articles on metalink and Oracle Posts. They have been a good source of information.

I have not been able to resolve this issue so far

Any suggestions ?

PT

you deserve it because you consistently haven't read the manuals - we all remember the linux debacle.

Do you actually understand what you are doing, or are you just reading and doing without knowing what you are doing
11-19-2004, 08:37 PM
stecal

Re: WebReports: REP-51018 / REP-50004 errors

Quote:

Originally posted by ptreves

2) Would reinstalling Forms/Reports 10g without any SSO (Single Sign ON) feature resolve this matter ?

I have read that I should use the SYNCHRONIZE keyword before the call to Web.Show_document + make changes to my (report server).conf file + make changes to my rwservlet.properties file.

For you, reinstalling is always an option. Wipe the disk and reload the OS first.

I have read that I should use the SYNCHRONIZE keyword before the call to Web.Show_document

And have you done this, just like the MetaLink note says to do, or will you leave the world wondering if you can read and follow directions?
11-20-2004, 12:17 PM
ptreves

Oracle Documentation

Hello everyone,

Your guys are tough.
Here is a source of Oracle documents that I have read related to this matter as well as forum postings and metalink notes:

1) Oracle Forms Services - Using Run_Report_Object to call Reports with a Parameter Form (frmrepparamforms.pdf)
2) Oracle Application Server 10g - Integrating Oracle Reports in Oracle Forms Services Applications
3) Oracle Forms Services - Secure Web.Show_Document calls to Oracle Reports
4) Integrating Oracle9iAS Reports in Oracle9iAS Forms

These refences mention that calls to WebReports from WebForms should be made through a generic function called RUN_REPORT_OBJECT_PROC which I have done. Which I have done.

These references also mentioon that 3 extra USER_PARAMETERS should be added to the reports to Web Enable them. Also, A Before Parameter Form trigger should be added. All of this I have also done and has resulted in the best results that I have so far.

I have also read Metalink documents:
1) Note: 219464.1 How to COnvert Run_Product to Run_Report_Object for Migrating to the Web
2) FRM-41213 while calling reports form from in 9iDS
3) Note: 115532.1 Call to RUN_REPORT_OBJECT from WebForms does not display Reports in Browser
4) Note: 139546.1: Using Reports parameter forms with RUN_REPORT_OBJECT on the web

In addition I have read the following article that I found on the Web:
1) Installation Cookbooks: Deploying Reports on the Web

=====
Through these sources and other, I have learned a greath deal about the working environment iDS and iAS but I have not been able to resolve the issues I have mentionned.

By uncommenting certain parameters in the rwservlet.properties file, I generated a reports trace file and looked at its content which kind of mentionned the errors: REP-50125, REP-51018 and REP-50004.

I have doing a lot of work on my own to resolve these issues.
Your feedback is appreciated.

Regards,

PT
11-20-2004, 12:25 PM
ptreves

Effort so far

Hello again,

Let me just mention to you the effort that I have been doing to resolve this issue on the Oracle 9iDS and Forms/Reports Services 10g.

1) rwservlet.properties: made the following settings:
SINGLESIGNON=NO, RELOAD_KEYMAP=NO, TRACEFILE=rwservlet.trc, TRACEOPTS=TRACE_ALL
2) rep_terrain2004.conf: sourceDir="H:/TEMP/", removed the and tags

Just for reference on the iDS environement, my stand-alone report server is called RepSRV and on the iAS, my in-process reports server is called rep_Linux2005.

3) init.ora: set the SESSIONS=9999
4) Added the SYNCHRONIZE keywork in the generic RUN_REPORT_OBJECT_PROC

All these modification I have read aboutin reference to these errors, but have not resolved these problems.

Your insight is appreciated...

Regards,

PT
11-24-2004, 11:20 AM
ptreves

Still Unresolved

Hello,

Does any one have any ideas how to resolve this issue ?

PT
11-24-2004, 12:54 PM
davey23uk

raise a Tar with support, they will help you and might even be courteous with is
11-25-2004, 01:27 AM
ptreves

Raising a TAR

Hello davey,

You mean raise a TAR with Oracle support.
The problem is that I do not have a support account with Oracle.

Any suggestions about how to resolve this issue ?

Paolo
11-25-2004, 04:55 AM
davey23uk

Re: Raising a TAR

Quote:

Originally posted by ptreves
Hello davey,

You mean raise a TAR with Oracle support.
The problem is that I do not have a support account with Oracle.

Any suggestions about how to resolve this issue ?

Paolo

FANTASTIC - is this for business or pleasure?
11-25-2004, 02:00 PM
ptreves

Feasability work

Hello,

This is an evaluation/feasability consulting project.
This analysis/implementation is done in order to determine the complexity of installing this software.

Again, is there any source of information on this ?

Paolo
11-25-2004, 02:03 PM
davey23uk

Re: Feasability work

Quote:

Originally posted by ptreves
Hello,

This is an evaluation/feasability consulting project.
This analysis/implementation is done in order to determine the complexity of installing this software.

Again, is there any source of information on this ?

Paolo

yes - its called the docs and metalink - get a support contract
11-25-2004, 03:12 PM
stecal

Re: Feasability work

Quote:

Originally posted by ptreves
This is an evaluation/feasability consulting project.
This analysis/implementation is done in order to determine the complexity of installing this software.

Is the determination of complexity based upon your recommendation(s)? That's not a fair evaluation. It typically installs and runs with no problems whatsoever. Thousands of users/customers have done it. How many other postings do you see on the Internet (in all of the other web sites you've posted this and other questions to) with problems like the ones you're continually experiencing? I'm not hacking on you, just wondering what the customer's response is going to be when you say installation is a nightmare, but it was only a nightmare for you and not the rest of the world. Think about how much time you've spent over the past several months with simple, I mean really simple issues such as installation, and weigh that against the cost of buying support from Oracle. In your case, you would have been able to save numerous hours and much personal grief. Just something to think about. Oracle Support can do a remote desktop session with you and "look" at your setup a lot better than anyone reading your repeated questions on the Internet.
11-25-2004, 04:05 PM
ptreves

Comments

Hello,

I understand what you are saying.
I installed the Oracle 9i Database and Forms/Reports Services 10g without errors and I am using them.

The errors I am mentionning are related to the deployment of the Forms/Reports application itself, more precisely Forms calling Reports through a Parameter Form. Like I said, I searched though Metalink and the Oracle documentation I have sited on the matter and implemented several of the fixes suggested but have not been able to resolve the issue so far.

I would appreciate your guidance in trying to resolve this issue ???

Regards,

PT
11-25-2004, 04:27 PM
stecal

Re: Re: Feasability work

Quote:

Originally posted by stecal
Oracle Support can do a remote desktop session with you and "look" at your setup a lot better than anyone reading your repeated questions on the Internet.
11-25-2004, 05:24 PM
ptreves

Web Migration / Oracle

Hello,

This being a trial version and feasibility study, the client does not want to Oracle involved at this stage for financial reasons.

Are you telling me that no one as ran into these problems or that no one worked a migration to the Web with Forms calling Reports over the Web (using Parameter Forms)?

PT
11-25-2004, 05:31 PM
davey23uk

Re: Web Migration / Oracle

Quote:

Originally posted by ptreves
Hello,

This being a trial version and feasibility study, the client does not want to Oracle involved at this stage for financial reasons.

Are you telling me that no one as ran into these problems or that no one worked a migration to the Web with Forms calling Reports over the Web (using Parameter Forms)?

PT

im sure the people who tried it did it properly, due to the fact you can't find anything to help you anywhere - trash it and start again
11-25-2004, 07:23 PM
ptreves

Comments

Hello,

I can run my Forms Through the Web on Oracle 9i iDS and call my Reports from my Forms. The only problem, like I have mentionned is that on the first time that I try to invoke my Reports from my Forms using Parameter Forms, I get the REP-51018 / REP-500O4 Errors.

I found some refences on MEtalink, saying to disable the SSO in the rwservlet.properties file, increase the SESSION parameter in the init.ora file. Which I have done.

However the problem still persist. I get the impression this is more
a configuration issue.

-----
On the iAS running on Linux Red Hat Forms/Reports Services 10g,
I get a Parameter form that is missing for Fields of Type Character + my corresponding WebReports do not come-up through the Web.

The same code works under Oracle 9iiDS however.

I am not convinced that these issues are related to my installation. I did not run into any errors during the installation.

Any ideas ?

PT