This That and Other vs separate processes passing BO's

rbross

Hello,

I have a very tricky process that I am creating where I need to read a few tables more than once.
Currently most of the rules are contained in the same process so it looks like I will need to use This, That and Other when referencing attributes from the BO's I will be reading.
My Question is, If I were to split things up into separate processes and pass the BO's I do the FINDS on would that work better and be easier to manage?

Please keep in mind that I am rewriting this process in AIM based off a program that was created in another application originally, so there may be an easier way to do it in AIM?

The Bo's I am reading are external MS_SQL Tables. Without getting in to a ton of detail the finds that I need to do are in this order:
FIND Sales_History Where(...)
DO somethings based on result
FIND po_Hdr Where(...)
Do Something base on result
FIND apinv_line Where(...)
FIND apin_hdr Where(...)
Do something based on result
Create a temp table with some of the values found so far
FIND apinv_hdr Where(...)
FIND apinv_line Where(...)
Update some fields in temp table with results
Call process to FIND Part No. in a special Pricing Agreement Table. This is done to find lowest possible price for part no. based on a start and end date of the pricing agreement
Write Part No and details to Special pricing Sales Ledger BO.
End Process

Any help and suggestions are most appreciated....

Regards,
Roger

tford

My preference is to break up this kind of process into multiple processes and pass the attributes as needed.

You may find that in certain cases you need to use IN BATCHES OF to iterate through the values that are found and process them appropriately.

rbross

Thanks Tom, I'll try that.
Is the rule for "This That and Other" only applicable when you do more than one find within the same process?
If you pass the BO to the next process then you don't have to use "This" Correct?

Roger

tford

If you pass the BO to the next process then you don't have to use "This" Correct?

In general this is correct. Be sure to read the User Guide about using these prefixes, and of course testing the processes that you build by working through examples where you know what the result should be is always a must when programming.

rbross

Splitting the processes up helped, but now i am getting a "JAVA Heap Space" error during one of the called processes. I did look this error up in the user group, but I must say that I don't really understand how to resolve it?

the memory settings for AIM are:
AwareIM Server 512Mg
Tomcat 1024Mb
Configuration Tool 1024Mb

It does not look like the server is running a 64 bit version of Java.
Server specs are: Windows server 2008 R2 Standard, 8Gb memory 64 bit OS Intel Xeon CPU-2690 v2 @ 3.00GHz (2 processors)

Any suggestion on how to resolve this issue...

Thanks

Roger

aware_support

You may be reading too much data when executing a FIND. A possible solution is to use IN BATCHES.

Or you genuinely need to increase memory of the Aware IM Server

rbross

I reviewed this error with the IT support for the customer and they were familiar with it. We installed Java 64 bit version and replace the JDK folder under AwareIM with it and restarted everything and that resolved the issue. We also increased the memory for Tomcat from 512Mgb to 1024Mb.
I have run the process several times now without any Java Heap Space Errors.
I have also changed how the processes are called. I split them up into several sub processes which seems to help as well.

Thanks,
Roger