[
https://issues.apache.org/jira/browse/OFBIZ-11668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pawan Verma closed OFBIZ-11668.
-------------------------------
Fix Version/s: 17.12.04
18.12.01
Resolution: Fixed
> startup-service does not work without runtime-data-id
> -----------------------------------------------------
>
> Key: OFBIZ-11668
> URL: https://issues.apache.org/jira/browse/OFBIZ-11668
> Project: OFBiz
> Issue Type: Bug
> Components: framework/service
> Affects Versions: Release Branch 18.12, Release Branch 17.12, Trunk
> Reporter: Pawan Verma
> Assignee: Pawan Verma
> Priority: Major
> Fix For: 18.12.01, 17.12.04
>
> Attachments: OFBIZ-11668.patch
>
>
> startup-service has runtime-data-id as an optional parameter(Find more info
> at service-config.xsd).
> Example:
> <startup-service name="getAllCategories" runtime-delay="0"
> run-in-pool="pool"/>
> If we do not provide runtime-data-id while defining startup-service we got
> following error:
> |E| Failure in createSetNextSeqId operation for entity [JobSandbox]:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:JobSandbox][createdStamp,2020-05-08
> 11:43:05.631(java.sql.Timestamp)][createdTxStamp,2020-05-08
> 11:43:05.629(java.sql.Timestamp)][currentRetryCount,0(java.lang.Long)][jobId,34100(java.lang.String)][jobName,1588918385514(java.lang.String)][lastUpdatedStamp,2020-05-08
> 11:43:05.631(java.sql.Timestamp)][lastUpdatedTxStamp,2020-05-08
> 11:43:05.629(java.sql.Timestamp)][loaderName,default(java.lang.String)][maxRetry,-1(java.lang.Long)][poolId,pool(java.lang.String)][recurrenceInfoId,null()][runTime,2020-05-08
>
> 11:43:06.514(java.sql.Timestamp)][runtimeDataId,(java.lang.String)][serviceName,getAllCategories(java.lang.String)][statusId,SERVICE_PENDING(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, CURRENT_RETRY_COUNT,
> 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,
> JOB_RESULT, 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_RNTMDTA' for key (). The
> statement has been rolled back.)). Rolling back transaction.
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:JobSandbox][createdStamp,2020-05-08
> 11:43:05.631(java.sql.Timestamp)][createdTxStamp,2020-05-08
> 11:43:05.629(java.sql.Timestamp)][currentRetryCount,0(java.lang.Long)][jobId,34100(java.lang.String)][jobName,1588918385514(java.lang.String)][lastUpdatedStamp,2020-05-08
> 11:43:05.631(java.sql.Timestamp)][lastUpdatedTxStamp,2020-05-08
> 11:43:05.629(java.sql.Timestamp)][loaderName,default(java.lang.String)][maxRetry,-1(java.lang.Long)][poolId,pool(java.lang.String)][recurrenceInfoId,null()][runTime,2020-05-08
>
> 11:43:06.514(java.sql.Timestamp)][runtimeDataId,(java.lang.String)][serviceName,getAllCategories(java.lang.String)][statusId,SERVICE_PENDING(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, CURRENT_RETRY_COUNT,
> 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,
> JOB_RESULT, 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_RNTMDTA' for key (). The
> statement has been rolled back.))
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
