linux运行kettle 遇到问题汇总

1、把本地的repositories.xml 放在跟目录

2、配置机台名解析

vi /etc/hosts

bogon是服务器名字，根据实际情况修改

3、指定内存和字符集

  vi  spoon.sh

-Xms1024m -Xmx2048m -Dfile.encoding=UTF-8

4、执行kettle job

./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job

5、不打印info类日志

方式1

./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job 2>&1 |grep -v ':INFO:'
方式2

./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job 2>&1 |grep -v ':INFO:' |grep -v 'RepositoriesMeta' |grep -v 'lockAcquired'

方式3

new_uuid=$(uuidgen)
logFilePath = "/usr/local/kettle/output_$new_uuid.log"
execResult=0
./kitchen.sh /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job 2>&1 |grep -v ':INFO:' |grep -v 'RepositoriesMeta' |grep -v 'lockAcquired' > $logFilePath
cat $logFilePath
if grep -q "ERROR" $logFilePath then
    execResult=1
fi
rm -f $logFilePath
exit $execResult

powershell方式

$uuid = [guid]::NewGuid()
$logFilePath = "D:\logfile_$uuid.log"
$execResult=0
[Console]::OutputEncoding = [System.Text.Encoding]::UTF8
 .\Kitchen.bat /rep pg_kettle /user admin /pass admin -dir=/bingtest -job=aa_convert_job > $logFilePath
$commands = Get-Content -Path $logFilePath  -Encoding Default
Write-Host $commands
if ($commands -match "ERROR") {
    $execResult=1
} 
Remove-Item -Path $logFilePath
Write-Host "运行结果 $execResult"
exit $execResult

6、集成xxljob命令

execResult=$?
echo "运行结果：$execResult"
exit $execResult

power shell

Write-Host "运行结果:$LastExitCode"
exit $LastExitCode