Home » Developer & Programmer » Reports & Discoverer » FRM-41214: Unable to run report (Oracle Reports 12.2.1.3.0)
| FRM-41214: Unable to run report [message #677863] |
Wed, 16 October 2019 13:06  |
 |
Goldaxe
Messages: 36
Registered: September 2019
|
Member |
|
|
Hi, I have reinstalled weblogic12c over other Linux machine, but I am not able to run a report:
* Report Server is RUNNING:
[oracle@dachserwls2 ~]$ sh /opt/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/reports/bin/rwdiag.sh -findAll
Reading the rwnetwork.conf from :/opt/oracle/Oracle/Middleware/Oracle_Home/user_projects/domains/base_domain/config/fmwconfig/components/ReportsToolsComponent/reptoo ls1/rwnetwork.conf
Broadcast mechanism used to locate servers
------------------------------------------
Channel address = 228.5.6.7
Channel port = 14021
(1) Name = rep_wls_reports_dachserwls2 : Type = server : Host = dachserwls2
* But when I call a report from my fmx, through:
ReportServerJob := run_report_object(Report_id,PL_ID);
I get the error:
FRM-41214: Unable to run report
I attach you procedure Lanza_report
.rep and .fmx are on then same path.
The .env file contains REPORTS_PATH and FORMS_PATH variables with the correct path.
report has execution permissions
* If I execute:
http://172.24.47.103:9002/reports/rwservlet/showjobs?
I access to the reports console. I have no reports executed, but it is running.
*One doubt in my fmb:
SET_REPORT_OBJECT_PROPERTY(Report_id,REPORT_SERVER, 'WLS_REPORTS');
WLS_REPORTS is the name I see in my console, but then rep_wls_reports_dachserwls2 is up. Should I change WLS_REPORTS to rep_wls_reports_dachserwls2?
Thanks
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: FRM-41214: Unable to run report [message #677996 is a reply to message #677995] |
Tue, 29 October 2019 11:13  |
|
Goldaxe
Messages: 36
Registered: September 2019
|
Member |
|
|
Now we have the problem that the report runs correctly but does not send it to the printer.
The code is:
Procedure Lanza_Report Is
PL_ID PARAMLIST;
TMPDATA VARCHAR2(10):= 'LISTA';
Report_id Report_Object;
ReportServerJob VARCHAR2(4000) := '';
vjob_id varchar2(200);
vc_rep_status varchar2(200);
Begin
Report_id := find_report_object('CTR80250');
--Report_id := find_report_object('MODULE3');
PL_ID:=GET_PARAMETER_LIST(TMPDATA);
IF NOT ID_NULL(PL_ID) THEN
DESTROY_PARAMETER_LIST(PL_ID);
END IF;
PL_ID:=CREATE_PARAMETER_LIST(TMPDATA);
----- parametros del sistema
Add_parameter(PL_ID,'BACKGROUND', TEXT_PARAMETER, 'YES');
SET_REPORT_OBJECT_PROPERTY(Report_id,REPORT_COMM_MODE, SYNCHRONOUS);
--Muestra el informe en la pantalla y deja el informe en el servidor (%DOMAIN_HOME%\reports\cache)
--tipo de salida
--SET_REPORT_OBJECT_PROPERTY(Report_id,REPORT_DESTYPE, CACHE);
--Para imprimir en impresora desde el formulario
--tipo de salida
SET_REPORT_OBJECT_PROPERTY(Report_id,REPORT_DESTYPE, PRINTER);
--nombre de la salida
SET_REPORT_OBJECT_PROPERTY(Report_id,REPORT_DESNAME, 'IMPBIOPCL_HP');
SET_REPORT_OBJECT_PROPERTY(Report_id,REPORT_DESFORMAT, 'PDF');
SET_REPORT_OBJECT_PROPERTY(Report_id,REPORT_SERVER, 'rep_wls_reports_dachserwls2');
Add_parameter(PL_ID,'PRINTJOB' , TEXT_PARAMETER, 'YES');
Add_parameter(PL_ID,'PARAMFORM' , TEXT_PARAMETER, 'NO');
-- parametros de ususario
ADD_PARAMETER(PL_ID,'PV_ALMACEN' ,TEXT_PARAMETER,:GLOBAL.ALMACEN);
ADD_PARAMETER(PL_ID,'PV_ARTICULO' ,TEXT_PARAMETER,:B1.MVM_ARTICU);
ADD_PARAMETER(PL_ID,'PV_CLIENTE' ,TEXT_PARAMETER,To_Char(:B1.DRV_PROPIE));
ADD_PARAMETER(PL_ID,'PV_CODMOV' ,TEXT_PARAMETER,To_Char(:B1.MVM_CODIGO));
ADD_PARAMETER(PL_ID,'PV_FECDES' ,TEXT_PARAMETER,To_char(:B1.DRV_FECDES,'dd/mm/yyyy'));
ADD_PARAMETER(PL_ID,'PV_FECHAS' ,TEXT_PARAMETER,To_char(:B1.DRV_FECHAS,'dd/mm/yyyy'));
ADD_PARAMETER(PL_ID,'PV_OPERARIO' ,TEXT_PARAMETER,To_char(:B1.Mvm_Operar));
ADD_PARAMETER(PL_ID,'PV_PALETA' ,TEXT_PARAMETER,:B1.Mvm_Paleta);
ADD_PARAMETER(PL_ID,'PV_TIPMOV' ,TEXT_PARAMETER,:B1.Mvm_TipMov);
--ADD_PARAMETER(PL_ID,'PV_TIPO_STOCK',TEXT_PARAMETER,:GLOBAL.Tipo_Operacion);
ADD_PARAMETER(PL_ID,'PV_TIPO_STOCK',TEXT_PARAMETER,'1');
ADD_PARAMETER(PL_ID,'PV_VARLO1' ,TEXT_PARAMETER,:B1.Mvm_Varia1);
ADD_PARAMETER(PL_ID,'PV_VARLO2' ,TEXT_PARAMETER,:B1.Mvm_Varia2);
ADD_PARAMETER(PL_ID,'PV_VARLOG' ,TEXT_PARAMETER,To_Char(:B1.Mvm_Varlog));
ADD_PARAMETER(PL_ID,'PV_CODFA1' ,TEXT_PARAMETER,:B1.CODFA1);
ADD_PARAMETER(PL_ID,'PV_SUBFA1' ,TEXT_PARAMETER,:B1.SUBFA1);
ADD_PARAMETER(PL_ID,'PV_CODFA2' ,TEXT_PARAMETER,:B1.CODFA2);
ADD_PARAMETER(PL_ID,'PV_WHERE' ,TEXT_PARAMETER,:B1.Drv_Where);
ADD_PARAMETER(PL_ID,'PV_2WHERE' ,TEXT_PARAMETER,:B1.Drv_Where2);
ReportServerJob := run_report_object(Report_id,PL_ID);
message('9');pause;
PL_ID := GET_PARAMETER_LIST(TMPDATA);
IF NOT ID_NULL(PL_ID) THEN
DESTROY_PARAMETER_LIST(PL_ID);
END IF;
END;
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Mar 06 07:03:39 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
