You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacopo Cappellato (JIRA)" <ji...@apache.org> on 2014/04/21 09:33:14 UTC
[jira] [Commented] (OFBIZ-4936) Installation error occur about
JobSandbox
[ 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)