| Reports Problem in 10g [message #513898] |
Thu, 30 June 2011 00:40 |
mrnaveed
Messages: 74
Registered: December 2009
Location: Pakistan
|
Member |
|
|
What i have done so for
DECLARE
RO_Report_ID REPORT_OBJECT;
Str_Report_Server_Job VARCHAR2(100);
Str_Job_ID VARCHAR2(100);
Str_URL VARCHAR2(100);
PL_ID PARAMLIST ;
BEGIN
PL_ID := GET_PARAMETER_LIST('TEMPDATA');
IF NOT ID_NULL(PL_ID) THEN
DESTROY_PARAMETER_LIST(PL_ID);
END IF;
PL_ID := CREATE_PARAMETER_LIST('TEMPDATA');
RO_Report_ID := FIND_REPORT_OBJECT('EMPLOYEE');
SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_FILENAME, 'D:\projects\Employee.rdf');
SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_EXECUTION_MODE, BATCH);
SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_DESTYPE, FILE);
SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_DESFORMAT, 'PDF');
SET_REPORT_OBJECT_PROPERTY(RO_Report_ID, REPORT_SERVER, 'Rep_programming');
Str_Report_Server_Job := RUN_REPORT_OBJECT(RO_Report_ID, PL_ID);
Str_Job_ID := SUBSTR(Str_Report_Server_Job, LENGTH('Rep_programming') + 2, LENGTH(Str_Report_Server_Job));
Str_URL := '/reports/rwservlet/getjobid' || Str_Job_ID || '?server=Rep_programming';
WEB.SHOW_DOCUMENT(Str_URL, '_SELF');
DESTROY_PARAMETER_LIST(PL_ID);
END;
But when i run the form and click on the button to view the report then the browser shows this error
"REP-52266: The in-process Reports Server rep_programming failed to start.oracle.reports.RWException: IDL:oracle/reports/RWException:1.0"
And OC4J shows
Rep-50141 Cann't delete file C:\DevSuiteHome_1\reports\server\rep_programming
What could be the problem and how to resolve it.
When i run it through my browser it gives me this error
REP-51002: Bind to Reports Server rep_programming failed
Then i start my report server as mentioned in my previous post then it gives me folllowing message
REP-52266: The in-process Reports Server rep_programming failed to start.oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
Waht could be the probelm and also i would like to know did i need no to strat my report server every time????
Here the detail of my log file
*** 2011/6/29 8:24:28:859 -- Reading server config file C:\DevSuiteHome_1\reports\conf\rep_progrmming.conf
*** 2011/6/29 8:24:28:859 -- <server version="10.1.2.0.2">
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="50"/>
<!--property name="cacheDir" value="your cache directory"/-->
<!--property name="maxCacheFileNumber" value="max number of cache files"/-->
<!--property name="ignoreParameters" value="parameter names to be ignored in constructing cache key, separated by comma ','"/-->
</cache>
<!--Please do not change the id for reports engine.-->
<!--The class specifies below is subclass of _EngineClassImplBase and implements EngineInterface.-->
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="90000">
<!--property name="sourceDir" value="your reports source directory"/-->
<!--property name="tempDir" value="your reports temp directory"/-->
<!--property name="keepConnection" value="yes"/-->
</engine>
<engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" initEngine="1" maxEngine="1" minEngine="0" engLife="50" maxIdle="30" callbackTimeOut="60000"/>
<!--security id="rwSec" class="oracle.reports.server.RWSecurity">
<property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
<property name="oidEntity" value="%REPORTS_OID_ENTITY%"/>
</security-->
<!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">
<property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/>
</destination-->
<destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP">
<!--property name="proxy" value="proxyinfo.xml"/-->
</destination>
<destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV">
<!--property name="proxy" value="proxyinfo.xml"/-->
</destination>
<!-- By default server will use rwnetwork.conf as network config file
Use this element to override the same -->
<!--networkConfig file="rwnetwork.conf"></networkConfig-->
<job jobType="report" engineId="rwEng"/>
<job jobType="rwurl" engineId="rwURLEng"/>
<notification id="mailNotify" class="oracle.reports.server.MailNotify">
<property name="succnotefile" value="succnote.txt"/>
<property name="failnotefile" value="failnote.txt"/>
</notification>
<!--notification id="wfNotify" class="oracle.reports.server.WorkflowNotify">
<property name="connStr" value="%WF_DB_USERNAME%/%WF_DB_PASSWORD%@%WF_DB_TNSNAME%" confidential="yes" encrypted="no"/>
</notification-->
<log option="noJob"/>
<!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
<property name="repositoryConn" value="repo_db_username/repo_db_password@repo_db_tnsname" confidential="yes" encrypted="no"/>
</jobStatusRepository-->
<!--trace traceOpts="trace_all"/-->
<connection maxConnect="20" idleTimeOut="15">
<orbClient id="RWClient" publicKeyFile="clientpub.key"/>
</connection>
<queue maxQueueSize="1000"/>
<!--jobRecovery auxDatFiles="yes"/-->
<!--
The value of the 'identifier' element is encrypted and is of the form SERVERACCESSKEY_USER/SERVERACCESSKEY_PASSWORD
SERVERACCESSKEY_USER and SERVERACCESSKEY_PASSWORD in <server>.conf and targets.xml
file should match for Reports EM pages to display data correctly.
Corresponding entries of username and password in targets.xml:
<Property NAME="Password" VALUE="SERVERACCESSKEY_PASSWORD" ENCRYPTED="FALSE"/>
<Property NAME="UserName" VALUE="SERVERACCESSKEY_USER" ENCRYPTED="FALSE"/>
-->
<pluginParam name="mailServer">mail.hashoogroup.com</pluginParam>
<!--pluginParam name="proxy" type="file">proxyinfo.xml</pluginParam-->
<pluginParam name="xmlpds" type="file">xmlpds.conf</pluginParam>
<pluginParam name="jdbcpds" type="file">jdbcpds.conf</pluginParam>
<pluginParam name="textpds" type="file">textpds.conf</pluginParam>
</server>
*** 2011/6/29 8:24:28:875 -- Reports Server is starting up
*** 2011/6/29 8:24:31:984 -- Reports Server started up engine rwURLEng-0
*** 2011/6/29 8:24:32:109 -- Reports Server started up engine rwEng-0
*** 2011/6/29 8:25:20:93 -- Shutting down engine rwEng-0
*** 2011/6/29 8:25:20:93 -- Reports Server shut down engine rwEng-0
*** 2011/6/29 8:25:20:93 -- Shutting down engine rwURLEng-0
*** 2011/6/29 8:25:20:93 -- Reports Server shut down engine rwURLEng-0
*** 2011/6/29 8:25:20:109 -- Server is shutting down
Please help me what could be the problem i am using stand alone machine which is not on network is it the problem???
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
