3 Replies Latest reply on Jun 5, 2019 10:59 AM by Matthew D.

    Run reports....

    Jomar

      Hi,

       

      Very hard... instatation forms  and reports... (f² + r² = app²)

       

      Sorry for coming back to insist on this topic, except that something steps failed...

      The Forms builder, without report work beautifully!

       

      I installed normally with the documentation oracle and I could not take run report ...

      Try re-installing, and following as the video, https://www.youtube.com/watch?v=j-BTJiOoBNA, but  cannot run report agains...

      I started reports builder and created new report and run paper layout and fine!

      But run the web layout and ERROR: FAILED TO FIND THE BROWSER TRY TO CONNECT AGAIN. The browser it's opens, but does not put anything without address ...

       

      I run http://localhost:9001/forms/frmservlet

      forms.jpg

      Forms Open e click run reports: FRM-41213: Unable to connect to report server rep_wls_reports_guido-lap.

       

      But rep_wls_reports_guido-lap exists!

      reportgetinfo.jpg

      What is happens?

       

      Regards

       

      SO: Windows 10 64bit

      DB: 18XE

      FR: 12.2.1.3.0

        • 1. Re: Run reports....
          Jomar

          Hi,

           

          I open Report Builder and run web layout:

          Open browser ie:

          Error:

           

          Reports Error Page

           

          Tue Jun 04 16:44:03 BST 2019

          java.lang.NullPointerException

          java.lang.NullPointerException 
          at oracle.reports.jsp.ReportTag.release(ReportTag.java:535)
          at jsp_servlet.__demo2000314992._jspService(__demo2000314992.java:157)
          at weblogic.servlet.jsp.JspBase.service(JspBase.java:35)
          at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
          at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
          at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
          at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
          at weblogic.servlet.internal.ServletStubImpl.onAddToMapException(ServletStubImpl.java:489)
          at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:376)
          at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
          at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:172)
          at java.security.AccessController.doPrivileged(Native Method)
          at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
          at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:650)
          at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:110)
          at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:273)
          at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:147)
          at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
          at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:248)
          at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3701)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3667)
          at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326)
          at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
          at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
          at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
          at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2443)
          at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2291)
          at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2269)
          at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1703)
          at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1663)
          at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
          at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
          at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
          at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
          at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
          at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:644)
          at weblogic.work.ExecuteThread.execute(ExecuteThread.java:415)
          at weblogic.work.ExecuteThread.run(ExecuteThread.java:355) 

          Why?

          Regards


          • 2. Re: Run reports....
            Jomar

            hI,

             

            error tag, but repor open blanck page and when run forms and call report frm-41213....

            My rwnetwork.conf

            <?xml version="1.0" encoding="ISO-8859-1"?>

            <discoveryService

                xmlns="http://xmlns.oracle.com/reports/network"

                  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     

                   >

              <!--multicast channel="228.5.6.7" port="14021" timeout="1000"/-->

             

             

              <namingService name="Cos" host="192.168.0.151" port="14021"/>

            </discoveryService>

             

            My rwbuilder.conf

            <?xml version = '1.0' encoding = 'ISO-8859-1'?>

            <server 

                xmlns="http://xmlns.oracle.com/reports/server"

                xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                xsi:schemaLocation="http://xmlns.oracle.com/reports/server"

                >

              

               <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"/-->

               </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" maxEngine="1" minEngine="0" engLife="50" >

                  <!--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" maxEngine="1" minEngine="0" engLife="50" />

               <!--security id="rwJaznSec" class="oracle.reports.server.RWJAZNSecurity"/-->

                  <!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">

                        <property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" encrypted="no"/>

               </destination-->

              

               <!--security id="rwSec" class="oracle.reports.server.RWSecurity">

               </security-->

              

               <destination destype="ftp" class="oracle.reports.plugin.destination.ftp.DesFTP"/>

               <destination destype="WebDav" class="oracle.reports.plugin.destination.webdav.DesWebDAV"/>

             

               <job jobType="report" engineId="rwEng" securityId="rwJaznSec"/>

               <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%" encrypted="no"/>

               </notification-->

               <!--jobStatusRepository class="oracle.reports.server.JobRepositoryDB">

                  <property name="repositoryConn" value="repo_db_username/repo_db_password@repo_db_tnsname" encrypted="no"/>

               </jobStatusRepository-->

              

               <connection maxConnect="50" idleTimeOut="15">

               </connection>

               <queue maxQueueSize="1000"/>

               <!--jobRecovery auxDatFiles="yes"/-->

               <!--C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain-->

               <proxyInfo>

                 <proxyServers>

                   <proxyServer name="$$Self.proxyHost$$" port="$$Self.proxyPort$$" protocol="all"/>

                 </proxyServers>

                 <bypassProxy>

                  <domain>$$Self.proxyByPass$$</domain>

                 </bypassProxy>

               </proxyInfo>

               <pluginParam name="mailServer" value="%MAILSERVER_NAME%">

                  <!--property name="enableSSL" value="yes"/-->

               </pluginParam>

               <webLayout port="9002" docroot="C:\Oracle\Middleware\Oracle_Home\user_projects\domains\base_domain\servers\WLS_REPORTS\tmp\_WL_user\reports_12.2.1\5ah7s6\war"/>

            </server>

            My rwservlet.properties

            <?xml version="1.0" encoding="UTF-8"?>

            <rwservlet xmlns="http://xmlns.oracle.com/reports/rwservlet" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

               <server>rep_wls_reports_guido-lap</server>

               <singlesignon>no</singlesignon>

               <inprocess>yes</inprocess>

               <webcommandaccess>L2</webcommandaccess>

            </rwservlet>

             

            Regards

             

            PS: I'm sorry, but I've been in this for several days....

            • 3. Re: Run reports....
              Matthew D.

              Did you add to forms env file COMPONENT_CONFIG_PATH?

               

              Use this note to diagnose the problem:

               

              Diagnosis Test Form for Easy Debugging of FRM-41213 or FRM-41214 Error (12c) (Doc ID 2335343.1)

               

              Also, change report_destype from file to cache in when-button-pressed trigger.