Help with Process Logic

ab042

Could you give me some pointers, something I'm doing is very wrong. I created a process to look at a BO and create new records in another BO.
Here is the basic logic I have setup and it creates records or a lot of the same record but I can't figure out how to get it working correctly.

Note I also tryed using THIS in front of the attributes. Using THIS in the attributes gets me closer but things like xTask.NextReminder date never updates.
Can I use CREATE FOR EACH in different RULES with the IF statement above them? Note the last few lines of the rule are used to update the original record so it sets it up for the process next Day, Week etc.

First Rule, This is selecting the records and the count is correct so I believe this is working.

FIND xTask WHERE .....

Next Rule:
If xTask.Sched='Daily' AND xTask.LastProc<>CURRENT_DATE THEN
CREATE Work FOR EACH xTask WITH
Work.Now=xTask.NextReminder
Work.Contact=xTask.Contact,
Work.Agent=xTask.Agent,
Work.Subject=xTask.Subject

INCREASE xTask.NumUsed BY 1 (Note sure I can update the original record with the above CREATE in same rule?)
xTask.LastProc=Current_Date

xTask.NextReminder=BUSINESS_DAY_FORWARD(xTask.NextReminder,1)

Next Rule is the same as above except its for xTask.Sched='Week' / Then next Rule is same except 'Month' etc

Any pointers?

aware_support2

> Can I use CREATE FOR EACH in different RULES with the IF statement above them?
No - this is what creates duplicate instances. "CREATE Work FOR EACH xTask" will work on all xTask instances placed into the context by query "FIND xTask WHERE ....." above - not just those constrained by condition in "If".

You need to split the process into multiple processes with conditions from "If" placed into the query. For example, a DoDailyProcessing process would have 5 rules like these:

FIND xTask WHERE xTask.Sched='Daily' AND Task.LastProc<>CURRENT_DATE

CREATE Work FOR EACH xTask WITH Work.Now=xTask.NextReminder, Work.Contact=xTask.Contact, Work.Agent=xTask.Agent, Work.Subject=xTask.Subject

INCREASE xTask.NumUsed BY 1

xTask.LastProc=CURRENT_DATE

xTask.NextReminder=BUSINESS_DAY_FORWARD(xTask.NextReminder,1)

There would be separate processes for weekly and monthly processing. For convenience (e.g. starting the processing) you can call the separate processes from a container process:

DoDailyProcessing
DoWeeklyProcessing
DoMonthlyProcessing

Each separate process will have its own context that will be discarded when the process finishes on return to the container process. Therefore, there will be no creation of duplicate instances.

ab042

I'm getting several unknown errors or reports in the Server Output log and can't figure out what they are or why.

#1) 2006-08-19 14:14:22 ERROR -Unable to connect to remote host mydomain.com access denied
Since I use "mydomain.com" for more than one business space I can't figure out which business space is causing this error.

#2) Unable to find ThisContact.LoginName in aggregate operation COUNT
What is running this and what is "Aggregate operation COUNT"

#3) Controller has commited 100 transactions
What is this? Sometimes it says more than 100

#4) log4j:WARN No appenders could be found for logger (BUSINESS_LOGGER). Please initialize the log4j system properly.

ab042

The above helped and solved my problem. THANK YOU!

Sorry, the above message should have been a NEW thread.

aware_support2

#1) When do you get this message, what do you do to get it?

#2) This is likely to be from a rule that uses EXISTS (which is internally implemented through COUNT). It indicates that an instance of Contact is not available in the context when the rule is executed, which may or may not be a problem depending on the application logic.

#3) This is internal diagnostic message. Please ignore it.

#4) This is internal diagnostic message. Please ignore it.

ab042

#1) Unable to connect
This just happens by itself. I assume maybe incorrectly so that it is an automated process checking for email or something but I can't figure out which business space its from.

#2) Aggregae operation COUNT
I've searched Process and All other Rules / Expression and Rule Name and the only place I have COUNT is in the LoginNotification, LoginAttemptNotification and they Initialise Process. So I'm assuming when this shows up while running the application with one user logged in that its not one of the 3 places. Any suggestions?

aware_support2

#1) It does seem like coming from an attempt to contact the mail server for collecting incoming emails. Please check your business spaces that use this server name for incoming emails and ensure the parameters for email account are specified correctly.

#2) As I said previously, this could come from a rule that uses EXISTS - not COUNT. The Log Viewer should have clear indications where this happens, like creating an object, updating an object, starting a process, etc. Please inspect the preceding entries in the log to see where it happens.

ab042

#1) I've check and can't find it. I don't believe this is urgent so if your able and when you get time, you may want to add the Business Space in front of the error or something so we can figure it out later.

#2) Ok I searched the EXISTS and found TWO RULES in my CONTACT Business object. I took them directly from the Customer File in the CRM demo (modified what needed to be and they work fine), so I don't know why they are creating errors.

To check I removed the Unique LoginName rule and Unique CompanyName rule and the error is no longer appearing.

Is it possible that I have corrupted data? I would love to know how to EXPORT my data into a CSV file and delete all the data files and have something recreate them fresh and IMPORT my CSV files back in RETAINING ALL the links. This would confirm I have clean data.

I'm having an issue with the WEEK rule I talked about above and it works fine on my TEST data and even works if I have one or two records that apply to the rule. But as soon as I get several records that the rule has to process, I get an INTERNAL ERROR after 20 seconds or so. When I look at the log it shows OUT OF MEMORY. Running on a 2gig machine.

For the record I've tryed increasing the memory on everything from 96 to 512 including the StartAwareIM.bat and don't believe this has anything to do with the issue other than the process is running away and eating it all up. The log files don't point me in any direction.

If I DELETE the TWO files from the BASDB directory will they get recreated? This would at least allow me to key fresh data without killing the rest of my app and the data in it.

aware_support2

#2) As I said previously, error messages in the log file may or may not indicate a problem. For example, when the "Uniqueness of login name" is executed during the initialization of the form before the object is created, the message "Unable to find ThisContact" could be displayed in the log. This is expected because the object has not been created yet, so ThisContact is not available. Once the user clicks Create, the object becomes available and the message should no longer appear.

As I said previously, you need to inspect the preceding entries in the log to determine if this is a problem.

B) Regarding the out of memory message. It is possible that your rules cause a repeated execution loop because of incorrectly specified conditions. Normally the system should detect it, but maybe it runs out of memory before the default recurrence limit is reached (which is controlled by MaxNmbOfRepeats entry in file BASServer.props located in BIN directlry).

Please inspect the Log Viewer to see if you can observe a repeated execution pattern and fix the rule conditions accordingly if this is the case. You can also try specifying a lower value for MaxNmbOfRepeats (remember to restart Control Panel) to see if the system detects a repeated execution pattern automatically.

C) All files in BASDB directory are managed by the database engine (Derby, MySQL, etc.). Changing a file there may render the entire database inoperable. If you need to delete instances of a particular business object you can either use a query in your application with the delete operation enabled for multiple instances, or configure a process with two rules like these:

FIND ALL MyObject
DELETE MyObject

tford

Support,

From ab042's post of August 19, 2006 @ 11:57 pm

#1) I've check and can't find it. I don't believe this is urgent so if your able and when you get time, you may want to add the Business Space in front of the error or something so we can figure it out later.

I have also been having a problem tracking down an "unable to connect ...." error message. Not sure which BSV it's coming from after a lot of trial and error.

It would be a HUGE help if you could add the BSV name to this error message!

Thanks much!
Tom

bmeyns

A+
adding businessSpace to log-file should help al lot.