miércoles, 19 de diciembre de 2018

Oracle Reports 12c: OCI_INVALID_HANDLE. ==> select

Al tratar de ejecutar algún reporte en la versión 12c de Oracle Reports, se puede mostrar el siguiente mensaje de error de forma intermitente:

REP-300: OCI_INVALID_HANDLE. ==> select .....

Desde el Reports Builder el mensaje de error se puede ver de esta manera:



En el log de diagnostico se puede encontrar alguno de este estos errores: REP-300 : OCI_INVALID_HANDLE, REP-0501, and ORA-00002
CAUSA:

Este comportamiento se debe a los siguientes bugs:

Bug:10100777 "Reports Engine Crash With Rep-501"
Bug:13327994 "REP-300 / REP-501 AFTER A WHILE OF USING REPORTS SERVER EVEN WITH PATCH 10100777"
Bug:18595884 "REP-300 UNTIL ENGINE IS RESTARTED"



SOLUCIONES:

12c:

Usar versión R2 pues los fix a estos bugs ya están incluidos en las versiones 12.2.1.X

11gR2:

11.1.2.2 : Aplicar parche 18595884

11.1.2.1 : Los fix para los bugs 10100777 y 13327994 ya están incluidos en esta versión, no hay necesidad de aplicar nada.

11.1.2.0 : El fix para el bug 10100777 ya esta incluido en esta versión, solo es necesario aplicar el parche correspondiente para el bug 13327994

Otras versiones leer Doc ID 1270315.1

viernes, 7 de diciembre de 2018

BEA-000386 - Server subsystem failed. Reason: A MultiException has 20 exceptions

Al tratar de iniciar Weblogic 12c, se puede presentar el siguiente error y éste no inicia:

<Nov 25, 2018 12:01:56,844 PM MST> <Critical> <WebLogicServer> <BEA-000386> <Server subsystem failed. Reason: A MultiException has 20 exceptions.  They are:
1. java.lang.NullPointerException
2. java.lang.IllegalStateException: Unable to perform operation: post construct on weblogic.store.admin.DefaultStoreService
3. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.transaction.internal.TransactionService errors were found
4. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.transaction.internal.TransactionService
5. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.jdbc.common.internal.JDBCService errors were found
6. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.jdbc.common.internal.JDBCService
7. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.PartitionRuntimeStateManager errors were found
8. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.PartitionRuntimeStateManager
9. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.partition.admin.DomainLevelResourceGroupStateHelperImpl errors were found
10. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.partition.admin.DomainLevelResourceGroupStateHelperImpl
11. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.PartitionRuntimeStateManager errors were found
12. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.PartitionRuntimeStateManager
13. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.partition.admin.PartitionResourceGroupStateHelperImpl errors were found
14. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.partition.admin.PartitionResourceGroupStateHelperImpl
15. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.deploy.internal.ConfiguredDeployments errors were found
16. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.deploy.internal.ConfiguredDeployments
17. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.deploy.internal.DeploymentShutdownService errors were found
18. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.deploy.internal.DeploymentShutdownService
19. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.application.services.ApplicationShutdownService errors were found
20. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.application.services.ApplicationShutdownService


A MultiException has 20 exceptions.  They are:
1. java.lang.NullPointerException
2. java.lang.IllegalStateException: Unable to perform operation: post construct on weblogic.store.admin.DefaultStoreService
3. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.transaction.internal.TransactionService errors were found
4. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.transaction.internal.TransactionService
5. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.jdbc.common.internal.JDBCService errors were found
6. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.jdbc.common.internal.JDBCService
7. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.PartitionRuntimeStateManager errors were found
8. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.PartitionRuntimeStateManager
9. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.partition.admin.DomainLevelResourceGroupStateHelperImpl errors were found
10. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.partition.admin.DomainLevelResourceGroupStateHelperImpl
11. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.PartitionRuntimeStateManager errors were found
12. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.PartitionRuntimeStateManager
13. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.partition.admin.PartitionResourceGroupStateHelperImpl errors were found
14. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.partition.admin.PartitionResourceGroupStateHelperImpl
15. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.deploy.internal.ConfiguredDeployments errors were found
16. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.deploy.internal.ConfiguredDeployments
17. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.management.deploy.internal.DeploymentShutdownService errors were found
18. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.management.deploy.internal.DeploymentShutdownService
19. java.lang.IllegalArgumentException: While attempting to resolve the dependencies of weblogic.application.services.ApplicationShutdownService errors were found
20. java.lang.IllegalStateException: Unable to perform operation: resolve on weblogic.application.services.ApplicationShutdownService


        at org.jvnet.hk2.internal.Collector.throwIfErrors(Collector.java:89)
        at org.jvnet.hk2.internal.ClazzCreator.resolveAllDependencies(ClazzCreator.java:250)
        at org.jvnet.hk2.internal.ClazzCreator.create(ClazzCreator.java:358)
        at org.jvnet.hk2.internal.SystemDescriptor.create(SystemDescriptor.java:487)
        at org.glassfish.hk2.runlevel.internal.AsyncRunLevelContext.findOrCreate(AsyncRunLevelContext.java:305)
        Truncated. see log file for complete stacktrace
Caused By: java.lang.NullPointerException
        at weblogic.store.internal.PersistentStoreImpl.isDefaultStoreOfOtherServer(PersistentStoreImpl.java:322)
        at weblogic.store.internal.PersistentStoreImpl.isSpecialStore(PersistentStoreImpl.java:366)
        at weblogic.store.internal.PersistentStoreImpl.setFatalException(PersistentStoreImpl.java:303)
        at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:551)
        at weblogic.store.admin.AdminHandler.activate(AdminHandler.java:157)
        Truncated. see log file for complete stacktrace
>
<Nov 25, 2018 12:01:56,862 PM MST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED.>
<Nov 25, 2018 12:01:56,862 PM MST> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down.>
<Nov 25, 2018 12:01:56,865 PM MST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN.>
Stopping Derby server...
Derby server stopped.


Esto sucede cuando al parecer la tienda por defecto (default store) está corrupta.

Para su solución podemos realizar los siguientes pasos:

1. Movernos al directorio: $DOMAIN/servers/SERVERNAME/data/store/default
2. Sacar un backup del archivo: _WLS_SERVERNAME000000.DAT
3. Eliminar el archivo _WLS_SERVERNAME000000.DAT
4. Reiniciar Weblogic

Con esto se creará un nuevo archivo y el Weblogic subirá sin problemas.