How to Set Request sets for PAC operations

Source: Internet
Author: User

Because of the first PAC: regular request for the cost processing program requests, the system automatically submits regular actual cost processing program requests during operation, and the two requests do not have a parent-child relationship, as a result, when the second request has not been processed, the first request has been completed, which makes it impossible to set the link stage when setting the request set. The same is true for the second PAC.

Idea: Set the second PAC request: average cost processing program during the period and third PAC request: the regular cost allocation processing program is not compatible with the regular actual cost processing program, in this way, once the regular actual cost processing program is in the running state, the second and third requests will be in the waiting state. For example:

There is another problem after this setting: when the first or second PAC request triggers the regular actual cost processing program request, because it has already been completed, this causes the next stage (second or third PAC) to start running, so: Regular actual cost processing program and next stage (second or third PAC) it is likely to be in the undetermined status at the same time. At this time, we find that there are uncertainties even if compatibility is set. Sometimes we run the former first, and sometimes the latter, this will cause the final operation to fail (here I also set the priority to test, but the result is still the same)

Solution: add the sleep request that comes with Oracle, as shown below: note that you need to define this request. The standard only provides the PL/SQL stored procedure and does not provide this request, new definitions are required:

 

If the default value is not set here, the system's standard default value is 20 seconds. The default value is that this parameter value can be adjusted when the request set is running, the value here needs to be set based on system resources: its main function is to delay the next stage to start running, so that regular actual cost processing program requests are already running, in this way, the second or third pac will be in the waiting state due to incompatibility (ThereforeHere, the sleep time mainly depends on server processing.The response time of conflicting requests. If the request is slow, the time is set to be a little longer.).

 

The final settings are as follows:

Note:Because 3rdSupport PacBased on the previous request, the current request has not been completed, and the subsequent request cannot be selected. ThereforeDuring this period, you must first run the first and second requests so that the request set can be assigned a value.(OrChange the system standard value set)

 

 

DelayRegular actual cost processing programThe request set is successfully processed when the request is running.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.