I have been researching this problem for a couple weeks now and at a dead end.
Running 12c form and reports, Linux OEL 6, WebLogic 12c. Also, this is a 6i to 12c migration of all objects. This fails when sending the report directly across in the URL and with web.show_document.
Have added the COMPONENT_CONFIG_PATH, added the suggested changes to rwserver.conf and the rwservlet.properties, all folders and objects are wide open at 0777. I've tried a number of different users with various privileges but all have resulted in the same error. I have tried with RUN_REPORT_OBJECT and that also results in an error of FRM-41219. Here is the rwserver.confg:
<?xml version="1.0" encoding="UTF-8"?>
<server xmlns="" xmlns:xsd=""> <cache> <property name="cacheSize" value="50"/> </cache> <engine engLife="1" maxEngine="1" minEngine="1" maxIdle="3" callbackTime="90000"> <property name="sourceDir" value="/app01/bcis/forms"/> <property name="tempDir" value="/app01/oracle/tmp"/> <property name="keepConnection" value="yes"/> </engine> <engine engLife="50" maxEngine="1" minEngine="0"/> <!-- <destination destype="file"/> <destination destype="cache"/> <destination destype="printer"/> --> <destination destype="ftp"/> <destination destype="WebDav"/> <!--job engineId="rwEng" jobType="report" securityId="Empty"/--> <!--job engineId="rwURLEng" jobType="rwurl" securityId="Empty"/--> <notification> <property name="succnotefile" value="succnote.txt"/> <property name="failnotefile" value="failnote.txt"/> </notification> <jobRepository> <property name="dbuser" value="rwadmin"/> <property name="dbpassword" value="csf:reports:repo"/> <property name="dbconn" value="dcis2d01.mlgw.org:1522:CISDB12"/> </jobRepository> <connection idleTimeOut="30" maxConnect="250"/> <queue maxQueueSize="1000"/> <folderAccess> <read>/app01/bcis/forms:/app01/bcis/reports:/app01/bcis/dev/exe:/app01/bcis/exe:/app01/oracle/tmp</read> <write>/app01/bcis/forms:/app01/bcis/reports:/app01/bcis/dev/exe:/app01/bcis/exe:/app01/oracle/tmp</write> <defaultWriteFolder>/app01/bcis/forms</defaultWriteFolder> </folderAccess> <identifier encrypted="yes">QgZSFEalKUbL0t/KwwqSEg0=</identifier> <proxyInfo> <proxyServers> <proxyServer name="$$Self.proxyHost$$" port="$$Self.proxyPort$$" protocol="all"/> </proxyServers> <bypassProxy> <domain>$$Self.proxyByPass$$</domain> </bypassProxy> </proxyInfo> <pluginParam value="%MAILSERVER_NAME%" name="mailServer"/>
</server>The naming service:
<namingService name="Cos" host="10.211.212.164" port="14021"/>I have checked the spelling of all paths, so they are right and they do run under rwrun and I can bring them up in rwbuilder. If there is anything else that would be helpful, please let me know. Any suggestions at this point will be helpful and I would appreciate as many quick responses as possible.
2 Answers
Have you added the report as an object in the calling form? (Similar to adding a new canvas or new datablock)
The find_report_object call should be passed the name of the report object as it was added to the form. The FRM-41219 makes me think you haven't added the report object. This did not need to be done in 6i.
Have you tried to verify that the reports are generated? You could try trigger generation of a report directly from a curl command on the reports server. I use something like the below URL to verify that the reportsserver is running:
1
