Talk:首页
出自Opentaps Wiki
你们公司的账目计算方法是什么: LIFO, FIFO, or平均值（ average cost）? 你们公司的结账日期和月份是什么? 得到你的公司的账目列表 与默认的进行比较.
我觉得是不是应该译成： 你们公司的成本计价方法是什么：后进先出(LIFO)，先进先出(FIFO)，或是移动平均(average cost)？ 你们公司的会计年度在几月几日截止？ 将你们公司的会计科目与默认的会计科目进行对比。
[编辑] opentaps 1.4.3 启动时报错：Error in polling JobSandbox
目前opentaps 1.4.3是不是不支持Oracle Timestamp类型？
2011-10-21 15:45:49,046 (org.ofbiz.service.job.JobPoller@6c5356) [ SQLProcessor.java:434:ERROR] SQL Exception while executing the following: UPDATE OPENTAPS.JOB_SANDBOX SET RUN_BY_INSTANCE_ID = ?, STATUS_ID = ? WHERE ((RUN_TIME <= '2011-10-21 15:43:54.656' 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-10-21 15:45:49,046 (org.ofbiz.service.job.JobPoller@6c5356) [ GenericDelegator.java:1288:ERROR]
exception report ----------------------------------------------------------
Failure in storeByCondition operation for entity [JobSandbox]: org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception: (ORA-01843: not a valid month )). Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (SQL Exception: (ORA-01843: not a valid month ))
cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception: (ORA-01843: not a valid month )
cause ---------------------------------------------------------------------
Exception: java.sql.SQLDataException Message: ORA-01843: not a valid month
stack trace ---------------------------------------------------------------
java.sql.SQLDataException: ORA-01843: not a valid month oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:79) oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381) oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462) oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349) 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:430) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:340) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:187) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1277) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1247) 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-10-21 15:45:49,046 (org.ofbiz.service.job.JobPoller@6c5356) [ JobManager.java:188:ERROR]
exception report ----------------------------------------------------------
Error in polling JobSandbox: [org.ofbiz.entity.GenericDataSourceException: Generic Entity Exception occured in updateByCondition (SQL Exception: (ORA-01843: not a valid month ))]. Rolling back transaction. Exception: org.ofbiz.entity.GenericDataSourceException Message: Generic Entity Exception occured in updateByCondition (SQL Exception: (ORA-01843: not a valid month ))
cause ---------------------------------------------------------------------
Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception: (ORA-01843: not a valid month )
cause ---------------------------------------------------------------------
Exception: java.sql.SQLDataException Message: ORA-01843: not a valid month
stack trace ---------------------------------------------------------------
java.sql.SQLDataException: ORA-01843: not a valid month oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:79) oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413) oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194) oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:947) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381) oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3462) oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1349) 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:430) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:340) org.ofbiz.entity.datasource.GenericDAO.updateByCondition(GenericDAO.java:291) org.ofbiz.entity.datasource.GenericHelperDAO.storeByCondition(GenericHelperDAO.java:187) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1277) org.ofbiz.entity.GenericDelegator.storeByCondition(GenericDelegator.java:1247) 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)
