Open Business Intelligence

La red del Business Intelligence

Hola a todos.

En nuestra organización usamos Alfresco como sistema ECM. Se prentede obtener información sobre el número de documentos que se generan en dicho sistema. Para ello se está usando  el plugin CMIS Input para Pentaho Data Integration desarrollado por http://francescocorti.wordpress.com/. El objetivo, hasta ahora, lo hemos cumplido, pero por lo que se ha probado sólo conseguimos obtener los documentos (select * from cmis:document), cuando en realidad se podría obtener más información, como carpetas. El manual de este paso de Pentaho Data Integration no indica ninguna restricción. ¿Alguien lo ha probado?

Este es el error que provoca la sentencia "select * from cmis:folder" :

2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Error desconocido
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Unable to get queryfields for SQL:
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : SELECT * FROM cmis:folder
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) : Parsing exception!
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :     at it.francescocorti.kettle.cmis_input.CmisInputMeta.getFields(Unknown Source)
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :     at it.francescocorti.kettle.cmis_input.CmisInput.processRow(Unknown Source)
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :     at org.pentaho.di.trans.step.RunThread.run(RunThread.java:50)
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21 16.02.21 by buildguy) :     at java.lang.Thread.run(Thread.java:722)
2013/08/13 12:50:05 - Cmis Input.0 - ERROR (version 4.4.0-stable, build 17588 from 2012-11-21

Muchas gracias de antemano.

Etiquetas: Alfresco, CMIS, plugin

Visitas: 426

Responde a esto

Respuestas a esta discusión

Sorry, if I don't speak spanish (I can read it because I'm italian). ;-)

Probably I'm in late but I try...

In those cases I always suggest to use the CMIS Workbech (http://chemistry.apache.org/java/developing/tools/dev-tools-workben...) to check the CMIS query because most of the times the problem depends on it.

Also in this case, for example, CMIS probably does not accept the "SELECT *" without filters.

Hope this help. :-)

Thank you very much for the answer Francesco.
Actuallly, our the CMIS development is pending, so I'll try your suggestion.

Good job for CMIS Input and AAAR solution. I just reviewed the documentation but it seems very complete and powerful. AAAR solution is very useful to explode Alfresco.

Thank you very much again.

Hi Jaun,

Thank you for the feedback.

Let me know if you need some more details, I plan to add some new features because users are asking me. ;-)

Responder a debate

RSS

Distintivo

Cargando…

© 2024   Creado por Emilio.   Tecnología de

Emblemas  |  Reportar un problema  |  Términos de servicio