The type of that column is text now. Thanks -----Original Message----- From: Amine AZZI [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 07, 2007 11:10 AM To: user@ofbiz.apache.org; [EMAIL PROTECTED] Subject: Re: ms sql server 2005 shoppinglist problem
it's because of the field runtimeInfo in the table RUNTIME_DATA that hasn't the suitable size, it should be changed to type text or ntext. Amine. 2007/8/7, William Perng <[EMAIL PROTECTED]>: > > My ofbiz instance uses ms sql server 2005. The schedule service > doesn't generate orders from my automatic re-orders shopping lists. > If I force the "runShoppingListAutoReorder" process to run, it seems > the process will run forever. I don't see error in log file. I have > tried the source code from trunk and Release4.0, and also tried ms > jdbc driver and jtds driver. If I use derby, everything is ok. Any > idea ? > > Thanks > > > William Perng > [EMAIL PROTECTED] > (516) 742-7888 Ext; 223 > Yahoo IM: william.perng > > > > >