Error Creating Static Asset in Admin 1.5.4
Posted: Thu Apr 19, 2012 2:15 pm
Hi all:
I'm trying to create a static asset in broadleaf admin; no code modifications have been made by myself to this section of the admin. When I click the add button in the Assets section of the Content Management module, I select my file and fill out the name and full URL fields, and then click upload. The following error message appears in the browser:
Could not execute JDBC batch update; SQL [insert into BLC_SANDBOX_ITEM (ARCHIVED_FLAG, CREATED_BY, DATE_CREATED, DATE_UPDATED, UPDATED_BY, DESCRIPTION, ORIGINAL_ITEM_ID, ORIG_SANDBOX_ID, SANDBOX_ID, SANDBOX_ITEM_TYPE, SANDBOX_OPERATION_TYPE, TEMPORARY_ITEM_ID, SANDBOX_ITEM_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
From my server log, the following appears stack trace appears. Is there some configuration I need to do before I can create this object in the admin? I am logged into the admin tool with the admin account.
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:467)
... 86 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into BLC_SANDBOX_ITEM (ARCHIVED_FLAG, CREATED_BY, DATE_CREATED, DATE_UPDATED, UPDATED_BY, DESCRIPTION, ORIGINAL_ITEM_ID, ORIG_SANDBOX_ID, SANDBOX_ID, SANDBOX_ITEM_TYPE, SANDBOX_OPERATION_TYPE, TEMPORARY_ITEM_ID, SANDBOX_ITEM_ID) values ('N', '1', '2012-04-19 14:45:45.040000 -04:00:00', NULL, NULL, '/img_storefront.jpg', NULL, NULL, '5000', 'STATIC_ASSET', 'ADD', '20', '200') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at com.sun.gjc.spi.base.StatementWrapper.executeBatch(StatementWrapper.java:585)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 102 more
Thanks for any help you can provide.
I'm trying to create a static asset in broadleaf admin; no code modifications have been made by myself to this section of the admin. When I click the add button in the Assets section of the Content Management module, I select my file and fill out the name and full URL fields, and then click upload. The following error message appears in the browser:
Could not execute JDBC batch update; SQL [insert into BLC_SANDBOX_ITEM (ARCHIVED_FLAG, CREATED_BY, DATE_CREATED, DATE_UPDATED, UPDATED_BY, DESCRIPTION, ORIGINAL_ITEM_ID, ORIG_SANDBOX_ID, SANDBOX_ID, SANDBOX_ITEM_TYPE, SANDBOX_OPERATION_TYPE, TEMPORARY_ITEM_ID, SANDBOX_ITEM_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
From my server log, the following appears stack trace appears. Is there some configuration I need to do before I can create this object in the admin? I am logged into the admin tool with the admin account.
Caused by: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:76)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:467)
... 86 more
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into BLC_SANDBOX_ITEM (ARCHIVED_FLAG, CREATED_BY, DATE_CREATED, DATE_UPDATED, UPDATED_BY, DESCRIPTION, ORIGINAL_ITEM_ID, ORIG_SANDBOX_ID, SANDBOX_ID, SANDBOX_ITEM_TYPE, SANDBOX_OPERATION_TYPE, TEMPORARY_ITEM_ID, SANDBOX_ITEM_ID) values ('N', '1', '2012-04-19 14:45:45.040000 -04:00:00', NULL, NULL, '/img_storefront.jpg', NULL, NULL, '5000', 'STATIC_ASSET', 'ADD', '20', '200') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at com.sun.gjc.spi.base.StatementWrapper.executeBatch(StatementWrapper.java:585)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 102 more
Thanks for any help you can provide.