Try put it ntext, this is the type I used (I didn't try text) Did you reset ofbiz? if it doesn't still work, try to see the log, or run the service directly from the webtools module through the service reference menu (you select the service, and then click on schedule)
2007/8/7, William Perng <[EMAIL PROTECTED]>: > > I double check my RUNTIME_DATA column in runtimeInfo table. It has been > set > to type "text", and it still doesn't work. Please help, thanks. > > -----Original Message----- > From: William Perng [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 07, 2007 11:39 AM > To: user@ofbiz.apache.org > Subject: RE: ms sql server 2005 shoppinglist problem > > 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 > > > > > > > > > > > > > > > >
