Oracle Data Integrator SQL to HDFS IKM returns error -

-

i using odi (12.1.3.0.0). created topology oracle db ok , created topology hdfs using file technology think problem in.

dataserver hdfs, left jdbc driver empty, , filled jdbc url hdfs://remotehostname:port

physical schema hdfs, filled both schema , work schema /my/path

then created logical schema , model. after created datastore under model these definitions. name: testname resource name: testfile.txt file format: fixed

after these, created project , mapping under project.

mapping

finally when run mapping see these errors:

odi-1217: session oracle2hdfsmapping_physical_sess (15) fails return code odi-1298. odi-1226: step physical_step fails after 1 attempt(s). odi-1240: flow physical_step fails while performing add execute sqoop script-ikm sql hdfs file (sqoop)- operation. flow loads target table null. odi-1298: serial task "serial-map_main- (10)" failed because child task "serial-eu-gguser_unit (20)" in error. odi-1298: serial task "serial-eu-gguser_unit (20)" failed because child task "add execute sqoop script-ikm sql hdfs file (sqoop)- (40)" in error. caused by: java.io.ioexception: cannot run program "chmod": createprocess error=2, system cannot find file specified     @ java.lang.processbuilder.start(processbuilder.java:1047)     @ java.lang.runtime.exec(runtime.java:617)     @ java.lang.runtime.exec(runtime.java:450)     @ java.lang.runtime.exec(runtime.java:347)     @ oracle.odi.runtime.agent.execution.cmd.oscommandexecutor.execute(oscommandexecutor.java:54)     @ oracle.odi.runtime.agent.execution.cmd.oscommandexecutor.execute(oscommandexecutor.java:29)     @ oracle.odi.runtime.agent.execution.taskexecutionhandler.handletask(taskexecutionhandler.java:52)     @ oracle.odi.runtime.agent.execution.sessiontask.processtask(sessiontask.java:203)     @ oracle.odi.runtime.agent.execution.sessiontask.doexecutetask(sessiontask.java:114)     @ oracle.odi.runtime.agent.execution.abstractsessiontask.execute(abstractsessiontask.java:886)     @ oracle.odi.runtime.agent.execution.sessionexecutor$serialtrain.runtasks(sessionexecutor.java:2198)     @ oracle.odi.runtime.agent.execution.sessionexecutor.executesession(sessionexecutor.java:591)     @ oracle.odi.runtime.agent.processor.taskexecutoragentrequestprocessor$1.doaction(taskexecutoragentrequestprocessor.java:718)     @ oracle.odi.runtime.agent.processor.taskexecutoragentrequestprocessor$1.doaction(taskexecutoragentrequestprocessor.java:611)     @ oracle.odi.core.persistence.dwgobject.dwgobjecttemplate.execute(dwgobjecttemplate.java:203)     @ oracle.odi.runtime.agent.processor.taskexecutoragentrequestprocessor.doprocessstartagenttask(taskexecutoragentrequestprocessor.java:800)     @ oracle.odi.runtime.agent.processor.impl.startsessrequestprocessor.access$1400(startsessrequestprocessor.java:74)     @ oracle.odi.runtime.agent.processor.impl.startsessrequestprocessor$startsesstask.doexecute(startsessrequestprocessor.java:702)     @ oracle.odi.runtime.agent.processor.task.agenttask.execute(agenttask.java:180)     @ oracle.odi.runtime.agent.support.defaultagenttaskexecutor$2.run(defaultagenttaskexecutor.java:108)     @ java.lang.thread.run(thread.java:745) caused by: java.io.ioexception: createprocess error=2, system cannot find file specified     @ java.lang.processimpl.create(native method)     @ java.lang.processimpl.<init>(processimpl.java:385)     @ java.lang.processimpl.start(processimpl.java:136)     @ java.lang.processbuilder.start(processbuilder.java:1028)     ... 20 more

i wonder did wrong?

for file datastore, need define attributes (columns) opening datastore , going on attribute tab. if file exists, can reverse-engineer attributes , rename them , change datatype if needed.

the error message received second task mentions file (generated in fist task) not exist. there might problem first task, due missing attributes in datastore.

here detailed article sql hdfs file (sqoop) km written odi a-team : http://www.ateam-oracle.com/importing-data-from-sql-databases-into-hadoop-with-sqoop-and-oracle-data-integrator-odi/


Comments

Post a Comment

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

-
i have a little website header no longer renders correctly, since updating firefox 38.0.5 [the faceplant logo missing top right, , main logo no longer centred]. still renders expected in other browsers. how has engine's rendering changed in update? according mdn , list of changes is: css support ruby-position , ruby-align have been added , available default ( bug 1055676 , bug 1123917 , bug 1039006 ). the :unresolved pseudo-class has been implemented custom elements ( bug 1111633 ). the predefined style ethiopic-numeric uses space, instead of dot, suffix match recent change spec ( bug 1120721 ). css transitions on generated content (with ::before , ::after ) on both inline , block splits them start expected specification ( bug 1110277 ). the implementation of css logical properties made big progress. [...] how css transitions start has been modified match recent change of specifications, aiming @ having interoperable behavio...
Read more

android - CollapsingToolbarLayout: position the ExpandedText programmatically -

-
i using new android support design view collapsingtoolbarlayout. have need position expandedtitle programmatically. actually way set position expandedtitle in .xml file (example here: https://goo.gl/l5h5fc ) there no public api set text position programmatically , fields private . do know if it's possible without reflection or 'hacky' tricks? i have solved problem exposing properties via reflection ( https://gist.github.com/fpezzato/8e7d45112883dbbc5ffb ), works don't use trick in production code. @google: please no more private or final stuff! :)
Read more

Listeners to visualise results of load test in JMeter -

-
i want run load test in non-gui mode , save results in .csv file. (i have not modified .properties files, standard information saved) i plan load file , visualise results jmeter’s listeners. which listeners suited purpose? should avoid @ cost, might cause me misinterpret information? (e.g. in view results tree response data empty have - - not saved this. however, there has in fact been response. if saw listener might think there hasn’t been one. since want avoid this, listeners have gain information needed .csv file.) i’d know both jmeter listeners plugins. if running test in non-ui mode ideally should disable listeners in script. use '-l' option store test results .jtl extension. can later open jtl file jmeter. aggregate report or summary report should summarize test results , response time , throughput. if want plot graphs see trends on test duration can use http://jmeter-plugins.org/#/ standard , lib set. i suggest following listeners: response ...
Read more