Forum Discussion

sdeng's avatar
sdeng
New Contributor II
7 years ago
Solved

Can Workday Write add parameter X-Validate-Only to run in validation mode?

Can Workday Write add parameter X-Validate-Only to run in validation mode?

  • I just ran across this, but did not see a response, so here goes. Yes indeed! As of this writing you can use this flag on a write:

2 Replies

  • sgrajpal's avatar
    sgrajpal
    New Contributor

    Hello PSAmmirata
    The same issue I am facing right now. my database account batch size is set to 50 and if error is in single record entire batch is getting error out with error message of first record where as other 49 records are valid records without erroneous data (tried and tested by manually removing 1 erroneous record ).
    By setting batch size to 1 resolved the issue but now pipeline is taking 20 times more time as earlier ☹️
    Kindly suggest me you came across any other better solution that would help me a lot.

    • phunter's avatar
      phunter
      New Contributor

      Just adding to the chorus here. I am having the same issue. I am working to replace sqlldr, so, I am able to compare the same import between 2 methods. Snaplogic loads fine if the data is perfect. If there is any issue, in my case foreign key exceptions. It errors out a lot of good records with the same error code. The error clearly does not apply to a majority of the records (the parent does exist). The rejects do include the records that are appropriately rejected.