CMDBuild Forum

Error upgrading from v2.0 to v2.3.2

Old Versions
#1

Hi

I tried to upgrade from version 2.0 to version 2.3.2 today and hit a number of errors.

Do I need to upgrade in smaller steps?

The upgrade goes smoothly and all the patches applied without any errors however when I log on I get this error - "Lookup type FlowStatus non found" :-

Call: services/json/schema/modlookup/getlookuplist
---------------------------------------------------
Error: org.cmdbuild.exception.NotFoundException: LOOKUP_TYPE_NOTFOUND FlowStatus
	at org.cmdbuild.exception.NotFoundException$NotFoundExceptionType.createException(NotFoundException.java:20)
	at org.cmdbuild.logic.data.lookup.LookupLogic$Exceptions.lookupTypeNotFound(LookupLogic.java:110)
	at org.cmdbuild.logic.data.lookup.LookupLogic.getAllLookup(LookupLogic.java:340)
	at org.cmdbuild.servlets.json.schema.ModLookup.getLookupList(ModLookup.java:121)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	...................

However looking in the database there are 5 FlowStatus.

Also if I go into the 'Administration Module' I get this error "An Error has occured"

Call: services/json/schema/modsecurity/getgrouplist
----------------------------------------------------
Error: java.lang.NoClassDefFoundError: org/postgresql/jdbc4/Jdbc4Array
	at org.cmdbuild.dao.driver.postgres.SqlType$14.sqlToJavaValue(SqlType.java:219)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.addUserAttributes(EntryQueryCommand.java:238)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.createBasicCards(EntryQueryCommand.java:152)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.processRow(EntryQueryCommand.java:101)
	at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1492)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)

And on the Admin screen the Users and Groups are no longer shown however they are in the database and must be accessable as I can login using my credentials.

Any suggestions will be great as I want to make use of some of the new features.

Thanks

#2
Dear Karl,
 
talking about LookUp issue: are you able to post the rows of "LookUp" table where "Type" is "FlowStatus"?
 
And talking about PostgreSQL issue: which version of JDBC driver is installed?
 
Best regards.
 
-- CMDBuild Team
 
Previously Karl wrote:

Hi

I tried to upgrade from version 2.0 to version 2.3.2 today and hit a number of errors.

Do I need to upgrade in smaller steps?

The upgrade goes smoothly and all the patches applied without any errors however when I log on I get this error - "Lookup type FlowStatus non found" :-

Call: services/json/schema/modlookup/getlookuplist
---------------------------------------------------
Error: org.cmdbuild.exception.NotFoundException: LOOKUP_TYPE_NOTFOUND FlowStatus
	at org.cmdbuild.exception.NotFoundException$NotFoundExceptionType.createException(NotFoundException.java:20)
	at org.cmdbuild.logic.data.lookup.LookupLogic$Exceptions.lookupTypeNotFound(LookupLogic.java:110)
	at org.cmdbuild.logic.data.lookup.LookupLogic.getAllLookup(LookupLogic.java:340)
	at org.cmdbuild.servlets.json.schema.ModLookup.getLookupList(ModLookup.java:121)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	...................

 

However looking in the database there are 5 FlowStatus.

Also if I go into the 'Administration Module' I get this error "An Error has occured"

Call: services/json/schema/modsecurity/getgrouplist
----------------------------------------------------
Error: java.lang.NoClassDefFoundError: org/postgresql/jdbc4/Jdbc4Array
	at org.cmdbuild.dao.driver.postgres.SqlType$14.sqlToJavaValue(SqlType.java:219)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.addUserAttributes(EntryQueryCommand.java:238)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.createBasicCards(EntryQueryCommand.java:152)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.processRow(EntryQueryCommand.java:101)
	at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1492)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)

 

And on the Admin screen the Users and Groups are no longer shown however they are in the database and must be accessable as I can login using my credentials.

Any suggestions will be great as I want to make use of some of the new features.

Thanks

 

#3

The lookup rows are as follows

:

 Id | IdClass  | User |         BeginDate

 |            Code            | Description | Stat

us | Notes |    Type     | ParentType | ParentId |

 Number | IsDefault |           TranslationUuid

 

  1 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | open.running               | Running     | A

   |       | Flow Status |            |          |

      1 | t         | 6163c31b-a955-0f1d-4305-71e1

56864840

  2 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | open.not_running.suspended | Suspended   | A

   |       | Flow Status |            |          |

      2 | f         | e1244447-681c-52de-81c5-f717

48f3e6ea

  3 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | closed.completed           | Completed   | A

   |       | Flow Status |            |          |

      3 | f         | fb0fa6d7-2be3-fc5d-74a7-e741

0faa4597

  4 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | closed.terminated          | Terminated  | A

   |       | Flow Status |            |          |

      4 | f         | d49f96ac-c936-0cd6-b087-4c02

453d52c7

  5 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | closed.aborted             | Aborted     | A

   |       | Flow Status |            |          |

      5 | f         | 9d57bb76-8c69-5c68-2fdb-51f7

420f7db0

 

and the version of PSQL is version

9.1.6

and we are using this driver 'postgresql-9.1-903.jdbc3.jar'

 

Thanks

 

Previously Tecnoteca wrote:
Dear Karl,
 
talking about LookUp issue: are you able to post the rows of "LookUp" table where "Type" is "FlowStatus"?
 
And talking about PostgreSQL issue: which version of JDBC driver is installed?
 
Best regards.
 
-- CMDBuild Team
 
Previously Karl wrote:

Hi

I tried to upgrade from version 2.0 to version 2.3.2 today and hit a number of errors.

Do I need to upgrade in smaller steps?

The upgrade goes smoothly and all the patches applied without any errors however when I log on I get this error - "Lookup type FlowStatus non found" :-

Call: services/json/schema/modlookup/getlookuplist
---------------------------------------------------
Error: org.cmdbuild.exception.NotFoundException: LOOKUP_TYPE_NOTFOUND FlowStatus
	at org.cmdbuild.exception.NotFoundException$NotFoundExceptionType.createException(NotFoundException.java:20)
	at org.cmdbuild.logic.data.lookup.LookupLogic$Exceptions.lookupTypeNotFound(LookupLogic.java:110)
	at org.cmdbuild.logic.data.lookup.LookupLogic.getAllLookup(LookupLogic.java:340)
	at org.cmdbuild.servlets.json.schema.ModLookup.getLookupList(ModLookup.java:121)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	...................

 

However looking in the database there are 5 FlowStatus.

Also if I go into the 'Administration Module' I get this error "An Error has occured"

Call: services/json/schema/modsecurity/getgrouplist
----------------------------------------------------
Error: java.lang.NoClassDefFoundError: org/postgresql/jdbc4/Jdbc4Array
	at org.cmdbuild.dao.driver.postgres.SqlType$14.sqlToJavaValue(SqlType.java:219)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.addUserAttributes(EntryQueryCommand.java:238)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.createBasicCards(EntryQueryCommand.java:152)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.processRow(EntryQueryCommand.java:101)
	at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1492)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)

 

And on the Admin screen the Users and Groups are no longer shown however they are in the database and must be accessable as I can login using my credentials.

Any suggestions will be great as I want to make use of some of the new features.

Thanks

 

 

#4
Dear Karl,
 
within database the type is "Flow Status" (with a space), but it must be "FlowStatus" (without the space).
 
Try to use the jdbc4 version of the library.
 
Best regards.
 
-- CMDBuild Team
 
Previously Karl wrote:
The lookup rows are as follows

:

 Id | IdClass  | User |         BeginDate

 |            Code            | Description | Stat

us | Notes |    Type     | ParentType | ParentId |

 Number | IsDefault |           TranslationUuid

 

  1 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | open.running               | Running     | A

   |       | Flow Status |            |          |

      1 | t         | 6163c31b-a955-0f1d-4305-71e1

56864840

  2 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | open.not_running.suspended | Suspended   | A

   |       | Flow Status |            |          |

      2 | f         | e1244447-681c-52de-81c5-f717

48f3e6ea

  3 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | closed.completed           | Completed   | A

   |       | Flow Status |            |          |

      3 | f         | fb0fa6d7-2be3-fc5d-74a7-e741

0faa4597

  4 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | closed.terminated          | Terminated  | A

   |       | Flow Status |            |          |

      4 | f         | d49f96ac-c936-0cd6-b087-4c02

453d52c7

  5 | "LookUp" |      | 2015-06-10 09:59:28.497143

 | closed.aborted             | Aborted     | A

   |       | Flow Status |            |          |

      5 | f         | 9d57bb76-8c69-5c68-2fdb-51f7

420f7db0

 

and the version of PSQL is version

9.1.6

and we are using this driver 'postgresql-9.1-903.jdbc3.jar'

 

Thanks

 

Previously Tecnoteca wrote:
Dear Karl,
 
talking about LookUp issue: are you able to post the rows of "LookUp" table where "Type" is "FlowStatus"?
 
And talking about PostgreSQL issue: which version of JDBC driver is installed?
 
Best regards.
 
-- CMDBuild Team
 
Previously Karl wrote:

Hi

I tried to upgrade from version 2.0 to version 2.3.2 today and hit a number of errors.

Do I need to upgrade in smaller steps?

The upgrade goes smoothly and all the patches applied without any errors however when I log on I get this error - "Lookup type FlowStatus non found" :-

Call: services/json/schema/modlookup/getlookuplist
---------------------------------------------------
Error: org.cmdbuild.exception.NotFoundException: LOOKUP_TYPE_NOTFOUND FlowStatus
	at org.cmdbuild.exception.NotFoundException$NotFoundExceptionType.createException(NotFoundException.java:20)
	at org.cmdbuild.logic.data.lookup.LookupLogic$Exceptions.lookupTypeNotFound(LookupLogic.java:110)
	at org.cmdbuild.logic.data.lookup.LookupLogic.getAllLookup(LookupLogic.java:340)
	at org.cmdbuild.servlets.json.schema.ModLookup.getLookupList(ModLookup.java:121)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	...................

 

However looking in the database there are 5 FlowStatus.

Also if I go into the 'Administration Module' I get this error "An Error has occured"

Call: services/json/schema/modsecurity/getgrouplist
----------------------------------------------------
Error: java.lang.NoClassDefFoundError: org/postgresql/jdbc4/Jdbc4Array
	at org.cmdbuild.dao.driver.postgres.SqlType$14.sqlToJavaValue(SqlType.java:219)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.addUserAttributes(EntryQueryCommand.java:238)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.createBasicCards(EntryQueryCommand.java:152)
	at org.cmdbuild.dao.driver.postgres.EntryQueryCommand$ResultFiller.processRow(EntryQueryCommand.java:101)
	at org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1492)
	at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:651)

 

And on the Admin screen the Users and Groups are no longer shown however they are in the database and must be accessable as I can login using my credentials.

Any suggestions will be great as I want to make use of some of the new features.

Thanks

 

 

 

#5

Hi

I changed "Flow Status" to "FlowStatus" and upgraded the driver to postgresql-9.4-1201.jdbc4.jar and all now works even some other things that were also not fully functional like my Reports had disappeared but they are now visable again.

 

Thanks for the fast and precise responses.

Regards

#6

Hi, 

 
Same problem here:
 
java.lang.NoClassDefFoundError: org/postgresql/jdbc4/Jdbc4Array

This error didn't appear after fresh installation of version 2.3.4
It started appearing after trying to configure group permissions over classes. I mean: I went to Users and Groups, selected a group, went to Permissions tab and tried to give read permissions to the group, and the application crashed.
 
My postgresql driver version is postgresql-9.4.1208.jre6.jar
#7
Hello Alex,
for version 2.4 of CMDBuild, you must pick this version of the driver “JDBC42 Postgresql Driver, Version 9.4-1208” https://jdbc.postgresql.org/download.html.
 
Kind regards
CMDBuild Team

#8

Previously Tecnoteca wrote:

Hello Alex,
for version 2.4 of CMDBuild, you must pick this version of the driver “JDBC42 Postgresql Driver, Version 9.4-1208” https://jdbc.postgresql.org/download.html.
 
Kind regards
CMDBuild Team

Hi,
 
But my cmdbuild version is 2.3.4. What driver should I use?
#9

If you are using 2.3.x version we advise you to use Postgres 9.3 with this driver: postgresql-9.3-1101.jdbc4.jar.

 
CMDBuild Team