forall insert intermittently skips 77 rows.
Procedure receives an array of 50000 rows. Procedure performs a "forall insert" for this 50000 rows.
Randomly skips 77 rows, i.e., 77 rows are not inserted. There are no errors. Trying to process this failed rows again, successfully inserts the rows.
1. It does not fail at row 77. Intermittently fails with a group of 77 rows (random position) in the 50000 inserted rows. Each row has 387 bytes.
2. No triggers are involved.
3. Data is valid, verified and re-processed.
Code Snippet:
----------------------------
--- Collection prior to forall:
--- clear the memory !
t_Insert.delete();
----fill the collection
For x In 1 .. records.Count Loop
Begin
---- pass each record of collection 'records' to a 'recordtype'
Randomly skips 77 rows, i.e., 77 rows are not inserted. There are no errors. Trying to process this failed rows again, successfully inserts the rows.
1. It does not fail at row 77. Intermittently fails with a group of 77 rows (random position) in the 50000 inserted rows. Each row has 387 bytes.
2. No triggers are involved.
3. Data is valid, verified and re-processed.
Code Snippet:
----------------------------
--- Collection prior to forall:
--- clear the memory !
t_Insert.delete();
----fill the collection
For x In 1 .. records.Count Loop
Begin
---- pass each record of collection 'records' to a 'recordtype'
0