This forum is in readonly mode and serves as an archive of old information. All posting, registration and commenting abilities have been turned off. To get help, the Broadleaf team reguarly monitors the broadleaf-commerce tag on Stack Overflow so please ask your questions there.

BLC build process creates only two tables in ORACLE database.After that getting the following error message in eclipse console log :-

[artifact:mvn] [ERROR] 19:21:36 SchemaExport - HHH000389: Unsuccessful: alter table SANDBOX_ITEM_ACTION add constraint FKB270D74A9797A024 foreign key (SANDBOX_ACTION_ID) references BLC_SANDBOX_ACTION[artifact:mvn] [ERROR] 19:21:36 SchemaExport - ORA-00942: table or view does not exist[artifact:mvn] [ERROR] 19:21:36 SchemaExport - HHH000389: Unsuccessful: create table SEQUENCE_GENERATOR ( ID_NAME varchar(255) not null , ID_VAL bigint, primary key ( ID_NAME ) ) [artifact:mvn] [ERROR] 19:21:36 SchemaExport - ORA-00902: invalid datatype[artifact:mvn] [ERROR] 19:21:36 SchemaExport - HHH000231: Schema export unsuccessful[artifact:mvn] org.hibernate.tool.hbm2ddl.ImportScriptException: Error during statement execution (file: '/config/bc/sql/load_admin_permissions.sql'): INSERT INTO BLC_ADMIN_PERMISSION (ADMIN_PERMISSION_ID, DESCRIPTION, NAME, PERMISSION_TYPE) VALUES (-1,'Default Permission','PERMISSION_OTHER_DEFAULT', 'OTHER')[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:451)[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:378)[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:304)[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:293)[artifact:mvn] at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:498)[artifact:mvn] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1743)[artifact:mvn] at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:94)[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:905)[artifact:mvn] at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:890)[artifact:mvn] at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:74)[artifact:mvn] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:288)[artifact:mvn] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:310)[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1547)[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1485)[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524)[artifact:mvn] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461)[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295)[artifact:mvn] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)[artifact:mvn] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:922)[artifact:mvn] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)[artifact:mvn] at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389)[artifact:mvn] at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294)[artifact:mvn] at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112)[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandler.callContextInitialized(ContextHandler.java:766)[artifact:mvn] at org.eclipse.jetty.servlet.ServletContextHandler.callContextInitialized(ServletContextHandler.java:406)[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:758)[artifact:mvn] at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:242)[artifact:mvn] at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1233)[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:701)[artifact:mvn] at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:475)[artifact:mvn] at org.mortbay.jetty.plugin.JettyWebAppContext.doStart(JettyWebAppContext.java:256)[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)[artifact:mvn] at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)[artifact:mvn] at org.eclipse.jetty.server.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java:167)[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)[artifact:mvn] at org.eclipse.jetty.server.handler.HandlerCollection.doStart(HandlerCollection.java:224)[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)[artifact:mvn] at org.eclipse.jetty.server.handler.HandlerWrapper.doStart(HandlerWrapper.java:90)[artifact:mvn] at org.eclipse.jetty.server.Server.doStart(Server.java:272)[artifact:mvn] at org.mortbay.jetty.plugin.JettyServer.doStart(JettyServer.java:65)[artifact:mvn] at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:59)[artifact:mvn] at org.mortbay.jetty.plugin.AbstractJettyMojo.startJetty(AbstractJettyMojo.java:511)[artifact:mvn] at org.mortbay.jetty.plugin.AbstractJettyMojo.execute(AbstractJettyMojo.java:364)[artifact:mvn] at org.mortbay.jetty.plugin.JettyRunMojo.execute(JettyRunMojo.java:516)[artifact:mvn] at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo(DefaultBuildPluginManager.java:101)[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:209)[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:153)[artifact:mvn] at org.apache.maven.lifecycle.internal.MojoExecutor.execute(MojoExecutor.java:145)[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:84)[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject(LifecycleModuleBuilder.java:59)[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.singleThreadedBuild(LifecycleStarter.java:183)[artifact:mvn] at org.apache.maven.lifecycle.internal.LifecycleStarter.execute(LifecycleStarter.java:161)[artifact:mvn] at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:320)[artifact:mvn] at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:156)[artifact:mvn] at org.apache.maven.cli.MavenCli.execute(MavenCli.java:537)[artifact:mvn] at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:196)[artifact:mvn] at org.apache.maven.cli.MavenCli.main(MavenCli.java:141)[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[artifact:mvn] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)[artifact:mvn] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[artifact:mvn] at java.lang.reflect.Method.invoke(Method.java:597)[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:290)[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:230)[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:409)[artifact:mvn] at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:352)[artifact:mvn] at org.codehaus.classworlds.Launcher.main(Launcher.java:47)[artifact:mvn] Caused by: java.sql.SQLException: ORA-00942: table or view does not exist[artifact:mvn] at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)[artifact:mvn] at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)[artifact:mvn] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)[artifact:mvn] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)[artifact:mvn] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)[artifact:mvn] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)[artifact:mvn] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)[artifact:mvn] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)[artifact:mvn] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)[artifact:mvn] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)[artifact:mvn] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)[artifact:mvn] at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:274)[artifact:mvn] at org.hibernate.tool.hbm2ddl.DatabaseExporter.export(DatabaseExporter.java:64)[artifact:mvn] at org.hibernate.tool.hbm2ddl.SchemaExport.importScript(SchemaExport.java:446)[artifact:mvn] ... 68 more[artifact:mvn] [ERROR] 19:21:41 Ejb3Configuration - HHH000050: Container is providing a null PersistenceUnitRootUrl: discovery impossible[artifact:mvn] [ WARN] 19:21:41 Ejb3Configuration - HHH000144: hibernate.connection.autocommit = false breaks the EJB3 specification[artifact:mvn] [ERROR] 19:21:41 SchemaUpdate - HHH000319: Could not get database metadata[artifact:mvn] java.sql.SQLException: ORA-00942: table or view does not exist