TS Install DB issue

Andy Knipp

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