topic Re: import error in Alfresco Archive

import error

diklish — Mon, 30 Dec 2013 04:53:35 GMT

Good afternoon.When you import errorrocessing stopped because of an error:Unable to load the job from XML file [C 😕 alfrescof / data-integration / Alfresco / Get all.kjb].Where to look for this file.Thank you.

Re: import error

fcorti — Mon, 30 Dec 2013 19:26:45 GMT

Hi diklish,

The 'Get all.kjb' file is a job file used to publish the reports on Alfresco.
The message seems to say that the file is not reachable…
Please, attach the log otherwise is impossibile to understand what is wrong.

Re: import error

diklish — Thu, 09 Jan 2014 03:30:00 GMT

Thanks for the fast reply Mr fcorti.

log file:


DEBUG: Using PENTAHO_JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=C:\alfrescof\java
DEBUG: _PENTAHO_JAVA=C:\alfrescof\java\bin\java.exe
 .
"C:\alfrescof\java\bin\java.exe" "-Xmx512m" "-Djava.library.path=C:\apps\data-integration\libswt\win64" "-DKETTLE_HOME=" "-DKETTLE_REPOSITORY=C:\alfrescof\data-integration" "-DKETTLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT="  "-DKETTLE_JNDI_ROOT=" -jar "C:\apps\data-integration\launcher\pentaho-application-launcher-5.0.1-stable.jar" -main org.pentaho.di.kitchen.Kitchen /rep:"AAAR_Kettle_JDBC" /job:"Get all" /dir:/Alfresco /user:postgres /pass:******* /param:get_parents=true /level:Debug
 .
2013/12/30 10:35:26 - Kitchen - Logging is at level : Debugging
2013/12/30 10:35:26 - Kitchen - Repository and username supplied
2013/12/30 10:35:26 - Kitchen - Start of run.
2013/12/30 10:35:26 - Kitchen - Allocate new job.
2013/12/30 10:35:26 - Kitchen - Parsing command line options.
2013/12/30 10:35:26 - Kitchen - Loading available repositories.
2013/12/30 10:35:26 - RepositoriesMeta - Reading repositories XML file: C:\Users\*******\.kettle\repositories.xml
2013/12/30 10:35:27 - Kitchen - Finding repository [C:\alfrescof\data-integration]
2013/12/30 10:35:27 - Kitchen - Allocate & connect to repository.
2013/12/30 10:35:27 - Kitchen - Check supplied username and password.
2013/12/30 10:35:27 - Kitchen - Load the  repositories defined on this system.
Processing stopped because of an error: 
Unable to load the job from XML file [C:/alfrescof/data-integration/Alfresco/Get all.kjb]

Unable to read file [file:///C:/alfrescof/data-integration/Alfresco/Get all.kjb]
Could not read from "file:///C:/alfrescof/data-integration/Alfresco/Get all.kjb" because it is a not a file.


ERROR: Kitchen can't continue because the job couldn't be loaded.
Для продолжения нажмите любую клавишу . . . 
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: import error

fcorti — Thu, 09 Jan 2014 07:03:28 GMT

Hi,

The error is because the 'Get all' job is read from the file system instead of from the Pentaho repository (stored in the AAAR_Kettle schema).
I'm a little bit confused because in your log, it seems to be invoked on a JDBC called AAAR_Kettle_JDBC and this is not the one contained in the script 'AAAR_Export.bat'.
Please, confirm you are using this script or confirm you are using your own customized way to invoke the extraction.

PS: Yesterday I released a major release (v2.0) of the solution directly in the Pentaho Marketplace. Could be an idea to use the new version. For more informations, please read here:
<a href="http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/">http://fcorti.com/alfresco-audit-analysis-reporting/aaar-how-to-install/</a>

Re: import error

diklish — Thu, 09 Jan 2014 10:43:03 GMT

Thank you very much.
I installed the new version. Everything works, I learn.
Before. I used the revised script. (added value variables only)

Re: import error

diklish — Thu, 09 Jan 2014 10:47:26 GMT

I got an error when running AAAR_Extract.bat, but when you start AAAR_Puplish.bat all good.


2014/01/09 16:40:17 - AAAR_Kettle - Unexpected error loading class:
2014/01/09 16:40:17 - AAAR_Kettle - it/francescocorti/kettle/cmis_input/CmisInputMeta : Unsupported major.minor version 51.0
2014/01/09 16:40:17 - Get CMIS documents and folders - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 
2014/01/09 16:40:17 - Get CMIS documents and folders - Unexpected error during transformation metadata load
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - An error occured reading a transformation from the repository
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - Unexpected error loading class:
2014/01/09 16:40:17 - Get CMIS documents and folders - it/francescocorti/kettle/cmis_input/CmisInputMeta : Unsupported major.minor version 51.0
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1212)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:634)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.Job.execute(Job.java:678)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.Job.execute(Job.java:815)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.Job.execute(Job.java:815)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.Job.execute(Job.java:815)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.Job.execute(Job.java:815)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.Job.execute(Job.java:815)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.Job.execute(Job.java:562)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.entries.job.JobEntryJobRunner.run(JobEntryJobRunner.java:73)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.lang.Thread.run(Thread.java:662)
2014/01/09 16:40:17 - Get CMIS documents and folders - Caused by: org.pentaho.di.core.exception.KettleException: 
2014/01/09 16:40:17 - Get CMIS documents and folders - An error occured reading a transformation from the repository
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - Unexpected error loading class:
2014/01/09 16:40:17 - Get CMIS documents and folders - it/francescocorti/kettle/cmis_input/CmisInputMeta : Unsupported major.minor version 51.0
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:531)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:279)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadTransformation(KettleDatabaseRepository.java:1712)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1190)
2014/01/09 16:40:17 - Get CMIS documents and folders -    … 10 more
2014/01/09 16:40:17 - Get CMIS documents and folders - Caused by: org.pentaho.di.core.exception.KettlePluginException: 
2014/01/09 16:40:17 - Get CMIS documents and folders - Unexpected error loading class:
2014/01/09 16:40:17 - Get CMIS documents and folders - it/francescocorti/kettle/cmis_input/CmisInputMeta : Unsupported major.minor version 51.0
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.core.plugins.PluginRegistry.loadClass(PluginRegistry.java:442)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.core.plugins.PluginRegistry.loadClass(PluginRegistry.java:308)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryStepDelegate.loadStepMeta(KettleDatabaseRepositoryStepDelegate.java:137)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryTransDelegate.loadTransformation(KettleDatabaseRepositoryTransDelegate.java:420)
2014/01/09 16:40:17 - Get CMIS documents and folders -    … 13 more
2014/01/09 16:40:17 - Get CMIS documents and folders - Caused by: java.lang.UnsupportedClassVersionError: it/francescocorti/kettle/cmis_input/CmisInputMeta : Unsupported major.minor version 51.0
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.lang.ClassLoader.defineClass1(Native Method)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.lang.ClassLoader.defineClassCond(ClassLoader.java:632)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.lang.ClassLoader.defineClass(ClassLoader.java:616)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.security.AccessController.doPrivileged(Native Method)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.core.plugins.KettleURLClassLoader.loadClass(KettleURLClassLoader.java:86)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
2014/01/09 16:40:17 - Get CMIS documents and folders -    at org.pentaho.di.core.plugins.PluginRegistry.loadClass(PluginRegistry.java:428)
2014/01/09 16:40:17 - Get CMIS documents and folders -    … 16 more
2014/01/09 16:40:17 - Get CMIS documents and folders - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleException: 
2014/01/09 16:40:17 - Get CMIS documents and folders - Unexpected error occurred while launching entry [Get CMIS documents and folders.0]
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - Unexpected error during transformation metadata load
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - An error occured reading a transformation from the repository
2014/01/09 16:40:17 - Get CMIS documents and folders - 
2014/01/09 16:40:17 - Get CMIS documents and folders - Unexpected error loading class:
2014/01/09 16:40:17 - Get CMIS documents and folders - it/francescocorti/kettle/cmis_input/CmisInputMeta : Unsupported major.minor version 51.0

……


2014/01/09 16:40:19 - Get Alfresco audit in operational - Finished job entry [Get CMIS documents and folders] (result=[false])
2014/01/09 16:40:19 - Get Alfresco audit in operational - Finished job entry [Clean cmis staging] (result=[false])
2014/01/09 16:40:19 - Get Alfresco audit in operational - Finished job entry [Get alfresco connection params] (result=[false])
2014/01/09 16:40:19 - dm_dim_paths.0 - Finished job entry [Init nodes staging] (result=[false])
2014/01/09 16:40:19 - Get all - Finished job entry [Get nodes] (result=[false])
2014/01/09 16:40:19 - Get all - Finished job entry [Get audit] (result=[false])
2014/01/09 16:40:19 - Get all - Finished job entry [Get all source id] (result=[false])
2014/01/09 16:40:19 - Get all - Job execution finished
2014/01/09 16:40:19 - Kitchen - Finished!
2014/01/09 16:40:19 - Kitchen - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Finished with errors
2014/01/09 16:40:19 - Kitchen - Start=2014/01/09 16:39:42.949, Stop=2014/01/09 16:40:19.907
2014/01/09 16:40:19 - Kitchen - Processing ended after 36 seconds.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: import error

diklish — Fri, 10 Jan 2014 01:57:07 GMT

When you run the script AAAR_Extract.bat an error.
But when you run the script AAAR_Publish.bat no errors.

Re: import error

fcorti — Fri, 10 Jan 2014 06:15:40 GMT

Hi,

Please, check here:
<a href="http://fcorti.com/alfresco-audit-analysis-reporting/aaar-faq/#q15">http://fcorti.com/alfresco-audit-analysis-reporting/aaar-faq/#q15</a>

Re: import error

diklish — Fri, 10 Jan 2014 11:08:21 GMT

INSTALLED java (7v)
further error


2014/01/10 17:52:45 - Cmis Input modified document.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
2014/01/10 17:52:45 - Cmis Input modified document.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: Internal Server Error
‍‍‍‍

I Followed the instructions in http://fcorti.com/2013/07/23/aaar-internal-server-error-solr/
but the problem persists

A.A.A.R. (v2.0) on Alfresco Community 4.0.e, Windows platform and PostgreSQL database.

sorry for my english

Re: import error

fcorti — Sat, 11 Jan 2014 09:23:08 GMT

Hi,

The 'Internal Server Error' message you see, means some kind of problems performing the CMIS query on Alfresco.
This is the OpenCMIS library that reply this.

For some kind of reasons the resulting CMIS query fails and this is very strange because it works! 🙂

I would like to help you more than this so, may I access to you Alfresco to debug AAAR directly in you case?
If you can consider this support, write me privately to give me the access parameters.

Let me know how it goes.