DEMANTRA- UNABLE TO LOGIN TO COLLABORATOR WORKBENCH (Doc ID 970586.1)

Last updated on APRIL 19, 2015

Applies to:

Oracle Demantra Demand Management - Version 7.2.0.1 to 7.2.0.1 [Release 7.2]
Information in this document applies to any platform.
***Checked for relevance on 16-Nov-2012***


Symptoms



On : 7.2.0.1 version, MS Sql server,

When attempting to login to demantra customer is unable to login. They get the following error in the collaborator logs:

appserver.system: Configuration file loaded > E:\\Program Files\\Demantra Spectrum\\Collaborator\\demantra\\conf\\logconf.lcf\
2009-11-23 09:05:33,706 [main] DEBUG appserver.system: Logs will be dumped to E:\\Program Files\\Demantra Spectrum\\Collaborator\\demantra\\conf\\..\\logs\\collaborator.log\
2009-11-23 09:05:33,721 [main] DEBUG appserver.system: Logs will be dumped to E:\\Program Files\\Demantra Spectrum\\Collaborator\\demantra\\conf\\..\\logs\\integration.log\
2009-11-23 09:05:33,737 [main] DEBUG appserver.system: Value for parameter client.javaPlugin.downloadUrl was not specified, using ../plugin/\
2009-11-23 09:05:33,753 [main] FATAL appserver.fatal: appserver.fatal\
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDataSource\
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1383)\
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1230)\
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)\
at java.lang.Class.forName0(Native Method)\
at java.lang.Class.forName(Class.java:141)\
at com.demantra.applicationServer.pools.DBConnectionFactory.getMSSqlDataSource(DBConnectionFactory.java:142)\
at com.demantra.applicationServer.pools.DBConnectionFactory.<init>(DBConnectionFactory.java:56)\
at com.demantra.applicationServer.pools.JDBCConnectionPool.setPoolDataSource(JDBCConnectionPool.java:132)\
at com.demantra.applicationServer.pools.JDBCConnectionPool.<init>(JDBCConnectionPool.java:66)\
at com.demantra.applicationServer.pools.JDBCConnectionPool.getInstance(JDBCConnectionPool.java:93)\
at com.demantra.applicationServer.start.StarterServlet.init(StarterServlet.java:59)\
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)\
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)\
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3959)\
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4284)\
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)\
at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)\
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)\
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)\
at org.apache.catalina.core.StandardService.start(StandardService.java:519)\
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)\
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)\
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\
at java.lang.reflect.Method.invoke(Method.java:324)\
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)\
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)\
2009-11-23 09:05:33,768 [main] DEBUG appserver.system: Starting Service Demantra Application Server/7.2.0 (97)\
2009-11-23 09:05:33,800 [main] ERROR appserver.error: \
java.lang.NullPointerException\
at com.demantra.applicationServer.pools.DBConnectionFactory.createConnection(DBConnectionFactory.java:190)\
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)\
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)\
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)\
at com.demantra.applicationServer.pools.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:216)\
at com.demantra.applicationServer.metaDataObjects.sysParams.SysParamList.init(SysParamList.java:274)\
at com.demantra.applicationServer.metaDataObjects.sysParams.SysParamList.getInstance(SysParamList.java:56)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.setSystemDefaultParams(ComponentsList.java:903)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.loadAsServer(ComponentsList.java:214)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.<init>(ComponentsList.java:198)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.loadObjects(ComponentsList.java:1730)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.getInstance(ComponentsList.java:170)\
at com.demantra.applicationServer.start.main.StartMain.getComponentsList(StartMain.java:118)\
at com.demantra.applicationServer.start.main.StartMain.startMain(StartMain.java:86)\
at com.demantra.applicationServer.start.StarterServlet.initServer(StarterServlet.java:88)\
at com.demantra.applicationServer.start.StarterServlet.init(StarterServlet.java:62)\
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)\
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)\
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3959)\
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4284)\
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)\
at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)\
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)\
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)\
at org.apache.catalina.core.StandardService.start(StandardService.java:519)\
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)\
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)\
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\
at java.lang.reflect.Method.invoke(Method.java:324)\
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)\
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)\
2009-11-23 09:05:33,815 [main] ERROR appserver.error: \
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: org.apache.commons.dbcp.c
at com.demantra.applicationServer.metaDataObjects.sysParams.SysParamList.init(SysParamList.java:333)\
at com.demantra.applicationServer.metaDataObjects.sysParams.SysParamList.getInstance(SysParamList.java:56)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.setSystemDefaultParams(ComponentsList.java:903)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.loadAsServer(ComponentsList.java:214)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.<init>(ComponentsList.java:198)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.loadObjects(ComponentsList.java:1730)\
at com.demantra.applicationServer.metaDataObjects.component.ComponentsList.getInstance(ComponentsList.java:170)\
at com.demantra.applicationServer.start.main.StartMain.getComponentsList(StartMain.java:118)\
at com.demantra.applicationServer.start.main.StartMain.startMain(StartMain.java:86)\
at com.demantra.applicationServer.start.StarterServlet.initServer(StarterServlet.java:88)\
at com.demantra.applicationServer.start.StarterServlet.init(StarterServlet.java:62)\
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1044)\
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:887)\
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3959)\
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4284)\
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)\
at org.apache.catalina.core.StandardHost.start(StandardHost.java:832)\
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1126)\
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)\
at org.apache.catalina.core.StandardService.start(StandardService.java:519)\
at org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)\
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)\
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)\
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)\
at java.lang.reflect.Method.invoke(Method.java:324)\
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)\
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)\
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: null\
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)\
at com.demantra.applicationServer.pools.JDBCConnectionPool.getConnection(JDBCConnectionPool.jav



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms