OFBiz › OFBiz - User

run time error

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

4 messages Options

Pal Infocom Technologies-2

run time error

when i try to create order i get following error

store found in request, cannot set locale!
[java] 2007-06-21 19:32:03,673 (http-0.0.0.0-8443-Processor4) [ JavaEventHandler.java:96 :ERROR]
[java] ---- runtime exception report --------------------------------------------------
[java] Problems Processing Event
[java] Exception: java.lang.NullPointerException
[java] Message: null

Mathius Allo

"ant run-install " failed to install demo & seed data

Hi All,

Just got the latest ofbiz yesterday from svn "co https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz"

What I did:
1. cleaned up mysql database by creating a new schema & user/password
2. updated entityengine.xml to use localmysql & set add-missing-on-start="false"
3. tried to install demo & seed data by running "ant run-install" but could not make it work. I noticed that there is no table created under my schema.

Previously I don't have such issue. Only with the latest OfBiz from SVN that I encountered this. I have looked at the instruction on how to run OfBiz

I have tried the following sequence few times but the problem persist:
1. ant clean
2. ant run-install

Are there any other changes required with the latest version of OfBiz?

I have searched the Forum but nobody seems to have similar issue previously.

Below is what I noticed in the console:

[I noticed a number warnings]

[java] 2007-06-22 13:39:23,703 (main) [ ModelViewEntity.java:461:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: statusDelay of view-entity ExampleStatusDetail
[java] 2007-06-22 13:39:23,796 (main) [ ModelViewEntity.java:625:INFO ] Throwing out field alias in view entity InventoryItemAndLocation because one already exists with the alias name [facilityId] and field name [PR(Product).facilityId], existing field name is [II.facilityId]
[java] 2007-06-22 13:39:23,796 (main) [ ModelViewEntity.java:625:INFO ] Throwing out field alias in view entity InventoryItemAndLocation because one already exists with the alias name [comments] and field name [PR(Product).comments], existing field name is [II.comments]
[java] 2007-06-22 13:39:23,843 (main) [ ModelViewEntity.java:461:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemQuantityReportGroupByItem

[It is checking database]

[java] 2007-06-22 13:39:24,437 (main) [ GenericDelegator.java:182:INFO ] Doing database check as requested in entityengine.xml with addMissing=false
[java] 2007-06-22 13:39:24,812 (main) [ DatabaseUtil.java:760:INFO ] Database Product Name is MySQL
[java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:761:INFO ] Database Product Version is 5.0.17-nt
[java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:769:INFO ] Database Driver Name is MySQL-AB JDBC Driver
[java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:770:INFO ] Database Driver Version is mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )

[Getting table info and give warnings:]

[java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:853:INFO ] Getting Table Info From Database
[java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN ] Entity [AcctgTrans]has no table in the database
[java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN ] Entity [AcctgTransAttribute] has no table in the database
[java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN ] Entity [AcctgTransEntry] has no table in the database

[Register Dispatcher]

[java] 2007-06-22 13:39:25,437 (main) [ ServiceDispatcher.java:166:INFO ] Registered dispatcher: entity-default
[java] 2007-06-22 13:39:25,500 (main) [ ModelServiceReader.java:208:INFO ] Loaded 47 Service definitions from file:/C:/MyAppl/OfBiz/framework/common/servicedef/services.xml
[java] 2007-06-22 13:39:25,531 (main) [ ModelServiceReader.java:208:INFO ] Loaded 28 Service definitions from file:/C:/MyAppl/OfBiz/framework/common/servicedef/services_test.xml

[It is loading data]

[java] 2007-06-22 13:39:27,171 (main) [EntityDataLoadContainer.java:253:INFO ] =-=-=-=-=-=-= Doing a data load with the following files:
[java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO ] file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
[java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO ] file:/C:/MyAppl/OfBiz/framework/common/data/CommonSecurityData.xml

[Start loading data but failed causing transaction rollback]

[java] 2007-06-22 13:39:27,250 (main) [EntityDataLoadContainer.java:260:INFO ] =-=-=-=-=-=-= Starting the data load...
[java] 2007-06-22 13:39:27,265 (main) [ EntitySaxReader.java:195:INFO ] Beginning import from URL: file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
[java] 2007-06-22 13:39:27,281 (main) [ EntitySaxReader.java:233:INFO ] Transaction Timeoutset to 2 hours (7200 seconds)
[java] 2007-06-22 13:39:27,296 (main) [ GenericDelegator.java:1131:ERROR]
[java] ---- exception report ----------------------------------------------------------
[java] Failure in storeAll operation: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table 'ofbiz.security_group' doesn't exist). Rolling back transaction.
[java] Exception: org.ofbiz.entity.GenericDataSourceException
[java] Message: SQL Exception while executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table 'ofbiz.security_group' doesn't exist)

Regards,
Mathius Allo

---------------------------------
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.

Scott Gray

Re: "ant run-install " failed to install demo & seed dat

Hi Mathius

set add-missing-on-start="false"

This tells ofbiz not to add missing tables change it to true and it should
work fine.

Regards
Scott

On 22/06/07, Mathius Allo <[hidden email]> wrote:

>
> Hi All,
>
> Just got the latest ofbiz yesterday from svn "co
> https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz"
>
> What I did:
> 1. cleaned up mysql database by creating a new schema & user/password
> 2. updated entityengine.xml to use localmysql & set
> add-missing-on-start="false"
> 3. tried to install demo & seed data by running "ant run-install" but
> could not make it work. I noticed that there is no table created under my
> schema.
>
> Previously I don't have such issue. Only with the latest OfBiz from SVN
> that I encountered this. I have looked at the instruction on how to run
> OfBiz
>
> I have tried the following sequence few times but the problem persist:
> 1. ant clean
> 2. ant run-install
>
> Are there any other changes required with the latest version of OfBiz?
>
> I have searched the Forum but nobody seems to have similar issue
> previously.
>
>
> Below is what I noticed in the console:
>
> [I noticed a number warnings]
>
> [java] 2007-06-22 13:39:23,703 (main) [ ModelViewEntity.java:461:WARN
> ] Conversion for complex-alias needs to be implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias: statusDelay
> of view-entity ExampleStatusDetail
> [java] 2007-06-22 13:39:23,796 (main) [ ModelViewEntity.java:625:INFO
> ] Throwing out field alias in view entity InventoryItemAndLocation because
> one already exists with the alias name [facilityId] and field name
> [PR(Product).facilityId], existing field name is [II.facilityId]
> [java] 2007-06-22 13:39:23,796 (main) [ ModelViewEntity.java:625:INFO
> ] Throwing out field alias in view entity InventoryItemAndLocation because
> one already exists with the alias name [comments] and field name
> [PR(Product).comments], existing field name is [II.comments]
> [java] 2007-06-22 13:39:23,843 (main) [ ModelViewEntity.java:461:WARN
> ] Conversion for complex-alias needs to be implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias:
> quantityOrdered of view-entity OrderItemQuantityReportGroupByItem
>
> [It is checking database]
>
> [java] 2007-06-22 13:39:24,437 (main) [ GenericDelegator.java:182:INFO
> ] Doing database check as requested in entityengine.xml with
> addMissing=false
> [java] 2007-06-22 13:39:24,812 (main) [ DatabaseUtil.java:760:INFO
> ] Database Product Name is MySQL
> [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:761:INFO
> ] Database Product Version is 5.0.17-nt
> [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:769:INFO
> ] Database Driver Name is MySQL-AB JDBC Driver
> [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:770:INFO
> ] Database Driver Version is mysql-connector-java-3.1.12 ( $Date:
> 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
>
> [Getting table info and give warnings:]
>
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:853:INFO
> ] Getting Table Info From Database
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN
> ] Entity [AcctgTrans]has no table in the database
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN
> ] Entity [AcctgTransAttribute] has no table in the database
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN
> ] Entity [AcctgTransEntry] has no table in the database
>
>
> [Register Dispatcher]
>
>
> [java] 2007-06-22 13:39:25,437 (main) [ ServiceDispatcher.java:166:INFO
> ] Registered dispatcher: entity-default
> [java] 2007-06-22 13:39:25,500 (main) [ ModelServiceReader.java:208:INFO
> ] Loaded 47 Service definitions from
> file:/C:/MyAppl/OfBiz/framework/common/servicedef/services.xml
> [java] 2007-06-22 13:39:25,531 (main) [ ModelServiceReader.java:208:INFO
> ] Loaded 28 Service definitions from
> file:/C:/MyAppl/OfBiz/framework/common/servicedef/services_test.xml
>
> [It is loading data]
>
> [java] 2007-06-22 13:39:27,171 (main) [EntityDataLoadContainer.java:253:INFO
> ] =-=-=-=-=-=-= Doing a data load with the following files:
> [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO
> ] file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
> [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO
> ] file:/C:/MyAppl/OfBiz/framework/common/data/CommonSecurityData.xml
>
> [Start loading data but failed causing transaction rollback]
>
> [java] 2007-06-22 13:39:27,250 (main) [EntityDataLoadContainer.java:260:INFO
> ] =-=-=-=-=-=-= Starting the data load...
> [java] 2007-06-22 13:39:27,265 (main) [ EntitySaxReader.java:195:INFO
> ] Beginning import from URL:
> file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
> [java] 2007-06-22 13:39:27,281 (main) [ EntitySaxReader.java:233:INFO
> ] Transaction Timeoutset to 2 hours (7200 seconds)
> [java] 2007-06-22 13:39:27,296 (main) [ GenericDelegator.java
> :1131:ERROR]
> [java] ---- exception report
> ----------------------------------------------------------
> [java] Failure in storeAll operation:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table
> 'ofbiz.security_group' doesn't exist). Rolling back transaction.
> [java] Exception: org.ofbiz.entity.GenericDataSourceException
> [java] Message: SQL Exception while executing the following:SELECT
> DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table '
> ofbiz.security_group' doesn't exist)
>
> Regards,
> Mathius Allo
>
>
>
> ---------------------------------
> No need to miss a message. Get email on-the-go
> with Yahoo! Mail for Mobile. Get started.

Mathius Allo

Re: "ant run-install " failed to install demo & seed dat

Hi Scott,

Thanks for your quick reply.

It works fine now.

Regards,
Mathius

Scott Gray <[hidden email]> wrote:
Hi Mathius

set add-missing-on-start="false"

This tells ofbiz not to add missing tables change it to true and it should
work fine.

Regards
Scott

On 22/06/07, Mathius Allo wrote:

---------------------------------
Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.