Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

import error

diklish
Champ in-the-making
Champ in-the-making

‎12-29-2013 11:53 PM

Good afternoon.
When you import error:
Processing 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.
Labels:
0 Kudos
9 REPLIES 9

fcorti
Elite Collaborator
Elite Collaborator

‎12-30-2013 02:26 PM

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.
0 Kudos

diklish
Champ in-the-making
Champ in-the-making

‎01-08-2014 10:30 PM

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.
Для продолжения нажмите любую клавишу . . . 
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos

fcorti
Elite Collaborator
Elite Collaborator
In response to diklish

‎01-09-2014 02:03 AM

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>
0 Kudos

diklish
Champ in-the-making
Champ in-the-making

‎01-09-2014 05:43 AM

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

diklish
Champ in-the-making
Champ in-the-making

‎01-09-2014 05:47 AM

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.
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍
0 Kudos

diklish
Champ in-the-making
Champ in-the-making

‎01-09-2014 08:57 PM

When you run the script AAAR_Extract.bat an error.
But when you run the script AAAR_Publish.bat no errors.
AAAR.log.zip
0 Kudos

diklish
Champ in-the-making
Champ in-the-making
In response to fcorti

‎01-10-2014 06:08 AM

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
0 Kudos

fcorti
Elite Collaborator
Elite Collaborator

‎01-11-2014 04:23 AM

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.
0 Kudos
Getting started

Tags

Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

Copyright © 2025 Khoros, LLC