SQL exceptions when running CREATE import (Lotus)

Description

Overview: 

When doing a CREATE data import, out of the blue SQL errors occurred in mod-source-record-storage and the current job and subsequent jobs trip over the same errors. Jobs therefore became stuck at some point in the import.  This does not happen consistently, but once the error happened then subsequent jobs would fail. The workaround is to restart mod-srs and if that doesn't work restart all DI modules.

Steps to Reproduce:

  1. Log into https://pre-kiwi-cap1.int.aws.folio.org/data-import 

  2. Do a 20K Create import using the profile PTF - Create Success 2.  

  3. The job could get stuck at some point, or not. 

Expected Results:

Import job succeeds
Actual Results:

Errors found and the job is stuck.
Additional Information:

We used the attached file to do a 20K Create import.

Exceptions: 

Interested parties:

 

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Checklist

hide

TestRail: Results

Activity

Show:

Ann-Marie BreauxFebruary 10, 2022 at 7:46 PM

Assign same RCA group as (currently TBD)

Done

Details

Assignee

Reporter

Priority

Story Points

Development Team

Folijet Support

Fix versions

Release

Lotus R1 2022

RCA Group

Third party component integration

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created February 3, 2022 at 1:07 PM
Updated February 11, 2022 at 2:49 PM
Resolved February 3, 2022 at 1:15 PM
TestRail: Cases
TestRail: Runs