CMDBuild Forum

Report is not working

Old Versions
#1

Hello !

 

I was working with version 1.5 of cmdbuild.

 

Since 2 months, i work on the version 2.2.2.

 

 

 

Everything is fine, but i have a problem with one report. It worked perfectly on version 1.5 but since the version 2.2.2 the report is empty.

 

 

 

I tried to do this on my pc :

 

 

 

--

 

 

 

1 Cmdbuild 1.5 + 1 postgresql 9.3 database

 

1 cmdbuild 2.2.2 + 1 postgresql 9.3 database (with database update when i configure cmdbuild for the first time)

 

--

 

 

 

Both version of cmdbuild.

 

 

 

My report works on 1.5, but on 2.2.2 the rapport is empty

 

 

 

No error on log file. 

 

Any idea ?

 

 

#2

Does the report work, if you run it directly from iReport?

Does the SQL query extract the right data, if you run it from pgAdmin ?

CMDBuild Team

#3

Previously Tecnoteca wrote:

Does the report work, if you run it directly from iReport?

Does the SQL query extract the right data, if you run it from pgAdmin ?

CMDBuild Team

 

I opened the report with Jaspersoft Studio.
 
The report is working perfectly when the database connection = the database for the version 1.5
 
But same as on cmdbuild, the report is empty when the database connection = the database for the version 2.2.2
 
The only difference between theses database is the update when i upgrade cmdbuild to 2.2.2
 
Same on pgadmin.
 
 
#4

So it is not a report problem, but a SQL query problem.
Perhaps your query uses some feature of the CMDBuild data model that changed after version 1.5
CMDBuild Team

#5

Previously Tecnoteca wrote:

So it is not a report problem, but a SQL query problem.
Perhaps your query uses some feature of the CMDBuild data model that changed after version 1.5
CMDBuild Team

 

 
Ok, thank you. i will try to fix it :-)