Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
TS Install DB issue
nipper
7.2.1 Linux new install. SQL Server DB,
GUI fails with failed to update DB (doing common services), check user permissions. The user has DBO permissions and the table in question is created by the installer.
Here is the error:
2011-02-17 12:52:40,327 DEBUG org.hibernate.util.JDBCExceptionReporter - could not execute update query [delete from IR_DBINFO where componentName='CommonServices']
com.microsoft.sqlserver.jdbc.SQLServerException: SELECT permission denied on object 'IR_DBINFO', database 'NewLinuxEvents', owner 'newuser'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1168)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
at com.interwoven.wcm.ir.service.install.PopulateDBInfo.runTask(PopulateDBInfo.java:165)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.framework.MultiComponentCompositeTask.runTask(MultiComponentCompositeTask.java:111)
at com.interwoven.wcm.install.framework.ia.Driver.install(Driver.java:429)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGaei.run(DashoA10*..)
2011-02-17 12:52:40,328 WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 229, SQLState: S0005
2011-02-17 12:52:40,328 ERROR org.hibernate.util.JDBCExceptionReporter - SELECT permission denied on object 'IR_DBINFO', database 'NewLinuxEvents', owner 'newuser'.
2011-02-17 12:52:40,329 ERROR com.interwoven.wcm.ir.service.install.IWIRDBConfigFileMunge - Error while populate DB Info
org.hibernate.exception.SQLGrammarException: could not execute update query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:107)
at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:419)
at org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:283)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1168)
at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117)
at com.interwoven.wcm.ir.service.install.PopulateDBInfo.runTask(PopulateDBInfo.java:165)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.framework.MultiComponentCompositeTask.runTask(MultiComponentCompositeTask.java:111)
at com.interwoven.wcm.install.framework.ia.Driver.install(Driver.java:429)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGaei.run(DashoA10*..)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: SELECT permission denied on object 'IR_DBINFO', database 'NewLinuxEvents', owner 'newuser'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:306)
at org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:98)
... 11 more
2011-02-17 12:52:40,332 DEBUG org.hibernate.jdbc.ConnectionManager - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2011-02-17 12:52:40,336 ERROR com.interwoven.wcm.install.framework.ia.Driver - Error creating/updating database table, Please check the user privileges
com.interwoven.wcm.install.util.InstallException: Error creating/updating database table, Please check the user privileges
at com.interwoven.wcm.ir.service.install.PopulateDBInfo.runTask(PopulateDBInfo.java:185)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.api.CompositeTask.runTask(CompositeTask.java:134)
at com.interwoven.wcm.install.framework.MultiComponentCompositeTask.runTask(MultiComponentCompositeTask.java:111)
at com.interwoven.wcm.install.framework.ia.Driver.install(Driver.java:429)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at ZeroGaei.run(DashoA10*..)
2011-02-17 12:52:40,336 INFO com.interwoven.wcm.install.util.Iwinstall - iwinstall location ==> /opt/Interwoven/iwinstall
Find more posts tagged with
Comments
nipper
OK, blew it all away, used a different DB and sa and it worked. No idea why this failed.
I can only assume I missed some config setting for this user.
