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.