As need to store the errors in snowflake database table that is which component failed and what is the error when run the job, if job failed.
Hi Brayn,
Thanks for reply, could you please specify step by step to implement error handling.
Actually i have used API Query as you suggested but still getting error as "HTTP protocol error. 401 ."
If you are getting a 401 error then you are hitting an authentication issue. This means that the username and password you are using is either wrong or the user doesn't have access to the API. You can check the API access of the user by going to the Admin menu and then User Configuration.
If you are using the External authentication method then you will want to check to make sure the AD group used for API includes the user being used in the API Query: https://documentation.matillion.com/docs/8233018#external
If you are using internal for your authentication method then you will want to make sure you have the user added and that API is checked: https://documentation.matillion.com/docs/8233018#internal
I hope this get's you further.
Thanks for your quick response, could you please let me know the step by step to achieve Error handling (capture the error details in snowflake table which is our target source). So this step by step with example including components because i may be doing write way of this process.
The steps would be to go to Project --> Manage API Profiles --> Manage Query Profiles and create a new Profile if you don't already have one. Once the Profile is created you will want to import the profile I posted. You do this by opening the profile you just created and then clicking the the New File button. Select the "Use Config File" option and click next. Give the filename anything you would like (i.e. HistoryByRange). On the Review File section you will want to remove all the existing code and replace it with the code I posted in your other post and then click Finish. Now you should see your new file listed on the left under files. Let's test it first because if this test fails then anything after this point will fail as well. In order to test the file you will need to give the test harness credentials that have API access. To enter the credentials click the Gear icon and add User, AuthScheme as Basic and Password.
Once you have that credentials configured you can click the Test button. This will show the files for testing in the lower left pane. When you click on the new file in the lower left pane the test will fire and you will be prompted with the inputs (i.e. group, project, start/end dates, and start/end times). The test will then try to execute using the credentials you configured. If this fails with a 401 then you need to check the credentials you used as they are either wrong or don’t have access to the API.
Please do this and let me know if this part works. If so, I can give you the rest what a job might look like to achieve what you are trying to do. I hope this get’s you further.
Could you please upload attachment, as you send to my mail. my organization not allowing attachment
I'm not sure what you mean. I didn't send anything to your email. I don't know what your email address is. The screenshot I uploaded was only to this forum. If you received my response in your email then that is likely a notification from the Matillion forum. You will need to open the forum in a browser to see the screenshot I posted.