Process works in test but not in published version

rocketman

Tearing my hair out... I have a process which basically does a "Pick one or more from [queryname], then allows the user to select members to send a previously composed email to.

The process code is as follows (3 lines)

PICK ONE OR MORE FROM Memberfind_All_Active
If BulkMail.HTML='Yes' Then SEND BulkEmail TO Members ELSE SEND BulkText TO Members
DISPLAY MESSAGE 'E-mail has been sent to your selected list'

The query Memberfind_All_Active is:

FIND Members WHERE Members.ActiveMkr='Yes' AND Members.EmailAddress CONTAINS '@'

This works fine in test mode but will not work in the published version. The only difference between test and published version is the number of records in the database - but even in the published version we are still only talking about 550 records. In test mode, the number of records returned is 89. In published mode it SHOULD be around 160

What happens is the list gets displayed in test but in published mode the process seems to fail and/or time out. nothing is displayed and the little processing wheel on the bottom of the window just keeps spinning round. (the number of records per page is set to 999 on the query Memberfind_All_Active)

Any ideas? the only thing I can think of is if there is some corruption in the database that might be screwing up the search - but I don't know how to go about testing this. Are there any routines to check the integrity of Mysql data??

Aware V4.8 and Mysql datbase

tford

I would check out various parts one by one. For example

1) change from 999 to 30 records per page
2) In Memberfind_All_Active, try FIND ALL Members

aware_support

If anything is wrong in Aware IM the first thing you need to do is:

Check the LogViewer
Check the output of the Aware IM Server, Tomcat, JBoss for possible suspicious exceptions

Test and regular mode should behave ABSOLUTELY IDENITICALLY.

rocketman

Oh No ... This is the worse possible scenario.

This morning I stopped all services, deleted all the logs I could find, then started AwareIM via the control panel so I could set the logging levels and easily see the Tomcat and Jboss outputs.

My processes worked first time in both testing and regular mode.

Whilst this is great - it's not good since I now have no way of knowing what went wrong and it might happen again.

Any clues as to why this should have happened would be gratefully received.

I have a lot of stuff to get out for our upcoming annual general meeting so will leave the control panel running form now but I'll revert to running aware as a service (which I need to be able to reliably do tonight to see if the problem returns

rocketman

Don't know whether this is related to the problem outlined in this post, but following the completion of the process to actually send the mail, I got a lot of these in my system.log file

2009-12-01 09:41:34,811 ERROR -Exception forming notification for e-mail Delivery Status Notification (Failure) from postmaster@hotmail.com unicode-1-1-utf-7 E-mail will not be processed

Looking at the file, some process appears to be looping - since the same 4 "Postmasters" appear over and over again which may be ultimately causing a backlog in the process engine - especially if someone sends out another clubwide email? dunno, any thoughts.

vinsnash

I believe if you haven't selected the "test" check box on the log in screen you launch the latested published version and not the test version even if you have set the version you're working on to "test" mode.

It made me think stuff I spent a couple of hours developing had just disappeared. 😉

Vins Nash