错误在运行pan.bat在命令行 [英] error while running pan.bat in command line

查看:1406
本文介绍了错误在运行pan.bat在命令行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

参考我的上一篇文章,这里是链接

我仍然面临一些错误。我尝试运行其他.ktr文件它运行成功,但是当我试图运行pivot_inject_etl_metadata.ktr它给我以下错误

I'm still yet facing with some errors. I tried running other .ktr file it ran successfully but when I'm trying to run "pivot_inject_etl_metadata.ktr" it gives me following error

 C:\pdi-ce-5.2.0.0-209\data-integration>pan.bat /file:E:\Practise_TRANSFORMATION_OUTPUT\dynamic_pivot\pivot_inject_etl_metadata.ktr /level:Basic 
DEBUG: Using PENTAHO_JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jre1.8.0_51
DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\jre1.8.0_51\bin\java.exe

C:\pdi-ce-5.2.0.0-209\data-integration>"C:\Program Files\Java\jre1.8.0_51\bin\java.exe"  "-Xmx256m" "-XX:MaxPermSize=256m" "-Djava.library.path=libswt\win64" "-DKETTLE_HOME=" "-DKETTLE_REPOSITORY=" "-
DKETTLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\pentaho-application-launcher-5.2.0.0-209.jar -lib ..\libswt\win64  -main
org.pentaho.di.pan.Pan /file:E:\Practise_TRANSFORMATION_OUTPUT\dynamic_pivot\pivot_inject_etl_metadata.ktr /level:Basic
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
2016/03/04 09:46:41 - Pan - Logging is at level : Basic logging
2016/03/04 09:46:41 - Pan - Start of run.
2016/03/04 09:46:41 - pivot_inject_etl_metadata - Dispatching started for transformation [pivot_inject_etl_metadata]
2016/03/04 09:46:41 - ETL Metadata Injection.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Bad encoding!
2016/03/04 09:46:41 - ETL Metadata Injection.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : org.pentaho.di.core.exception.KettleException:
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Unable to load transformation ///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr from file.
2016/03/04 09:46:41 - ETL Metadata Injection.0 -
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Unable to read file [file:///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr]
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Could not read from "file:///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr" because it is a not a file.
2016/03/04 09:46:41 - ETL Metadata Injection.0 -
2016/03/04 09:46:41 - ETL Metadata Injection.0 -
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.trans.steps.metainject.MetaInjectMeta.loadTransformationMeta(MetaInjectMeta.java:443)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.trans.steps.metainject.MetaInject.init(MetaInject.java:403)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at java.lang.Thread.run(Unknown Source)
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Caused by: org.pentaho.di.core.exception.KettleXMLException:
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Unable to read file [file:///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr]
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Could not read from "file:///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr" because it is a not a file.
2016/03/04 09:46:41 - ETL Metadata Injection.0 -
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:559)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:538)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2660)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.trans.steps.metainject.MetaInjectMeta.loadTransformationMeta(MetaInjectMeta.java:438)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        ... 3 more
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Caused by: org.apache.commons.vfs.FileNotFoundException: Could not read from "file:///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr"
 because it is a not a file.
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.apache.commons.vfs.provider.AbstractFileObject.getInputStream(Unknown Source)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.apache.commons.vfs.provider.DefaultFileContent.getInputStream(Unknown Source)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.core.vfs.KettleVFS.getInputStream(KettleVFS.java:247)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:557)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        ... 6 more
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Caused by: java.io.FileNotFoundException: E:\Practise_TRANSFORMATION OUTPUT\dynamic pivot\pivot_inject.ktr (The system cannot find the file specified)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at java.io.FileInputStream.open0(Native Method)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at java.io.FileInputStream.open(Unknown Source)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at java.io.FileInputStream.<init>(Unknown Source)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        at org.apache.commons.vfs.provider.local.LocalFile.doGetInputStream(Unknown Source)
2016/03/04 09:46:41 - ETL Metadata Injection.0 -        ... 10 more
2016/03/04 09:46:41 - ETL Metadata Injection.0 - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Error initializing step [ETL Metadata Injection]
2016/03/04 09:46:41 - pivot_inject_etl_metadata - ERROR (version 5.2.0.0, build 1 from 2014-09-30_19-48-28 by buildguy) : Step [ETL Metadata Injection.0] failed to initialize!
Unable to prepare and initialize this transformation

我可以有一个解决方案吗?先感谢。

can I have a solution for this? Thanks in advance.

推荐答案

这里:在命令行中运行pan.bat 在您写的注释之一:

Here: Running pan.bat from command line in one of comment you wrote:

谢谢,我尝试删除

,然后你得到错误:

2016/03/04 09:46:41 - ETL Metadata Injection.0 -
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Unable to read file [file:///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr]
2016/03/04 09:46:41 - ETL Metadata Injection.0 - Could not read from "file:///E:/Practise_TRANSFORMATION OUTPUT/dynamic pivot/pivot_inject.ktr" because it is a not a file.

一次再次 -

Practise_TRANSFORMATION OUTPUT

硬盘编码不正确的文件夹,用于转换参考。我想应该是

Incorrect folder hard-coded for transformation reference. I suppose should be

Practise_TRANSFORMATION_OUTPUT

请在重命名某个文件夹后进行检查 - 所有其他手动硬编码路径也会更新。使用存储库。
如果你仍然不使用仓库 - 但想引用一个转换从其他在同一文件夹下 - 使用变量调用:

Please check after you rename some folder - all other manually hard-coded paths is also updated. Use repository. If you still don't use repository - but want to reference one transformation from other under same folder - use variable called:

${Internal.Transformation.Filename.Directory}

用于转换和

${Internal.Job.Filename.Directory}

。希望这将有所帮助。

这篇关于错误在运行pan.bat在命令行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆