CMDBuild Forum

cannot get content of column 'MaintenanceRequest#FlowStatus#Description'

Old Versions
#1

Hi 

I've been testing a demo openmaint instance of ours and noticed we cannot 'advance' a Maintenance Request workflow instance. Had a look on the cmdbuild.log and see the following WARN msg:

 

WARN  2016-05-03 14:12:09 [sql     ] cannot get content of column 'MaintenanceRequest#FlowStatus#Description'

Any idea why this happened?

Thanks

Shawn

#2
I have recently upgraded the openMAINT instance with the latest CMDBuild 2.4. is this the cause of this problem?
 
I'm also getting this error:
 
...
2016-05-03 15:29:28,552: activity 'SYS03-SetData' started
2016-05-03 15:29:28,568: Activity[Process Id=17_Package_workorder_Process_workorder, Id=448_17_Package_workorder_Process_workorder_SYS03-SetData, ba=null, ActDefId=SYS03-SetData] - Executing script [type=text/java,value=ActivityStatus=cmdb.selectLookupByCode("ActivityStatus","EXECUTION");
StartDate=Calendar.getInstance().getTime();
GotoAcceptance=null;
card_request = null;
if(Request.checkValidity()){
card_request = cmdb.cardFrom(Request); 
}
if(card_request != null){
lookup_status = card_request.get("RequestStatus");
if(lookup_status != null && !"EXECUTION".equals(lookup_status.getCode())){
cmdb.existingProcessInstance("MaintenanceRequest",Request.getId())
.withAttribute("RequestStatus",cmdb.selectLookupByCode("ActivityStatus","EXECUTION"))
.update();
} 
if(card_request.get("StartDate") == null){
cmdb.existingProcessInstance("MaintenanceRequest",Request.getId())
.withAttribute("StartDate",StartDate)
.update();
}
}]
2016-05-03 15:29:28,569: loading workflow api 'org.cmdbuild.workflow.api.SoapSharkWorkflowApiFactory'
2016-05-03 15:29:28,569: loading class 'org.cmdbuild.workflow.api.SoapSharkWorkflowApiFactory' that should be a 'org.cmdbuild.workflow.api.SharkWorkflowApiFactory'
2016-05-03 15:29:28,611: loading mail api 'org.cmdbuild.common.api.mail.javax.mail.JavaxMailBasedMailApiFactory'
2016-05-03 15:29:28,611: loading class 'org.cmdbuild.common.api.mail.javax.mail.JavaxMailBasedMailApiFactory' that should be a 'org.cmdbuild.common.api.mail.MailApiFactory'
2016-05-03 15:29:28,682: BshToolAgent - application ActivityStatus=cmdb.selectLookupByCode("ActivityStatus","EXECUTION");
StartDate=Calendar.getInstance().getTime();
GotoAcceptance=null;
card_request = null;
if(Request.checkValidity()){
card_request = cmdb.cardFrom(Request); 
}if(card_request != null){
lookup_status = card_request.get("RequestStatus");
if(lookup_status != null && !"EXECUTION".equals(lookup_status.getCode())){
cmdb.existingProcessInstance("MaintenanceRequest",Request.getId())
.withAttribute("RequestStatus",cmdb.selectLookupByCode("ActivityStatus","EXECUTION"))
.update();
} 
if(card_request.get("StartDate") == null){
cmdb.existingProcessInstance("MaintenanceRequest",Request.getId())
.withAttribute("StartDate",StartDate)
.update();
}
} terminated incorrectly: Sourced file: eval stream : at Line: 6 : in file: eval stream : Request .checkValidity ( ) 
Target exception: java.lang.NullPointerException: Null Pointer in Method Invocation
2016-05-03 15:29:28,690: cannot execute tool agent - application  terminated incorrectly
Sourced file: eval stream : at Line: 6 : in file: eval stream : Request .checkValidity ( )
Target exception: java.lang.NullPointerException: Null Pointer in Method Invocation
...
#3

Hello,

the first error you are reporting (cannot get content of column 'MaintenanceRequest#FlowStatus#Description') is not indeed an error but just a warning in the log file, you should not worry about it.
The second problem (Request .checkValidity ( ) Target exception: java.lang.NullPointerException: Null Pointer) is due to a change in the initialization of process variables implemented in one of the last version of CMDBuild. To avoid it, please use openMAINT with the ceritified version of CMDBuild (2.3.1). In a couple of months we will release a new version of openMAINT, compatible with CMDBuild 2.4.
 
Best regards
CMDBuild Team
 
#4
Hi there,
so does it mean Request variable is one of process variable which was defined in <xpdl:DataField>..</xpdl:DataField> ? 
 
Previously Tecnoteca wrote:
Hello,
the first error you are reporting (cannot get content of column 'MaintenanceRequest#FlowStatus#Description') is not indeed an error but just a warning in the log file, you should not worry about it.
The second problem (Request .checkValidity ( ) Target exception: java.lang.NullPointerException: Null Pointer) is due to a change in the initialization of process variables implemented in one of the last version of CMDBuild. To avoid it, please use openMAINT with the ceritified version of CMDBuild (2.3.1). In a couple of months we will release a new version of openMAINT, compatible with CMDBuild 2.4.
 
Best regards
CMDBuild Team
 

 

#5
Yes, Request should be now defined among the process variables in <xpdl:DataFields>.
 
Best regards
CMDBuild Team
 
Previously Sandy wrote:
Hi there,
so does it mean Request variable is one of process variable which was defined in <xpdl:DataField>..</xpdl:DataField> ? 
 
Previously Tecnoteca wrote:
Hello,
the first error you are reporting (cannot get content of column 'MaintenanceRequest#FlowStatus#Description') is not indeed an error but just a warning in the log file, you should not worry about it.
The second problem (Request .checkValidity ( ) Target exception: java.lang.NullPointerException: Null Pointer) is due to a change in the initialization of process variables implemented in one of the last version of CMDBuild. To avoid it, please use openMAINT with the ceritified version of CMDBuild (2.3.1). In a couple of months we will release a new version of openMAINT, compatible with CMDBuild 2.4.
 
Best regards
CMDBuild Team