[
https://issues.apache.org/jira/browse/OFBIZ-4936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacopo Cappellato closed OFBIZ-4936.
------------------------------------
Resolution: Cannot Reproduce
Tested in trunk, it works 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: Trunk
> Environment: Mac OS X Lion 1.7.4
> Oracle Java SDK 1.7
> Apache OFBiz trunk Rev: 1350081
> Reporter: Thanakrit Wongyued
> Assignee: Jacopo Cappellato
> 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.3.4#6332)
