Reports & Discoverer :: FRM-41213 - Unable To Connect To Report Server Error
Feb 27, 2011
I am getting the error FRM-41213: Unable to connect to the report server error when trying to run report by calling from form.
Im not able to access even
with the urls.....rwservlet/showjobs
and /reports/conf/showjobs.
Is there any configuration need to be made in order to run report from form.
I use my report server name as rep_dpaoscit211 .
I havent added any line to any config file for reporting....
View 1 Replies
ADVERTISEMENT
Jul 5, 2013
I'm trying to catch the FRM-41213 ERROR (Unable to connect to the report server), so I can switch the generation to another report server. At runtime the message FRM-41213 appers but I'm unable to catch it using 'exception' or 'error_code'.
Here's my
begin
v_rep := run_report_object (repid, pl_id);
if err_type = 'FRM' and (err_code = '41213' or err_code = '41214') then
message('ss error catch');
end if;
exception
when others then
message('ss error to handle');
end;
View 1 Replies
View Related
May 18, 2010
"FRM- 41213: Unable to connect to the report server error"
View 17 Replies
View Related
Mar 4, 2012
I'm having trouble with my forms builder. I can't connect to my reports server.
DECLARE
REP_ID REPORT_OBJECT;
REP_J_ID VARCHAR2(25);
SERVER_LENGTH NUMBER;
REP_STATUS VARCHAR2(25);
[code]...
View 1 Replies
View Related
Sep 26, 2012
every time user run the report they have got an error like unable to run report.
select b.branchdesc ,
c.description ,
d.groupgldesc ,
a.loanno,f.agreementno,
e.customername ,
(sum(a.dramt) - sum(a.cramt) ) diffamt ,
a.groupglid
[code]....
View 4 Replies
View Related
Aug 25, 2010
I was having report server running well on my oracle database db1.
Now, I created new database :When trying to run the old report server it gives me error.
How could I uninstall the report server and install it again??
View 1 Replies
View Related
Feb 27, 2012
I have installed Windows7 64bit on my laptop and then installed Reports10G. I am not able to connect to DB from Reports10g, Its gives below error -
REP-0501: Unable to connect to the specified database
ORA-02248: Invalid Option for ALTER SESSION
Same Reports10g is able to connect to DB on Windows XP machine. Database version is 11g which is remote.
View 5 Replies
View Related
Dec 6, 2012
The code works great for few reports and for few reports it gives an error saying Unable to run the reports in 10g, When i checked the job status it says Terminated with error: <br>REP-163: Invalid value for keyword DESTYPE. Valid options are FILE, PRINTER, MAIL, INTEROFFICE, or CACHE.
I have kept the DESTYPE as CACHE. It is failing at Run_Report_Object(ReportId, Pl_Id)
View 3 Replies
View Related
Jul 22, 2013
I tried to run the report from form in oracle forms 10g,
The following error is coming when I click on Report Button. frm-41214: unable to run report.
View 5 Replies
View Related
Nov 25, 2010
My own created software is running since last 4 years but now when I am trying to run a report then I got a message "REP-0002 unable to retrieve a string from the report builder" and as a result my report don't run. Please note that some other reports are working properly, this problem is happens only with some of them reports.
View 3 Replies
View Related
Jul 6, 2010
I m trying to open Report in Microsoft Office Excel format with below code.
declare
v_report_nameVARCHAR2(100) := 'F:IrfanNewReportsCurrency.rdf';
v_formatVARCHAR2(12):= 'SPREADSHEET';
begin
Web.Show_Document([URL]......);
end;
when my report run I received one message window File download after that this below error window appear & data can't show in proper format.
View 2 Replies
View Related
Feb 3, 2013
I have developed a bitmap report on report 6i, But I am not able to print report on printer (Thermal Printer Model PRP-085III, A baylan POS printer).
I tried to convert the same report to Character mode and it print fine.
why it is not printing or what I need to set ?
View 4 Replies
View Related
Jan 4, 2012
We are using APPS 11i, Yesterday some Report are end with Error. Error Details Given Below.
X Error of failed request: BadWindow (invalid Window parameter)
Major opcode of failed request: 15 (X_QueryTree)
Resource id in failed request: 0x2600001
Serial number of failed request: 614
Current serial number in output stream: 614
View 1 Replies
View Related
Jul 4, 2013
I m trying to run reports from my application developed using Oracle FORMS6i but the report engine does not show any job. Platform Information: Microsoft Windows Server 2012 Version 6.2 (64 bit).
View 2 Replies
View Related
Jan 18, 2011
I am generating a report with parameter form.
I do not want users to leave a parameter value null . so I applied after parameter form trigger
function AfterPForm return boolean is
begin
IF ( :my_no IS NULL ) THEN
srw.message(101, 'Please enter proper No.');
return (FALSE);
END IF;
return (TRUE);
end;
it is working fine, it displays proper message but after my message, a default message is displayed
REP-0771: After Form Trigger Failed.
I want to avoid this message. if i comment out return(false) then it displays message and runs the report. I want to avoid default oracle message and stop running report also.
View 7 Replies
View Related
Mar 30, 2011
.I created the following procedure to implement Event Driven Reporting:
CREATE OR REPLACE procedure ABC.eve_drv_rep as
myPlist system.SRW_PARAMLIST;
myIdent system.SRW.Job_Ident;
BEGIN
myPlist := system.SRW_PARAMLIST(system.SRW_PARAMETER('',''));
system.srw.add_parameter(myPlist,'GATEWAY','apsIP/reports/rwservlet');
[code]...
Procedure is created successfully but when I execute this procedure, I get the following error:
ORA-20001'Error sending email.Error: ORA-20999
ORA-06512: at "Nml.Eve_Drv_Rep", line 17
ORA-06512: at line 1
2ndly I want to know that whether I should give IP address or Application Server Machine Name in GATEWAY parameter?
And in SERVER parameter either I should give the Application Server Machine Name or Report Server name installed on Application Server Machine?Lastly from where I can get the complete list of Parameters to be added in SRW.Add_Parameter like SERVER, GATEWAY etc.
note that we r using Database 10g Rel.2 and Forms and Reports services on Application Server and the report being called was developed in Reports 10g.
View 6 Replies
View Related
Apr 27, 2012
I have a report where the Shipments list will appear.The shipment_id appears as hyperlink and when it is pressed it should be redirected to another report which displays the cost details on the respective shipments
But we get an error message as in the attachment when i press the hyperlink. what would be the issue and where should i check for the error to resolve? Also the query used to extract data is
/*select
decode(cost_type,
'B','Base',
'A','Accessorial',
'D','Discount',
[code]....
View 12 Replies
View Related
Aug 8, 2011
I have a report that use &totalpages. output PDF, font unicode is error (Mã) but two last page's font is OK (Mã).
View 2 Replies
View Related
Dec 23, 2011
I have developed a tabular report in report builder 6i. Total columns in report 28 in all. Now its throwing following error.
REP-1213: Field 'F_orpahn_Code'references column 'orphan_code'at a frequence below its group
View 1 Replies
View Related
Jan 31, 2012
I prepared a report in Oracle reports and trying to run the report through command line by creating a batch file. but i am getting the following error message when i run the batch file
REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
the batch file is as follows
D:DevSuiteHome_1BINRWRUN p:spannawazeitspanna_wa_zeit.Rep userid=alrayatec/alrayatecprod@alraya.world
DESFORMAT=HTMLCSS DESTYPE='mail' DESNAME='sarfraz_it@hnd.com'
View 1 Replies
View Related
Sep 16, 2002
while trying to generate a PDF or HTML file from a report previewer, I came upon a REP-0999 error message and the previewer was closed!
View 8 Replies
View Related
Jul 10, 2010
when I am trying to send report for prints then I received this error.
"
REP-57054: In-Process Job terminated: The report generated successfully but distribution to destination failed.
REP-50159:The report generated Successfully but distribution to destination failed.
REP-50151: Destination ID Currency failed with error An error occured while sending the file to the printer :HPofficejetpro7700Series- Cannot run program "COrcaleMiddlewareasinst_5Config
eportsin
wlpr":
create process error=2, The system cannot fine the file specified."
View 6 Replies
View Related
Feb 7, 2013
In one machine I have windows xp with Oracle 11.2.0.2 database installed and I am able to connect to the database using both sql developer and sql plus.
In another machine I have windows 7. I installed Oracle client 11.2.0.1, then using Net configuration tool, I installed both listener.ora and tnsnames.ora files.
Now, I want to connect to the database which is installed on windows xp from windows 7 using the oracle client. When I tried to connect, I got the following error :
ERROR:ORA-12560: TNS:protocol adapter error
In order to rectify the above error, I was making sure that ORACLE_HOME AND ORACLE_SID were properly set in the regedit file (under HKEY_LOCAL_MACHINE > SOFTWARE > ORACLE). The ORACLE_HOME was set properly. But I found ORACLE_SID missing. So I added ORACLE_SID environment variable in the registry and re-tried connecting to the database. But I am not able to connect. What else should I do in order to connect?
View 6 Replies
View Related
Apr 20, 2011
i want to know how can i run my report using report server which exist on remote machine ?
is it possible to set parameters then report would use the report server of remote location ?
View 4 Replies
View Related
Jun 29, 2012
I could not connect the reports builder to the database. Im trying to connect it to the XE database. I checked the tns names and the hosts. Everything seems to be fine. But still when i try to connect the report it throws an error "ORA 12541- tns no listner"..
View 11 Replies
View Related
Sep 20, 2012
How can i print a report name with full path at left bottom on report.
View 3 Replies
View Related
Nov 29, 2011
I am trying to open report in parameter form in drill down report.
View 7 Replies
View Related
Dec 19, 2011
I had report A which drill down to report B. While drilling down to report B, The parameter form of report B should be displayed which accept parameter code and then open the report B. My parameter form is displayed but not accepting the input. i am using the hyperlink to display the second report. Is there any cgimap.bat file to be configured for the parameter report? If yes then how to configure this file?
View 1 Replies
View Related
Jun 23, 2010
When I try to manage the report the Discoverer application frozen.
View 5 Replies
View Related
Jul 24, 2011
Is there any way of stopping the report from executing in Before-Report Trigger.
Actually what i am doing is to see whether some records are present there in the table in Before-Report Trigger on which the report is going to print. Because I am doing some updates in After-Report trigger. I want to stop if there is no records present in the table in Before-Report Trigger so the report will not go forward to After-Trigger of the report.
how to stop and by using which statement.the other way so that if report has no data then After-Report Trigger should not fired.
View 2 Replies
View Related