Word - SpagoBI

[SPAGOBI-1733] Problem with PostgreSQL and table
SBI_AUTHORIZATIONS Created: 18/Apr/14 Updated: 11/Jul/14 Resolved: 11/Jul/14
Status:
Closed
Project:
SpagoBI
Component/s:
None
Affects
Version/s:
4.2
Fix Version/s:
4.2
Type:
Bug
Priority:
Major
Reporter:
Welsh Georges
Assignee:
Marco Cortella
Resolution:
Fixed
Votes:
0
Labels:
None
Remaining
Estimate:
Not Specified
Time Spent:
Not Specified
Original
Estimate:
Not Specified
Attachments:
PG_create_quartz_schema.sql
Bug type:
New bug
Description
I use SpagoBI 4.2 with PostgreSQL 9.3.
I executed the "PG_create.sql" and "PG_create_quartz_schema.sql" scripts but when I start the server, I have the
following errors:
[localhost-startStop-1] 18 avr. 2014 13:07:37,043 ERROR
org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - L'élément du batch 0 insert into
SBI_AUTHORIZATIONS (NAME, USER_IN, USER_UP, USER_DE, TIME_IN, TIME_UP, TIME_DE,
SBI_VERSION_IN, SBI_VERSION_UP, SBI_VERSION_DE, ORGANIZATION, ID) values
('SAVE_SUBOBJECTS', 'server', NULL, NULL, '2014-04-18 13:07:36.928000 +02:00:00', NULL, NULL, '4.0',
NULL, NULL, 'SPAGOBI', 1) a été annulé. Appeler getNextException pour en connaître la cause.
[localhost-startStop-1] 18 avr. 2014 13:07:37,043 ERROR
org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - L'élément du batch 0 insert into
SBI_AUTHORIZATIONS (NAME, USER_IN, USER_UP, USER_DE, TIME_IN, TIME_UP, TIME_DE,
SBI_VERSION_IN, SBI_VERSION_UP, SBI_VERSION_DE, ORGANIZATION, ID) values
('SAVE_SUBOBJECTS', 'server', NULL, NULL, '2014-04-18 13:07:36.928000 +02:00:00', NULL, NULL, '4.0',
NULL, NULL, 'SPAGOBI', 1) a été annulé. Appeler getNextException pour en connaître la cause.
[localhost-startStop-1] 18 avr. 2014 13:07:37,044 ERROR
org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - ERROR: null value in column "creation_date"

violates not-null constraint
Détail : Failing row contains (1, SAVE_SUBOBJECTS, null, null, server, null, null, 2014-04-18 13:07:36.928,
null, null, 4.0, null, null, null, SPAGOBI).
[localhost-startStop-1] 18 avr. 2014 13:07:37,044 ERROR
org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - ERROR: null value in column "creation_date"
violates not-null constraint
Détail : Failing row contains (1, SAVE_SUBOBJECTS, null, null, server, null, null, 2014-04-18 13:07:36.928,
null, null, 4.0, null, null, null, SPAGOBI).
[localhost-startStop-1] 18 avr. 2014 13:07:37,047 ERROR
it.eng.spagobi.commons.dao.AbstractHibernateDAO.logException:225 -
org.hibernate.exception.ConstraintViolationException Could not execute JDBC batch update
org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
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 it.eng.spagobi.commons.dao.RoleDAOHibImpl.insertAuthorization(RoleDAOHibImpl.java:1231)
at
it.eng.spagobi.security.init.InternalSecurityInitializer.initDefaultAuthorizations(InternalSecurityInitializer.java:523)
at it.eng.spagobi.security.init.InternalSecurityInitializer.init(InternalSecurityInitializer.java:65)
at it.eng.spago.init.InitializerManager.init(InitializerManager.java:79)
at it.eng.spago.configuration.ConfigServlet.init(ConfigServlet.java:115)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1280)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1193)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1088)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5176)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5460)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:633)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1120)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1678)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.BatchUpdateException: L'élément du batch 0 insert into SBI_AUTHORIZATIONS (NAME,

USER_IN, USER_UP, USER_DE, TIME_IN, TIME_UP, TIME_DE, SBI_VERSION_IN, SBI_VERSION_UP,
SBI_VERSION_DE, ORGANIZATION, ID) values ('SAVE_SUBOBJECTS', 'server', NULL, NULL, '2014-04-18
13:07:36.928000 +02:00:00', NULL, NULL, '4.0', NULL, NULL, 'SPAGOBI', 1) a été annulé. Appeler
getNextException pour en connaître la cause.
at
org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2740)
at org.postgresql.core.v3.QueryExecutorImpl$1.handleError(QueryExecutorImpl.java:461)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1891)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:405)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2889)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 28 more
Comments
Comment by Marco Cortella [ 11/Jul/14 ]
Fixed script with the creation of the table SBI_AUTHORIZATIONS.
Generated at Sat Apr 15 19:00:25 CEST 2017 using JIRA 7.2.2#72004-
sha1:9d5132893cc8c728a3601a9034a1f8547ef5c7be.