[
https://issues.apache.org/jira/browse/OPENMEETINGS-997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13995080#comment-13995080
]
Miguel Muñoz commented on OPENMEETINGS-997:
-------------------------------------------
When I tried the web installer I got this error message:
----
Installation is failed
org.springframework.orm.jpa.JpaSystemException: El nombre de objeto
'user_level' no es válido. {prepstmnt 233014852 SELECT t0.deleted,
t0.description, t0.starttime, t0.statuscode, t0.updatetime FROM user_level t0
WHERE t0.id = ?} [code=208, state=S0002]; nested exception is
<openjpa-2.2.2-r422266:1468616 fatal general error>
org.apache.openjpa.persistence.PersistenceException: El nombre de objeto
'user_level' no es válido. {prepstmnt 233014852 SELECT t0.deleted,
t0.description, t0.starttime, t0.statuscode, t0.updatetime FROM user_level t0
WHERE t0.id = ?} [code=208, state=S0002]
FailedObject: org.apache.openmeetings.db.entity.user.Userlevel@64802124
[java.lang.String]
at
org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:326)
at
org.springframework.orm.jpa.DefaultJpaDialect.translateExceptionIfPossible(DefaultJpaDialect.java:120)
at
org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:516)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)
at
org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:393)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:120)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
at
org.apache.openmeetings.db.dao.user.UserLevelDao$$EnhancerByCGLIB$$3c9e08e6.addUserLevel(<generated>)
at
org.apache.openmeetings.installation.ImportInitvalues.loadUserLevels(ImportInitvalues.java:136)
at
org.apache.openmeetings.installation.ImportInitvalues.loadSystem(ImportInitvalues.java:959)
at
org.apache.openmeetings.installation.ImportInitvalues.loadAll(ImportInitvalues.java:997)
at
org.apache.openmeetings.web.pages.install.InstallWizard$InstallProcess.run(InstallWizard.java:389)
at java.lang.Thread.run(Thread.java:744)
Caused by: <openjpa-2.2.2-r422266:1468616 fatal general error>
org.apache.openjpa.persistence.PersistenceException: El nombre de objeto
'user_level' no es válido. {prepstmnt 233014852 SELECT t0.deleted,
t0.description, t0.starttime, t0.statuscode, t0.updatetime FROM user_level t0
WHERE t0.id = ?} [code=208, state=S0002]
FailedObject: org.apache.openmeetings.db.entity.user.Userlevel@64802124
[java.lang.String]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:86)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:311)
at
org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
at
org.apache.openjpa.datacache.DataCacheStoreManager.initialize(DataCacheStoreManager.java:386)
at
org.apache.openjpa.kernel.DelegatingStoreManager.initialize(DelegatingStoreManager.java:112)
at
org.apache.openjpa.kernel.ROPStoreManager.initialize(ROPStoreManager.java:57)
at org.apache.openjpa.kernel.BrokerImpl.initialize(BrokerImpl.java:1046)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:1004)
at org.apache.openjpa.kernel.BrokerImpl.find(BrokerImpl.java:926)
at org.apache.openjpa.kernel.BrokerImpl.isDetached(BrokerImpl.java:4607)
at org.apache.openjpa.kernel.BrokerImpl.isDetached(BrokerImpl.java:4576)
at
org.apache.openjpa.kernel.VersionAttachStrategy.attach(VersionAttachStrategy.java:80)
at
org.apache.openjpa.kernel.AttachManager.attach(AttachManager.java:252)
at
org.apache.openjpa.kernel.AttachManager.attach(AttachManager.java:105)
at org.apache.openjpa.kernel.BrokerImpl.attach(BrokerImpl.java:3487)
at
org.apache.openjpa.kernel.DelegatingBroker.attach(DelegatingBroker.java:1214)
at
org.apache.openjpa.persistence.EntityManagerImpl.merge(EntityManagerImpl.java:878)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240)
at com.sun.proxy.$Proxy15.merge(Unknown Source)
at
org.apache.openmeetings.db.dao.user.UserLevelDao.addUserLevel(UserLevelDao.java:47)
at
org.apache.openmeetings.db.dao.user.UserLevelDao$$FastClassByCGLIB$$19fb57a6.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
... 8 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: El nombre de
objeto 'user_level' no es válido. {prepstmnt 233014852 SELECT t0.deleted,
t0.description, t0.starttime, t0.statuscode, t0.updatetime FROM user_level t0
WHERE t0.id = ?} [code=208, state=S0002]
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:59)
at
org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1118)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:268)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1801)
at
org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:258)
at
org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:499)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:424)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:382)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.getInitializeStateResult(JDBCStoreManager.java:549)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initializeState(JDBCStoreManager.java:351)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.initialize(JDBCStoreManager.java:306)
... 35 more
----
Thanks for your help
> error installing with mssql
> ----------------------------
>
> Key: OPENMEETINGS-997
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-997
> Project: Openmeetings
> Issue Type: Bug
> Affects Versions: 3.0.1
> Environment: windows 2008 r2
> Reporter: Miguel Muñoz
> Assignee: Maxim Solodovnik
> Fix For: 3.0.2, 3.1.0
>
>
> I was not able to configure mssql during the install process. I changed the
> persistence.xml, added sqljdbc4.jar (or sqljdbc.jar) and tried to install
> using the command line and the web ui, both of them failed.
> When I use the command line I get the following error:
> -----
> Setting default logging context: default
> [ERROR] [main] org.apache.openmeetings.cli.Admin - Install failed
> java.lang.IllegalArgumentException: No enum constant
> org.apache.openmeetings.cli.ConnectionProperties.DbType.mssql
> at java.lang.Enum.valueOf(Enum.java:236) ~[na:1.7.0_45]
> at
> org.apache.openmeetings.cli.ConnectionProperties$DbType.valueOf(ConnectionProperties.java:22)
> ~[openmeetings-cli-3.0.1-RELEASE.jar:na]
> at
> org.apache.openmeetings.cli.ConnectionPropertiesPatcher.getPatcher(ConnectionPropertiesPatcher.java:46)
> ~[openmeetings-cli-3.0.1-RELEASE.jar:na]
> at org.apache.openmeetings.cli.Admin.process(Admin.java:253)
> [openmeetings-cli-3.0.1-RELEASE.jar:na]
> at org.apache.openmeetings.cli.Admin.main(Admin.java:625)
> [openmeetings-cli-3.0.1-RELEASE.jar:na]
> -----
> I'm using the command:
> -----
> admin.bat -i -v -tz Europe/Berlin ^
> -group gusers ^
> -user admin --password xxxx --email [email protected] ^
> --smtp-server correu.upc.es --system-email-address [email protected] ^
> --email-auth-user [email protected] --email-auth-pass somepass ^
> --email-use-tls yes --disable-frontend-register yes ^
> --db-type mssql --db-host localhost --db-port 1433 ^
> --db-name openmeetings --db-user openmeetings --db-pass somepass
> ---
> The web ui install also failed with an error related with language.xml...
--
This message was sent by Atlassian JIRA
(v6.2#6252)
