nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

import error

diklish

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.

Find more posts tagged with

Comments

fcorti

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.

diklish

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

fcorti

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>

diklish

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

diklish

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

diklish

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

AAAR.log.zip

fcorti

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>

diklish

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

fcorti

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.