I am re-designing one FI Document postings program which is taking long time in our production system. In the new version, I had to implement parallel processing to get better response time.
If you want understand little more about the program flow:
Currently I am testing this in one of our testing environment where we have 4 servers with 14+18+18+18 DIA processors.
We are receiving run time error "SQL error 60 when accessing table NRIV." , in very few cases i.e couple of times out of 20-25 executions. Apparently, we got this error when we tried with "6" parallel tasks (as we can control this from selection-screen). But I don't see any technical or logical reason behind "6" tasks.
As you can see in run time error, we are facing this error due to number range that we are using. In this number range object RF_BELEG we did not set any buffering, till now. I don't see much documentation on "Parallel buffering" option that we have for this number range (as per the name, it seems relevant to parallel processing). Actually, i am worried if there will be any impact on other applications/programs if we change this, as we are using FI document posting (which will hit this number range) widely in our system.