ms sql server 2005 /ofBiz : shoppinglist issue

[Dave Tenerowicz]

We are still having issues with ofBiz and SQL Server 2005. Basically the
issue is that the automatic shopping list service does not run after we
change the db from Derby to SQL Server.
If we force the "runShoppingListAutoReorder" process to run, it seems to
hang. The process will run forever, as if waiting for input. Although we
can resolve the issue temporarily  by commenting some sections of
createListReorders in shoppingListServices.java, this is not a real
solution.

Does anyone have any experience using SQL Server with ofBiz, or have any
idea what could be going on here?

Thanks!

Dave Tenerowicz

2007/8/8, William Perng <[hidden email]>:

>
> 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:[hidden email]]
> Sent: Tuesday, August 07, 2007 3:58 PM
> To: [hidden email]; [hidden email]
> 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 <[hidden email]>:
> >
> > 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:[hidden email]]
> > Sent: Tuesday, August 07, 2007 11:39 AM
> > To: [hidden email]
> > Subject: RE: ms sql server 2005 shoppinglist problem
> >
> > The type of that column is text now.  Thanks
> >
> > -----Original Message-----
> > From: Amine AZZI [mailto:[hidden email]]
> > Sent: Tuesday, August 07, 2007 11:10 AM
> > To: [hidden email]; [hidden email]
> > 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 <[hidden email]>:
> > >
> > > 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
> > > [hidden email]
> > > [phone] Ext; 223
> > > Yahoo IM: william.perng
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>
>
>

--
Dave Tenerowicz
[hidden email]

Office: 303.493.6727
Mobile [phone]
Fax [phone]

Visit us at http://www.salmonllc.com

[Vince Clark]

Have you tried different jdbc drivers?

Dave Tenerowicz wrote:

> We are still having issues with ofBiz and SQL Server 2005. Basically
> the issue is that the automatic shopping list service does not run
> after we change the db from Derby to SQL Server.
> If we force the "runShoppingListAutoReorder" process to run, it seems
> to hang. The process will run forever, as if waiting for input.
> Although we can resolve the issue temporarily  by commenting some
> sections of createListReorders in shoppingListServices.java, this is
> not a real solution.
>
> Does anyone have any experience using SQL Server with ofBiz, or have
> any idea what could be going on here?
>
> Thanks!
>
> Dave Tenerowicz
>
> 2007/8/8, William Perng <[hidden email]>:
>>
>> 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:[hidden email]]
>> Sent: Tuesday, August 07, 2007 3:58 PM
>> To: [hidden email]; [hidden email]
>> 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 <[hidden email]>:
>> >
>> > 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:[hidden email]]
>> > Sent: Tuesday, August 07, 2007 11:39 AM
>> > To: [hidden email]
>> > Subject: RE: ms sql server 2005 shoppinglist problem
>> >
>> > The type of that column is text now.  Thanks
>> >
>> > -----Original Message-----
>> > From: Amine AZZI [mailto:[hidden email]]
>> > Sent: Tuesday, August 07, 2007 11:10 AM
>> > To: [hidden email]; [hidden email]
>> > 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 <[hidden email]>:
>> > >
>> > > 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
>> > > [hidden email]
>> > > [phone] Ext; 223
>> > > Yahoo IM: william.perng
>> > >
>> > >
>> > >
>> > >
>> > >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>
>
>
>
>
>

[Dave Tenerowicz]

We've used two - the Microsoft driver and JTDS. The Microsoft driver
created even more problems. David Jones had recommended JTDS, so we have
settled on that.


Vince Clark wrote:

> Have you tried different jdbc drivers?
>
> Dave Tenerowicz wrote:
>> We are still having issues with ofBiz and SQL Server 2005. Basically
>> the issue is that the automatic shopping list service does not run
>> after we change the db from Derby to SQL Server.
>> If we force the "runShoppingListAutoReorder" process to run, it seems
>> to hang. The process will run forever, as if waiting for input.
>> Although we can resolve the issue temporarily  by commenting some
>> sections of createListReorders in shoppingListServices.java, this is
>> not a real solution.
>>
>> Does anyone have any experience using SQL Server with ofBiz, or have
>> any idea what could be going on here?
>>
>> Thanks!
>>
>> Dave Tenerowicz
>>
>> 2007/8/8, William Perng <[hidden email]>:
>>>
>>> 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:[hidden email]]
>>> Sent: Tuesday, August 07, 2007 3:58 PM
>>> To: [hidden email]; [hidden email]
>>> 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 <[hidden email]>:
>>> >
>>> > 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:[hidden email]]
>>> > Sent: Tuesday, August 07, 2007 11:39 AM
>>> > To: [hidden email]
>>> > Subject: RE: ms sql server 2005 shoppinglist problem
>>> >
>>> > The type of that column is text now.  Thanks
>>> >
>>> > -----Original Message-----
>>> > From: Amine AZZI [mailto:[hidden email]]
>>> > Sent: Tuesday, August 07, 2007 11:10 AM
>>> > To: [hidden email]; [hidden email]
>>> > 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 <[hidden email]>:
>>> > >
>>> > > 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
>>> > > [hidden email]
>>> > > [phone] Ext; 223
>>> > > Yahoo IM: william.perng
>>> > >
>>> > >
>>> > >
>>> > >
>>> > >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>
>

--
Dave Tenerowicz
[hidden email]

Office: 303.493.6727
Mobile [phone]
Fax [phone]

Visit us at http://www.salmonllc.com

[BJ Freeman]

the best way I debugged SQL sever was to use the SQL tools provide with
the server and see what ofbiz is sending and what the server is
responding with.


Dave Tenerowicz sent the following on 8/21/2007 10:01 AM:

> We are still having issues with ofBiz and SQL Server 2005. Basically the
> issue is that the automatic shopping list service does not run after we
> change the db from Derby to SQL Server.
> If we force the "runShoppingListAutoReorder" process to run, it seems to
> hang. The process will run forever, as if waiting for input. Although we
> can resolve the issue temporarily  by commenting some sections of
> createListReorders in shoppingListServices.java, this is not a real
> solution.
>
> Does anyone have any experience using SQL Server with ofBiz, or have any
> idea what could be going on here?
>
> Thanks!
>
> Dave Tenerowicz
>
> 2007/8/8, William Perng <[hidden email]>:
>>
>> 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:[hidden email]]
>> Sent: Tuesday, August 07, 2007 3:58 PM
>> To: [hidden email]; [hidden email]
>> 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 <[hidden email]>:
>> >
>> > 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:[hidden email]]
>> > Sent: Tuesday, August 07, 2007 11:39 AM
>> > To: [hidden email]
>> > Subject: RE: ms sql server 2005 shoppinglist problem
>> >
>> > The type of that column is text now.  Thanks
>> >
>> > -----Original Message-----
>> > From: Amine AZZI [mailto:[hidden email]]
>> > Sent: Tuesday, August 07, 2007 11:10 AM
>> > To: [hidden email]; [hidden email]
>> > 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 <[hidden email]>:
>> > >
>> > > 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
>> > > [hidden email]
>> > > [phone] Ext; 223
>> > > Yahoo IM: william.perng
>> > >
>> > >
>> > >
>> > >
>> > >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>
>
>
>
>
>