Skip to Navigation
Home › Forums › Opentaps General Discussions › opentaps中文讨论 › opentaps1.5的安装问题，请帮助

opentaps1.5的安装问题，请帮助

No replies
Tue, 09/20/2011 - 12:27
shroger
User offline. Last seen 35 weeks 1 day ago. Offline
Joined: 09/19/2011

根据手册windos下安装Opentaps，一步一步顺利完成。启动ofbiz,通过查看日志文件，出现如下内容，请帮助查找原因，谢谢！
2011-09-20 19:17:32,095 (org.ofbiz.service.job.JobPoller@d4d311) [ JobManager.java:188:ERROR]
---- exception report ----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist)
---- cause ---------------------------------------------------------------------
Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Message: Table 'opentaps.job_sandbox' doesn't exist
---- stack trace ---------------------------------------------------------------
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opentaps.job_sandbox' doesn't exist
sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:335)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:294)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1287)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1262)
org.ofbiz.service.job.JobManager.poll(JobManager.java:158)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:91)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2011-09-20 19:17:32,095 (org.ofbiz.service.job.JobPoller@d4d311) [ SQLProcessor.java:424:ERROR] SQL Exception while executing the following: UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2011-09-20 19:17:12.317' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool'))
2011-09-20 19:17:32,095 (org.ofbiz.service.job.JobPoller@d4d311) [ GenericDelegator.java:1298:ERROR]
---- exception report ----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist)
---- cause ---------------------------------------------------------------------
Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Message: Table 'opentaps.job_sandbox' doesn't exist
---- stack trace ---------------------------------------------------------------
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opentaps.job_sandbox' doesn't exist
sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:335)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:294)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1287)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1262)
org.ofbiz.service.job.JobManager.poll(JobManager.java:158)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:91)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2011-09-20 19:17:32,105 (org.ofbiz.service.job.JobPoller@d4d311) [ JobManager.java:188:ERROR]
---- exception report ----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist)
---- cause ---------------------------------------------------------------------
Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Message: Table 'opentaps.job_sandbox' doesn't exist
---- stack trace ---------------------------------------------------------------
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opentaps.job_sandbox' doesn't exist
sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:335)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:294)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1287)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1262)
org.ofbiz.service.job.JobManager.poll(JobManager.java:158)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:91)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2011-09-20 19:17:32,165 (org.ofbiz.service.job.JobPoller@d4d311) [ SQLProcessor.java:424:ERROR] SQL Exception while executing the following: UPDATE JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2011-09-20 19:17:12.317' AND START_DATE_TIME IS NULL AND CANCEL_DATE_TIME IS NULL AND RUN_BY_INSTANCE_ID IS NULL) AND (POOL_ID IS NULL OR POOL_ID = 'pool'))
2011-09-20 19:17:32,165 (org.ofbiz.service.job.JobPoller@d4d311) [ GenericDelegator.java:1298:ERROR]
---- exception report ----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist)). Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist)
---- cause ---------------------------------------------------------------------
Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Message: Table 'opentaps.job_sandbox' doesn't exist
---- stack trace ---------------------------------------------------------------
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opentaps.job_sandbox' doesn't exist
sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:335)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:294)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1287)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1262)
org.ofbiz.service.job.JobManager.poll(JobManager.java:158)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:91)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

2011-09-20 19:17:32,165 (org.ofbiz.service.job.JobPoller@d4d311) [ JobManager.java:188:ERROR]
---- exception report ----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))]. Rolling back transaction.
Exception: org.ofbiz.entity.GenericDataSourceException
Message: Generic Entity Exception occured in updateByCondition (SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist))
---- cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException
Message: SQL Exception: (Table 'opentaps.job_sandbox' doesn't exist)
---- cause ---------------------------------------------------------------------
Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
Message: Table 'opentaps.job_sandbox' doesn't exist
---- stack trace ---------------------------------------------------------------
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'opentaps.job_sandbox' doesn't exist
sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
com.mysql.jdbc.Util.getInstance(Util.java:381)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
org.ofbiz.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:420)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:335)
org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:294)
org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:186)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1287)
org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1262)
org.ofbiz.service.job.JobManager.poll(JobManager.java:158)
org.ofbiz.service.job.JobPoller.run(JobPoller.java:91)
java.lang.Thread.run(Thread.java:619)
--------------------------------------------------------------------------------

Top

Opentaps service provider erp crm   Site designed by IntegratingWeb with Drupal
© 2011 Open Source Strategies Inc.  Terms of Use