1 Reply Latest reply on Mar 27, 2019 6:32 AM by Nico Heinze

    Issue with stored proc when calling from SQ sql override

    Jogesh Kumar Pati New Member

      I have a mapping where I am calling a stored proc from SQ sql override.

      exec up_get_unprocessed_payments 

      The stored proc is simple having a select query only.

      The SQ is having all the fields which are defined in the select query of the stored proc. There is no other filter/transformations.

      When the mapping is run, the stored proc outputs only 442 records(out of 446). There is no mention of dropped/rejected records in session log. But when I run the same procedure in DB, it gives all 446 records. The interesting part, the dropped records are every 101th record.

      Can you guys help here?