Forum Stats

  • 3,852,361 Users
  • 2,264,096 Discussions
  • 7,905,046 Comments

Discussions

Unable to configure Job Status Repository for WLS_REPORTS

myluism
myluism Member Posts: 965 Bronze Badge

Hi all.

I'm using Forms lastest version (12.2.1.4).

I created the following credential:

Accessing the showJobs page comes with REP-52266:

rwserver.conf is set to:

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

   <property name="dbuser" value="SFIGOAUX"/>

   <property name="dbpassword" value="csf:reports:repo"/>

   <property name="dbconn" value="AAOSABQTO:1521:PDB_WFIGO"/>

  </jobStatusRepository>

This is a pluggable database. Have tried several options but can't enable it.

Any idea on what to check?

Thanks so much in advance !!!

Best Answer

  • myluism
    myluism Member Posts: 965 Bronze Badge
    Answer ✓

    Done !!!

    Solution:

    corrected db_conn value in rwserver.conf:

    <property name="dbconn" value="192.168.0.1:1521/pdb_wfigo"/>

    Using easy connect method change to service_name as reported by lsnrctl status command.

Answers

  • myluism
    myluism Member Posts: 965 Bronze Badge

    Additional info:

    Provided Resource Bundle not available - oracle.sysman.emai.rsc.reports.ReportsMsg

    Detalle Complementario java.util.MissingResourceException: Can't find bundle for base name oracle.sysman.emai.rsc.reports.ReportsMsg, locale es_ES

    at java.util.ResourceBundle.throwMissingResourceException(ResourceBundle.java:1581)

    at java.util.ResourceBundle.getBundleImpl(ResourceBundle.java:1396)

    at java.util.ResourceBundle.getBundle(ResourceBundle.java:854)

    at oracle.sysman.core.model.logmgmt.common.LogMgmtModelUtils.getTranslatedLabel(LogMgmtModelUtils.java:988)

    at oracle.sysman.core.model.logmgmt.common.SelectedTargetInstance.updateSelectedTargetCache(SelectedTargetInstance.java:686)

    at oracle.sysman.core.model.logmgmt.common.SelectedTargetInstance.initLogViewerInstances(SelectedTargetInstance.java:433)

    at oracle.sysman.core.model.logmgmt.common.SelectedTargetInstance.initSelectedTargets(SelectedTargetInstance.java:345)

    at oracle.sysman.core.model.logmgmt.msgs.LogMessagesModel.initSelectedTargets(LogMessagesModel.java:1305)

    at oracle.sysman.core.model.logmgmt.msgs.LogMessagesModel.setSelectedTargets(LogMessagesModel.java:1288)

    at oracle.sysman.core.model.logmgmt.common.LogMgmtModelUtils.populateTargetDetails(LogMgmtModelUtils.java:304)

    at oracle.sysman.core.pagemodel.logmgmt.msgs.LogMessagesPageModel._populateSelectedTargets(LogMessagesPageModel.java:1402)

    at oracle.sysman.core.pagemodel.logmgmt.msgs.LogMessagesPageModel._populateSelectedTargets(LogMessagesPageModel.java:1327)

    at oracle.sysman.core.pagemodel.logmgmt.msgs.LogMessagesPageModel.initializeData(LogMessagesPageModel.java:714)

    at oracle.sysman.core.view.logmgmt.msgs.LogMessagesViewBean.callLogMessagesInitializeData(LogMessagesViewBean.java:2015)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.sun.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:181)

    at com.sun.el.parser.AstValue.invoke(AstValue.java:289)

    at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:304)

    at oracle.sysman.emSDK.view.util.AdfUtil.invokeEL(AdfUtil.java:612)

    at oracle.sysman.sdkImpl.core.uifwk.ui.progress.ProgressBackingBean.pollListener(ProgressBackingBean.java:216)

    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

    at java.lang.reflect.Method.invoke(Method.java:498)

    at com.sun.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:181)

    at com.sun.el.parser.AstValue.invoke(AstValue.java:289)

    at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:304)

    at org.apache.myfaces.trinidad.component.UIXComponentBase.broadcastToMethodExpression(UIXComponentBase.java:2072)

    at org.apache.myfaces.trinidad.component.UIXPoll.broadcast(UIXPoll.java:98)

    at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:373)

    at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:91)

    at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:110)

    at org.apache.myfaces.trinidad.component.UIXComponent.broadcastInContext(UIXComponent.java:373)

    at org.apache.myfaces.trinidad.component.WrapperEvent.broadcastWrappedEvent(WrapperEvent.java:91)

    at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent$1.run(ContextSwitchingComponent.java:169)

    at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent._processPhase(ContextSwitchingComponent.java:511)

    at oracle.adf.view.rich.component.fragment.ContextSwitchingComponent.broadcast(ContextSwitchingComponent.java:172)

    at oracle.adf.view.rich.component.fragment.UIXInclude.broadcast(UIXInclude.java:114)

    at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:790)

    at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1282)

    at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1673)

    at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executeInvokeApplication(LifecycleImpl.java:798)

    at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:380)

    at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:237)

    at javax.faces.webapp.FacesServlet.service(FacesServlet.java:650)

    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)

    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:353)

    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:207)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.adf.view.page.editor.webapp.WebCenterComposerFilter.doFilter(WebCenterComposerFilter.java:119)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.adf.share.http.ServletADFFilter.doFilter(ServletADFFilter.java:77)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.help.web.rich.OHWFilter.doFilter(OHWFilter.java:95)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain$1.call(TrinidadFilterImpl.java:591)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain$1.call(TrinidadFilterImpl.java:587)

    at org.apache.myfaces.trinidad.context.ExternalContextPropagator.processInScope(ExternalContextPropagator.java:216)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:596)

    at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:91)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain$1.call(TrinidadFilterImpl.java:591)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain$1.call(TrinidadFilterImpl.java:587)

    at org.apache.myfaces.trinidad.context.ExternalContextPropagator.processInScope(ExternalContextPropagator.java:216)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:596)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$1.call(TrinidadFilterImpl.java:372)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$1.call(TrinidadFilterImpl.java:368)

    at org.apache.myfaces.trinidad.context.ExternalContextPropagator.processInScope(ExternalContextPropagator.java:216)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:383)

    at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:241)

    at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:101)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.sysman.eml.app.EMRepLoginFilter.doFilter(EMRepLoginFilter.java:729)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at weblogic.websocket.tyrus.TyrusServletFilter.doFilter(TyrusServletFilter.java:274)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.sysman.emas.fwk.MASConnectionFilter.doFilter(MASConnectionFilter.java:50)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.sysman.eml.app.MBeanServerConnFilter.doFilter(MBeanServerConnFilter.java:43)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.adf.library.webapp.LibraryFilter.doFilter(LibraryFilter.java:169)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.sysman.eml.app.ContextInitFilter.doFilter(ContextInitFilter.java:561)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.adfinternal.view.faces.caching.filter.AdfFacesCachingFilterImpl.doFilter(AdfFacesCachingFilterImpl.java:134)

    at oracle.adf.view.rich.webapp.AdfFacesCachingFilter.doFilter(AdfFacesCachingFilter.java:66)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.sysman.core.app.exception.EMRuntimeExceptionFilter.doFilter(EMRuntimeExceptionFilter.java:81)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at oracle.security.jps.ee.http.JpsAbsFilter$3.run(JpsAbsFilter.java:175)

    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:112)

    at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293)

    at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150)

    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 oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3797)

    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763)

    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)

    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:2451)

    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299)

    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277)

    at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1720)

    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1680)

    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:655)

    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

    at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

  • Suresh Sangaran-Oracle
    Suresh Sangaran-Oracle Member, Moderator Posts: 325 Employee

    Provided Resource Bundle not available - oracle.sysman.emai.rsc.reports.ReportsMsg -->

    This message shouldn't be affecting the Reports component.

    1. Can you copy/paste the contents of rwserver.conf
    2. Check for the actual stack trace for REP-52266 in rwservlet_diagnostic.log and rwserver_diagnostic.log
    3. Can you connect to the DB using Reports repository credentials from FMW ORACLE_HOME/bin/sqlplus?

    Thanks, Suresh

  • myluism
    myluism Member Posts: 965 Bronze Badge

    Additional info:

    this is my tns for FMW:

    WFIGO =

     (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = AAOSABQTO)(PORT = 1521))

      (CONNECT_DATA =

       (SERVER = DEDICATED)

       (SERVICE_NAME = PDB_WFIGO)

      )

     )

    Change rwserver.conf to:

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

       <property name="dbuser" value="SFIGOAUX"/>

       <property name="dbpassword" value="csf:reports:repo"/>

       <property name="dbconn" value="AAOSABQTO:1521:wfigo"/>

      </jobStatusRepository>


    Have tried changing "dbconn" value="AAOSABQTO:1521:wfigo" to "dbconn" value="AAOSABQTO:1521:PDB_WFIGO"

    No luck.

    Any idea?

    Thanks in advance !!!

  • myluism
    myluism Member Posts: 965 Bronze Badge

    Hi Suresh.

    rwserver.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"    

      >

      

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

      

      <!--

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

       <property name="oidAppEntity" value="$$Self.oidAppEntity$$"/>

       <property name="oidUrl" value="$$Self.oidUrl$$"/>

       <property name="oidPasswdKey" value="$$Self.oidPasswdKey$$"/>

       <property name="portalUserName" value="$$Self.portalUserName$$" />

       <property name="portalConnection" value="$$Self.portalConnection$$" />

       <property name="portalPasswdKey" value="$$Self.portalPasswdKey$$" />

      </security>

      -->

      

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

       <property name="dbuser" value="$$PORTAL_DB_USERNAME$$"/>

       <property name="dbpassword" value="csf:$$CSF_ALIAS$$:$$PORTAL_DB_PASSWORD_KEYE$$"/>

       <property name="dbconn" value="$$PORTAL_DB_TNSNAME$$"/>

      </destination-->

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

      <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="dbuser" value="SFIGOAUX"/>

       <property name="dbpassword" value="csf:reports:repo"/>

       <property name="dbconn" value="AAOSABQTO:1521:wfigo"/>

      </jobStatusRepository>

      

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

      </connection>

      <queue maxQueueSize="1000"/>

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

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


       <!--UserName and Password that can be used to connect to the mail server-->


       <!--property name="mailUserName" value="%MAIL_USERID%" /-->

       <!--property name="mailPassword" value="%MAIL_PASSWORD%"/-->

      </pluginParam>

    </server>

    Connection from sqlplus:

    C:\Users\Administrador>C:\Oracle\Middleware\FMW\bin\sqlplus sfigoaux/[email protected]

    igo


    SQL*Plus: Release 12.1.0.2.0 Production on Mar Feb 1 08:20:43 2022


    Copyright (c) 1982, 2019, Oracle. All rights reserved.


    Hora de ┌ltima Conexi¾n Correcta: Mar Feb 01 2022 08:16:33 -04:00


    Conectado a:

    Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production


    SQL> show user

    USER es "SFIGOAUX"

    SQL>

    Logs:

    [2022-02-01T07:56:13.543-04:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-52266] [oracle.reports.servlet] [tid: 23] [userId: <anonymous>] [ecid: 00jDObUS5BsFw00Fzzw0w00001PW0003Cq,0:1:100000000] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-52266 : Fallo al iniciar el servidor de Reports en proceso rep_wls_reports_aaosabqto.oracle.reports.RWException: IDL:oracle/reports/RWException:1.0 [[

    oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

    at oracle.reports.utility.Utility.newRWException(Utility.java:1016)

    at oracle.reports.rwclient.RWClient.startInProcessServer(RWClient.java:1161)

    at oracle.reports.rwclient.ServletCmdMgr.handleWebCommand(ServletCmdMgr.java:314)

    at oracle.reports.rwclient.RWClient.handleWebCommand(RWClient.java:1312)

    at oracle.reports.rwclient.RWClient.processRequest(RWClient.java:1900)

    at oracle.reports.rwclient.RWClient.doPost(RWClient.java:789)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)

    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:353)

    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:175)

    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:112)

    at oracle.security.jps.ee.http.JpsAbsFilter.doFilterInternal(JpsAbsFilter.java:293)

    at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:150)

    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 oracle.jrf.servlet.ExtensibleGlobalFilter.doFilter(ExtensibleGlobalFilter.java:92)

    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78)

    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3797)

    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763)

    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)

    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:2451)

    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299)

    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277)

    at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1720)

    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1680)

    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:655)

    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)

    at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)


    ]]

    [2022-02-01T07:58:26.786-04:00] [WLS_REPORTS] [WARNING] [] [oracle.reports.servlet] [tid: 131] [userId: <anonymous>] [ecid: 00jDObavEK^Fw00Fzzw0w00001PW0003Cw,0:1:100000000] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] Multicast:init java.net.SocketException: Unrecognized Windows Sockets error: 0: no Inet4Address associated with interface

    [2022-02-01T07:58:30.028-04:00] [WLS_REPORTS] [WARNING] [] [oracle.reports.servlet] [tid: 131] [userId: <anonymous>] [ecid: 00jDObavEK^Fw00Fzzw0w00001PW0003Cw,0:1:100000000] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] RWClient:startInProcessServer start inprocess server rep_wls_reports_aaosabqto

    [2022-02-01T07:56:09.180-04:00] [WLS_REPORTS] [ERROR] [] [oracle.reports.server] [tid: 160] [userId: <anonymous>] [ecid: 00jDObUS5BsFw00Fzzw0w00001PW0003Cq,0:1:100000000:3] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] SecurityHelper:start Writeable folders not configured. Output destination to 'File' will fail.

    [2022-02-01T07:56:10.520-04:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-1017] [oracle.reports.server] [tid: 160] [userId: <anonymous>] [ecid: 00jDObUS5BsFw00Fzzw0w00001PW0003Cq,0:1:100000000:3] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL]

    REP-1017 : java.sql.SQLException: ORA-01017: nombre de usuario/contraseña no válidos; conexión denegada[[

      

    oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

    at oracle.reports.utility.Utility.newRWException(Utility.java:1016)

    at oracle.reports.utility.DBConnection.connectByThinJDBC(DBConnection.java:197)

    at oracle.reports.utility.DBConnection.connect(DBConnection.java:127)

    at oracle.reports.server.JobRepositoryDB.start(JobRepositoryDB.java:68)

    at oracle.reports.server.JobStore.start(JobStore.java:164)

    at oracle.reports.server.RWServer.startServer(RWServer.java:995)

    at oracle.reports.server.RWServer.run(RWServer.java:340)

    at java.lang.Thread.run(Thread.java:748)


    ]]

    [2022-02-01T07:58:30.072-04:00] [WLS_REPORTS] [NOTIFICATION] [] [oracle.reports.server] [tid: 160] [userId: <anonymous>] [ecid: 00jDObavEK^Fw00Fzzw0w00001PW0003Cw,0:1:100000000:3] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] ServerConfig:logConf Reading server config file C:\Oracle\MIDDLE~1\FMW\USER_P~1\domains\FRSDOM~1\config\fmwconfig\servers\WLS_REPORTS\applications\reports_12.2.1\configuration\rwserver.conf

    [2022-02-01T07:58:30.077-04:00] [WLS_REPORTS] [NOTIFICATION] [] [oracle.reports.server] [tid: 160] [userId: <anonymous>] [ecid: 00jDObavEK^Fw00Fzzw0w00001PW0003Cw,0:1:100000000:3] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] ServerConfig:logConf  <server version="12.2.1.4.0" xmlns="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="1" engLife="50">

       <!--property name="sourceDir" value="your reports source directory"/-->

       <!--property name="tempDir" value="your reports temp directory"/-->

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

       <!--property name="" 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"/>

      <!--

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

       <property name="oidAppEntity" value="$$Self.oidAppEntity$$"/>

       <property name="oidUrl" value="$$Self.oidUrl$$"/>

       <property name="oidPasswdKey" value="$$Self.oidPasswdKey$$"/>

       <property name="portalUserName" value="$$Self.portalUserName$$" />

       <property name="portalConnection" value="$$Self.portalConnection$$" />

       <property name="portalPasswdKey" value="$$Self.portalPasswdKey$$" />

      </security>

      -->

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

       <property name="dbuser" value="$$PORTAL_DB_USERNAME$$"/>

       <property name="dbpassword" value="csf:$$CSF_ALIAS$$:$$PORTAL_DB_PASSWORD_KEYE$$"/>

       <property name="dbconn" value="$$PORTAL_DB_TNSNAME$$"/>

      </destination-->

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

      <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="dbuser" value="$$REPO_DB_USERNAME$$"/>

       <property name="dbpassword" value="csf:$$CSF_ALIAS$$:$$REPO_DB_PASSWORD_KEYE$$"/>

       <property name="dbconn" value="$$REPO_DB_TNSNAME$$"/>

      </jobStatusRepository-->

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

      <queue maxQueueSize="1000"/>

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

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

       <!--UserName and Password that can be used to connect to the mail server-->

       <!--property name="mailUserName" value="%MAIL_USERID%" /-->

       <!--property name="mailPassword" value="%MAIL_PASSWORD%"/-->

      </pluginParam>

    </server>


    ]]

    [2022-02-01T07:58:30.998-04:00] [WLS_REPORTS] [ERROR] [] [oracle.reports.server] [tid: 160] [userId: <anonymous>] [ecid: 00jDObavEK^Fw00Fzzw0w00001PW0003Cw,0:1:100000000:3] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] SecurityHelper:start Writeable folders not configured. Output destination to 'File' will fail.


    Thanks Suresh.

    Clearly credentials are wrong: REP-1017. For me this mean:

    1) Credentials are located.

    2) Database connection is tested. but fails. usuario/contraseña no válidos. For me it means service name is OK.

    Now this is weird. I changed user name to uppercase. I'm sure password is not wrong. I'll give it a try once more.

    Any ideas?

  • myluism
    myluism Member Posts: 965 Bronze Badge

    I have change it again and get this warning:


  • myluism
    myluism Member Posts: 965 Bronze Badge
    Answer ✓

    Done !!!

    Solution:

    corrected db_conn value in rwserver.conf:

    <property name="dbconn" value="192.168.0.1:1521/pdb_wfigo"/>

    Using easy connect method change to service_name as reported by lsnrctl status command.