Sorry, that my suggestion wasn't the right one, and happy that it works for
you.
Amine.
2007/8/8, William Perng <[EMAIL PROTECTED]>:
>
> I tried the ntext, it still doesn't work for me. However, it works after
> I
> comment out "dispatcher.runAsync("sendOrderPayRetryNotification",
> UtilMisc.toMap("orderId", orderId));" in createListReorders method of
> ShoppingListServices.java. It is hung before the control reaches the
> implementation of "sendOrderPayRetryNotification" service. There is no
> error message since it looks like the system is waiting for something.
>
> Thanks
>
> -----Original Message-----
> From: Amine AZZI [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 07, 2007 3:58 PM
> To: user@ofbiz.apache.org; [EMAIL PROTECTED]
> Subject: Re: ms sql server 2005 shoppinglist problem
>
> 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
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>
>
>
