投稿2018/11/06 05:02
編集2018/11/06 07:40oracleDBからBiqgueryへデータをバルクインサートしたいのですが
embulkを実行しますと、以下のエラーが出力されます
p12keyfileは、別途作成する必要があるのでしょうか。
p12keyfileがなんの役割をはたすものか調査中の状況です。
環境：Windows 7 / Embulk 0.98 / OracleDB12c
C:\Users\yazaki\Desktop\embulk>embulk-0.9.8.bat run config_bq.yml 2018-11-06 13:45:36.780 +0900: Embulk v0.9.8 2018-11-06 13:45:37.841 +0900 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected. 2018-11-06 13:45:41.694 +0900 [INFO] (main): Gem's home and path are set by default: "C:\Users\yazaki.embulk\lib\gems" 2018-11-06 13:45:43.113 +0900 [INFO] (main): Started Embulk v0.9.8 2018-11-06 13:45:43.238 +0900 [INFO] (0001:transaction): Loaded plugin embulk-input-oracle (0.9.3) 2018-11-06 13:45:49.135 +0900 [INFO] (0001:transaction): Loaded plugin embulk-output-bigquery (0.4.9) 2018-11-06 13:45:49.182 +0900 [INFO] (0001:transaction): Connecting to jdbc:oracle:thin:@A0430-02396:1521:ORCL options {oracle.jdbc.ReadTimeout=1800000, user=system, password=***, oracle.net.CONNECT_TIMEOUT=300000} 2018-11-06 13:45:49.743 +0900 [INFO] (0001:transaction): Using JDBC Driver 12.1.0.2.0 2018-11-06 13:45:49.884 +0900 [INFO] (0001:transaction): Using local thread executor with max_threads=8 / output tasks 4 = input tasks 1 * 4 org.embulk.exec.PartialExecutionException: org.jruby.proxy.org.embulk.config.ConfigException$Proxy1: `p12_keyfile` is required for auth_method private_key at org.embulk.exec.BulkLoader$LoaderState.buildPartialExecuteException(BulkLoader.java:339) at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:565) at org.embulk.exec.BulkLoader.access$000(BulkLoader.java:34) at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:352) at org.embulk.exec.BulkLoader$1.run(BulkLoader.java:349) at org.embulk.spi.Exec.doWith(Exec.java:22) at org.embulk.exec.BulkLoader.run(BulkLoader.java:349) at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:161) at org.embulk.EmbulkRunner.runInternal(EmbulkRunner.java:292) at org.embulk.EmbulkRunner.run(EmbulkRunner.java:156) at org.embulk.cli.EmbulkRun.runSubcommand(EmbulkRun.java:436) at org.embulk.cli.EmbulkRun.run(EmbulkRun.java:91) at org.embulk.cli.Main.main(Main.java:26) Suppressed: java.lang.NullPointerException at org.embulk.exec.BulkLoader.doCleanup(BulkLoader.java:462) at org.embulk.exec.BulkLoader$3.run(BulkLoader.java:396) at org.embulk.exec.BulkLoader$3.run(BulkLoader.java:393) at org.embulk.spi.Exec.doWith(Exec.java:22) at org.embulk.exec.BulkLoader.cleanup(BulkLoader.java:393) at org.embulk.EmbulkEmbed.run(EmbulkEmbed.java:164) ... 5 more Caused by: org.jruby.proxy.org.embulk.config.ConfigException$Proxy1: `p12_keyfile` is required for auth_method private_key at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at org.jruby.javasupport.proxy.JavaProxyConstructor.newInstanceImpl(JavaProxyConstructor.java:119) at org.jruby.javasupport.proxy.JavaProxyConstructor.newInstance(JavaProxyConstructor.java:205) at org.jruby.javasupport.Java$JCreateMethod.call(Java.java:618) at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:200) at org.jruby.internal.runtime.methods.JavaMethod$JavaMethodN.call(JavaMethod.java:739) at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:278) at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:79) at org.jruby.java.proxies.ConcreteJavaProxy$InitializeMethod.call(ConcreteJavaProxy.java:48) at org.jruby.ir.runtime.IRRuntimeHelpers.instanceSuper(IRRuntimeHelpers.java:984) at org.jruby.ir.instructions.InstanceSuperInstr.interpret(InstanceSuperInstr.java:69) at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:360) at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:74) at org.jruby.ir.interpreter.InterpreterEngine.interpret(InterpreterEngine.java:84) at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:179) at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:165) at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:328) at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:165) at org.jruby.RubyClass.newInstance(RubyClass.java:1001) at org.jruby.RubyClass$INVOKER$i$newInstance.call(RubyClass$INVOKER$i$newInstance.gen) at org.jruby.internal.runtime.methods.DynamicMethod.call(DynamicMethod.java:200) at org.jruby.java.proxies.ConcreteJavaProxy$NewMethod.call(ConcreteJavaProxy.java:158) at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:318) at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:155) at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:315) at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:74) at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:109) at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:95) at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:278) at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:79) at org.jruby.ir.instructions.CallBase.interpret(CallBase.java:432) at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:360) at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:74) at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:109) at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:95) at org.jruby.runtime.callsite.CachingCallSite.cacheAndCall(CachingCallSite.java:278) at org.jruby.runtime.callsite.CachingCallSite.call(CachingCallSite.java:79) at org.jruby.runtime.callsite.CachingCallSite.callIter(CachingCallSite.java:84) at org.jruby.ir.instructions.CallBase.interpret(CallBase.java:429) at org.jruby.ir.interpreter.InterpreterEngine.processCall(InterpreterEngine.java:360) at org.jruby.ir.interpreter.StartupInterpreterEngine.interpret(StartupInterpreterEngine.java:74) at org.jruby.internal.runtime.methods.MixedModeIRMethod.INTERPRET_METHOD(MixedModeIRMethod.java:109) at org.jruby.internal.runtime.methods.MixedModeIRMethod.call(MixedModeIRMethod.java:95) at Embulk$$OutputPlugin$$JavaAdapter_161232248.transaction(Embulk$$OutputPlugin$$JavaAdapter_161232248.gen:13) at org.embulk.exec.BulkLoader$4$1$1.transaction(BulkLoader.java:520) at org.embulk.exec.LocalExecutorPlugin.transaction(LocalExecutorPlugin.java:49) at org.embulk.exec.BulkLoader$4$1.run(BulkLoader.java:515) at org.embulk.spi.util.Filters$RecursiveControl.transaction(Filters.java:84) at org.embulk.spi.util.Filters.transaction(Filters.java:42) at org.embulk.exec.BulkLoader$4.run(BulkLoader.java:510) at org.embulk.input.jdbc.AbstractJdbcInputPlugin.transaction(AbstractJdbcInputPlugin.java:206) at org.embulk.exec.BulkLoader.doRun(BulkLoader.java:506) ... 11 more Error: org.jruby.proxy.org.embulk.config.ConfigException$Proxy1: `p12_keyfile` is required for auth_method private_key C:\Users\yazaki\Desktop\embulk>
ymlファイルの定義です。
C:\Users\yazaki\Desktop\embulk>type seed_bq.yml in: type: oracle driver_path: C:\Users\yazaki\Desktop\embulkDB\product\12.2.0\dbhome_1\sqldeveloper\jdbc\lib\ojdbc7.jar host: A0430-02396 user: ｘｘｘｘ password: ｘｘｘｘ database: ORCL table: INPUT_TEST out: type: bigquery project: fluid-emissary-216806 dataset: embulk_test auto_create_table: true table: users
回答2件
0
自己解決
ネットワークの状態が不安定で接続断が発生しておりました。
現在は、正常にBigQueryへデータのバルクインサートが成功しております。
投稿2018/11/06 08:44
総合スコア77
あなたの回答
tips
プレビュー
Q&A
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。
2018/11/06 08:48 編集
2018/11/06 09:00
2018/11/06 09:02
2018/11/06 09:08