[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=17123685#comment-17123685 ]

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

Commit 8cac7f1fc5dfebd53184b2e3ba9f7588b79876c6 in ofbiz-framework's branch refs/heads/trunk from Pawan Verma
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=8cac7f1 ]

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)