Problème avec l'intégration des rapports BIRT dans SpagoBI

**hakrimi** · 22/09/2010, 18h37

Bonjour
J'ai terminé l'installation de SpagoBI et je croyais que tout allais bien sauf que quand j'ai essayé d'ajouter un rapport BIRT à spagoBI je ne trouve pas l'arborescence là ou je dois cocher le chemin là où je dois placer le rapport
et j'ai en plus un message d'erreur en bas qui me dis:

error has occurred. Retry later.
If the problems persists, contact the system administrator.

j'ai essayé de voir les logs, j'ai trouvé plein d'erreur mais je ne sais pas ce que je dois faire
voici le log SpagBI

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
[main] 22 sept. 2010 17:35:39,479 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - ERROR: relation "jbpm_processdefinition" does not exist
[main] 22 sept. 2010 17:35:39,479 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - ERROR: relation "jbpm_processdefinition" does not exist
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ACTION (ID_ bigint not null auto_increment, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EXPRESSION_ text, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ACTION (ID_ bigint not null auto_increment, class char(1) not null, NAME_ varchar(255), ISPROPAGATIONALLOWED_ bit, ACTIONEXPRESSION_ varchar(255), ISASYNC_ bit, REFERENCEDACTION_ bigint, ACTIONDELEGATION_ bigint, EVENT_ bigint, PROCESSDEFINITION_ bigint, TIMERNAME_ varchar(255), DUEDATE_ varchar(255), REPEAT_ varchar(255), TRANSITIONNAME_ varchar(255), TIMERACTION_ bigint, EXPRESSION_ text, EVENTINDEX_ integer, EXCEPTIONHANDLER_ bigint, EXCEPTIONHANDLERINDEX_ integer, primary key (ID_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 47
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 47
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_BYTEARRAY (ID_ bigint not null auto_increment, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_BYTEARRAY (ID_ bigint not null auto_increment, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 50
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 50
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: type "blob" does not exist
  Position*: 67
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: type "blob" does not exist
  Position*: 67
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_COMMENT (ID_ bigint not null auto_increment, VERSION_ integer not null, ACTORID_ varchar(255), TIME_ datetime, MESSAGE_ text, TOKEN_ bigint, TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_COMMENT (ID_ bigint not null auto_increment, VERSION_ integer not null, ACTORID_ varchar(255), TIME_ datetime, MESSAGE_ text, TOKEN_ bigint, TASKINSTANCE_ bigint, TOKENINDEX_ integer, TASKINSTANCEINDEX_ integer, primary key (ID_))
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 48
[main] 22 sept. 2010 17:35:39,541 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 48
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_DELEGATION (ID_ bigint not null auto_increment, CLASSNAME_ text, CONFIGURATION_ text, CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_DELEGATION (ID_ bigint not null auto_increment, CLASSNAME_ text, CONFIGURATION_ text, CONFIGTYPE_ varchar(255), PROCESSDEFINITION_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 51
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 51
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_EVENT (ID_ bigint not null auto_increment, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_EVENT (ID_ bigint not null auto_increment, EVENTTYPE_ varchar(255), TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 46
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 46
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null auto_increment, EXCEPTIONCLASSNAME_ text, TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_EXCEPTIONHANDLER (ID_ bigint not null auto_increment, EXCEPTIONCLASSNAME_ text, TYPE_ char(1), GRAPHELEMENT_ bigint, PROCESSDEFINITION_ bigint, GRAPHELEMENTINDEX_ integer, NODE_ bigint, TRANSITION_ bigint, TASK_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 57
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 57
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ID_GROUP (ID_ bigint not null auto_increment, CLASS_ char(1) not null, NAME_ varchar(255), TYPE_ varchar(255), PARENT_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ID_GROUP (ID_ bigint not null auto_increment, CLASS_ char(1) not null, NAME_ varchar(255), TYPE_ varchar(255), PARENT_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 49
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 49
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ID_MEMBERSHIP (ID_ bigint not null auto_increment, CLASS_ char(1) not null, NAME_ varchar(255), ROLE_ varchar(255), USER_ bigint, GROUP_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ID_MEMBERSHIP (ID_ bigint not null auto_increment, CLASS_ char(1) not null, NAME_ varchar(255), ROLE_ varchar(255), USER_ bigint, GROUP_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 54
[main] 22 sept. 2010 17:35:39,557 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 54
[main] 22 sept. 2010 17:35:39,573 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ID_USER (ID_ bigint not null auto_increment, CLASS_ char(1) not null, NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
[main] 22 sept. 2010 17:35:39,573 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_ID_USER (ID_ bigint not null auto_increment, CLASS_ char(1) not null, NAME_ varchar(255), EMAIL_ varchar(255), PASSWORD_ varchar(255), primary key (ID_))
[main] 22 sept. 2010 17:35:39,573 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 48
[main] 22 sept. 2010 17:35:39,573 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:259 - ERROR: syntax error at or near "auto_increment"
  Position*: 48
[main] 22 sept. 2010 17:35:39,573 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_LOG (ID_ bigint not null auto_increment, CLASS_ char(1) not null, INDEX_ integer, DATE_ datetime, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ text, EXCEPTION_ text, ACTION_ bigint, NODE_ bigint, ENTER_ datetime, LEAVE_ datetime, DURATION_ bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint, DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_ datetime, NEWDATEVALUE_ datetime, OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_ double precision, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ text, NEWSTRINGVALUE_ text, TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
[main] 22 sept. 2010 17:35:39,573 ERROR org.hibernate.tool.hbm2ddl.SchemaExport.create:258 - Unsuccessful: create table JBPM_LOG (ID_ bigint not null auto_increment, CLASS_ char(1) not null, INDEX_ integer, DATE_ datetime, TOKEN_ bigint, PARENT_ bigint, MESSAGE_ text, EXCEPTION_ text, ACTION_ bigint, NODE_ bigint, ENTER_ datetime, LEAVE_ datetime, DURATION_ bigint, NEWLONGVALUE_ bigint, TRANSITION_ bigint, CHILD_ bigint, SOURCENODE_ bigint, DESTINATIONNODE_ bigint, VARIABLEINSTANCE_ bigint, OLDBYTEARRAY_ bigint, NEWBYTEARRAY_ bigint, OLDDATEVALUE_ datetime, NEWDATEVALUE_ datetime, OLDDOUBLEVALUE_ double precision, NEWDOUBLEVALUE_ double precision, OLDLONGIDCLASS_ varchar(255), OLDLONGIDVALUE_ bigint, NEWLONGIDCLASS_ varchar(255), NEWLONGIDVALUE_ bigint, OLDSTRINGIDCLASS_ varchar(255), OLDSTRINGIDVALUE_ varchar(255), NEWSTRINGIDCLASS_ varchar(255), NEWSTRINGIDVALUE_ varchar(255), OLDLONGVALUE_ bigint, OLDSTRINGVALUE_ text, NEWSTRINGVALUE_ text, TASKINSTANCE_ bigint, TASKACTORID_ varchar(255), TASKOLDACTORID_ varchar(255), SWIMLANEINSTANCE_ bigint, primary key (ID_))
...
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
  Indice*: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position*: 412
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
	at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:137)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1676)
	at org.hibernate.loader.Loader.doQuery(Loader.java:662)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
	at org.hibernate.loader.Loader.doList(Loader.java:2147)
	... 44 more
[http-8080-1] 22 sept. 2010 17:36:00,746 ERROR it.eng.spagobi._jspService:67 - it.eng.spago.error.EMFInternalError: severity [ERROR] description [100]

voici le contenu du log Catalina

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
23 sept. 2010 10:46:00 org.apache.coyote.http11.Http11Protocol pause
INFO: Suspension de Coyote HTTP/1.1 sur http-8080
23 sept. 2010 10:46:01 org.apache.catalina.core.StandardService stop
INFO: Arrï¿½t du service Catalina
23 sept. 2010 10:46:04 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jdk1.6.0_21\bin;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk1.6.0_21\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Intel\DMIX;C:\Program Files\NTRU Cryptosystems\NTRU TCG Software Stack\bin\;C:\Program Files\Wave Systems Corp\Gemalto\Access Client\v5\;c:\Program Files\Fichiers communs\Roxio Shared\DLLShared\;c:\Program Files\Fichiers communs\Roxio Shared\10.0\DLLShared\;C:\Program Files\Java\jdk1.6.0_21;C:\Program Files\miktex\miktex\bin
23 sept. 2010 10:46:04 org.apache.coyote.http11.Http11Protocol init
INFO: Initialisation de Coyote HTTP/1.1 sur http-8080
23 sept. 2010 10:46:04 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 219 ms
23 sept. 2010 10:46:04 org.apache.catalina.core.StandardService start
INFO: Dï¿½marrage du service Catalina
23 sept. 2010 10:46:04 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.18
23 sept. 2010 10:46:04 org.apache.catalina.startup.HostConfig deployDescriptor
ATTENTION: A docBase C:\Documents and Settings\hakrimi\Mes documents\Téléchargements\apache-tomcat-6.0.18\apache-tomcat-6.0.18\webapps\SpagoBI inside the host appBase has been specified, and will be ignored
23 sept. 2010 10:46:05 org.apache.catalina.session.PersistentManagerBase start
GRAVE: No Store configured, persistence disabled
23 sept. 2010 10:46:09 org.apache.catalina.startup.HostConfig deployDescriptor
ATTENTION: A docBase C:\Documents and Settings\hakrimi\Mes documents\Téléchargements\apache-tomcat-6.0.18\apache-tomcat-6.0.18\webapps\SpagoBIBirtReportEngine inside the host appBase has been specified, and will be ignored
23 sept. 2010 10:46:11 org.apache.catalina.session.PersistentManagerBase start
GRAVE: No Store configured, persistence disabled
23 sept. 2010 10:46:11 org.apache.catalina.startup.HostConfig deployDescriptor
ATTENTION: A docBase C:\Documents and Settings\hakrimi\Mes documents\Téléchargements\apache-tomcat-6.0.18\apache-tomcat-6.0.18\webapps\SpagoBIJPivotEngine inside the host appBase has been specified, and will be ignored
23 sept. 2010 10:46:11 org.apache.catalina.session.PersistentManagerBase start
GRAVE: No Store configured, persistence disabled
23 sept. 2010 10:46:11 org.apache.coyote.http11.Http11Protocol start
INFO: Dï¿½marrage de Coyote HTTP/1.1 sur http-8080
23 sept. 2010 10:46:11 org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
23 sept. 2010 10:46:11 org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/31  config=null
23 sept. 2010 10:46:11 org.apache.catalina.startup.Catalina start
INFO: Server startup in 6813 ms
23 sept. 2010 10:48:59 org.apache.coyote.http11.Http11Protocol pause
INFO: Suspension de Coyote HTTP/1.1 sur http-8080
23 sept. 2010 10:49:00 org.apache.catalina.core.StandardService stop
INFO: Arrï¿½t du service Catalina

**hakrimi** · 30/09/2010, 12h18

Mon problème est résolu
il suffisait que je modifie cette ligne dans "SpagoBI.xml"

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

<HIBERNATE-CFGFILE>hibernate.cfg.postgres.xml</HIBERNATE-CFGFILE>

Problème avec l'intégration des rapports BIRT dans SpagoBI [SBI BIRT]

SpagoBI

Discussions similaires

Partager

Partager