CMDBuild Forum

OCS import woes (java stack trace) with basic-connector

Old Versions
#1

I have been working my way through the connector documentation and thought I did everything right, but I'm getting a java stack trace in the cmdbuild.log file whenever I run the connector script. Does anyone have any ideas what I am doing wrong?

I have created the views in the OCS database and it appears that the connector is talking to both the OCS directory and CMDBuild properly. I see the queries in the access log. However, the POST requests always result in a 502 and a stack trace. The basic-connector log looks good except for the "Fault occurred while processing" error:

Reading card nr. 6 - Code: time-2014-07-03-19-48-04

keyNode name is: devicewith id:10

New master card [Code: time-2014-07-03-19-48-04]

A new item has been detected [card master is PC.Code: time-2014-07-03-19-48-04]

 

Fault occurred while processing.

My configs are still the defaults except for changing TAG to UUID, SO to SerialNumber (since that's what I called it in my PC class) and entering the correct login information in configuration.xml.

Here is the stack trace:

WARN  2014-07-17 19:26:12 [cmdbuild] cannot apply filter, user is not guest

INFO  2014-07-17 19:26:12 [cmdbuild] trying to login user ocs with group null

INFO  2014-07-17 19:26:12 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'

INFO  2014-07-17 19:26:12 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'

INFO  2014-07-17 19:26:12 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'

INFO  2014-07-17 19:26:12 [cmdbuild] getting all-in-one 'interface org.cmdbuild.services.event.Observer'

WARN  2014-07-17 19:26:12 [org.apache.cxf.phase.PhaseInterceptorChain] Application {http://proxy.sun.com/}$Proxy24Service#{http://soap.services.cmdbuild.org}updateWorkflow has thrown exception, unwinding now

org.apache.cxf.interceptor.Fault

at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162)

at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:213)

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

at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:178)

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

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

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

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

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:263)

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

at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:237)

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

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

at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:131)

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

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

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

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

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

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

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

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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

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

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

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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

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

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

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

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

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

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)

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

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

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

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

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)

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

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

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)

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

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

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)

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:744)

Caused by: java.lang.reflect.UndeclaredThrowableException

at com.sun.proxy.$Proxy24.updateWorkflow(Unknown Source)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

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

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

... 52 more

Caused by: java.lang.reflect.InvocationTargetException

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at org.cmdbuild.common.utils.NotifierProxy$1.invoke(NotifierProxy.java:92)

... 59 more

Caused by: java.lang.NullPointerException

at org.cmdbuild.services.soap.operation.CardAdapter.resolveAttributes(CardAdapter.java:31)

at org.cmdbuild.services.soap.operation.WorkflowLogicHelper.updateProcess(WorkflowLogicHelper.java:181)

at org.cmdbuild.services.soap.PrivateImpl.updateWorkflow(PrivateImpl.java:222)

 

... 64 more

 
#2
Ah, answering my own questions.... I managed to get past the java stack trace, I found that the workflow engine wasn't working. However, I'm still stuck getting my hosts imported from OCS. I can't seem to get the workflow configured properly (at least I'm assuming that is the problem).
 
Is there any more documentation on setting up the workflows above what is in the connector docs? It's really non-specific. I tried creating a workflow called ImportAsset and importing the ImportAsset_Shark4.4.xpdl file from the basicon_connector zip, but that doesn't appear to be quite everything that is needed.
 
Previously Dan wrote:

I have been working my way through the connector documentation and thought I did everything right, but I'm getting a java stack trace in the cmdbuild.log file whenever I run the connector script. Does anyone have any ideas what I am doing wrong?

I have created the views in the OCS database and it appears that the connector is talking to both the OCS directory and CMDBuild properly. I see the queries in the access log. However, the POST requests always result in a 502 and a stack trace. The basic-connector log looks good except for the "Fault occurred while processing" error:

Reading card nr. 6 - Code: time-2014-07-03-19-48-04

keyNode name is: devicewith id:10

New master card [Code: time-2014-07-03-19-48-04]

A new item has been detected [card master is PC.Code: time-2014-07-03-19-48-04]

 

Fault occurred while processing.

My configs are still the defaults except for changing TAG to UUID, SO to SerialNumber (since that's what I called it in my PC class) and entering the correct login information in configuration.xml.

Here is the stack trace:

 ... removed from the response ...

 

#3
And the problem is solved! It all comes down to the actual script that runs the import: bin/connector.sh
 
There is a line in there that specifies "ImportSCCM" as the process to run. However, the workflow that comes with the connector (the xpdl I mentioned above) is configured for a process named "ImportAsset". If you change connector.sh to use ImportAsset instead of ImportSCCM, everything works beautifully!
 
Now I just need to tune my cmdbuild-schema.xml, transform.xsl and CMDBuild views to contain exactly what I want to import, and I should be up and running!
 
Previously Dan wrote:
Ah, answering my own questions.... I managed to get past the java stack trace, I found that the workflow engine wasn't working. However, I'm still stuck getting my hosts imported from OCS. I can't seem to get the workflow configured properly (at least I'm assuming that is the problem).
 
Is there any more documentation on setting up the workflows above what is in the connector docs? It's really non-specific. I tried creating a workflow called ImportAsset and importing the ImportAsset_Shark4.4.xpdl file from the basicon_connector zip, but that doesn't appear to be quite everything that is needed.
 
Previously Dan wrote:

I have been working my way through the connector documentation and thought I did everything right, but I'm getting a java stack trace in the cmdbuild.log file whenever I run the connector script. Does anyone have any ideas what I am doing wrong?

I have created the views in the OCS database and it appears that the connector is talking to both the OCS directory and CMDBuild properly. I see the queries in the access log. However, the POST requests always result in a 502 and a stack trace. The basic-connector log looks good except for the "Fault occurred while processing" error:

Reading card nr. 6 - Code: time-2014-07-03-19-48-04

keyNode name is: devicewith id:10

New master card [Code: time-2014-07-03-19-48-04]

A new item has been detected [card master is PC.Code: time-2014-07-03-19-48-04]

 

Fault occurred while processing.

My configs are still the defaults except for changing TAG to UUID, SO to SerialNumber (since that's what I called it in my PC class) and entering the correct login information in configuration.xml.

Here is the stack trace:

 ... removed from the response ...

 

 

#4

Thanks for your reporting.

We have change connector.sh to use ImportAsset instead of ImportSCCM and reuploaded the basic-connector-1.5.0.zip file.

Best regards.

CMDBuild Team 
#5
 
Hi,
 
Iuglio do you managed to solve this problem? 
 
Thank you so much,
WARN  2014-10-09 14:37:24 [org.apache.cxf.phase.PhaseInterceptorChain] Application {http://proxy.sun.com/}$Proxy24Service#{http://soap.services.cmdbuild.org}updateWorkflow has thrown exception, unwinding now
org.apache.cxf.interceptor.Fault
        at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:162)
        at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:213)
        at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:128)
        at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:178)
        at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:66)
        at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)
        at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:57)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        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:263)
        at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
        at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:237)
        at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:239)
        at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:213)
        at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:131)
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:266)
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:186)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
        at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:242)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.cmdbuild.filters.AuthFilter.doFilter(AuthFilter.java:158)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.cmdbuild.filters.PatchManagerFilter.doFilter(PatchManagerFilter.java:48)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.cmdbuild.filters.ConfCheckFilter.doFilter(ConfCheckFilter.java:31)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.cmdbuild.filters.TranslationFilter.doFilter(TranslationFilter.java:52)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.reflect.UndeclaredThrowableException
        at com.sun.proxy.$Proxy24.updateWorkflow(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
        at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
        ... 56 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor90.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.cmdbuild.common.utils.NotifierProxy$1.invoke(NotifierProxy.java:92)
        ... 62 more
Caused by: java.lang.NullPointerException
        at org.cmdbuild.services.soap.operation.CardAdapter.resolveAttributes(CardAdapter.java:31)
        at org.cmdbuild.services.soap.operation.WorkflowLogicHelper.updateProcess(WorkflowLogicHelper.java:181)
        at org.cmdbuild.services.soap.PrivateImpl.updateWorkflow(PrivateImpl.java:222)
        ... 66 more