[OFBiz] Users - Demo data not installed 2 of 2
Locked
 
|
2 of 2.
Here are the logs from console.log after
installation. They looked fine to me unles I missed something.
---------------------------------------------------------------------------------------
12784[
DatabaseUtil.java:272:WARN ] Entity "ProductAttribute" has no table in the
database
12795[ DatabaseUtil.java:285:INFO ] Created table "public.PRODUCT_ATTRIBUTE" 12796[ DatabaseUtil.java:272:WARN ] Entity "ProductCategory" has no table in the database 12809[ DatabaseUtil.java:285:INFO ] Created table "public.PRODUCT_CATEGORY" 12809[ DatabaseUtil.java:272:WARN ] Entity "ProductCategoryAttribute" has no table in the database 12829[ DatabaseUtil.java:285:INFO ] Created table "public.PRODUCT_CATEGORY_ATTRIBUTE" 15965[ DatabaseUtil.java:285:INFO ] Created table "public.ZIP_SALES_RULE_LOOKUP" 15965[ DatabaseUtil.java:272:WARN ] Entity "ZipSalesTaxLookup" has no table in the database 15977[ DatabaseUtil.java:285:INFO ] Created table "public.ZIP_SALES_TAX_LOOKUP" ***************************************************************************************************************************************************
THERE WERE MORE TABLES CREATED AND FOREIGN KEYS but
i had to cut them out cause the msg was to big to post it.
***************************************************************************************************************************************************
15978[
DatabaseUtil.java:1511:INFO ] Creating foreign keys for entity
"AcctgTrans"
44570[ DatabaseUtil.java:340:INFO ] Created declared indices for entity "ZipSalesRuleLookup" 44583[ DatabaseUtil.java:340:INFO ] Created declared indices for entity "ZipSalesTaxLookup" 44834[ ServiceDispatcher.java:74 :INFO ] [ServiceDispatcher] : Creating new instance. 44922[ ServiceGroupReader.java:105:INFO ] Loaded 1 Group definitions from file:/root/ofbiz/components/common/servicedef/groups_test.xml 44958[ ServiceGroupReader.java:105:INFO ] Loaded 4 Group definitions from file:/root/ofbiz/components/entityext/servicedef/groups.xml 44982[ ServiceGroupReader.java:105:INFO ] Loaded 1 Group definitions from file:/root/ofbiz/components/product/servicedef/groups_shipment.xml 45009[ ServiceGroupReader.java:105:INFO ] Loaded 4 Group definitions from file:/root/ofbiz/components/accounting/servicedef/groups.xml 45058[ ServiceEcaUtil.java:139:INFO ] Loaded 3 Service ECA definitions from file:/root/ofbiz/components/common/servicedef/secas_test.xml 45091[ ServiceEcaUtil.java:139:INFO ] Loaded 1 Service ECA definitions from file:/root/ofbiz/components/content/servicedef/secas.xml 45110[ ServiceEcaUtil.java:139:INFO ] Loaded 9 Service ECA definitions from file:/root/ofbiz/components/party/servicedef/secas.xml 45142[ ServiceEcaUtil.java:139:INFO ] Loaded 3 Service ECA definitions from file:/root/ofbiz/components/workeffort/servicedef/secas.xml 45159[ ServiceEcaUtil.java:139:INFO ] Loaded 12 Service ECA definitions from file:/root/ofbiz/components/product/servicedef/secas.xml 45176[ ServiceEcaUtil.java:139:INFO ] Loaded 12 Service ECA definitions from file:/root/ofbiz/components/product/servicedef/secas_shipment.xml 45198[ ServiceEcaUtil.java:139:INFO ] Loaded 11 Service ECA definitions from file:/root/ofbiz/components/accounting/servicedef/secas.xml 45228[ ServiceEcaUtil.java:139:INFO ] Loaded 28 Service ECA definitions from file:/root/ofbiz/components/order/servicedef/secas.xml 45698[ EntityEcaUtil.java:139:INFO ] Loaded 5 Entity ECA definitions from entitydef/eecas.xml in loader main 46023[ JobManager.java:232:INFO ] No crashed jobs to re-schedule 46167[ JobPoller.java:87 :INFO ] JobPoller: ([hidden email]) Thread Running... 46168[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: entity-default 46312[ ModelServiceReader.java:238:INFO ] Loaded 2 Service definitions from file:/root/ofbiz/components/service/servicedef/services.xml 46314[ JmsListenerFactory.java:72 :INFO ] Starting JMS Listener Factory Thread 46395[ ModelServiceReader.java:238:INFO ] Loaded 19 Service definitions from file:/root/ofbiz/components/common/servicedef/services.xml 46427[ ModelServiceReader.java:238:INFO ] Loaded 17 Service definitions from file:/root/ofbiz/components/common/servicedef/services_test.xml 46609[ ModelServiceReader.java:238:INFO ] Loaded 139 Service definitions from file:/root/ofbiz/components/content/servicedef/services.xml 46709[ ModelServiceReader.java:238:INFO ] Loaded 62 Service definitions from file:/root/ofbiz/components/party/servicedef/services.xml 46771[ ModelServiceReader.java:238:INFO ] Loaded 14 Service definitions from file:/root/ofbiz/components/securityext/servicedef/services.xml 46820[ ModelServiceReader.java:238:INFO ] Loaded 28 Service definitions from file:/root/ofbiz/components/entityext/servicedef/services.xml 46857[ ModelServiceReader.java:238:INFO ] Loaded 24 Service definitions from file:/root/ofbiz/components/workeffort/servicedef/services.xml 46908[ ModelServiceReader.java:238:INFO ] Loaded 2 Service definitions from file:/root/ofbiz/components/workeffort/servicedef/services_project.xml 47017[ ModelServiceReader.java:238:INFO ] Loaded 19 Service definitions from file:/root/ofbiz/components/workflow/servicedef/services.xml 47377[ ModelServiceReader.java:238:INFO ] Loaded 214 Service definitions from file:/root/ofbiz/components/product/servicedef/services.xml 47459[ ModelServiceReader.java:238:INFO ] Loaded 57 Service definitions from file:/root/ofbiz/components/product/servicedef/services_shipment.xml 47543[ ModelServiceReader.java:238:INFO ] Loaded 27 Service definitions from file:/root/ofbiz/components/manufacturing/servicedef/services.xml 47687[ ModelServiceReader.java:238:INFO ] Loaded 119 Service definitions from file:/root/ofbiz/components/accounting/servicedef/services.xml 47790[ ModelServiceReader.java:238:INFO ] Loaded 90 Service definitions from file:/root/ofbiz/components/order/servicedef/services.xml 47841[ ModelServiceReader.java:238:INFO ] Loaded 15 Service definitions from file:/root/ofbiz/components/marketing/servicedef/services.xml 47842[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: entity-default 47848[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: RMIDispatcher 47852[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: RMIDispatcher 49080[ Log.java:302:INFO ] Starting Jetty/4.2.18 49186[ Log.java:302:INFO ] Started [hidden email] 49322[ Log.java:302:INFO ] Checking Resource aliases 49730[ Log.java:302:INFO ] Started WebApplicationContext[/catalog,Open For Business - Catalog] 49792[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 49853[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: catalog 49854[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: catalog 50224[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/product/webapp/catalog 50323[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 50518[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 50642[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 50774[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (237) records. 50886[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (64) records. 51988[ Log.java:302:INFO ] Started WebApplicationContext[/manufacturing,Open For Business - Manufacturing Manager] 51989[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 52043[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: manufacturing 52102[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: manufacturing 52118[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/manufacturing/webapp/manufacturing 52118[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 52168[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 52212[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 52280[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (66) records. 52316[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (22) records. 52673[ Log.java:302:INFO ] Started WebApplicationContext[/partymgr,Open For Business - Party Manager] 52674[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 52728[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: partymgr 52782[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: partymgr 52889[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/party/webapp/partymgr 52890[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 52960[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 53026[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 53087[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (91) records. 53149[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (30) records. 53336[ Log.java:302:INFO ] Started WebApplicationContext[/workeffort,Open For Business - Work Manager] 53337[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 53475[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: workeffort 53476[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: workeffort 53482[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/workeffort/webapp/workeffort 53483[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 53522[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 53560[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 53588[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (82) records. 53617[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (34) records. 53747[ Log.java:302:INFO ] Started WebApplicationContext[/ecommerce,Open For Business - demostore] 53748[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 53750[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: ecommerce 53756[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: ecommerce 53768[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/ecommerce/webapp/ecommerce 53769[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 53814[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 53849[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 53899[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (130) records. 53936[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (46) records. 54008[ Log.java:302:INFO ] Started WebApplicationContext[/content,Open For Business - Content Manager] 54009[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 54011[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: content 54027[ ModelServiceReader.java:228:INFO ] Loaded 3 Service definitions from file:/root/ofbiz/components/content/webapp/content/WEB-INF/services.xml 54028[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: content 54043[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/content/webapp/content 54044[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 54285[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 54337[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 54398[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (186) records. 54460[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (69) records. 54546[ Log.java:302:INFO ] Started WebApplicationContext[/accounting,Open For Business - Accounting Manager] 54547[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 54548[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: accounting 54550[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: accounting 54581[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/accounting/webapp/accounting 54581[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 54618[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 54634[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 54653[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (40) records. 54668[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (19) records. 54744[ Log.java:302:INFO ] Started WebApplicationContext[/facility,Open For Business - Facility Manager] 54745[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 54746[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: facility 54752[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: facility 54754[ Log.java:302:ERROR] Delete existing temp dir /tmp/Jetty_0_0_0_0_8443__facility for WebApplicationContext[/facility,Open For Business - Facility Manager] 54779[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/product/webapp/facility 54780[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 54829[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 54865[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 54907[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (118) records. 54944[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (36) records. 55035[ Log.java:302:INFO ] Started WebApplicationContext[/webtools,Open For Business - Web Tools] 55036[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 55040[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: webtools 55045[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: webtools 55053[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/webtools/webapp/webtools 55054[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 55073[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 55097[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 55118[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (49) records. 55138[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (40) records. 55212[ Log.java:302:INFO ] Started WebApplicationContext[/marketing,Open For Business - Marketing Manager] 55213[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 55218[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: marketing 55225[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: marketing 55227[ Log.java:302:ERROR] Delete existing temp dir /tmp/Jetty_0_0_0_0_8443__marketing for WebApplicationContext[/marketing,Open For Business - Marketing Manager] 55279[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/marketing/webapp/marketing 55280[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 55295[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 55505[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 55529[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (24) records. 55550[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (11) records. 55638[ Log.java:302:INFO ] Started WebApplicationContext[/images,Open For Business - demostore images] 55706[ Log.java:302:INFO ] Started WebApplicationContext[/ordermgr,Open For Business - Order Manager] 55707[ ContextFilter.java:291:INFO ] [ContextFilter.init] Getting Entity Engine Delegator with delegator name default 55711[ ServiceDispatcher.java:140:INFO ] [ServiceDispatcher.register] : Registered dispatcher: order 55716[ GenericDispatcher.java:85 :INFO ] [LocalDispatcher] : Created Dispatcher for: order 55724[ ControlServlet.java:74 :INFO ] [ControlServlet.init] Loading Control Servlet mounted on path /root/ofbiz/components/order/webapp/ordermgr 55725[ RequestHandler.java:78 :INFO ] [RequestHandler Loading...] 55756[ ConfigXMLReader.java:664:INFO ] ConfigMap Created: (4) records. 55786[ ConfigXMLReader.java:748:INFO ] HandlerMap Created: (2) records. 55812[ ConfigXMLReader.java:328:INFO ] RequestMap Created: (83) records. 55840[ ConfigXMLReader.java:480:INFO ] ViewMap Created: (32) records. 55850[ Log.java:302:INFO ] jetty.ssl.keystore=base/config/ofbizssl.jks 55851[ Log.java:302:INFO ] jetty.ssl.password=******** 55852[ Log.java:302:INFO ] jetty.ssl.keypassword=******** 55857[ Log.java:302:INFO ] jetty.ssl.keystore.type=jks 55861[ Log.java:302:INFO ] jetty.ssl.keystore.provider.name=[DEFAULT] 55934[ Log.java:302:INFO ] [hidden email] 55944[ Log.java:302:INFO ] JsseListener.needClientAuth=false 55960[ Log.java:302:INFO ] Started SocketListener on 0.0.0.0:8443 55969[ Log.java:302:INFO ] Started SocketListener on 0.0.0.0:8080 55983[ Log.java:302:INFO ] Started AJP13Listener on 0.0.0.0:8009 55984[ Log.java:302:INFO ] NOTICE: AJP13 is not a secure protocol. Please protect the port 0.0.0.0:8009 55984[ Log.java:302:INFO ] Started [hidden email] 56364[ BeanShellContainer.java:106:INFO ] Started BeanShell telnet service on 9989, 9990 56364[ BeanShellContainer.java:107:INFO ] NOTICE: BeanShell service ports are not secure. Please protect the ports 66383[ JmsListenerFactory.java:82 :INFO ] JMS Listener Factory Thread Finished; All listeners connected. ---------------------------------------------------------------------------------------
I`m sorry for this long log but maybe someone can
point me in a direction to find this error.
THank you
Michal _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - Demo data not installed 2 of 2
|
|
Hi,
Are you saying you get these sort of messages every time you restart ofbiz? 12796[ DatabaseUtil.java:272:WARN ] Entity "ProductCategory" has no table in the database 12809[ DatabaseUtil.java:285:INFO ] Created table "public.PRODUCT_CATEGORY" Could it be that your user connection to the DB is not privileged enough to query the schema? How about a little more detail on your set up like versions for OS, OFBiz, java, DB etc. Also if you are testing against the an svn version try running an "svn st" command to double check which files if any have been changed. Ray michal wrote: > 2 of 2. > Here are the logs from console.log after installation. They looked > fine to me unles I missed something. > --------------------------------------------------------------------------------------- > 12784[ DatabaseUtil.java:272:WARN ] Entity "ProductAttribute" > has no table in the database > 12795[ DatabaseUtil.java:285:INFO ] Created table > "public.PRODUCT_ATTRIBUTE" > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Thanks for the reply.
The lines you have mentioned I get during installation and I dont think there is something wrong with them because all the tables are created. The problem I have is that demo data is not populated in my database. Iam using PostgreSQL 7.4.6 on RedHat Enterprise 4.0, java 1.4.2_09 and ofbiz 3.0.0. I tried to access ofbiz catalog after installation and the page comes up asking me for username and password. I enter admin and ofbiz and I get this errors in console: JobManager.java:176:ERROR] org.ofbiz.entity.transaction.GenericTransactionException: System error, could not commit transaction (Unexpected Exception on commit_one_phase) Thread.run(Thread.java:534) javax.transaction.SystemException: Unexpected Exception on commit_one_phase and directly on the page that I was entering username and pass I get this error: The following error occurred during login: Service [userLogin] Failed (Exception on rollback:java.rmi.RemoteException: rollback: Unexpected XAException:7) I think my user has privilegeds for inserting data but I will double check that. Michal ----- Original Message ----- From: "Ray" <[hidden email]> To: "OFBiz Users / Usage Discussion" <[hidden email]> Sent: Monday, November 07, 2005 10:09 AM Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 > Hi, > > Are you saying you get these sort of messages every time you restart > ofbiz? > 12796[ DatabaseUtil.java:272:WARN ] Entity "ProductCategory" has > no table in the database > 12809[ DatabaseUtil.java:285:INFO ] Created table > "public.PRODUCT_CATEGORY" > Could it be that your user connection to the DB is not privileged enough > to query the schema? > > How about a little more detail on your set up like versions for OS, OFBiz, > java, DB etc. Also if you are testing against the an svn version try > running an "svn st" command to double check which files if any have been > changed. > > Ray > > michal wrote: > >> 2 of 2. >> Here are the logs from console.log after installation. They looked fine >> to me unles I missed something. >> --------------------------------------------------------------------------------------- >> 12784[ DatabaseUtil.java:272:WARN ] Entity "ProductAttribute" has >> no table in the database >> 12795[ DatabaseUtil.java:285:INFO ] Created table >> "public.PRODUCT_ATTRIBUTE" >> > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Michal
The production setup guide is intended for the OFBIZ post 3.0.0 releases. I recommend you delete your db, get a ofbiz trunk version from svn or a stable release at http://www.sequoiaerp.org/ . And start your steps again. mit freundlichen Grüssen/ Kind regards / muchos saludos -- Dipl. Wirt.-Ing. Michael Pfurtscheller zentric GmbH & Co. KG mobil: +49-172-5457143 fon: +49-6101-556060 fax: +49-6101-556065 icq# 8724822 mailto:[hidden email] http://www.zentric.com [hidden email] wrote on 07.11.2005 20:20:03: > Thanks for the reply. > The lines you have mentioned I get during installation and I dont think > there is something wrong with them because all the tables are created. The > problem I have is that demo data is not populated in my database. > > Iam using PostgreSQL 7.4.6 on RedHat Enterprise 4.0, java 1.4.2_09 and ofbiz > 3.0.0. I tried to access ofbiz catalog after installation and the page comes > up asking me for username and password. I enter admin and ofbiz and I get > this errors in console: > JobManager.java:176:ERROR] > org.ofbiz.entity.transaction.GenericTransactionException: > System error, could not commit transaction (Unexpected > Exception on commit_one_phase) > > Thread.run(Thread.java:534) > javax.transaction.SystemException: Unexpected > Exception on commit_one_phase > > and directly on the page that I was entering username and pass I get > error: > The following error occurred during login: > Service [userLogin] Failed (Exception on > rollback:java.rmi.RemoteException: rollback: > Unexpected XAException:7) > I think my user has privilegeds for inserting data but I will double check > that. > > Michal > > > ----- Original Message ----- > From: "Ray" <[hidden email]> > To: "OFBiz Users / Usage Discussion" <[hidden email]> > Sent: Monday, November 07, 2005 10:09 AM > Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 > > > > Hi, > > > > Are you saying you get these sort of messages every time you restart > > ofbiz? > > 12796[ DatabaseUtil.java:272:WARN ] Entity "ProductCategory" > > no table in the database > > 12809[ DatabaseUtil.java:285:INFO ] Created table > > "public.PRODUCT_CATEGORY" > > Could it be that your user connection to the DB is not privileged enough > > to query the schema? > > > > How about a little more detail on your set up like versions for OS, OFBiz, > > java, DB etc. Also if you are testing against the an svn version try > > running an "svn st" command to double check which files if any have been > > changed. > > > > Ray > > > > michal wrote: > > > >> 2 of 2. > >> Here are the logs from console.log after installation. They looked fine > >> to me unles I missed something. > >> > --------------------------------------------------------------------------------------- > >> 12784[ DatabaseUtil.java:272:WARN ] Entity "ProductAttribute" has > >> no table in the database > >> 12795[ DatabaseUtil.java:285:INFO ] Created table > >> "public.PRODUCT_ATTRIBUTE" > >> > > > > _______________________________________________ > > Users mailing list > > [hidden email] > > http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - Demo data not installed 2 of 2
|
|
In reply to this post by michal-2
I was trying to clarify that the message only occurred the once during
the first run and not there after for each subsequent run, which you appear to be confirming. It might be worth checking out the java database driver version that you are running. Make sure that it is compatible with PostgreSQL 7.4.6. Also check your path/classpath for other potential undesired files being picked up or used. There are ways to list files used by a process which can make it very clear what files have been picked up and used. In all PostgreSQL is probably the most tested/used database with OFBiz so this really should be something reasonably basic, it's just a case of pinning it down which is not always so easy. Ray michal wrote: > Thanks for the reply. > The lines you have mentioned I get during installation and I dont > think there is something wrong with them because all the tables are > created. The problem I have is that demo data is not populated in my > database. > > Iam using PostgreSQL 7.4.6 on RedHat Enterprise 4.0, java 1.4.2_09 and > ofbiz 3.0.0. I tried to access ofbiz catalog after installation and > the page comes up asking me for username and password. I enter admin > and ofbiz and I get this errors in console: > JobManager.java:176:ERROR] > org.ofbiz.entity.transaction.GenericTransactionException: > System error, could not commit transaction (Unexpected > Exception on commit_one_phase) > > Thread.run(Thread.java:534) > javax.transaction.SystemException: Unexpected > Exception on commit_one_phase > > and directly on the page that I was entering username and pass I get > this error: > The following error occurred during login: > Service [userLogin] Failed (Exception on > rollback:java.rmi.RemoteException: rollback: > Unexpected XAException:7) > I think my user has privilegeds for inserting data but I will double > check that. > > Michal > > > ----- Original Message ----- From: "Ray" <[hidden email]> > To: "OFBiz Users / Usage Discussion" <[hidden email]> > Sent: Monday, November 07, 2005 10:09 AM > Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 > > >> Hi, >> >> Are you saying you get these sort of messages every time you restart >> ofbiz? >> 12796[ DatabaseUtil.java:272:WARN ] Entity "ProductCategory" >> has no table in the database >> 12809[ DatabaseUtil.java:285:INFO ] Created table >> "public.PRODUCT_CATEGORY" >> Could it be that your user connection to the DB is not privileged >> enough to query the schema? >> >> How about a little more detail on your set up like versions for OS, >> OFBiz, java, DB etc. Also if you are testing against the an svn >> version try running an "svn st" command to double check which files >> if any have been changed. >> >> Ray > _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
I have downloaded the right JDBC driver but i dont know how to install it.
grrrrr. I will play around with it and see what happens. Can i check if JDBC driver is compatible with postgreSql before installing new one ?? Is there any way to test it ? Michal ----- Original Message ----- From: "Ray" <[hidden email]> To: "OFBiz Users / Usage Discussion" <[hidden email]> Sent: Tuesday, November 08, 2005 4:05 AM Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 >I was trying to clarify that the message only occurred the once during the >first run and not there after for each subsequent run, which you appear to >be confirming. > > It might be worth checking out the java database driver version that you > are running. Make sure that it is compatible with PostgreSQL 7.4.6. Also > check your path/classpath for other potential undesired files being picked > up or used. There are ways to list files used by a process which can make > it very clear what files have been picked up and used. > > In all PostgreSQL is probably the most tested/used database with OFBiz so > this really should be something reasonably basic, it's just a case of > pinning it down which is not always so easy. > > Ray > > michal wrote: > >> Thanks for the reply. >> The lines you have mentioned I get during installation and I dont think >> there is something wrong with them because all the tables are created. >> The problem I have is that demo data is not populated in my database. >> >> Iam using PostgreSQL 7.4.6 on RedHat Enterprise 4.0, java 1.4.2_09 and >> ofbiz 3.0.0. I tried to access ofbiz catalog after installation and the >> page comes up asking me for username and password. I enter admin and >> ofbiz and I get this errors in console: >> JobManager.java:176:ERROR] >> org.ofbiz.entity.transaction.GenericTransactionException: >> System error, could not commit transaction (Unexpected >> Exception on commit_one_phase) >> >> Thread.run(Thread.java:534) >> javax.transaction.SystemException: Unexpected >> Exception on commit_one_phase >> >> and directly on the page that I was entering username and pass I get this >> error: >> The following error occurred during login: >> Service [userLogin] Failed (Exception on >> rollback:java.rmi.RemoteException: rollback: >> Unexpected XAException:7) >> I think my user has privilegeds for inserting data but I will double >> check that. >> >> Michal >> >> >> ----- Original Message ----- From: "Ray" <[hidden email]> >> To: "OFBiz Users / Usage Discussion" <[hidden email]> >> Sent: Monday, November 07, 2005 10:09 AM >> Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 >> >> >>> Hi, >>> >>> Are you saying you get these sort of messages every time you restart >>> ofbiz? >>> 12796[ DatabaseUtil.java:272:WARN ] Entity "ProductCategory" >>> has no table in the database >>> 12809[ DatabaseUtil.java:285:INFO ] Created table >>> "public.PRODUCT_CATEGORY" >>> Could it be that your user connection to the DB is not privileged enough >>> to query the schema? >>> >>> How about a little more detail on your set up like versions for OS, >>> OFBiz, java, DB etc. Also if you are testing against the an svn version >>> try running an "svn st" command to double check which files if any have >>> been changed. >>> >>> Ray >> > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
In reply to this post by MPF-2
I dloaded Sequoia/ofbiz, went throught installation steps and everything
worked fine. Data was there and I was albe to login. Now I have noticed big difference when I was running ofbiz with derby db and then with postgresql. With postgresql everything is much slower. The pages are loading slowely. Is there any way i can tweak that ? Also I am going now for production setup. I have created new database with new user(tested db and it worked fine), unzipped new sequoia packagae, changed entityengine.xml for proper info and run this command: $JAVA_HOME/bin/java -jar ofbiz.jar -install-readers=seed and I got this output : Exception in thread "main" java.io.IOException: Cannot load configuration properties : org/ofbiz/base/start/install-readers=seed.properties at org.ofbiz.base.start.Start$Config.getPropertiesFile(Start.java:500) at org.ofbiz.base.start.Start$Config.readConfig(Start.java:518) at org.ofbiz.base.start.Start.init(Start.java:75) at org.ofbiz.base.start.Start.main(Start.java:412) Console.log is emtpy. Any ideas what happen there ? Michal ----- Original Message ----- From: <[hidden email]> To: "OFBiz Users / Usage Discussion" <[hidden email]> Sent: Tuesday, November 08, 2005 3:57 AM Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 > Michal > > The production setup guide is intended for the OFBIZ post 3.0.0 releases. > I recommend you delete your db, get a ofbiz trunk version from svn or a > stable release at http://www.sequoiaerp.org/ . > And start your steps again. > > > mit freundlichen Grüssen/ Kind regards / muchos saludos > -- > Dipl. Wirt.-Ing. Michael Pfurtscheller > zentric GmbH & Co. KG > mobil: +49-172-5457143 > fon: +49-6101-556060 > fax: +49-6101-556065 > icq# 8724822 > mailto:[hidden email] > http://www.zentric.com > > [hidden email] wrote on 07.11.2005 20:20:03: > >> Thanks for the reply. >> The lines you have mentioned I get during installation and I dont think >> there is something wrong with them because all the tables are created. > The >> problem I have is that demo data is not populated in my database. >> >> Iam using PostgreSQL 7.4.6 on RedHat Enterprise 4.0, java 1.4.2_09 and > ofbiz >> 3.0.0. I tried to access ofbiz catalog after installation and the page > comes >> up asking me for username and password. I enter admin and ofbiz and I > get >> this errors in console: >> JobManager.java:176:ERROR] >> org.ofbiz.entity.transaction.GenericTransactionException: >> System error, could not commit transaction (Unexpected >> Exception on commit_one_phase) >> >> Thread.run(Thread.java:534) >> javax.transaction.SystemException: Unexpected >> Exception on commit_one_phase >> >> and directly on the page that I was entering username and pass I get > this >> error: >> The following error occurred during login: >> Service [userLogin] Failed (Exception on >> rollback:java.rmi.RemoteException: rollback: >> Unexpected XAException:7) >> I think my user has privilegeds for inserting data but I will double > check >> that. >> >> Michal >> >> >> ----- Original Message ----- >> From: "Ray" <[hidden email]> >> To: "OFBiz Users / Usage Discussion" <[hidden email]> >> Sent: Monday, November 07, 2005 10:09 AM >> Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 >> >> >> > Hi, >> > >> > Are you saying you get these sort of messages every time you restart >> > ofbiz? >> > 12796[ DatabaseUtil.java:272:WARN ] Entity "ProductCategory" > has >> > no table in the database >> > 12809[ DatabaseUtil.java:285:INFO ] Created table >> > "public.PRODUCT_CATEGORY" >> > Could it be that your user connection to the DB is not privileged > enough >> > to query the schema? >> > >> > How about a little more detail on your set up like versions for OS, > OFBiz, >> > java, DB etc. Also if you are testing against the an svn version try >> > running an "svn st" command to double check which files if any have > been >> > changed. >> > >> > Ray >> > >> > michal wrote: >> > >> >> 2 of 2. >> >> Here are the logs from console.log after installation. They looked > fine >> >> to me unles I missed something. >> >> >> > --------------------------------------------------------------------------------------- >> >> 12784[ DatabaseUtil.java:272:WARN ] Entity "ProductAttribute" > has >> >> no table in the database >> >> 12795[ DatabaseUtil.java:285:INFO ] Created table >> >> "public.PRODUCT_ATTRIBUTE" >> >> >> > >> > _______________________________________________ >> > Users mailing list >> > [hidden email] >> > http://lists.ofbiz.org/mailman/listinfo/users >> >> >> _______________________________________________ >> Users mailing list >> [hidden email] >> http://lists.ofbiz.org/mailman/listinfo/users > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
Re: [OFBiz] Users - Demo data not installed 2 of 2
|
|
From what I can see you have no space between the two options
"-install" and "-readers", should read "-install -readers". Ray michal wrote: > I dloaded Sequoia/ofbiz, went throught installation steps and > everything worked fine. Data was there and I was albe to login. > Now I have noticed big difference when I was running ofbiz with derby > db and then with postgresql. With postgresql everything is much > slower. The pages are loading slowely. Is there any way i can tweak > that ? > > Also I am going now for production setup. > I have created new database with new user(tested db and it worked > fine), unzipped new sequoia packagae, changed entityengine.xml for > proper info and run this command: > $JAVA_HOME/bin/java -jar ofbiz.jar -install-readers=seed > and I got this output : > Exception in thread "main" java.io.IOException: Cannot > load configuration properties : > org/ofbiz/base/start/install-readers=seed.properties > at > org.ofbiz.base.start.Start$Config.getPropertiesFile(Start.java:500) > at > org.ofbiz.base.start.Start$Config.readConfig(Start.java:518) > at > org.ofbiz.base.start.Start.init(Start.java:75) > at > org.ofbiz.base.start.Start.main(Start.java:412) > > Console.log is emtpy. Any ideas what happen there ? > > Michal _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
|
|
Thank you and that was correct.
What about issue #2 speeding the system cause its working kind of slowely ?? How can i check heap(dunno if spelled correctly?!) memory? Michal ----- Original Message ----- From: "Ray" <[hidden email]> To: "OFBiz Users / Usage Discussion" <[hidden email]> Sent: Tuesday, November 08, 2005 1:05 PM Subject: Re: [OFBiz] Users - Demo data not installed 2 of 2 > From what I can see you have no space between the two options "-install" > and "-readers", should read "-install -readers". > > Ray > > > michal wrote: > >> I dloaded Sequoia/ofbiz, went throught installation steps and everything >> worked fine. Data was there and I was albe to login. >> Now I have noticed big difference when I was running ofbiz with derby db >> and then with postgresql. With postgresql everything is much slower. The >> pages are loading slowely. Is there any way i can tweak that ? >> >> Also I am going now for production setup. >> I have created new database with new user(tested db and it worked fine), >> unzipped new sequoia packagae, changed entityengine.xml for proper info >> and run this command: >> $JAVA_HOME/bin/java -jar ofbiz.jar -install-readers=seed >> and I got this output : >> Exception in thread "main" java.io.IOException: Cannot >> load configuration properties : >> org/ofbiz/base/start/install-readers=seed.properties >> at >> org.ofbiz.base.start.Start$Config.getPropertiesFile(Start.java:500) >> at >> org.ofbiz.base.start.Start$Config.readConfig(Start.java:518) >> at >> org.ofbiz.base.start.Start.init(Start.java:75) >> at >> org.ofbiz.base.start.Start.main(Start.java:412) >> >> Console.log is emtpy. Any ideas what happen there ? >> >> Michal > > > _______________________________________________ > Users mailing list > [hidden email] > http://lists.ofbiz.org/mailman/listinfo/users _______________________________________________ Users mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/users |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |