My application has an integration test that runs a complete OpenWFE
process, simulating all interaction with participants. When I use a
FilePersistedEngine it runs fine. When I use a DbPersistedEngine, the
process terminates as a specific location in the process definition.

After a while I found out that the limited size of the svalue column
in the expressions table was causing the problem. When I use
FilePersistedEngine, I have yaml files in work/expool which are up to
126673 bytes. The svalue column is of type text which is limited to
64K. I also queried the expressions table, and indeed it had svalue
columns of 65535 bytes.

I changed the column definition of svalue in extras/expool/
dbexpstorage.rb:

t.column :svalue, :text, :null => false, :limit => 1024*1024

Now the column is of type mediumtext. My test still didn't work, but
that was caused by "rake test" which re-initializes the schema of the
test database. I tested it on production after recreating the
expression table, and it runs without problems.

Maybe the svalue column should be set to a larger size to accomodate
larger process definitions.

Maarten O.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"OpenWFEru users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/openwferu-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to