running a job in ETL

[DCIM_Support]

I'm trying to run a job in ETL but cannot run weel due the job doesn't find the ktr files. Where must be stored the ktr files? I put them in /data/pentaho/import.

Best regards,

Enric

(CID:100340544)

[DCIM_Support]

Hi Enric, can you give us more information on the error you are getting? Logs/screenshots? Also, check your job to make sure you are invoking the transformations correctly.

(CID:100340546)

[DCIM_Support]

Hi Ajay, 

The ETL log error is as follows:

2015-08-25 16:07:32,363 INFO [apc] [org.pentaho.di] (http-192.168.15.94-8080-11) RepositoriesMeta - Reading repositories XML file: FromInputStream
2015-08-25 16:07:43,940 INFO [org.pentaho.di] (QuartzSharedThreadPool-1) RepositoriesMeta - Reading repositories XML file: FromInputStream
2015-08-25 16:07:43,982 INFO [org.pentaho.di] (QuartzSharedThreadPool-1) provaXARXA - Starting entry [provaXARXA01]
2015-08-25 16:07:43,983 INFO [org.pentaho.di] (QuartzSharedThreadPool-1) provaXARXA01 - Loading transformation from XML file [/provaXARXA01.ktr]
2015-08-25 16:07:43,986 ERROR [org.pentaho.di] (QuartzSharedThreadPool-1) provaXARXA - org.pentaho.di.core.exception.KettleException:
Unexpected error during transformation metadata load

Unable to read file [file:///provaXARXA01.ktr]
Could not read from "file:///provaXARXA01.ktr" because it is a not a file.

at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1212)
at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:634)
at org.pentaho.di.job.Job.execute(Job.java:678)
at org.pentaho.di.job.Job.execute(Job.java:815)
at org.pentaho.di.job.Job.execute(Job.java:562)

.........

If I run the job from spoon application it run well but not from SWO.

Regards,

Enric

(CID:100340889)

[DCIM_Support · Accepted solution]

Hi Enric, the error indicates your job is trying to execute provaXARXA01.ktr at the root directory and does not find the transformation files there. Please change this to /data/pentaho/import or / which means the same directory where your job is located at.

Unable to read file [file:///provaXARXA01.ktr]

Could not read from "file:///provaXARXA01.ktr" because it is a not a file.

In your job, if you are running transformation by 'transformation filename', please specify '/data/pentaho/import/provaXARXA01.ktr'. Otherwise, use 'Specify by name and directory' and browse your transformation.

(CID:100340557)

[DCIM_Support]

Hi Ajay,

Thanks for your support. I've specified the right path and now the job is running from SWO.

Best regards,

Enric

(CID:100340890)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.