ms sql server 2005 shoppinglist problem

[wperng]

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
 
 
 
 

[Amine AZZI]

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
>
>
>
>
>

[wperng]

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
>
>
>
>
>

[wperng]

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
>
>
>
>
>

[Amine AZZI]

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
> >
> >
> >
> >
> >
>
>
>
>
>
>

[wperng]

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
> >
> >
> >
> >
> >
>
>
>
>
>
>

[Amine AZZI]

Sorry, that my suggestion wasn't the right one, and happy that it works for
you.

Amine.

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
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>
>
>

[wperng]

Hi, Amine :

I appreciate your help. I learn how to test it from your reply.  But I still
need to figure out why this is not working, since I cannot just comment it
out.

Thanks

William

-----Original Message-----
From: Amine AZZI [mailto:[hidden email]]
Sent: Wednesday, August 08, 2007 11:42 AM
To: [hidden email]; [hidden email]
Subject: Re: ms sql server 2005 shoppinglist problem

Sorry, that my suggestion wasn't the right one, and happy that it works for
you.

Amine.

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
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
> >
>
>
>

[wperng]

I put the partyId in session attribute, however, I am not able to use the
following code to retrieve it in screen widget.   <set field="partyId"
from-field="sessionAttributes.partyId"/>  It works fine, if I put my partyId
in url and use parameters.partyId to read it.  Could anyone please help ?

Thanks

William Perng
[hidden email]  

[Adrian Crum]

Why not just put the partyId in the parameters Map?

William Perng wrote:

> I put the partyId in session attribute, however, I am not able to use the
> following code to retrieve it in screen widget.   <set field="partyId"
> from-field="sessionAttributes.partyId"/>  It works fine, if I put my partyId
> in url and use parameters.partyId to read it.  Could anyone please help ?
>
> Thanks
>
> William Perng
> [hidden email]  
>
>
>
>

[wperng]

I am not sure I understand ofbiz correctly.  Please correct me, if I am
wrong.  I thought if I want to put the partyId in parameters Map, it has to
be in the url.  The ofbiz will automatically populate those parameters in
url to parameters map.  In our customized application, we need keep the
partyId in session, since our page content will change base one this partyId
in session attribute.


-----Original Message-----
From: Adrian Crum [mailto:[hidden email]]
Sent: Wednesday, August 08, 2007 4:30 PM
To: [hidden email]
Subject: Re: sessionAttributes in screen widget

Why not just put the partyId in the parameters Map?

William Perng wrote:

> I put the partyId in session attribute, however, I am not able to use the
> following code to retrieve it in screen widget.   <set field="partyId"
> from-field="sessionAttributes.partyId"/>  It works fine, if I put my
> partyId in url and use parameters.partyId to read it.  Could anyone please
help ?
>
> Thanks
>
> William Perng
> [hidden email]
>
>
>
>

[David E Jones]

Not sure where you got that idea... If anyone said it on the mailing lists they were wrong.

Check out the UtilHttp.getCombinedMap(HttpServletRequest request, Set namesToSkip) method.

-David


William Perng wrote:

> I am not sure I understand ofbiz correctly.  Please correct me, if I am
> wrong.  I thought if I want to put the partyId in parameters Map, it has to
> be in the url.  The ofbiz will automatically populate those parameters in
> url to parameters map.  In our customized application, we need keep the
> partyId in session, since our page content will change base one this partyId
> in session attribute.
>
>
> -----Original Message-----
> From: Adrian Crum [mailto:[hidden email]]
> Sent: Wednesday, August 08, 2007 4:30 PM
> To: [hidden email]
> Subject: Re: sessionAttributes in screen widget
>
> Why not just put the partyId in the parameters Map?
>
> William Perng wrote:
>
>> I put the partyId in session attribute, however, I am not able to use the
>> following code to retrieve it in screen widget.   <set field="partyId"
>> from-field="sessionAttributes.partyId"/>  It works fine, if I put my
>> partyId in url and use parameters.partyId to read it.  Could anyone please
> help ?
>> Thanks
>>
>> William Perng
>> [hidden email]
>>
>>
>>
>>
>
>
>

[David E Jones]

Oh, BTW, sessionAttributes.partyId should get that attribute out if it exists.

You can also try doing a label with ${sessionAttributes} in the widgets or in your FTL file to see what is in the session.

-David


David E Jones wrote:

>
> Not sure where you got that idea... If anyone said it on the mailing
> lists they were wrong.
>
> Check out the UtilHttp.getCombinedMap(HttpServletRequest request, Set
> namesToSkip) method.
>
> -David
>
>
> William Perng wrote:
>> I am not sure I understand ofbiz correctly.  Please correct me, if I am
>> wrong.  I thought if I want to put the partyId in parameters Map, it
>> has to
>> be in the url.  The ofbiz will automatically populate those parameters in
>> url to parameters map.  In our customized application, we need keep the
>> partyId in session, since our page content will change base one this
>> partyId
>> in session attribute.
>>
>>
>> -----Original Message-----
>> From: Adrian Crum [mailto:[hidden email]] Sent: Wednesday, August
>> 08, 2007 4:30 PM
>> To: [hidden email]
>> Subject: Re: sessionAttributes in screen widget
>>
>> Why not just put the partyId in the parameters Map?
>>
>> William Perng wrote:
>>
>>> I put the partyId in session attribute, however, I am not able to use
>>> the
>>> following code to retrieve it in screen widget.   <set field="partyId"
>>> from-field="sessionAttributes.partyId"/>  It works fine, if I put my
>>> partyId in url and use parameters.partyId to read it.  Could anyone
>>> please
>> help ?
>>> Thanks
>>>
>>> William Perng
>>> [hidden email]
>>>
>>>
>>>
>>>
>>
>>
>>

[Adrian Crum]

The parameters Map does contain the url parameters - as well as context parameters set in the
web.xml file and parameters set in scripts and <actions> elements in screen widgets.

So...

In web.xml:

<context-param>
   <param-name>myParameter</param-name>
   <param-value>Hello World</param-value>
</context-param>

In bsh script:

parameters.put("myParameter", "Hello World");

In screen widget:

<actions>
   <set field="parameters.myParameter" value="Hello World"/>
</actions>


William Perng wrote:

> I am not sure I understand ofbiz correctly.  Please correct me, if I am
> wrong.  I thought if I want to put the partyId in parameters Map, it has to
> be in the url.  The ofbiz will automatically populate those parameters in
> url to parameters map.  In our customized application, we need keep the
> partyId in session, since our page content will change base one this partyId
> in session attribute.
>
>
> -----Original Message-----
> From: Adrian Crum [mailto:[hidden email]]
> Sent: Wednesday, August 08, 2007 4:30 PM
> To: [hidden email]
> Subject: Re: sessionAttributes in screen widget
>
> Why not just put the partyId in the parameters Map?
>
> William Perng wrote:
>
>
>>I put the partyId in session attribute, however, I am not able to use the
>>following code to retrieve it in screen widget.   <set field="partyId"
>>from-field="sessionAttributes.partyId"/>  It works fine, if I put my
>>partyId in url and use parameters.partyId to read it.  Could anyone please
>
> help ?
>
>>Thanks
>>
>>William Perng
>>[hidden email]
>>
>>
>>
>>
>
>
>
>
>

[wperng]

Thanks to David and Amine.  It works.  I should use  <set field="partyId"
from-field="parameters.partyId"/>.  

William

-----Original Message-----
From: David E Jones [mailto:[hidden email]]
Sent: Wednesday, August 08, 2007 5:08 PM
To: [hidden email]
Subject: Re: sessionAttributes in screen widget


Oh, BTW, sessionAttributes.partyId should get that attribute out if it
exists.

You can also try doing a label with ${sessionAttributes} in the widgets or
in your FTL file to see what is in the session.

-David


David E Jones wrote:

>
> Not sure where you got that idea... If anyone said it on the mailing
> lists they were wrong.
>
> Check out the UtilHttp.getCombinedMap(HttpServletRequest request, Set
> namesToSkip) method.
>
> -David
>
>
> William Perng wrote:
>> I am not sure I understand ofbiz correctly.  Please correct me, if I
>> am wrong.  I thought if I want to put the partyId in parameters Map,
>> it has to be in the url.  The ofbiz will automatically populate those
>> parameters in url to parameters map.  In our customized application,
>> we need keep the partyId in session, since our page content will
>> change base one this partyId in session attribute.
>>
>>
>> -----Original Message-----
>> From: Adrian Crum [mailto:[hidden email]] Sent: Wednesday, August
>> 08, 2007 4:30 PM
>> To: [hidden email]
>> Subject: Re: sessionAttributes in screen widget
>>
>> Why not just put the partyId in the parameters Map?
>>
>> William Perng wrote:
>>
>>> I put the partyId in session attribute, however, I am not able to use
>>> the
>>> following code to retrieve it in screen widget.   <set field="partyId"
>>> from-field="sessionAttributes.partyId"/>  It works fine, if I put my
>>> partyId in url and use parameters.partyId to read it.  Could anyone
>>> please
>> help ?
>>> Thanks
>>>
>>> William Perng
>>> [hidden email]
>>>
>>>
>>>
>>>
>>
>>
>>