Thanakrit Wongyued created OFBIZ-4936:
-----------------------------------------
Summary: Installation error occur about JobSandbox
Key: OFBIZ-4936
URL: https://issues.apache.org/jira/browse/OFBIZ-4936
Project: OFBiz
Issue Type: Bug
Components: ALL COMPONENTS
Affects Versions: SVN trunk
Environment: Mac OS X Lion 1.7.4
Oracle Java SDK 1.7
Apache OFBiz trunk Rev: 1350081
Reporter: Thanakrit Wongyued
Attachments: Terminal Saved Output.log
Hi,
My name is Thanakrit from Thailand. I try to install ofbiz from trunk and then
error occured reading data from file below :
trunk/applications/accounting/data/AccountingScheduledServiceData.xml
trunk/framework/service/data/ScheduledServices.xml
and more...
[java] 2012-06-14 14:23:26,771 (main) [ EntitySaxReader.java:220:INFO ]
Beginning import from URL:
file:/Users/Thanakrit/Projects/srk/trunk/framework/service/data/ScheduledServices.xml
[java] 2012-06-14 14:23:26,771 (main) [ EntitySaxReader.java:270:INFO ]
Transaction Timeout set to 2 hours (7200 seconds)
[java] 2012-06-14 14:23:26,870 (main) [ GenericDelegator.java:891:ERROR]
Failure in create operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2012-06-14
14:23:26.829(java.sql.Timestamp)][createdTxStamp,2012-06-14
14:23:26.771(java.sql.Timestamp)][jobId,PURGE_OLD_JOBS(java.lang.String)][jobName,Purge
Old Jobs(java.lang.String)][lastUpdatedStamp,2012-06-14
14:23:26.829(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-14
14:23:26.771(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,purgeOldJobs(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, AUTH_USER_LOGIN_ID,
RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'JOB_SANDBOX' caused a violation of foreign key constraint 'JOB_SNDBX_USRLGN'
for key (system). The statement has been rolled back.)). Rolling back
transaction.
[java] 2012-06-14 14:23:26,871 (main) [ TransactionUtil.java:379:WARN ]
[java] ---- exception report
----------------------------------------------------------
[java] [TransactionUtil.setRollbackOnly] Calling transaction
setRollbackOnly; this stack trace shows where this is happening:
[java] Exception: java.lang.Exception
[java] Message: Failure in create operation for entity [JobSandbox]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:JobSandbox][createdStamp,2012-06-14
14:23:26.829(java.sql.Timestamp)][createdTxStamp,2012-06-14
14:23:26.771(java.sql.Timestamp)][jobId,PURGE_OLD_JOBS(java.lang.String)][jobName,Purge
Old Jobs(java.lang.String)][lastUpdatedStamp,2012-06-14
14:23:26.829(java.sql.Timestamp)][lastUpdatedTxStamp,2012-06-14
14:23:26.771(java.sql.Timestamp)][maxRecurrenceCount,-1(java.lang.Long)][poolId,pool(java.lang.String)][runAsUser,system(java.lang.String)][runTime,2000-01-01
00:00:00.0(java.sql.Timestamp)][serviceName,purgeOldJobs(java.lang.String)][tempExprId,MIDNIGHT_DAILY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO OFBIZ.JOB_SANDBOX
(JOB_ID, JOB_NAME, RUN_TIME, POOL_ID, STATUS_ID, PARENT_JOB_ID,
PREVIOUS_JOB_ID, SERVICE_NAME, LOADER_NAME, MAX_RETRY, AUTH_USER_LOGIN_ID,
RUN_AS_USER, RUNTIME_DATA_ID, RECURRENCE_INFO_ID, TEMP_EXPR_ID,
CURRENT_RECURRENCE_COUNT, MAX_RECURRENCE_COUNT, RUN_BY_INSTANCE_ID,
START_DATE_TIME, FINISH_DATE_TIME, CANCEL_DATE_TIME, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table
'JOB_SANDBOX' caused a violation of foreign key constraint 'JOB_SNDBX_USRLGN'
for key (system). The statement has been rolled back.)). Rolling back
transaction.
[java] ---- stack trace
---------------------------------------------------------------
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
