[ https://issues.apache.org/jira/browse/OFBIZ-4936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13975464#comment-13975464 ]
Jacopo Cappellato commented on OFBIZ-4936: ------------------------------------------ what is the status of this? is it resolved now? > 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 > Assignee: Hans Bakker > 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 was sent by Atlassian JIRA (v6.2#6252)