[jira] [Commented] (OFBIZ-11668) startup-service does not work without runtime-data-id

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-11668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17123688#comment-17123688 ]

ASF subversion and git services commented on OFBIZ-11668:
---------------------------------------------------------

Commit 1d3c7915c99d9a976217c58f94e715b75a1bd98c in ofbiz-framework's branch refs/heads/release18.12 from Pawan Verma
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=1d3c791 ]

Fixed: startup-service does not work without runtime-data-id(OFBIZ-11668)

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