Hi all.
I'm using forms 12c lastest version (12.2.1.3).
I have configured a standalone report server called rep_server1 and i can not successfully call any report from forms using run_report_object through this server.
I have performed several test to track the issue but no luck so far.
These are the tests:
1) A regular call from forms (which i have tested extensively on other installations) failed with FRM-41213.
2) Downloaded test debugging form trcrro12c and report testrro.rep. Tested and it seems to be running ok. The word "error" does not actually appear on trc file.
3) Tested testrro.rep using rwservlet from the browser URL and it works !!!!
http://10.23.202.19:7777/reports/rwservlet?report=/home/webfigo/app/bin/testrro.rep&userid=sqlfigo/password@BFIGO&server=re…
4) I have confirmed Job status repository is working as expected:
1* select count(*) from RW_SERVER_QUEUE
SQL> /
COUNT(*)
----------
5
5) Change the report server to in_process report server (to check my code is OK). It works !!!!.
6) Checked the show jobs page for report server. The jobs are there.
some info from log files which may or may not be relevant:
mar 09, 2018 12:11:24 PM oracle.ods.virtualization.engine.util.VDELogger error
GRAVE: ContextServiceConfig.getConfigPath - failed : JRF no puede determinar la plataforma del servidor de aplicaciones actual.
oracle.jrf.UnknownPlatformException: JRF no puede determinar la plataforma del servidor de aplicaciones actual.
at oracle.jrf.ServerPlatformSupportFactory.getInstance(ServerPlatformSupportFactory.java:61)
at oracle.ods.virtualization.config.impl.file.ContextServiceConfig.getConfigPath(ContextServiceConfig.java:75)
at oracle.ods.virtualization.config.ConfigureAdapters.checkAndSetupConfigFiles(ConfigureAdapters.java:223)
at oracle.ods.virtualization.config.ConfigureAdapters.configure(ConfigureAdapters.java:927)
at oracle.security.jps.internal.idstore.util.LibOvdUtil$LibOvdDataPusherImpl.pushLdapDataToLibOvdIntenal(LibOvdUtil.java:751)
at oracle.security.jps.internal.idstore.util.LibOvdUtil$LibOvdDataPusherImpl.pushLdapDataToLibOvd(LibOvdUtil.java:712)
at oracle.security.jps.internal.idstore.xml.XmlIdentityStoreProvider.getInstance(XmlIdentityStoreProvider.java:132)
at oracle.security.jps.internal.idstore.xml.XmlIdentityStoreProvider.getInstance(XmlIdentityStoreProvider.java:165)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.createContextInternal(ServiceContextManagerImpl.java:687)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.createDefaultContext(ServiceContextManagerImpl.java:322)
at oracle.security.opss.internal.runtime.ServiceContextManagerImpl.initialize(ServiceContextManagerImpl.java:242)
at oracle.security.jps.internal.config.OpssCommonStartup$1.run(OpssCommonStartup.java:166)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.internal.config.OpssCommonStartup.start(OpssCommonStartup.java:159)
at oracle.security.jps.se.JpsSEStartup.start(JpsSEStartup.java:88)
at oracle.security.jps.JpsStartup.startWithRetry(JpsStartup.java:287)
at oracle.security.jps.JpsStartup.start(JpsStartup.java:252)
at oracle.reports.server.RWServer.initSecuritySettings(RWServer.java:1312)
at oracle.reports.server.RWServer.startServer(RWServer.java:601)
at oracle.reports.server.RWServer.jniMain(RWServer.java:289)
mar 09, 2018 12:11:24 PM oracle.ods.virtualization.engine.util.VDELogger warn
ADVERTENCIA: Unable to determine WLS domain name or temp location or current username, using default ovd.lok file
mar 09, 2018 12:11:24 PM oracle.security.jps.internal.idstore.util.LibOvdUtil pushLdapNamesToLibOvd
INFORMACIÓN: Información de tipos y nombre de LDAP transferidos a libOvd. Los LDAP son: u01apporacleproduct12.2.1user_projectsdomainsfrsdomainconfigfmwconfigsystem-jazn-data.xmlidstore.xml.provideridstore.xml.
mar 09, 2018 12:12:22 PM org.hibernate.validator.internal.util.Version <clinit>
INFO: HV000001: Hibernate Validator 5.1.3.Final
mar 09, 2018 12:12:25 PM oracle.security.jps.internal.common.util.JpsCommonUtil initPolicyProvider
INFORMACIÓN: Inicializando el Proveedor de Políticas Java de OPSS.
mar 09, 2018 12:12:26 PM oracle.security.jps.internal.common.util.JpsCommonUtil initPolicyProvider
INFORMACIÓN: Se ha inicializado el proveedor de políticas Java de OPSS.
mar 09, 2018 12:12:26 PM oracle.security.jps.internal.common.util.JpsCommonUtil initPolicyProvider
INFORMACIÓN: Se ha configurado el proveedor de políticas Java de OPSS como el objeto de política de todo el sistema.
mar 09, 2018 12:12:26 PM oracle.security.jps.JpsStartup startWithRetry
INFORMACIÓN: Jps iniciado.
However this log info is register when report server is starting.
I have not enable trace level for report server.
Like i said, i've worked with these configuration before.
I really really appreciate any recomendation from an expert here.
I have configured the in_process report server as the report server where all jobs should be sent (no status repository here). This way the upgrade process won't stop. But i need to solve this issue. I have an interface on my app that uses information from Job Status Repository.
Thanks so much in advance !!!!.