Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Transaction Loop Skip Error

    Posted 09-27-2018 10:53
    ​
    I have a transaction V11 script for a FEV3 table insert and trying to insert about 1,500 rows into this table script has a Loop with H / D columns it runs up till it hits the first error and doesn't process the remaing rows in the data sheet? This is first LOOP script done so not seen this behavior as all other transactions would log the error and keep going?

    Is there a way to log the error on the 'D' row and continue with the remaining records? It seems to just log the error for both the log and extended log columns in the 'H' row only

    Thanks for help.....

    ------------------------------
    Paul Volkert | Support Developer

    ------------------------------


  • 2.  RE: Transaction Loop Skip Error

    Employee
    Posted 09-28-2018 04:45
    ​Hi Paul,

    the way the loop script works is saving the transaction only after processing all the rows. Since there is an error in one of the lines, it's impossible to save the transaction, since SAP will only allow to save when that error is fixed.

    You will have to choose between fixing the error and re-run all lines contained in that Header, or change the script to add and save one line each time.

    Hope that helps.

    Regards,

    ------------------------------
    Andre Monteiro | Senior Systems Administrator
    UK Power Networks
    ------------------------------



  • 3.  RE: Transaction Loop Skip Error

    Posted 09-28-2018 10:22
    ​Hi,

    I suspect the design of loop with Header and Data is treated as one item, so when error occur it terminates the group.
    We may need to use "Validate" option to check for data errors before actual load, my suggestion!

    Thanks

    ------------------------------
    Madhu Komaravolu | SAP Solution Architect
    Navajo Tribal Utility Authority | [City] | 9287296163
    ------------------------------



  • 4.  RE: Transaction Loop Skip Error

    Posted 10-01-2018 11:58
    This is all true. Another thing to note that Winshuttle will only report on the first error encountered, so if multiple errors occur on "D" rows, you will not have full visibility to all "D" rows that require update.

    ------------------------------
    Alexander Alonso | Business Analyst
    ---
    Medtronic - HQ
    ------------------------------

    Original Message


  • 5.  RE: Transaction Loop Skip Error

    Posted 10-02-2018 08:13
    ​Thanks for the input the scripts file is structured with a 'H' first line and remaining lines as 'D' but somewhere on the script when the error happens say line 215 of the 500 records the remaining lines are not executed but to the script it shows as data saved?

    Is there a way to execute transaction without having to have structure of file like below for all the records as this makes the upload file by BU harder to create each time for them over the current file which is Line one 'H' and all other lines below as 'D'

    H   6   2018
               D  Insert1    1500
    H   6   2018
               D  Insert2    1200
    H   6   2018
                D  Insert3    1300

    ------------------------------
    Paul Volkert | Developer

    ------------------------------

    Original Message