Automate

Hi.

I have built a query for someone based on the tables/fields/joins they provided. The query keeps timing out, so I need to know what I am missing that will allow it to return the requested data.

Any assistance is appreciated.

Hi Michelle

Don't have time to look at this in depth as I did with your other questions, but here are some things to look for in general

• join on key fields whenever possible
• use criteria on key fields when possible
• if you have a lot of data to return or in your SAP system to go through, consider enabling throttling and use chunking to keep the connection alive and return results in chunks: https://help.precisely.com/r/t/1016755938/2023-12-31/Automate-Studio/Connect/Latest/en-US/Automate-Studio-with-Studio-Administrator-User-Guide/Run-settings-for-Query
• look at timeout settings - you may need an SAP Basis person to help with this: https://help.precisely.com/r/n/Automate-Function-Module/pub/Latest/en-US/Automate-Function-Module/Query-and-Transaction-parameters-Maintain-Timeout-and-other-settings-centrally?tocId=LZqv1Ea72eeFun5hsC5lyg

Best Regards,

Sigrid

Hi.

I have built a query for someone based on the tables/fields/joins they provided. The query keeps timing out, so I need to know what I am missing that will allow it to return the requested data.

Any assistance is appreciated.