8 Replies Latest reply: Jul 18, 2013 8:46 AM by 1002570 RSS

    3.0 - Provisioning Service - excel upload error

    943250
      Just finished installing EID 3.0 and installed provisioning services on non-ssl / default settings (minus turning ssl off).

      I'm able to select an excel spreadsheet from the home page in Studio, when I click next, I get the following error.

      Looks like it's related to my jdbc settings. I'm using derby as a default, so not sure if I need to change any settings within a eid-ps file and not sure where to set this. Please let me know if anybody has advice. Thanks in advance.


      Error while uploading Excel file. EJB Exception: : javax.persistence.PersistenceException: Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.ValidationException\r\nException Description: Cannot acquire data source [jdbc/oracle.eid-ps].\r\nInternal Exception: javax.naming.NameNotFoundException: While trying to lookup 'jdbc.oracle.eid-ps' didn't find subcontext 'jdbc'. Resolved ''; remaining name 'jdbc/oracle/eid-ps'\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272)\r\n\tat weblogic.deployment.TransactionalEntityManagerProxyImpl.newPersistenceContext(TransactionalEntityManagerProxyImpl.java:66)\r\n\tat weblogic.deployment.BasePersistenceContextProxyImpl.getPersistenceContext(BasePersistenceContextProxyImpl.java:178)\r\n\tat weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:106)\r\n\tat weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:78)\r\n\tat weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:92)\r\n\tat weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:18)\r\n\tat $Proxy131.persist(Unknown Source)\r\n\tat com.oracle.endeca.pdi.bean.manager.workflow.WorkflowManagerEjb.create(WorkflowManagerEjb.java:40)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\r\n\tat java.lang.reflect.Method.invoke(Method.java:597)\r\n\tat com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)\r\n\tat
        • 1. Re: 3.0 - Provisioning Service - excel upload error
          Brett R-Oracle
          A couple of questions:

          * When installing Provisioning Service, did you follow basic installation or expert installation.
          * When you navigate to WebLogic console for your PS domain, under Services -> Data Sources, do you have an entry with name and JNDI name of jdbc/oracle.eid-ps ?
          * Do you have WebLogic JDBC drivers installed?
          * Do you have the WebLogic Server => Evaluation Database installed?
          • 2. Re: 3.0 - Provisioning Service - excel upload error
            943250
            * When installing Provisioning Service, did you follow basic installation or expert installation.

            -Basic


            * When you navigate to WebLogic console for your PS domain, under Services -> Data Sources, do you have an entry with name and JNDI name of jdbc/oracle.eid-ps ?

            Yes

            * Do you have WebLogic JDBC drivers installed?

            Yes

            * Do you have the WebLogic Server => Evaluation Database installed?

            Yes

            Getting this error during weblogic server startup:

            <Apr 9, 2013 1:41:44 AM JST> <Error> <Deployer> <BEA-149205> <Failed to initialize the application 'jdbc/oracle.eid-ps' due to error weblogic.application.ModuleException: .
            weblogic.application.ModuleException:
            at weblogic.jdbc.module.JDBCModule.prepare(JDBCModule.java:327)
            at weblogic.application.internal.flow.ModuleListenerInvoker.prepare(ModuleListenerInvoker.java:199)
            at weblogic.application.internal.flow.DeploymentCallbackFlow$1.next(DeploymentCallbackFlow.java:518)
            at weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:52)
            at weblogic.application.internal.flow.DeploymentCallbackFlow.prepare(DeploymentCallbackFlow.java:159)
            Truncated. see log file for complete stacktrace
            Caused By: weblogic.common.ResourceException: weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: java.net.ConnectException : Error connecting to server
            localhost on port 1527 with message Connection refused: connect.
            at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:283)
            at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1310)
            at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1227)
            at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:250)
            at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1330)
            Truncated. see log file for complete stacktrace
            >
            • 3. Re: 3.0 - Provisioning Service - excel upload error
              Brett R-Oracle
              Have a look for a file named derby.log within your Provisioning Service domain directory - it may contain log messages pertaining to the evaluation database, and whether/why it is failing to start.
              • 4. Re: 3.0 - Provisioning Service - excel upload error
                Marco Snels (AortaBI)(NL)
                I get the same error as the topic starter. But my weblogic domain works and I get the message that the state of provisioning service is Active and health is OK.

                Marco Snels

                Edited by: Marco Snels (AortaBI)(NL) on 15-apr-2013 6:55

                Edited by: Marco Snels (AortaBI)(NL) on 15-apr-2013 6:56
                • 5. Re: 3.0 - Provisioning Service - excel upload error
                  Brett R-Oracle
                  Marco,

                  If Studio is having problems connecting to the Provisioning Service, check the eid-studio.log file in your Studio WebLogic domain directory for additional details.

                  The Provisioning Service also depends on a connection to an active Endeca Server (specified in plan.xml endeca-server-host-name and endeca-server-ws-port), so it's worth checking that your Endeca Server is up and reachable.

                  Brett
                  • 6. Re: 3.0 - Provisioning Service - excel upload error
                    Marco Snels (AortaBI)(NL)
                    Hi Brett,

                    The connection is working. But when I try to upload an Excel file (doesn't matter which one) I get an error:

                    Error while uploading Excel file. EJB Exception: : javax.persistence.PersistenceException: Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.ValidationException\r\nException Description: Cannot acquire data source [jdbc/oracle.eid-ps].\r\nInternal Exception: javax.naming.NameNotFoundException: While trying to lookup 'jdbc.oracle.eid-ps' didn't find subcontext 'jdbc'. Resolved ''; remaining name 'jdbc/oracle/eid-ps'\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:517)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.getDatabaseSession(EntityManagerFactoryDelegate.java:188)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.createEntityManagerImpl(EntityManagerFactoryDelegate.java:277)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManagerImpl(EntityManagerFactoryImpl.java:294)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:272)\r\n\tat weblogic.deployment.TransactionalEntityManagerProxyImpl.newPersistenceContext(TransactionalEntityManagerProxyImpl.java:66)\r\n\tat weblogic.deployment.BasePersistenceContextProxyImpl.getPersistenceContext(BasePersistenceContextProxyImpl.java:178)\r\n\tat weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:106)\r\n\tat weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:78)\r\n\tat weblogic.deployment.BasePersistenceContextProxyImpl.invoke(BasePersistenceContextProxyImpl.java:92)\r\n\tat weblogic.deployment.TransactionalEntityManagerProxyImpl.invoke(TransactionalEntityManagerProxyImpl.java:18)\r\n\tat com.sun.proxy.$Proxy61.persist(Unknown Source)\r\n\tat com.oracle.endeca.pdi.bean.manager.workflow.WorkflowManagerEjb.create(WorkflowManagerEjb.java:40)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\r\n\tat java.lang.reflect.Method.invoke(Method.java:597)\r\n\tat com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)\r\n\tat com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)\r\n\tat com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)\r\n\tat com.oracle.pitchfork.spi.MethodInvocationVisitorImpl.visit(MethodInvocationVisitorImpl.java:34)\r\n\tat weblogic.ejb.container.injection.EnvironmentInterceptorCallbackImpl.callback(EnvironmentInterceptorCallbackImpl.java:54)\r\n\tat com.oracle.pitchfork.spi.EnvironmentInterceptor.invoke(EnvironmentInterceptor.java:42)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)\r\n\tat com.bea.core.repackaged.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)\r\n\tat com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131)\r\n\tat com.bea.core.repackaged.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)\r\n\tat com.bea.core.repackaged.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)\r\n\tat com.sun.proxy.$Proxy142.create(Unknown Source)\r\n\tat com.oracle.endeca.pdi.bean.manager.workflow.WorkflowManagerEjb_96rafy_WorkflowManagerImpl.__WL_invoke(Unknown Source)\r\n\tat weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:39)\r\n\tat com.oracle.endeca.pdi.bean.manager.workflow.WorkflowManagerEjb_96rafy_WorkflowManagerImpl.create(Unknown Source)\r\n\tat com.oracle.endeca.pdi.service.UserDataImpl.beginWorkflow(UserDataImpl.java:218)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n\tat sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\r\n\tat java.lang.reflect.Method.invoke(Method.java:597)\r\n\tat weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)\r\n\tat weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)\r\n\tat com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:151)\r\n\tat com.sun.xml.ws.server.sei.EndpointMethodHandlerImpl.invoke(EndpointMethodHandlerImpl.java:268)\r\n\tat com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:100)\r\n\tat com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:866)\r\n\tat com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:815)\r\n\tat com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:778)\r\n\tat com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:680)\r\n\tat com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:403)\r\n\tat com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:539)\r\n\tat com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:253)\r\n\tat com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:140)\r\n\tat weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)\r\n\tat weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)\r\n\tat weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)\r\n\tat weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)\r\n\tat weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)\r\n\tat weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)\r\n\tat weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)\r\n\tat weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)\r\n\tat weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:820)\r\n\tat weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)\r\n\tat weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)\r\n\tat weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)\r\n\tat weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)\r\n\tat weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3732)\r\n\tat weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)\r\n\tat weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)\r\n\tat weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)\r\n\tat weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)\r\n\tat weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)\r\n\tat weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)\r\n\tat weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)\r\n\tat weblogic.work.ExecuteThread.run(ExecuteThread.java:221)\r\nCaused by: Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.ValidationException\r\nException Description: Cannot acquire data source [jdbc/oracle.eid-ps].\r\nInternal Exception: javax.naming.NameNotFoundException: While trying to lookup 'jdbc.oracle.eid-ps' didn't find subcontext 'jdbc'. Resolved ''; remaining name 'jdbc/oracle/eid-ps'\r\n\tat org.eclipse.persistence.exceptions.ValidationException.cannotAcquireDataSource(ValidationException.java:497)\r\n\tat org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:109)\r\n\tat org.eclipse.persistence.sessions.DatasourceLogin.connectToDatasource(DatasourceLogin.java:162)\r\n\tat org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginAndDetectDatasource(DatabaseSessionImpl.java:584)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.login(EntityManagerFactoryProvider.java:206)\r\n\tat org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(EntityManagerSetupImpl.java:488)\r\n\t... 77 more\r\nCaused by: javax.naming.NameNotFoundException: While trying to lookup 'jdbc.oracle.eid-ps' didn't find subcontext 'jdbc'. Resolved ''; remaining name 'jdbc/oracle/eid-ps'\r\n\tat weblogic.jndi.internal.BasicNamingNode.newNameNotFoundException(BasicNamingNode.java:1139)\r\n\tat weblogic.jndi.internal.BasicNamingNode.lookupHere(BasicNamingNode.java:247)\r\n\tat weblogic.jndi.internal.ServerNamingNode.lookupHere(ServerNamingNode.java:182)\r\n\tat weblogic.jndi.internal.BasicNamingNode.lookup(BasicNamingNode.java:206)\r\n\tat weblogic.jndi.internal.WLEventContextImpl.lookup(WLEventContextImpl.java:254)\r\n\tat weblogic.jndi.internal.WLContextImpl.lookup(WLContextImpl.java:402)\r\n\tat javax.naming.InitialContext.lookup(InitialContext.java:396)\r\n\tat org.eclipse.persistence.sessions.JNDIConnector.connect(JNDIConnector.java:103)\r\n\t... 81 more\r\n; nested exception is: javax.persistence.PersistenceException: Exception [EclipseLink-7060] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.ValidationException\r\nException Description: Cannot acquire data source [jdbc/oracle.eid-ps].\r\nInternal Exception: javax.naming.NameNotFoundException: While trying to lookup 'jdbc.oracle.eid-ps' didn't find subcontext 'jdbc'. Resolved ''; remaining name 'jdbc/oracle/eid-ps'

                    The JDBC connection in the console is set to jdbc/oracle.eid-ps

                    Marco
                    • 7. Re: 3.0 - Provisioning Service - excel upload error
                      user8286873

                      Hi Marco/Brett,

                       

                      Even I am also getting the same error mentioned above. Did you find any resolution for it ?

                       

                      Please share if you have any resolution for the error.

                       

                      Regards

                      • 8. Re: 3.0 - Provisioning Service - excel upload error
                        1002570

                        When you are in...  Control Panel-> Provisioning Services...

                         

                        You have something like This? -->

                         

                        {

                          "port": "8201",

                          "server": "localhost"

                        }

                         

                        And when you save it is says  " Preferences updated successfully"