CMDBuild Forum

sql warning "cannot get content of column" ....#Description

Old Versions
#1

Hello,

After upgrading to version 2.3.2 i got warning messages in cmdbuild.log file for a "ExtAdmin" domain and a Lookup type.  Following is extraction of these warnings out of cmdbuild.log:

WARN  2015-06-18 09:28:09 [sql     ] cannot get content of column 'HostingServer#CustNoReboot#Description'

WARN  2015-06-18 09:28:09 [sql     ] cannot get content of column 'HostingServer#ExtAdmin#Description'

WARN  2015-06-18 10:18:39 [sql     ] cannot get content of column 'VirtualServer#ExtAdmin#Description'

WARN  2015-06-18 10:18:39 [sql     ] cannot get content of column 'VirtualServer#Brand#Description'

WARN  2015-06-18 10:18:39 [sql     ] cannot get content of column 'VirtualServer#Supplier#Description'

 

WARN  2015-06-18 10:19:13 [sql     ] cannot get content of column 'StandardServer#ExtAdmin#Description'

 

WARN  2015-06-18 10:19:52 [sql     ] cannot get content of column 'Workstation#ExtAdmin#Description'

 

WARN  2015-06-18 10:20:24 [sql     ] cannot get content of column 'Switches#ExtAdmin#Description'

 

Domain "ExtAdmin":

Name: ExtAdmin

Domain description: ExtAdmin

Origin: Supplier

Destination: Assets

Direct description: Supplier manages Asset

Inverse description: Asset is managed by Supplier

Cardinality: 1:N

Master/Detail:

Active: yes

 

Lookup type "YesNoType":

Description: YesNoType

Parent:

 

Tab "Lookup List":

Description: Yes, No  (both active)

 

It is always pointing to the column "Description" ???

#2

Dear Eric,

that message is not something peculiar of the new version. It is related to the fact that for reference and lookup attributes the description of the linked card is fetched for serializing the attributes. However it is just a warning, nothing you have to worry about. 
 
Best regards
CMDBuild Team
#3

Previously Tecnoteca wrote:

Dear Eric,
that message is not something peculiar of the new version. It is related to the fact that for reference and lookup attributes the description of the linked card is fetched for serializing the attributes. However it is just a warning, nothing you have to worry about. 
 
Best regards
CMDBuild Team

 

I have two questions:
- How can i solve this issue.  Now the log file cmdbuild.log is growing fast.
- Although this is just a warning, when i try to "Clone a card" i get an error message (popup) after saving this.  Pressing "Cancel" and do a refresh, the cloned card is added ?
 
INFO  2015-06-19 09:01:33 [jsonrpc ] Calling url /management/modcard/getcardlistshort
INFO  2015-06-19 09:01:33 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO  2015-06-19 09:01:33 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO  2015-06-19 09:01:33 [cmdbuild] Filter is a CQL filter
INFO  2015-06-19 09:02:02 [jsonrpc ] Calling url /management/modcard/updatecard
INFO  2015-06-19 09:02:02 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO  2015-06-19 09:02:02 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
WARN  2015-06-19 09:02:02 [sql     ] cannot get content of column 'Switches#ExtAdmin#Description'
ERROR 2015-06-19 09:02:02 [jsonrpc ] A java.util.NoSuchElementException occurred calling method class org.cmdbuild.servlets.json.management.ModCard.updateCard
java.util.NoSuchElementException
        at java.util.ArrayList$Itr.next(ArrayList.java:834)
        at org.cmdbuild.dao.query.DBQueryResult.getOnlyRow(DBQueryResult.java:55)
        at org.cmdbuild.services.store.DBLayerMetadataStore.getLayerMetadataCard(DBLayerMetadataStore.java:172)
        at org.cmdbuild.services.store.DBLayerMetadataStore.get(DBLayerMetadataStore.java:68)
        at org.cmdbuild.logic.DefaultGISLogic.updateFeatures(DefaultGISLogic.java:208)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
:
        at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:1771)
        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)
INFO  2015-06-19 09:02:04 [jsonrpc ] Calling url /management/modcard/unlockcard
INFO  2015-06-19 09:02:04 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO  2015-06-19 09:02:04 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO  2015-06-19 09:02:04 [jsonrpc ] Calling url /utils/generateid
INFO  2015-06-19 09:02:58 [jsonrpc ] Calling url /management/modcard/getcardlist
INFO  2015-06-19 09:02:58 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO  2015-06-19 09:02:58 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
WARN  2015-06-19 09:02:58 [sql     ] cannot get content of column 'Switches#ExtAdmin#Description'
WARN  2015-06-19 09:02:58 [sql     ] cannot get content of column 'Switches#ExtAdmin#Description'
WARN  2015-06-19 09:02:58 [sql     ] cannot get content of column 'Switches#ExtAdmin#Description'
WARN  2015-06-19 09:02:58 [sql     ] cannot get content of column 'Switches#ExtAdmin#Description'
INFO  2015-06-19 09:02:59 [jsonrpc ] Calling url /management/modcard/getcard
INFO  2015-06-19 09:02:59 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
INFO  2015-06-19 09:02:59 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'
WARN  2015-06-19 09:02:59 [sql     ] cannot get content of column 'Switches#ExtAdmin#Description'
INFO  2015-06-19 09:02:59 [cmdbuild] getting where clause
INFO  2015-06-19 09:02:59 [cmdbuild] getting where clause
 
#4

For avoiding the log to grow too much you can change the level of the logs from the WEB-INF/conf/log4j.conf and set the sql log to “error” level.


We are not aware of any bug for the "Clone card", so the issue should be something specific of your database. You can try to increase the level logs in order to obtain a more explanatory error message in the log. 
 
Best regards
CMDBuild Team