Nuclos startet nicht 404

[Marco Patzelt]

Hallo,

wir haben Nuclos auf einem Windows 2008 R2 mit SQL 2008 R2 Express installiert. Die Installations ist Fehlerfrei gelaufen aber der Tomcat kann Nuclos nicht starten.

Die Datenbank verbindung an sich scheint zu passen da Tables erstellt wurden. Im Log des Tomcat findes sich folgendes

011-09-23 21:17:44,368 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] – Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@109ce4a3: defining beans [appContext,org.springframework.context.annotation.CommonAnnotationBeanPostProcessor#0,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,propertyConfigurer,nuclosDataSource,transactionManager,customCodeManager,remoteInvocationExecutor,attrSource,nuclosRemoteRollback,masterDataService,parameterService,stateService,serverMetaService,localeService,preferencesService,securityService,layoutService,attributeService,metaDataService,genericObjectService,generatorService,searchFilterService,resourceService,timelimitTaskService,taskService,datasourceService,entityService,entityMetaService,genericObjectGroupService,reportService,ruleEngineService,ruleInterfaceService,timelimitRuleService,treeNodeService,consoleService,wikiService,transferService,importService,liveSearchService,schedulerControlService,processMonitorService,masterDataModuleService,jobControlService,ldapDataService,xmlExportImportProtocolService,xmlExportService,xmlImportService,instanceService,customComponentService,codeService,nuclosCacheService,nuclosScheduler,org.springframework.security.authentication.DefaultAuthenticationEventPublisher#0,org.springframework.security.authenticationManager,remoteAuthenticationManager,nuclosAuthenticationProvider,userDetailsService,org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor#0,org.springframework.security.methodSecurityMetadataSourceAdvisor,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#1,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuthenticationEntryPoint#0,org.springframework.security.config.http.UserDetailsServiceInjectionBeanPostProcessor#0,org.springframework.security.filterChainProxy,broker,destinationParameterProvider,destinationStatemodel,destinationRuleNotification,destinationMasterdataCache,destinationMetadataCache,destinationSecurityCache,destinationSearchfilterCache,destinationResourceCache,destinationLocalizationChanges,destinationProgressNotification,destinationCustomcomponentCache,jmsFactory,jmsProducerConnectionFactory,topic.parameterProvider,topic.statemodel,topic.ruleNotification,topic.masterdataCache,topic.metadataCache,topic.securityCache,topic.searchfilterCache,topic.resourceCache,topic.localizationChanges,topic.progressNotification,topic.customcomponentCache,listener.masterdataCache]; root of factory hierarchy
2011-09-23 21:17:44,790 INFO [org.nuclos.server.database.DataBaseHelper] – Set structure change log directory to C:Program FilesNucloslogsdatabase-structure-changes
2011-09-23 21:17:45,805 INFO [org.nuclos.server.dblayer.impl.mssql.MSSQLDBAccess] – Schema name resolved to ’nuclos‘
2011-09-23 21:17:45,883 ERROR [org.nuclos.server.dblayer.impl.DataSourceExecutor] – SQL exception
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‚T_AD_RELEASE‘.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$2.perform(StandardSqlDBAccess.java:200)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:55)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:191)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:178)
at org.nuclos.server.autosync.AutoDbSetup.getInstalledVersions(AutoDbSetup.java:143)
at org.nuclos.server.autosync.AutoDbSetup.determineLastVersion(AutoDbSetup.java:130)
at org.nuclos.server.database.DataBaseHelper.(DataBaseHelper.java:90)
at org.nuclos.server.common.ServerParameterProvider.getParametersFromDB(ServerParameterProvider.java:123)
at org.nuclos.server.common.ServerParameterProvider.loadParameters(ServerParameterProvider.java:98)
at org.nuclos.server.common.ServerParameterProvider.(ServerParameterProvider.java:73)
at org.nuclos.server.common.ServerParameterProvider.getInstance(ServerParameterProvider.java:65)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.postConstruct(MasterDataFacadeBean.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2011-09-23 21:17:45,899 INFO [org.nuclos.server.database.DataBaseHelper] – Nuclos auto-setup is enabled
2011-09-23 21:17:45,946 INFO [org.nuclos.server.database.DataBaseHelper] – Existing Nuclos installation found in schema nuclos
2011-09-23 21:17:45,962 ERROR [org.nuclos.server.dblayer.impl.DataSourceExecutor] – SQL exception
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‚T_AD_PARAMETER‘.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$2.perform(StandardSqlDBAccess.java:200)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:55)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:191)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:178)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:129)
at org.nuclos.server.common.ServerParameterProvider.getParametersFromDB(ServerParameterProvider.java:129)
at org.nuclos.server.common.ServerParameterProvider.loadParameters(ServerParameterProvider.java:98)
at org.nuclos.server.common.ServerParameterProvider.(ServerParameterProvider.java:73)
at org.nuclos.server.common.ServerParameterProvider.getInstance(ServerParameterProvider.java:65)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.postConstruct(MasterDataFacadeBean.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2011-09-23 21:17:45,962 INFO [org.springframework.beans.factory.support.DefaultListableBeanFactory] – Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@109ce4a3: defining beans [appContext,org.springframework.context.annotation.CommonAnnotationBeanPostProcessor#0,org.springframework.aop.config.internalAutoProxyCreator,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,propertyConfigurer,nuclosDataSource,transactionManager,customCodeManager,remoteInvocationExecutor,attrSource,nuclosRemoteRollback,masterDataService,parameterService,stateService,serverMetaService,localeService,preferencesService,securityService,layoutService,attributeService,metaDataService,genericObjectService,generatorService,searchFilterService,resourceService,timelimitTaskService,taskService,datasourceService,entityService,entityMetaService,genericObjectGroupService,reportService,ruleEngineService,ruleInterfaceService,timelimitRuleService,treeNodeService,consoleService,wikiService,transferService,importService,liveSearchService,schedulerControlService,processMonitorService,masterDataModuleService,jobControlService,ldapDataService,xmlExportImportProtocolService,xmlExportService,xmlImportService,instanceService,customComponentService,codeService,nuclosCacheService,nuclosScheduler,org.springframework.security.authentication.DefaultAuthenticationEventPublisher#0,org.springframework.security.authenticationManager,remoteAuthenticationManager,nuclosAuthenticationProvider,userDetailsService,org.springframework.security.access.method.DelegatingMethodSecurityMetadataSource#0,org.springframework.security.access.vote.AffirmativeBased#0,org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor#0,org.springframework.security.methodSecurityMetadataSourceAdvisor,org.springframework.security.web.PortMapperImpl#0,org.springframework.security.web.context.HttpSessionSecurityContextRepository#0,org.springframework.security.web.authentication.session.SessionFixationProtectionStrategy#0,org.springframework.security.authentication.ProviderManager#0,org.springframework.security.access.vote.AffirmativeBased#1,org.springframework.security.web.access.intercept.FilterSecurityInterceptor#0,org.springframework.security.web.access.DefaultWebInvocationPrivilegeEvaluator#0,org.springframework.security.authentication.AnonymousAuthenticationProvider#0,org.springframework.security.web.savedrequest.HttpSessionRequestCache#0,org.springframework.security.web.authentication.www.BasicAuthenticationEntryPoint#0,org.springframework.security.config.http.UserDetailsServiceInjectionBeanPostProcessor#0,org.springframework.security.filterChainProxy,broker,destinationParameterProvider,destinationStatemodel,destinationRuleNotification,destinationMasterdataCache,destinationMetadataCache,destinationSecurityCache,destinationSearchfilterCache,destinationResourceCache,destinationLocalizationChanges,destinationProgressNotification,destinationCustomcomponentCache,jmsFactory,jmsProducerConnectionFactory,topic.parameterProvider,topic.statemodel,topic.ruleNotification,topic.masterdataCache,topic.metadataCache,topic.securityCache,topic.searchfilterCache,topic.resourceCache,topic.localizationChanges,topic.progressNotification,topic.customcomponentCache,listener.masterdataCache]; root of factory hierarchy
2011-09-23 21:17:45,977 ERROR [org.springframework.web.context.ContextLoader] – Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‚masterDataService‘: Invocation of init method failed; nested exception is org.nuclos.server.dblayer.DbException: Invalid object name ‚T_AD_PARAMETER‘.
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.nuclos.server.dblayer.DbException: Invalid object name ‚T_AD_PARAMETER‘.
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.wrapSQLException(StandardSqlDBAccess.java:491)
at org.nuclos.server.dblayer.impl.standard.TransactSqlDbAccess.wrapSQLException(TransactSqlDbAccess.java:110)
at org.nuclos.server.dblayer.DbAccess$1.wrapSQLException(DbAccess.java:86)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:61)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:191)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:178)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:129)
at org.nuclos.server.common.ServerParameterProvider.getParametersFromDB(ServerParameterProvider.java:129)
at org.nuclos.server.common.ServerParameterProvider.loadParameters(ServerParameterProvider.java:98)
at org.nuclos.server.common.ServerParameterProvider.(ServerParameterProvider.java:73)
at org.nuclos.server.common.ServerParameterProvider.getInstance(ServerParameterProvider.java:65)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.postConstruct(MasterDataFacadeBean.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)
… 22 more
Caused by: java.sql.SQLException: Invalid object name ‚T_AD_PARAMETER‘.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$2.perform(StandardSqlDBAccess.java:200)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:55)
… 37 more
2011-09-23 21:17:46,102 INFO [org.apache.activemq.broker.BrokerService] – Using Persistence Adapter: MemoryPersistenceAdapter
2011-09-23 21:17:46,102 INFO [org.apache.activemq.broker.BrokerService] – ActiveMQ 5.3.0 JMS Message Broker (localhost) is starting
2011-09-23 21:17:46,102 INFO [org.apache.activemq.broker.BrokerService] – For help or more information please see: http://activemq.apache.org/
2011-09-23 21:17:46,430 INFO [org.apache.activemq.broker.TransportConnector] – Connector vm://localhost Started
2011-09-23 21:17:46,430 INFO [org.apache.activemq.broker.BrokerService] – ActiveMQ JMS Message Broker (localhost, ID:DEFFMSV017-49554-1316805466149-0:0) started
2011-09-23 21:17:46,477 INFO [org.apache.activemq.broker.BrokerService] – ActiveMQ Message Broker (localhost, ID:DEFFMSV017-49554-1316805466149-0:0) is shutting down
2011-09-23 21:17:46,477 INFO [org.apache.activemq.broker.TransportConnector] – Connector vm://localhost Stopped
2011-09-23 21:17:46,493 INFO [org.apache.activemq.broker.jmx.ManagementContext] – JMX consoles can connect to null
2011-09-23 21:17:46,508 INFO [org.apache.activemq.broker.BrokerService] – ActiveMQ JMS Message Broker (localhost, ID:DEFFMSV017-49554-1316805466149-0:0) stopped

Irgeneine Idee was das sein könnte?

Gruß

Marco

[Jan Giebels]

Sieht aus, als ob die Datenstruktur nicht in der Datenbank ist, zumindest weisst diese Fehlermeldung:

2011-09-23 21:17:45,883 ERROR [org.nuclos.server.dblayer.impl.DataSourceExecutor] - SQL exception
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'T_AD_RELEASE'.

darauf hin.
Lösche doch mal alle Objekte in der Datenbank (Tabellen, Views, Stored procedures, etc. pp) nund starte Nuclos neu .. dann sollte die DB-Struktur neu aufgebaut werden.

Fals das schiefgeht, währe wieder ein log hilfreich.

[Marco Patzelt]

Ich habe die ganze Datenbank geklöscht und neu erstellt. Der User, derim er nuclos.xml steht ist sysadmi im SQL und dbowner auf der Datenbank

nun nach dem neustart des services bekomme ich folgende meldungen

23.09.2011 22:39:07 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextDestroyed()
23.09.2011 22:39:07 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextDestroyed()
23.09.2011 22:40:06 org.apache.catalina.core.ApplicationContext log
INFO: Set web app root system property: ‚webapp.root‘ = [C:Program FilesNucloswebapp]
23.09.2011 22:40:06 org.apache.catalina.core.ApplicationContext log
INFO: Initializing log4j from [C:Program FilesNucloswebappWEB-INFlog4j.properties]
23.09.2011 22:40:06 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
23.09.2011 22:40:12 org.apache.catalina.core.StandardContext listenerStart
SCHWERWIEGEND: Exception sending context initialized event to listener instance of class org.nuclos.server.web.NuclosContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‚masterDataService‘: Invocation of init method failed; nested exception is java.lang.ExceptionInInitializerError
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ExceptionInInitializerError
at org.nuclos.server.common.ServerParameterProvider.getParametersFromDB(ServerParameterProvider.java:123)
at org.nuclos.server.common.ServerParameterProvider.loadParameters(ServerParameterProvider.java:98)
at org.nuclos.server.common.ServerParameterProvider.(ServerParameterProvider.java:73)
at org.nuclos.server.common.ServerParameterProvider.getInstance(ServerParameterProvider.java:65)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.postConstruct(MasterDataFacadeBean.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)
… 22 more
Caused by: org.nuclos.common.NuclosFatalException: Error initializing Nuclos datasource/database access: org.nuclos.common.NuclosFatalException: Error during Auto-Setup #1: Create sequence IDFACTORY: org.nuclos.server.dblayer.DbException: The specified schema name „nuclos“ either does not exist or you do not have permission to use it.
at org.nuclos.server.database.DataBaseHelper.(DataBaseHelper.java:129)
… 34 more
Caused by: org.nuclos.common.NuclosFatalException: Error during Auto-Setup #1: Create sequence IDFACTORY: org.nuclos.server.dblayer.DbException: The specified schema name „nuclos“ either does not exist or you do not have permission to use it.
at org.nuclos.server.database.DataBaseHelper.executeSetupStatements(DataBaseHelper.java:154)
at org.nuclos.server.database.DataBaseHelper.(DataBaseHelper.java:116)
… 34 more
Caused by: org.nuclos.server.dblayer.DbException: The specified schema name „nuclos“ either does not exist or you do not have permission to use it.
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.wrapSQLException(StandardSqlDBAccess.java:491)
at org.nuclos.server.dblayer.impl.standard.TransactSqlDbAccess.wrapSQLException(TransactSqlDbAccess.java:110)
at org.nuclos.server.dblayer.DbAccess$1.wrapSQLException(DbAccess.java:86)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:61)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.executeUpdate(DataSourceExecutor.java:90)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.executePreparedStatement(StandardSqlDBAccess.java:723)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.executePreparedStatements(StandardSqlDBAccess.java:715)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitStructureChange(StandardSqlDBAccess.java:696)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitStructureChange(StandardSqlDBAccess.java:674)
at org.nuclos.server.dblayer.statements.DbStructureChange.accept(DbStructureChange.java:75)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.execute(StandardSqlDBAccess.java:123)
at org.nuclos.server.dblayer.DbAccess.execute(DbAccess.java:164)
at org.nuclos.server.database.DataBaseHelper.executeSetupStatements(DataBaseHelper.java:147)
… 35 more
Caused by: java.sql.SQLException: The specified schema name „nuclos“ either does not exist or you do not have permission to use it.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:775)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:676)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:633)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
at org.nuclos.server.dblayer.impl.DataSourceExecutor$2.perform(DataSourceExecutor.java:95)
at org.nuclos.server.dblayer.impl.DataSourceExecutor$2.perform(DataSourceExecutor.java:90)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:55)
… 44 more
23.09.2011 22:40:12 org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
23.09.2011 22:40:13 org.apache.catalina.core.ApplicationContext log
INFO: Shutting down log4j
23.09.2011 22:40:13 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
23.09.2011 22:40:13 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
23.09.2011 22:40:13 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeAdded(‚org.apache.jasper.compiler.TldLocationsCache‘, ‚org.apache.jasper.compiler.TldLocationsCache@3914fc36‘)
23.09.2011 22:40:21 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextDestroyed()
23.09.2011 22:40:21 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextDestroyed()
23.09.2011 22:41:33 org.apache.catalina.core.ApplicationContext log
INFO: Set web app root system property: ‚webapp.root‘ = [C:Program FilesNucloswebapp]
23.09.2011 22:41:33 org.apache.catalina.core.ApplicationContext log
INFO: Initializing log4j from [C:Program FilesNucloswebappWEB-INFlog4j.properties]
23.09.2011 22:41:33 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
23.09.2011 22:41:42 org.apache.catalina.core.StandardContext listenerStart
SCHWERWIEGEND: Exception sending context initialized event to listener instance of class org.nuclos.server.web.NuclosContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‚masterDataService‘: Invocation of init method failed; nested exception is java.lang.ExceptionInInitializerError
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.ExceptionInInitializerError
at org.nuclos.server.common.ServerParameterProvider.getParametersFromDB(ServerParameterProvider.java:123)
at org.nuclos.server.common.ServerParameterProvider.loadParameters(ServerParameterProvider.java:98)
at org.nuclos.server.common.ServerParameterProvider.(ServerParameterProvider.java:73)
at org.nuclos.server.common.ServerParameterProvider.getInstance(ServerParameterProvider.java:65)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.postConstruct(MasterDataFacadeBean.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)
… 22 more
Caused by: org.nuclos.common.NuclosFatalException: Error initializing Nuclos datasource/database access: org.nuclos.common.NuclosFatalException: Error during Auto-Setup #498: Batch of 1 statements : org.nuclos.server.dblayer.DbBatchException: Invalid object name ‚T_MD_USER‘.
at org.nuclos.server.database.DataBaseHelper.(DataBaseHelper.java:129)
… 34 more
Caused by: org.nuclos.common.NuclosFatalException: Error during Auto-Setup #498: Batch of 1 statements : org.nuclos.server.dblayer.DbBatchException: Invalid object name ‚T_MD_USER‘.
at org.nuclos.server.database.DataBaseHelper.executeSetupStatements(DataBaseHelper.java:154)
at org.nuclos.server.database.DataBaseHelper.(DataBaseHelper.java:116)
… 34 more
Caused by: org.nuclos.server.dblayer.DbBatchException: Invalid object name ‚T_MD_USER‘.
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitBatch(StandardSqlDBAccess.java:757)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$StatementVisitor.visitBatch(StandardSqlDBAccess.java:674)
at org.nuclos.server.dblayer.statements.DbBatchStatement.accept(DbBatchStatement.java:50)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.execute(StandardSqlDBAccess.java:123)
at org.nuclos.server.dblayer.DbAccess.execute(DbAccess.java:164)
at org.nuclos.server.database.DataBaseHelper.executeSetupStatements(DataBaseHelper.java:147)
… 35 more
23.09.2011 22:41:43 org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
23.09.2011 22:41:43 org.apache.catalina.core.ApplicationContext log
INFO: Shutting down log4j
23.09.2011 22:41:43 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
23.09.2011 22:41:43 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
23.09.2011 22:41:43 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeAdded(‚org.apache.jasper.compiler.TldLocationsCache‘, ‚org.apache.jasper.compiler.TldLocationsCache@5492de02‘)

Und in der Datenbank werden gar keine Tables mehr erstellt, zumindest sehe ich keine.

Marco

[Marco Patzelt]

Sodas erstellen der Tables hat wohlnur etwas gedauert. Jetzt sind alle wieder da inkl. dem vorherigen Fehler

23.09.2011 22:45:45 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextDestroyed()
23.09.2011 22:45:45 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextDestroyed()
23.09.2011 22:45:53 org.apache.catalina.core.ApplicationContext log
INFO: Set web app root system property: ‚webapp.root‘ = [C:Program FilesNucloswebapp]
23.09.2011 22:45:53 org.apache.catalina.core.ApplicationContext log
INFO: Initializing log4j from [C:Program FilesNucloswebappWEB-INFlog4j.properties]
23.09.2011 22:45:53 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
23.09.2011 22:45:57 org.apache.catalina.core.StandardContext listenerStart
SCHWERWIEGEND: Exception sending context initialized event to listener instance of class org.nuclos.server.web.NuclosContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‚masterDataService‘: Invocation of init method failed; nested exception is org.nuclos.server.dblayer.DbException: Invalid object name ‚T_AD_PARAMETER‘.
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:394)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1413)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:276)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:197)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:47)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4723)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5226)
at org.apache.catalina.core.StandardContext$1.call(StandardContext.java:5221)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.nuclos.server.dblayer.DbException: Invalid object name ‚T_AD_PARAMETER‘.
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.wrapSQLException(StandardSqlDBAccess.java:491)
at org.nuclos.server.dblayer.impl.standard.TransactSqlDbAccess.wrapSQLException(TransactSqlDbAccess.java:110)
at org.nuclos.server.dblayer.DbAccess$1.wrapSQLException(DbAccess.java:86)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:61)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:191)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:178)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:129)
at org.nuclos.server.common.ServerParameterProvider.getParametersFromDB(ServerParameterProvider.java:129)
at org.nuclos.server.common.ServerParameterProvider.loadParameters(ServerParameterProvider.java:98)
at org.nuclos.server.common.ServerParameterProvider.(ServerParameterProvider.java:73)
at org.nuclos.server.common.ServerParameterProvider.getInstance(ServerParameterProvider.java:65)
at org.nuclos.server.masterdata.ejb3.MasterDataFacadeBean.postConstruct(MasterDataFacadeBean.java:152)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:340)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:293)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:130)
… 22 more
Caused by: java.sql.SQLException: Invalid object name ‚T_AD_PARAMETER‘.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$2.perform(StandardSqlDBAccess.java:200)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:55)
… 37 more
23.09.2011 22:45:58 org.apache.catalina.core.ApplicationContext log
INFO: Closing Spring root WebApplicationContext
23.09.2011 22:45:58 org.apache.catalina.core.ApplicationContext log
INFO: Shutting down log4j
23.09.2011 22:45:58 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
23.09.2011 22:45:58 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
23.09.2011 22:45:58 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeAdded(‚org.apache.jasper.compiler.TldLocationsCache‘, ‚org.apache.jasper.compiler.TldLocationsCache@61ae717f‘)

Marc

[Thomas Schiffmann]

Hallo Marco,

versuchen Sie es bitte erneut und folgen Sie dabei exakt der Anleitung unter http://wiki.nuclos.de/Installation_SQLServer. Geben Sie dem User dabei keine sysadmin-Rechte, da dann die DEFAULT_SCHEMA-Einstellung ignoriert wird. (Oder verwenden Sie das Schema „dbo“.)

Siehe [http://msdn.microsoft.com/en-us/library/ms176060.aspx]:

Important
The value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role. All members of the sysadmin fixed server role have a default schema of dbo.

Viele Grüße
tsc

[Marco Patzelt]

Dnk,

hat jetzt funktioniert. Dass diese Einstllungen nicht vom Setup durchgeführt werden ist by design, richtig?

Gruß und noch nen schönen Sonntag

Marco

[Thomas Schiffmann]

Hallo Marco,

ein automatisches Setup unterstützen wir momentan nur für PostgreSQL-Datenbanken.

Viele Grüße
tsc

[Autor]

Beiträge