[jira] [Commented] (OFBIZ-4936) Installation error occur about JobSandbox

[Nicolas Malin (Jira)]

    [ 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)