I created a transformation and also job with very simple query, when I run them manually, they are able to run both on Pentaho local server and also on the Carte server. But when I schedule them, like for every 24 hours, I’ve set up in seconds interval about 86,400 sec, I am unable to get the expected result.
-
Since 24 hours exactly wasn’t working, scheduled for 86,399 sec, but that also didn’t work out. Randomly checked for 2, 3, 6 and 12 hrs also, they were also not working.
-
Worked on server timing also, which is vain.
-
I’ve also tried using the bash file, that’s also a vain.
-
The log should be like this only:
Starting entry [Success]
Finished job entry [Success] (result=[true])
Finished job entry [bay_hrs_data_sync] (result=[true])
Job execution finished
- But what I am getting is here:
ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : Unable to run job bay_hrs_data_sync. The bay_hrs_data_sync has an error.
!JobTrans.Exception.MetaDataLoad!
org.pentaho.di.repository.KettleAuthenticationException: com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: null
ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : org.pentaho.di.core.exception.KettleException:
!JobTrans.Exception.MetaDataLoad!
org.pentaho.di.base.MetaFileLoaderImpl.getMetaForEntry(MetaFileLoaderImpl.java:250)
Caused by: org.pentaho.di.repository.KettleAuthenticationException: org.pentaho.di.repository.KettleAuthenticationException: com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: null
org.pentaho.di.repository.pur.UnifiedRepositoryInvocationHandler.invoke(UnifiedRepositoryInvocationHandler.java:48)
Caused by: com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: null
at com.sun.proxy.$Proxy1112.getFile(Unknown Source)
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Finished job entry [bay_hrs_data_sync] (result=[false])
nandhini sen is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.