Re: Where did this go?

2009-09-04 Thread Anne Jessel
Was looking at some of the code for header logo settings in trunk a
couple of days ago. Yes, the one defined in the theme is now used
instead, and there's a comment somewhere in the code that the logo
field for the product store is no longer used. I presume the same
applies to the style sheet, but haven't checked.

The code I looked at did appear to have some other mechanism for
overriding the logo defined by the theme. Didn't follow this up, but
it looked like it was associated with the company settings?

Cheers,
Anne.

2009/9/5 Ruth Hoffman :
> Hi Jacques:
> Thanks. Anyone else care to comment?
> TIA
> Ruth
> Jacques Le Roux wrote:
>>
>> I think it's now related to Visual Themes, but just a guess
>>
>> Jacques
>>
>> From: "Ruth Hoffman" 
>>>
>>> Hello List:
>>> Got a quick question:
>>> In 4.x releases dating back to 765601, there is a place in the Catalog
>>> Manager under store configuration where the user may enter in a style sheet
>>> and header logo for a store. By default these are set to
>>> /images/ecommain.css and /images/ofbiz_logo.jpg respectively.
>>>
>>> In the latest trunk release and 9.x releases, where did these fields go?
>>> How does one change these fields on an existing store (or a new store for
>>> that matter) using the Catalog Manager?
>>>
>>> TIA
>>> Ruth
>>>
>>
>>
>



-- 
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Phone: (03) 9585 6788
Fax: (03) 9585 1086
Web: http://www.cohsoft.com.au/
Email: sa...@cohsoft.com.au

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/


Re: "ant run-install" and mysql problems

2009-09-04 Thread Anne Jessel
A guess, which might be totally wrong, is that you've changed the
entityengine.xml file so it is inconsistent, and now ofbiz can't find
the right fieldtype file to use. I'd suggest reviewing your edits of
that file.

Cheers,
Anne.

2009/9/4 Lucio Crusca :
> I've tried "ant run-install" again with the same results, so I guess that's
> not a race condition. Then I ran ant again and logged the output to a file,
> here are the first exceptions I get:
>
> [java] 2009-09-04 08:16:23,864 (main) [   EntityDataLoader.java:130:WARN ]
> Could not get URL for Component ResourceHandler:
> org.ofbiz.base.component.ComponentException: File Resource not found:
> /opt/ofbiz-svn/ofbiz.9.04/themes/bizznesstime/data/BizznessTimeThemeData.xml
>
> [java] 2009-09-04 08:16:32,671 (main) [    EntitySaxReader.java:563:WARN ]
>     [java]  runtime exception report
> --
>     [java] Could not set field CurrencyDimension.dimensionId to the value _NF_
>     [java] Exception: java.lang.IllegalArgumentException
>     [java] Message: Type id-ne not found
>     [java]  stack trace
> ---
>     [java] java.lang.IllegalArgumentException: Type id-ne not found
>     [java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:461)
>     [java]
> org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:557)
>     [java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
> ...
>
>    [java] 2009-09-04 08:16:32,764 (main) [    TransactionUtil.java:285:ERROR]
>     [java]  exception report
> --
>     [java] [TransactionUtil.rollback]
>     [java] Exception: java.lang.Exception
>     [java] Message: Stack Trace
>     [java]  stack trace
> ---
>     [java] java.lang.Exception: Stack Trace
>     [java]
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:284)
>     [java]
> org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:266)
>     [java]
> org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:270)
> ...
>
>    [java] 2009-09-04 08:16:32,768 (main) [    TransactionUtil.java:295:INFO ]
> [TransactionUtil.rollback] transaction rolled back
>     [java] 2009-09-04 08:16:32,771 (main) [
> EntityDataLoader.java:220:ERROR]
>     [java]  exception report
> --
>     [java] [install.loadData]: Error loading XML Resource "file:/opt/ofbiz-
> svn/ofbiz.9.04/framework/common/data/DimensionTypeData.xml"; Error was: A
> transaction error occurred reading data
>     [java] Exception: org.xml.sax.SAXException
>     [java] Message: A transaction error occurred reading data
> ...
>
>
> and then a few other similar exceptions, all with message "Type id-ne not
> found".
>
> Any clue?
> --
> Virtual Bit di Lucio Crusca
> http://www.virtual-bit.com
>



-- 
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Phone: (03) 9585 6788
Fax: (03) 9585 1086
Web: http://www.cohsoft.com.au/
Email: sa...@cohsoft.com.au

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/


Adding a routing element in the order process

2009-09-04 Thread Torstein Hegbom
I have a question relating to the sales-order.

 

If I where to add a routing-task after picking and before packing and
shipment, called "Testing and quality control", how would I go about doing
that. The work-effort would need fixed assets and a party to perform the
activity.

 

Thanks.

 

Best regards

Torstein Hegbom

http://www.netbusiness.no



Re: Purchasing services to process components, and receiving processed components

2009-09-04 Thread Scott Gray

I'm sorry I never did get time to work on it.

Regards
Scott

On 5/09/2009, at 3:27 PM, Zhiyong Cui wrote:



Hi Scott
Did you have finish it , now I need do the same work , could you  
give me

some advices ?


Scott Gray wrote:


Hi Jonathan

I haven't looked into this very deeply but was pondering it a while  
back.


I had thought about creating a new order type along the lines of
"GOODS_WORK_ORDER" and then using a combination of the sales order  
code
(picking, packing and shipping the raw materials) and the purchase  
order

code (purchasing the service and receipting the serviced products).

I'm afraid I can't help get this done right now, but I could help  
with

reviewing any work you decide to submit back to OFBiz.

Regards
Scott

Jonathon -- Improov wrote:

Anil,


For associating a Order with WorkEffort, there is Orders tab in

WorkEffort
and we can associate a Order to WorkEffort there, It does not let  
us

specify

OrderItem, But that will be a simple change.


Yes, we can make the association there. But such an association
doesn't seem to serve any purpose in OFBiz!

Expert Guidence is needed for use of WorkOrderItemFulfillment for  
this

purpose. Because now we have a OrderItem created for doing Task

specified in
WorkEffort. where as this entity was designed to do just  
opposite. I

think it

should be ok.


You're right. It'll seem wrong to continue using that entity. The
mapping was meant to be in the other direction.

However, I also agree with you that there shouldn't be any harm in
using that entity. That is just a relationship table, not an actual
entity. The fact that the relationship between OrderItem and
WorkEffort is put in a separate table like that means we can
technically have a bidirectional relationship between OrderItem and
WorkEffort.

It looks like I can even tie > 1 routing tasks to a single OrderItem
in a PO. I may want my bicycle frame to be polished, painted, and
decal-ed, and I could make all 3 services a single Product (like
product Id "DOLL_UP_BICYCLE_FRAME").


Beyond this point for tracking Outgoing shipment of parts and then

receiving

them back into stock and production run, I cannot help much here.


Ok.

Yeah, there's still some work/planning needed for deciding how a
"Service" product in a PO can be received as a "Subassembly" or
"Finished Good" product. OFBiz doesn't seem to do this at the  
moment.



I did this workEffort deep copy thing for Fixed Asset Maintenance

project

that I am doing. I am not using Manufacturing component but may be

in future

someday.


Then I'll look at your deep copy function and see if I can extend or
reuse it for what I need here in Manufacturing.

Thanks!

Jonathon

Anil Patel wrote:

Jonathon,
I understand what you are saying. All database entities seems to  
be in

place. We can tie WorkEffort to OrderItem.

For associating a Order with WorkEffort, there is Orders tab in
WorkEffort
and we can associate a Order to WorkEffort there, It does not let  
us

specify
OrderItem, But that will be a simple change.

Expert Guidence is needed  for use of WorkOrderItemFulfillment  
for this

purpose. Because now we have a OrderItem created for doing Task
specified in
WorkEffort. where as this entity was designed to do just  
opposite. I

think
it should be ok.

Beyond this point for tracking Outgoing shipment of parts and then
receiving
them back into stock and production run, I cannot help much here.

I did this workEffort deep copy thing for Fixed Asset Maintenance
project
that I am doing. I am not using Manufacturing component but may  
be in

future
someday.

Regards
Anil Patel



On 1/19/07, Jonathon -- Improov  wrote:


Anil,

I realize that this is user mailing list, What I am suggesting  
will

take little bit of development work.


It's alright. I believe the dev list is for actual development
discussions, like a "do we code it
in a switch-case or a cascading if-else" issue. We're still  
discussing

whether we (as users) need
this function.


The tasks in Production run are nothing but WorkEffort.


Yes. And to confirm and align our understanding...

WorkEffort of type PROD_ORDER_HEADER are production runs.

WorkEffort of type PROD_ORDER_TASK are routing tasks inside  
production

runs (not defined/template
routing tasks).

(Above description won't be enough to implement your deep copy,  
but

please
bear with me for this
thread.)

I would like to connect a routing task to a PO when the routing  
task

calls
for a sub-contracted
service, like painting. Naturally, I'll usually need to ship some
parts to
my painting vendor for
processing, so an outgoing shipment will be tied to this PO.
Further, an
incoming shipment when
received should automatically put the processed parts back into  
the

production run (via "Issue
Components"?).


WorkEffort has association with Order entity.


Hmm. I didn't realize OFBiz applications actually do this  
association.

Does it? Example?

I'd prefer to have WorkEffort (production run) ti

Re: Purchasing services to process components, and receiving processed components

2009-09-04 Thread Zhiyong Cui

Hi Scott
Did you have finish it , now I need do the same work , could you give me
some advices ?


Scott Gray wrote:
> 
> Hi Jonathan
> 
> I haven't looked into this very deeply but was pondering it a while back. 
> 
> I had thought about creating a new order type along the lines of 
> "GOODS_WORK_ORDER" and then using a combination of the sales order code 
> (picking, packing and shipping the raw materials) and the purchase order 
> code (purchasing the service and receipting the serviced products). 
> 
> I'm afraid I can't help get this done right now, but I could help with 
> reviewing any work you decide to submit back to OFBiz.
> 
> Regards
> Scott
> 
> Jonathon -- Improov wrote:
>> Anil,
>>
>> > For associating a Order with WorkEffort, there is Orders tab in 
>> WorkEffort
>> > and we can associate a Order to WorkEffort there, It does not let us 
>> specify
>> > OrderItem, But that will be a simple change.
>>
>> Yes, we can make the association there. But such an association 
>> doesn't seem to serve any purpose in OFBiz!
>>
>> > Expert Guidence is needed for use of WorkOrderItemFulfillment for this
>> > purpose. Because now we have a OrderItem created for doing Task 
>> specified in
>> > WorkEffort. where as this entity was designed to do just opposite. I 
>> think it
>> > should be ok.
>>
>> You're right. It'll seem wrong to continue using that entity. The 
>> mapping was meant to be in the other direction.
>>
>> However, I also agree with you that there shouldn't be any harm in 
>> using that entity. That is just a relationship table, not an actual 
>> entity. The fact that the relationship between OrderItem and 
>> WorkEffort is put in a separate table like that means we can 
>> technically have a bidirectional relationship between OrderItem and 
>> WorkEffort.
>>
>> It looks like I can even tie > 1 routing tasks to a single OrderItem 
>> in a PO. I may want my bicycle frame to be polished, painted, and 
>> decal-ed, and I could make all 3 services a single Product (like 
>> product Id "DOLL_UP_BICYCLE_FRAME").
>>
>> > Beyond this point for tracking Outgoing shipment of parts and then 
>> receiving
>> > them back into stock and production run, I cannot help much here.
>>
>> Ok.
>>
>> Yeah, there's still some work/planning needed for deciding how a 
>> "Service" product in a PO can be received as a "Subassembly" or 
>> "Finished Good" product. OFBiz doesn't seem to do this at the moment.
>>
>> > I did this workEffort deep copy thing for Fixed Asset Maintenance 
>> project
>> > that I am doing. I am not using Manufacturing component but may be 
>> in future
>> > someday.
>>
>> Then I'll look at your deep copy function and see if I can extend or 
>> reuse it for what I need here in Manufacturing.
>>
>> Thanks!
>>
>> Jonathon
>>
>> Anil Patel wrote:
>>> Jonathon,
>>> I understand what you are saying. All database entities seems to be in
>>> place. We can tie WorkEffort to OrderItem.
>>>
>>> For associating a Order with WorkEffort, there is Orders tab in 
>>> WorkEffort
>>> and we can associate a Order to WorkEffort there, It does not let us 
>>> specify
>>> OrderItem, But that will be a simple change.
>>>
>>> Expert Guidence is needed  for use of WorkOrderItemFulfillment for this
>>> purpose. Because now we have a OrderItem created for doing Task 
>>> specified in
>>> WorkEffort. where as this entity was designed to do just opposite. I 
>>> think
>>> it should be ok.
>>>
>>> Beyond this point for tracking Outgoing shipment of parts and then 
>>> receiving
>>> them back into stock and production run, I cannot help much here.
>>>
>>> I did this workEffort deep copy thing for Fixed Asset Maintenance 
>>> project
>>> that I am doing. I am not using Manufacturing component but may be in 
>>> future
>>> someday.
>>>
>>> Regards
>>> Anil Patel
>>>
>>>
>>>
>>> On 1/19/07, Jonathon -- Improov  wrote:

 Anil,

 > I realize that this is user mailing list, What I am suggesting will
 > take little bit of development work.

 It's alright. I believe the dev list is for actual development
 discussions, like a "do we code it
 in a switch-case or a cascading if-else" issue. We're still discussing
 whether we (as users) need
 this function.

 > The tasks in Production run are nothing but WorkEffort.

 Yes. And to confirm and align our understanding...

 WorkEffort of type PROD_ORDER_HEADER are production runs.

 WorkEffort of type PROD_ORDER_TASK are routing tasks inside production
 runs (not defined/template
 routing tasks).

 (Above description won't be enough to implement your deep copy, but 
 please
 bear with me for this
 thread.)

 I would like to connect a routing task to a PO when the routing task 
 calls
 for a sub-contracted
 service, like painting. Naturally, I'll usually need to ship some 
 parts to
 my painting vendor for
 processing, so an outgoing shipment will be tied 

Re: Visual Themes

2009-09-04 Thread Scott Gray
Ah okay sorry, the general.properties setting only applies if the  
UserPreference record from CommonTypeData.xml that you mentioned is  
missing.


Also the wiki looks wrong to me, it should be partyId="_NA_" and not  
partyId="NA"


Once you've changed the CommonTypeData.xml file you'll need to run ant  
run-install-seed


ant run-install should only be used when you have an empty database  
since it also loads seed-initial data which should only be loaded once  
per install.


Regards
Scott

On 5/09/2009, at 1:58 PM, Ruth Hoffman wrote:


Sure:
http://docs.ofbiz.org/display/OFBIZ/Visual+Themes+-+How+to?focusedCommentId=9091#comment-9091
BTW, I just tried changing the theme in the general properties as  
you suggested in trunk version: 806815  and nothing changed. What  
else do I need to do?


Thanks
Ruth
Scott Gray wrote:

I'm not familiar with the document, could you send me the link?

Thanks
Scott

On 5/09/2009, at 1:47 PM, Ruth Hoffman wrote:


Hi Scott:
Thanks. So does that mean that what the Wiki says about  
CommonTypeData.xml is irrelevant?

TIA
Ruth

Scott Gray wrote:

Hi Ruth

The default visual theme id can set in general.properties, in  
this case to FLAT_GREY.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 5/09/2009, at 12:56 PM, Ruth Hoffman wrote:


Hi All:
Its not clear from the Wiki how this works:
To change a theme from the default "BLUELIGHT" on the version I  
downloaded to "FLATGREY".  Do I need to run the ant run-install  
as well as change CommonTypeData.xml? And how about restarting?  
I'm assuming that I also need to restart. Is that true?


Any advice would be appreciated.
Thanks
Ruth








smime.p7s
Description: S/MIME cryptographic signature


Re: Visual Themes

2009-09-04 Thread Ruth Hoffman

Sure:
http://docs.ofbiz.org/display/OFBIZ/Visual+Themes+-+How+to?focusedCommentId=9091#comment-9091
BTW, I just tried changing the theme in the general properties as you 
suggested in trunk version: 806815  and nothing changed. What else do I 
need to do?


Thanks
Ruth
Scott Gray wrote:

I'm not familiar with the document, could you send me the link?

Thanks
Scott

On 5/09/2009, at 1:47 PM, Ruth Hoffman wrote:


Hi Scott:
Thanks. So does that mean that what the Wiki says about 
CommonTypeData.xml is irrelevant?

TIA
Ruth

Scott Gray wrote:

Hi Ruth

The default visual theme id can set in general.properties, in this 
case to FLAT_GREY.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 5/09/2009, at 12:56 PM, Ruth Hoffman wrote:


Hi All:
Its not clear from the Wiki how this works:
To change a theme from the default "BLUELIGHT" on the version I 
downloaded to "FLATGREY".  Do I need to run the ant run-install as 
well as change CommonTypeData.xml? And how about restarting? I'm 
assuming that I also need to restart. Is that true?


Any advice would be appreciated.
Thanks
Ruth






Re: Visual Themes

2009-09-04 Thread Scott Gray

I'm not familiar with the document, could you send me the link?

Thanks
Scott

On 5/09/2009, at 1:47 PM, Ruth Hoffman wrote:


Hi Scott:
Thanks. So does that mean that what the Wiki says about  
CommonTypeData.xml is irrelevant?

TIA
Ruth

Scott Gray wrote:

Hi Ruth

The default visual theme id can set in general.properties, in this  
case to FLAT_GREY.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 5/09/2009, at 12:56 PM, Ruth Hoffman wrote:


Hi All:
Its not clear from the Wiki how this works:
To change a theme from the default "BLUELIGHT" on the version I  
downloaded to "FLATGREY".  Do I need to run the ant run-install as  
well as change CommonTypeData.xml? And how about restarting? I'm  
assuming that I also need to restart. Is that true?


Any advice would be appreciated.
Thanks
Ruth






smime.p7s
Description: S/MIME cryptographic signature


Re: Visual Themes

2009-09-04 Thread Ruth Hoffman

Hi Scott:
Thanks. So does that mean that what the Wiki says about 
CommonTypeData.xml is irrelevant?

TIA
Ruth

Scott Gray wrote:

Hi Ruth

The default visual theme id can set in general.properties, in this 
case to FLAT_GREY.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 5/09/2009, at 12:56 PM, Ruth Hoffman wrote:


Hi All:
Its not clear from the Wiki how this works:
To change a theme from the default "BLUELIGHT" on the version I 
downloaded to "FLATGREY".  Do I need to run the ant run-install as 
well as change CommonTypeData.xml? And how about restarting? I'm 
assuming that I also need to restart. Is that true?


Any advice would be appreciated.
Thanks
Ruth




Re: Visual Themes

2009-09-04 Thread Scott Gray

Hi Ruth

The default visual theme id can set in general.properties, in this  
case to FLAT_GREY.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 5/09/2009, at 12:56 PM, Ruth Hoffman wrote:


Hi All:
Its not clear from the Wiki how this works:
To change a theme from the default "BLUELIGHT" on the version I  
downloaded to "FLATGREY".  Do I need to run the ant run-install as  
well as change CommonTypeData.xml? And how about restarting? I'm  
assuming that I also need to restart. Is that true?


Any advice would be appreciated.
Thanks
Ruth




smime.p7s
Description: S/MIME cryptographic signature


Visual Themes

2009-09-04 Thread Ruth Hoffman

Hi All:
Its not clear from the Wiki how this works:
To change a theme from the default "BLUELIGHT" on the version I 
downloaded to "FLATGREY".  Do I need to run the ant run-install as well 
as change CommonTypeData.xml? And how about restarting? I'm assuming 
that I also need to restart. Is that true?


Any advice would be appreciated.
Thanks
Ruth


Re: Mysterious warnings when running ant run-install on iSeries / DB2

2009-09-04 Thread Scott Gray

It is preferable but not mandatory.

Regards
Scott

On 5/09/2009, at 9:48 AM, André Herbst wrote:


Thanks Scott,

Yes you were right about that. I have defined the following in the
entityengine.xml file:


   
   name="localdb2i"/>

   

Is it preferrable not to use the main database for olap?

-André

On Friday den 4. September 2009 18:30:19 Scott Gray wrote:

My guess is that you are using your main database for olap as well so
the second delegator is just complaining about all the extra tables
it's seeing but no harm is caused.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 5/09/2009, at 4:21 AM, André Herbst wrote:

Hi,

When I am running ant run-install, I get a lot of warings like the
following:

  [java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:
368:WARN ]
Table named [OFBIZ.ACCOMMODATION_CLASS] exists in the
database but has no corresponding entity
  [java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:
368:WARN ]
Table named [OFBIZ.ACCOMMODATION_MAP] exists in the
database but has no corresponding entity
  [java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:
368:WARN ]
Table named [OFBIZ.ACCOMMODATION_MAP_TYPE] exists in
the database but has no corresponding entity
  [java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java:
368:WARN ]
Table named [OFBIZ.ACCOMMODATION_SPOT] exists in the
daatabase but has no corresponding entity
  [java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java:
368:WARN ]
Table named [OFBIZ.ACCTG_TRANS] exists in the database
but has no corresponding entity
  [java] 2009-09-04 12:53:00,046 (main) [   DatabaseUtil.java:
368:WARN ]
Table named [OFBIZ.ACCTG_TRANS_ATTRIBUTE] exists in
the database but has no corresponding entity

Can anybody please help me to explain what these warnings mean?

-André







smime.p7s
Description: S/MIME cryptographic signature


Re: Mysterious warnings when running ant run-install on iSeries / DB2

2009-09-04 Thread André Herbst
Thanks Scott, 

Yes you were right about that. I have defined the following in the 
entityengine.xml file:

 




Is it preferrable not to use the main database for olap?

-André

On Friday den 4. September 2009 18:30:19 Scott Gray wrote:
> My guess is that you are using your main database for olap as well so
> the second delegator is just complaining about all the extra tables
> it's seeing but no harm is caused.
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 5/09/2009, at 4:21 AM, André Herbst wrote:
> > Hi,
> >
> > When I am running ant run-install, I get a lot of warings like the
> > following:
> >
> >[java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:
> > 368:WARN ]
> > Table named [OFBIZ.ACCOMMODATION_CLASS] exists in the
> > database but has no corresponding entity
> >[java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:
> > 368:WARN ]
> > Table named [OFBIZ.ACCOMMODATION_MAP] exists in the
> > database but has no corresponding entity
> >[java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:
> > 368:WARN ]
> > Table named [OFBIZ.ACCOMMODATION_MAP_TYPE] exists in
> > the database but has no corresponding entity
> >[java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java:
> > 368:WARN ]
> > Table named [OFBIZ.ACCOMMODATION_SPOT] exists in the
> > daatabase but has no corresponding entity
> >[java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java:
> > 368:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS] exists in the database
> >  but has no corresponding entity
> >[java] 2009-09-04 12:53:00,046 (main) [   DatabaseUtil.java:
> > 368:WARN ]
> > Table named [OFBIZ.ACCTG_TRANS_ATTRIBUTE] exists in
> > the database but has no corresponding entity
> >
> > Can anybody please help me to explain what these warnings mean?
> >
> > -André




Re: Where did this go?

2009-09-04 Thread Ruth Hoffman

Hi Jacques:
Thanks. Anyone else care to comment?
TIA
Ruth
Jacques Le Roux wrote:

I think it's now related to Visual Themes, but just a guess

Jacques

From: "Ruth Hoffman" 

Hello List:
Got a quick question:
In 4.x releases dating back to 765601, there is a place in the 
Catalog Manager under store configuration where the user may enter in 
a style sheet and header logo for a store. By default these are set 
to /images/ecommain.css and /images/ofbiz_logo.jpg respectively.


In the latest trunk release and 9.x releases, where did these fields 
go? How does one change these fields on an existing store (or a new 
store for that matter) using the Catalog Manager?


TIA
Ruth






Re: Where did this go?

2009-09-04 Thread Jacques Le Roux

I think it's now related to Visual Themes, but just a guess

Jacques

From: "Ruth Hoffman" 

Hello List:
Got a quick question:
In 4.x releases dating back to 765601, there is a place in the Catalog 
Manager under store configuration where the user may enter in a style 
sheet and header logo for a store. By default these are set to 
/images/ecommain.css and /images/ofbiz_logo.jpg respectively.


In the latest trunk release and 9.x releases, where did these fields go? 
How does one change these fields on an existing store (or a new store 
for that matter) using the Catalog Manager?


TIA
Ruth





Re: RED Cross on newly created .java class file

2009-09-04 Thread su2

Yes I guess I just have one jar file in build/lib, I do not see new jar file
for my new java class. This is what I understood from your explanation. Am I
understanding correctly ?



abdullah shaikh wrote:
> 
> You need to put the required jars on the classpath, you can find the jars
> under the build/lib directory of the components, but you can still compile
> &
> run ofbiz using ant as it sets the required jars on path.
> 
> On Fri, Sep 4, 2009 at 11:05 PM, su2  wrote:
> 
>>
>> Hi All,
>>
>> I created new .java class file in src folder. But I am getting red cross
>> on
>> the file and because of that I think, I am getting red cross on all above
>> directories too.
>>
>> Do anybody have any idea the reason behind this ?
>>
>> I really appreciate the help.
>>
>> Thank you.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/RED-Cross-on-newly-created-.java-class-file-tp25298736p25298736.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: 
http://www.nabble.com/RED-Cross-on-newly-created-.java-class-file-tp25298736p25301163.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Where did this go?

2009-09-04 Thread Ruth Hoffman

Hello List:
Got a quick question:
In 4.x releases dating back to 765601, there is a place in the Catalog 
Manager under store configuration where the user may enter in a style 
sheet and header logo for a store. By default these are set to 
/images/ecommain.css and /images/ofbiz_logo.jpg respectively.


In the latest trunk release and 9.x releases, where did these fields go? 
How does one change these fields on an existing store (or a new store 
for that matter) using the Catalog Manager?


TIA
Ruth


Re: RED Cross on newly created .java class file

2009-09-04 Thread Abdullah Shaikh
You need to put the required jars on the classpath, you can find the jars
under the build/lib directory of the components, but you can still compile &
run ofbiz using ant as it sets the required jars on path.

On Fri, Sep 4, 2009 at 11:05 PM, su2  wrote:

>
> Hi All,
>
> I created new .java class file in src folder. But I am getting red cross on
> the file and because of that I think, I am getting red cross on all above
> directories too.
>
> Do anybody have any idea the reason behind this ?
>
> I really appreciate the help.
>
> Thank you.
>
> --
> View this message in context:
> http://www.nabble.com/RED-Cross-on-newly-created-.java-class-file-tp25298736p25298736.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>


Re: RED Cross on newly created .java class file

2009-09-04 Thread Jacques Le Roux
I guess : you are in Eclipse, you use Subclipse, and this means that if you want to put thes files in repository you have to add 
them to the repository (using Subclipse). If I'm right, look for help on Subclipse...


Jacques

From: "su2" 


Hi All,

I created new .java class file in src folder. But I am getting red cross on
the file and because of that I think, I am getting red cross on all above
directories too.

Do anybody have any idea the reason behind this ?

I really appreciate the help.

Thank you.

--
View this message in context: 
http://www.nabble.com/RED-Cross-on-newly-created-.java-class-file-tp25298736p25298736.html
Sent from the OFBiz - User mailing list archive at Nabble.com.






RED Cross on newly created .java class file

2009-09-04 Thread su2

Hi All,

I created new .java class file in src folder. But I am getting red cross on
the file and because of that I think, I am getting red cross on all above
directories too.

Do anybody have any idea the reason behind this ?

I really appreciate the help.

Thank you.

-- 
View this message in context: 
http://www.nabble.com/RED-Cross-on-newly-created-.java-class-file-tp25298736p25298736.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



oracle to by Sun

2009-09-04 Thread BJ Freeman
this is old news but the EU is looking at it still.

http://www.sun.com/third-party/global/oracle/
-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.



Re: Mysterious warnings when running ant run-install on iSeries / DB2

2009-09-04 Thread Scott Gray
My guess is that you are using your main database for olap as well so  
the second delegator is just complaining about all the extra tables  
it's seeing but no harm is caused.


Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 5/09/2009, at 4:21 AM, André Herbst wrote:


Hi,

When I am running ant run-install, I get a lot of warings like the  
following:


   [java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java: 
368:WARN ]

Table named [OFBIZ.ACCOMMODATION_CLASS] exists in the
database but has no corresponding entity
   [java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java: 
368:WARN ]

Table named [OFBIZ.ACCOMMODATION_MAP] exists in the
database but has no corresponding entity
   [java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java: 
368:WARN ]

Table named [OFBIZ.ACCOMMODATION_MAP_TYPE] exists in
the database but has no corresponding entity
   [java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java: 
368:WARN ]

Table named [OFBIZ.ACCOMMODATION_SPOT] exists in the
daatabase but has no corresponding entity
   [java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java: 
368:WARN ]

Table named [OFBIZ.ACCTG_TRANS] exists in the database
 but has no corresponding entity
   [java] 2009-09-04 12:53:00,046 (main) [   DatabaseUtil.java: 
368:WARN ]

Table named [OFBIZ.ACCTG_TRANS_ATTRIBUTE] exists in
the database but has no corresponding entity

Can anybody please help me to explain what these warnings mean?

-André





smime.p7s
Description: S/MIME cryptographic signature


Mysterious warnings when running ant run-install on iSeries / DB2

2009-09-04 Thread André Herbst
Hi,

When I am running ant run-install, I get a lot of warings like the following:

[java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:368:WARN ] 
Table named [OFBIZ.ACCOMMODATION_CLASS] exists in the
 database but has no corresponding entity
[java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:368:WARN ] 
Table named [OFBIZ.ACCOMMODATION_MAP] exists in the
 database but has no corresponding entity
[java] 2009-09-04 12:53:00,016 (main) [   DatabaseUtil.java:368:WARN ] 
Table named [OFBIZ.ACCOMMODATION_MAP_TYPE] exists in
 the database but has no corresponding entity
[java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java:368:WARN ] 
Table named [OFBIZ.ACCOMMODATION_SPOT] exists in the
 daatabase but has no corresponding entity
[java] 2009-09-04 12:53:00,035 (main) [   DatabaseUtil.java:368:WARN ] 
Table named [OFBIZ.ACCTG_TRANS] exists in the database
  but has no corresponding entity
[java] 2009-09-04 12:53:00,046 (main) [   DatabaseUtil.java:368:WARN ] 
Table named [OFBIZ.ACCTG_TRANS_ATTRIBUTE] exists in
 the database but has no corresponding entity 

Can anybody please help me to explain what these warnings mean?

-André



Re: Re: problem Running with MS-SQL

2009-09-04 Thread Mridul Pathak
Abhijeet,

Is it OFBiz demo data or demo data created by you?  If the demo data is
created by you then it looks like primary key sequence problem.  In OFBiz
sequence always start with 1, so the recommended way of having demo/test
data is have sequences less then 1, as we do have in OFBiz demo data, to
avoid conflicts.  You can fix your current problem by adjusting sequence for
ProductDimension entity in SequenceValueItem entity, but it would be
difficult if you have many such records in other entities as well.
-- 
Thanks & Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
mridul.pat...@hotwaxmedia.com

2009/9/4 Abhijeet Pandey 

> Hi,
>
> i am able to connect to ofbiz with demo data after doing modification
> suggested.
>
> but i am not able to add product.
>
> i am getting below error -->
>
>  The Following Errors Occurred:
>
> Error: Error trying to begin transaction, could not process method: The
> current transaction is marked for rollback, not beginning a new transaction
> and aborting current operation; the rollbackOnly was caused by: Failure in
> create operation for entity [ProductDimension]:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04
> 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04
>
> 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A
> Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04
> 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04
>
> 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished
> Good(java.lang.String)] (SQL Exception while executing the following:INSERT
> INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE,
> BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The
> statement was aborted because it would have caused a duplicate key value in
> a unique or primary key constraint or unique index identified by
> 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)). Rolling back
> transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04
> 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04
>
> 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A
> Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04
> 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04
>
> 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished
> Good(java.lang.String)] (SQL Exception while executing the following:INSERT
> INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE,
> BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The
> statement was aborted because it would have caused a duplicate key value in
> a unique or primary key constraint or unique index identified by
> 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)) (Error while
> inserting:
> [GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04
> 19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04
>
> 19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A
> Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04
> 19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04
>
> 19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished
> Good(java.lang.String)] (SQL Exception while executing the following:INSERT
> INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE,
> BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The
> statement was aborted because it would have caused a duplicate key value in
> a unique or primary key constraint or unique index identified by
> 'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)))   calling service
> addProductToCategory in createProductInCategory
>
>
>
> does the changes suggested below is the culprit ?
>
>
> Plz guide.
>
>
> Thanks,
>
>
> Abhijeet Pandey
>
>
> On Mon, Aug 31, 2009 at 5:42 AM, weixuezhang  >wrote:
>
> >  Either demo data or entitymodel definition has problem. Can someone look
> > into this problem?
> >
> > I found 6 places with unique="true" in trunk as below. I simply changed
> > "true" into "false", then started from creating a new database.
> >
> >  accounting\entitydef\entitymodel.xml
> > 1,931: 
> >
> >  marketing\entitydef\entitymodel.xml
> > 216: 
> >
> >  party\entitydef\entitymodel.xml (2 matches)
> > 714: 
> > 1,007: 
> >
> >  product\entitydef\entitymodel.xml (2 matches)
> > 1,839: 
> > 1,842: 
> >
> > I found demo data doesn't specify value for some of the

Re: Problems processing event: java.lang.NoSuchMethodException

2009-09-04 Thread su2

Hi Abdullah,

Thanks for your response.

I tried making a new .java class in src file and moving all my method there
and it worked! I am not sure what might be the reason though its the same
exact file but a fresh copy.

Thanks for your help.


abdullah shaikh wrote:
> 
> You need to check the return statements of "receiveParams" method, and as
> you say that its happening to all your methods, then I don't know if this
> is
> the issue, but mostly likely it should be the response returned.
> 
> Check all you return statements.
> 
> On Fri, Sep 4, 2009 at 7:38 PM, su2  wrote:
> 
>>
>> Hi abdullah80,
>>
>> I am not sure, How would I check what my method is returning. And this
>> happens to all my new as well as previously working methods.
>>
>> Thanks for your help.
>>
>>
>>
>>
>> abdullah80 wrote:
>> >
>> > As it renders the screen, when you remove the java event, bcoz ofbiz by
>> > default takes response as "success", maybe then your "receiveParams"
>> > method
>> > must be returning some other response instead of "success"
>> >
>> > On Fri, Sep 4, 2009 at 1:00 AM, su2  wrote:
>> >
>> >>
>> >> Hi All,
>> >>
>> >> I am having issue with calling java event.
>> >>
>> >> If I remove java event call from request-map it renders the screen (of
>> >> course without processing anything since its not processing java
>> >> event/method). And with the  tag in request-map I get blank
>> >> screen.
>> >>
>> >> I have stopped and re-compiled component without any error.
>> >>
>> >> I really appreciate the help.
>> >>
>> >> Thanks in advance.
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Problems-processing-event%3A-java.lang.NoSuchMethodException-tp25282598p25282598.html
>> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Problems-processing-event%3A-java.lang.NoSuchMethodException-tp25282598p25295009.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Problems-processing-event%3A-java.lang.NoSuchMethodException-tp25282598p25296305.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Problems processing event: java.lang.NoSuchMethodException

2009-09-04 Thread Abdullah Shaikh
You need to check the return statements of "receiveParams" method, and as
you say that its happening to all your methods, then I don't know if this is
the issue, but mostly likely it should be the response returned.

Check all you return statements.

On Fri, Sep 4, 2009 at 7:38 PM, su2  wrote:

>
> Hi abdullah80,
>
> I am not sure, How would I check what my method is returning. And this
> happens to all my new as well as previously working methods.
>
> Thanks for your help.
>
>
>
>
> abdullah80 wrote:
> >
> > As it renders the screen, when you remove the java event, bcoz ofbiz by
> > default takes response as "success", maybe then your "receiveParams"
> > method
> > must be returning some other response instead of "success"
> >
> > On Fri, Sep 4, 2009 at 1:00 AM, su2  wrote:
> >
> >>
> >> Hi All,
> >>
> >> I am having issue with calling java event.
> >>
> >> If I remove java event call from request-map it renders the screen (of
> >> course without processing anything since its not processing java
> >> event/method). And with the  tag in request-map I get blank
> >> screen.
> >>
> >> I have stopped and re-compiled component without any error.
> >>
> >> I really appreciate the help.
> >>
> >> Thanks in advance.
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/Problems-processing-event%3A-java.lang.NoSuchMethodException-tp25282598p25282598.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Problems-processing-event%3A-java.lang.NoSuchMethodException-tp25282598p25295009.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>


Duplication of Scheduled jobs

2009-09-04 Thread Kojo Gambrah

Hi Everybody,

I am having a problem with scheduled jobs - both those defined in stock 
ofbiz (sendEmailDated, createMaintsFromInterval) and those created by 
myself. For some unknown reason, multiple jobs for the same job(with 
status - PENDING) are created as Ofbiz is repeatedly started and 
stopped. Eventually, it causes Ofbiz to use a lot of CPU cycles.


I would be grateful for a solution to this issue.

Regards,
Kojo Gambrah


Re: Problems processing event: java.lang.NoSuchMethodException

2009-09-04 Thread su2

Hi abdullah80,

I am not sure, How would I check what my method is returning. And this
happens to all my new as well as previously working methods. 

Thanks for your help.




abdullah80 wrote:
> 
> As it renders the screen, when you remove the java event, bcoz ofbiz by
> default takes response as "success", maybe then your "receiveParams"
> method
> must be returning some other response instead of "success"
> 
> On Fri, Sep 4, 2009 at 1:00 AM, su2  wrote:
> 
>>
>> Hi All,
>>
>> I am having issue with calling java event.
>>
>> If I remove java event call from request-map it renders the screen (of
>> course without processing anything since its not processing java
>> event/method). And with the  tag in request-map I get blank
>> screen.
>>
>> I have stopped and re-compiled component without any error.
>>
>> I really appreciate the help.
>>
>> Thanks in advance.
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Problems-processing-event%3A-java.lang.NoSuchMethodException-tp25282598p25282598.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Problems-processing-event%3A-java.lang.NoSuchMethodException-tp25282598p25295009.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Re: Re: problem Running with MS-SQL

2009-09-04 Thread Abhijeet Pandey
Hi,

i am able to connect to ofbiz with demo data after doing modification
suggested.

but i am not able to add product.

i am getting below error -->

 The Following Errors Occurred:

Error: Error trying to begin transaction, could not process method: The
current transaction is marked for rollback, not beginning a new transaction
and aborting current operation; the rollbackOnly was caused by: Failure in
create operation for entity [ProductDimension]:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04
19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04
19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A
Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04
19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04
19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished
Good(java.lang.String)] (SQL Exception while executing the following:INSERT
INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE,
BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The
statement was aborted because it would have caused a duplicate key value in
a unique or primary key constraint or unique index identified by
'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)). Rolling back
transaction.org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04
19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04
19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A
Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04
19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04
19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished
Good(java.lang.String)] (SQL Exception while executing the following:INSERT
INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE,
BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The
statement was aborted because it would have caused a duplicate key value in
a unique or primary key constraint or unique index identified by
'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)) (Error while
inserting:
[GenericEntity:ProductDimension][brandName,null()][createdStamp,2009-09-04
19:05:12.577(java.sql.Timestamp)][createdTxStamp,2009-09-04
19:05:11.797(java.sql.Timestamp)][dimensionId,10003(java.lang.String)][internalName,A
Beautifull Mind(java.lang.String)][lastUpdatedStamp,2009-09-04
19:05:12.577(java.sql.Timestamp)][lastUpdatedTxStamp,2009-09-04
19:05:11.797(java.sql.Timestamp)][productId,BHV1(java.lang.String)][productType,Finished
Good(java.lang.String)] (SQL Exception while executing the following:INSERT
INTO OFBIZ.PRODUCT_DIMENSION (DIMENSION_ID, PRODUCT_ID, PRODUCT_TYPE,
BRAND_NAME, INTERNAL_NAME, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (The
statement was aborted because it would have caused a duplicate key value in
a unique or primary key constraint or unique index identified by
'SQL090811123924980' defined on 'PRODUCT_DIMENSION'.)))   calling service
addProductToCategory in createProductInCategory



does the changes suggested below is the culprit ?


Plz guide.


Thanks,


Abhijeet Pandey


On Mon, Aug 31, 2009 at 5:42 AM, weixuezhang wrote:

>  Either demo data or entitymodel definition has problem. Can someone look
> into this problem?
>
> I found 6 places with unique="true" in trunk as below. I simply changed
> "true" into "false", then started from creating a new database.
>
>  accounting\entitydef\entitymodel.xml
> 1,931: 
>
>  marketing\entitydef\entitymodel.xml
> 216: 
>
>  party\entitydef\entitymodel.xml (2 matches)
> 714: 
> 1,007: 
>
>  product\entitydef\entitymodel.xml (2 matches)
> 1,839: 
> 1,842: 
>
> I found demo data doesn't specify value for some of these fields, default
> value of them is null. When inserting multiple records of data, demo data
> seeding will get failure due to the unique index constrain.
>
> Thanks.
> Weixue Zhang
>
> --
> *发件人:* Abhijeet Pandey
> *发送时间:* 2009-08-27  16:03:30
> *收件人:* user
> *抄送:* weixuezhang; Abhijeet Pandey
> *主题:* Re: problem Running with MS-SQL
>  *Hi Zhang,
>
> Thanks for this.
>
> Can you guide me that if i need to change all "unique=false" in all the
> entitymodel.xml (there are about 26 of them)?
>
> Hi All,
>
>
> Does anyone have an idea that why it happens with MSSQL ?
>
> Thanks ,
>
> Abhijeet Pandey
> *
>
> On Sun, Aug 16, 2009 at 4:16 PM, Weixue Zhang wrote:
>
>>
>> I am using ms sql server 2005 and this problem had bothered me for long
>> time.
>> At last I found it was caused by a few unique indices of so

Error in Eclipse for common.xml: Target classes/docs does not exist in this project

2009-09-04 Thread André Herbst
Hi, 

I am getting these two errors in Eclipse for the file common.xml after an svn 
update:

Target classes does not exist in this project
Target docs does not exist in this project

I am using the trunk r811297.

-André


Recalculate items price in cart

2009-09-04 Thread Abhishake Agarwal
Hi,

I want to recalculate the Prices, Tax and shipping prices for the items
which are present in the cart.

I need this because there are some rules related to taxes I have created for
different shipping country.
If user change the shipping country on checkout page unless I recalculate
the prices it does not get reflected on checkout screen. but it will get
reflected If i go to Cart screen and click recalculate cart.

There is a method called modifyCart which works but it requires parameter
such as _UPDATE and item number and quantity.

I need a method which will just recalculate prices of items in cart and
update it.



Regards,
Abhishake


Re: PCI compliance issue - week ciphers are enabled by default

2009-09-04 Thread Carsten Schinzer
Well, the trick is to separate your Apache as an access point in the DMZ and
put network-level restricitons (Layer 3, i.e. TCP/IP) on the traffic between
apache and ofbiz in this case.
That will suffice PCI requirements.

For your other question: A two-layer layout is IMHP strongly imposed by
section 1 of the PCI requirements document v1.2. If you do not have that,
check
https://www.pcisecuritystandards.org/security_standards/pci_dss.shtml

I am sure you will agree that a standalone instance with your cardholder
data in the DMZ (or a single zone exposed to internet traffic) will not
suffice these requirements.

Are you already in the audit process? Or just preparing?

Regards


Carsten

2009/9/3 rajesh ramkumar 

>
> Hi carsten,
>
> Thanks for the reply.
>
> As stated by yourself, we are on single layer OFBiz architecture and I have
> not come across any restrictions for getting PCI compliance based on this
> architecture. Can you please forward me links/website that mentions this
> restriction.
>
> Even if you introduce a web & application layer, i.e front your ofbiz
> server(server on which you run ofbiz) with apache using mod jk
> connector/ajp
> protocol, how are you restricting the access on http(80 or any) and
> https(443 or any) ports on the ofbiz server(internal tomcat).
>
> If you are running apache on a different server then, I would assume that
> you need to get both your servers audited for PCI compliance? If you are
> running both apache & ofbiz on the same server then you might have
> configured the http & https ports on internal tomcat to be different to 80
> &
> 443, but even then the new ports can be hit from outside, so how did you
> deal with that.
>
> Any reply/help is greatly appreciated.
>
> regards
> Rajesh
>
>
>
> Carsten Schinzer wrote:
> >
> > Hi Rajesh,
> >
> >
> > with a single MEDIUM criticality issue you are at compliance level 3,
> i.e.
> > you will not put your PCI compliance at risk.
> > However, you are right: We solve these issues at Apache level.
> >
> > I wonder how the auditors did approve your single layer OFBiz
> architecture
> > (which I assume you will have since you are asking this audience for help
> > in
> > a Web Layer configuration issue)?
> >
> > If there is a solution in OFBiz configuration itself, I would like to
> know
> > as well. However, I thought you would need to
> > * introduce a Web Layer and
> > * introduce a App Layer
> > and PCI will require you to not allow un-authorized access from Web to
> App
> > Layer. So how did you solve this architectural demand?
> >
> > Regards
> >
> >
> > Carsten
> >
> >
> > 2009/9/3 rajesh ramkumar 
> >
> >>
> >> We are trying to get PCI Compliance to be able to do credit card
> >> processing.
> >> We have resolved all the issues but for the "Weak Supported SSL Ciphers
> >> Suites on https(443/tcp)".
> >>
> >> In a typical environment this is normally set at tomcat
> >> configuration/apache
> >> configuration level and in ofbiz these setting are in
> >> ofbiz-container.xml(root/frameworks/base/config). Any help to fine tune
> >> to
> >> configuration to solve this risk is greatly appreciated
> >>
> >> Our current setting:
> >> server - linux, centOS5
> >> ssl certificate - supports upto 256-bit encryption
> >> security protocol used - TLSv1 (ofbiz_container.xml)
> >> cipher suite - "HIGH:MEDIUM:!SSLv2:!ADH:!aNULL:!eNULL:!NULL:!LOW"
> >> (Basically
> >> allows only high and medium ciphers of either SSLv3 or
> >> TLSv1)(ofbiz_container.xml)
> >>
> >> PCI rejection error:
> >> Risk factor :   Medium / CVSS Base Score : 5.0
> >> (CVSS2#AV:N/AC:L/Au:N/C:P/I:N/A:N)  Plugin output :  Here is the list
> >> of weak SSL ciphers supported by the remote server :Low Strength
> >> Ciphers (< 56-bit key) SSLv3   EXP-EDH-RSA-DES-CBC-SHA
> >> Kx=DH(512)Au=RSA Enc=DES(40)  Mac=SHA1   export
> >> EXP-DES-CBC-SHAKx=RSA(512)   Au=RSA Enc=DES(40)
> >> Mac=SHA1   exportEXP-RC4-MD5Kx=RSA(512)
> >> Au=RSA Enc=RC4(40)  Mac=MD5export  TLSv1
> >> EXP-EDH-RSA-DES-CBC-SHAKx=DH(512)Au=RSA Enc=DES(40)
> >> Mac=SHA1   exportEXP-DES-CBC-SHAKx=RSA(512)
> >> Au=RSA Enc=DES(40)  Mac=SHA1   exportEXP-RC4-MD5
> >>   Kx=RSA(512)   Au=RSA Enc=RC4(40)  Mac=MD5
> >> export   The fields above are :{OpenSSL ciphername}   Kx={key
> >> exchange}   Au={authentication}   Enc={symmetric encryption method}
> >> Mac={message authentication code}   {export flag}
> >>
> >>
> >>
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/PCI-compliance-issue---week-ciphers-are-enabled-by-default-tp25273745p25273745.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >>
> >
> >
> > --
> >
> > Best
> >
> > Carsten Schinzer
> >
> > Waisenhausstr. 53a
> > 80637 München
> > Germany
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/PCI-compliance-issue--

Re: Problems processing event: java.lang.NoSuchMethodException

2009-09-04 Thread BJ Freeman
add a response error that goes to an error.jsp

as do you have a view defined as WelcomeVisitor


su2 sent the following on 9/3/2009 12:58 PM:
> Hi Nicolas,
>  
> Following is my request-map
> 
> 
> path="org.ofbiz.learning.learning.LearningEvents"
> invoke="receiveParams"/>
>
> 
> 
> 
> Yeah, I think the path on the event is correct.
> 
> I was little confuse on your last question regarding CLASS_PATH.  
> 
> I do have   in
> ofbiz-component.xml.
> 
> Thanks.
> 
> Malin Nicolas wrote:
>> Hi su2,
>>
>> What calling method or request-map uri ?
>>
>> Are you sure that your path on the event is good ?
>> Are you sure that your class build is in the CLASS_PATH ?
>>
>> Nicolas
>>
>> su2 a écrit :
>>> Hi All,
>>>
>>> I am having issue with calling java event. 
>>>
>>> If I remove java event call from request-map it renders the screen (of
>>> course without processing anything since its not processing java
>>> event/method). And with the  tag in request-map I get blank
>>> screen.
>>>
>>> I have stopped and re-compiled component without any error.
>>>
>>> I really appreciate the help.
>>>
>>> Thanks in advance.
>>>
>>>   
>>
>> -- 
>> Nicolas MALIN
>> Consultant
>> Tél : 06.17.66.40.06
>> Site projet : http://www.neogia.org/
>> ---
>> Société LibrenBerry
>> Tél : 02.48.02.56.12
>> Site : http://www.librenberry.net/
>>
>>
>>
> 

-- 
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.



Re: virtual inventory

2009-09-04 Thread Zhiyong Cui

I don't know how to implement virtual  inventory in service vendor also, who
can tell me?

BJ Freeman wrote:
> 
> Take a look at the workeffort in the Data model book Vol I
> The Fig 6.3a.  the Performed at would be your outsource
> a production run would pull from inventory send to facility.
> to get you started
> 
> 
> 
> Zhiyong Cui sent the following on 8/31/2009 5:44 PM:
>> It would be wonderful.Thank you . what I want to know is , I should
>> outsource
>> some task to service supplier , I will  sent the material to them first
>> ,then after the work is done ,I should transfer the product back . and I
>> want to track the inventory . I think I can implement it as virtual
>> inventory. but I don't know how to implement it.
>> 
>> David E Jones-4 wrote:
>>>
>>> Maybe my imagination is getting away from me here, but I can imagine a  
>>> LOT of things that could be described as "virtual inventory"... could  
>>> you be more specific?
>>>
>>> -David
>>>
>>>
>>> On Aug 31, 2009, at 6:00 PM, Zhiyong Cui wrote:
>>>
 please give me some  advice.

 Zhiyong Cui wrote:
> Is there anyone could tell me  how to implement virtual inventory In
> ofbiz?
>
 -- 
 View this message in context:
 http://www.nabble.com/virtual-inventory-tp25209534p25232330.html
 Sent from the OFBiz - User mailing list archive at Nabble.com.

>>>
>>>
>> 
> 
> -- 
> BJ Freeman
> http://www.businessesnetwork.com/automation
> http://bjfreeman.elance.com
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> Systems Integrator.
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/virtual-inventory-tp25209534p25291000.html
Sent from the OFBiz - User mailing list archive at Nabble.com.



Facility Manager

2009-09-04 Thread Heidi Dehaes
Hello,

If i start the facility manager in ofbiz 09.04 i can choose a demo facility.
When i have choosen the demo facility, i have a blank screen with the
menu's.

I can only click on "shipment in" to see anything.

How functions these business procedures. Is the only way to create an
inventory in a facility by the receiving of a shipment?

thanks for your answers,
Olagos team
Olagos bvba