CMDBuild Forum

Problem when importing from OCS

Old Versions
#1

Hello,

 

I have problems when i try to import data from OCS to CMDbuild.

I execute the tutorial : readme_en.txt from

external-connectors-1.3.1.0

 

I can see all the processes in CMDbuild with the name of my server. When i try to execute one (Inserimento Modifiche > Edit activity > Advance) that makes anything.

 

Here is the log (tomcat/logs/cmdbuild.log) with problem (i think that is shark which doesnt work) : 

 

INFO  2012-04-23 09:13:43 [jsonrpc ] Calling url /management/modworkflow/saveactivity

INFO  2012-04-23 09:13:43 [workflow] Updating workitem 695_991_Package_importocs_Process_importocs_InserimentoModifiche#admin

INFO  2012-04-23 09:13:44 [workflow] Event audit - Activity 695_991_Package_importocs_Process_importocs_InserimentoModifiche modified

WARN  2012-04-23 09:13:45 [workflow] the process 991_Package_importocs_Process_importocs in card 4462 was not found in Shark!

WARN  2012-04-23 09:13:45 [workflow] the process 991_Package_importocs_Process_importocs in card 4462 was not found in Shark!

WARN  2012-04-23 09:13:45 [workflow] the process 991_Package_importocs_Process_importocs in card 4462 was not found in Shark!

WARN  2012-04-23 09:13:46 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.Code

WARN  2012-04-23 09:13:46 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.Description

WARN  2012-04-23 09:13:46 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.FlowStatus

WARN  2012-04-23 09:13:46 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.ActivityDescription

ERROR 2012-04-23 09:13:46 [soap    ]

java.lang.NullPointerException

        at org.dom4j.DocumentHelper.getEncoding(DocumentHelper.java:292)

        at org.dom4j.DocumentHelper.parseText(DocumentHelper.java:273)

        at org.cmdbuild.services.soap.operation.ELegacySync.sync(ELegacySync.java:65)

        at org.cmdbuild.services.soap.PrivateImpl.sync(PrivateImpl.java:270)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

        at java.lang.reflect.Method.invoke(Unknown Source)

        at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:173)

        at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:89)

        at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:61)

        at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)

        at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

        at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

        at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

        at java.util.concurrent.FutureTask.run(Unknown Source)

        at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

        at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

        at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:255)

        at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:113)

        at org.apache.cxf.transport.servlet.ServletDestination.invoke(ServletDestination.java:102)

        at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:464)

        at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:188)

        at org.apache.cxf.transport.servlet.AbstractCXFServlet.invoke(AbstractCXFServlet.java:148)

        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:179)

        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:103)

        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:159)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:54)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:28)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:37)

        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)

        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:602)

        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)

        at java.lang.Thread.run(Unknown Source)

INFO  2012-04-23 09:13:46 [workflow] Event audit - Activity 768_991_Package_importocs_Process_importocs_callSyncWS modified

INFO  2012-04-23 09:13:46 [workflow] Event audit - Process instance 991_Package_importocs_Process_importocs changed state to closed.completed

INFO  2012-04-23 09:13:46 [jsonrpc ] Calling url /management/modcard/getcardposition

INFO  2012-04-23 09:13:46 [jsonrpc ] Calling url /management/modworkflow/getactivitylist

 

#2

Hello again,

 

I changed my Shark.conf.

And now i have this messages on cmdbuild.log :

 

INFO  2012-04-23 16:05:48 [jsonrpc ] Calling url /management/modworkflow/saveactivity
INFO  2012-04-23 16:05:48 [workflow] Updating workitem 1043_1343_Package_importocs_Process_importocs_InserimentoModifiche#admin
INFO  2012-04-23 16:05:48 [workflow] Event audit - Activity 1043_1343_Package_importocs_Process_importocs_InserimentoModifiche modified
WARN  2012-04-23 16:05:53 [workflow] the process 1343_Package_importocs_Process_importocs in card 5022 was not found in Shark!
WARN  2012-04-23 16:05:53 [workflow] the process 1343_Package_importocs_Process_importocs in card 5022 was not found in Shark!
WARN  2012-04-23 16:05:53 [workflow] the process 1343_Package_importocs_Process_importocs in card 5022 was not found in Shark!
WARN  2012-04-23 16:05:53 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.Code
WARN  2012-04-23 16:05:53 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.Description
WARN  2012-04-23 16:05:53 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.FlowStatus
WARN  2012-04-23 16:05:53 [persist ] Meta-attribute DATEEXPIRE not valid for attribute ImportOCS.ActivityDescription
WARN  2012-04-23 16:05:53 [org.apache.cxf.phase.PhaseInterceptorChain] Interceptor for {http://soap.services.cmdbuild.org}WebservicesImplService has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault: Message part {http://soap.services.cmdbuild.org}sync was not recognized.  (Does it exist in service WSDL?)
        at org.apache.cxf.interceptor.DocLiteralInInterceptor.handleMessage(DocLiteralInInterceptor.java:197)
....
        at java.lang.Thread.run(Unknown Source)
ERROR 2012-04-23 16:05:53 [workflow] Original workflow exception
AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode:
 faultString: org.enhydra.shark.api.internal.toolagent.ToolAgentGeneralException: Message part {http://soap.services.cmdbuild.org}sync was not recognized.  (Does it exist in service WSDL?)
 faultActor:
 faultNode:
 faultDetail:
        {http://xml.apache.org/axis/}hostname:Server

org.enhydra.shark.api.internal.toolagent.ToolAgentGeneralException: Message part {http://soap.services.cmdbuild.org}sync was not recognized.  (Does it exist in service WSDL?)
        at org.apache.axis.message.SOAPFaultBuilder.createFault(SOAPFaultBuilder.java:222)
....
        at java.lang.Thread.run(Unknown Source)
ERROR 2012-04-23 16:05:53 [workflow] error executing an action (cmdb) - WF_CANNOT_COMPLETE_WORKITEM
org.cmdbuild.exception.CMDBWorkflowException: WF_CANNOT_COMPLETE_WORKITEM
        at org.cmdbuild.exception.CMDBWorkflowException$WorkflowExceptionType.createException(CMDBWorkflowException.java:54)
....
        at java.lang.Thread.run(Unknown Source)
ERROR 2012-04-23 16:05:53 [jsonrpc ] A org.cmdbuild.servlets.json.JSONBase.PartialFailureException occurred calling method class org.cmdbuild.servlets.json.management.ModWorkflow.saveActivity

 

 

Here is my Shark.conf :

 

CMDBuild.Groovy.Repository=shark-d/script
CMDBuild.WS.ExtSync.EndPoint=http://localhost:8080/cmdbuild-d/services/soap/ExternalSync
CMDBuild.WS.EndPoint=http://localhost:8080/cmdbuild-d/services/soap/Webservices
CMDBuild.EndPoint=http://localhost:8080/cmdbuild-d/shark/
CMDBuild.WS.MaxConn=100

 

 

with the database : cmdbuild-d

 

Where is the problem?

 

#3

I found the solution.

 

Your tutorial for the connector is WRONG (readme_en):

 

"

....

6. create a new process inside CMDBuild, with two attributes:

- actionList - type TEXT (editing: hidden

)

- actionDetail - type TEXT (editing: editable)

And upload the xpdl for this process.

..."

 

Change hidden to editable.

 

And it's good.

#4

Thanks, but we are actually using it with the hidden filed mode and it works.

The error you were experimenting was due to the use our public webservice named  Webservices that not contains the method sync, instead of the Private one...
Are you sure you have not changed anything else?
The XPDL or something else?
Plus: the most recent connector version is the 1.4.0, I strongly reccomend to use that one...
 
Best regards,
Lisa