sql server - SSIS - Missing column OBJID when importing from Orace using Attunity drivers -

-



my customer uses tool called ifs (an erp system), runs on oracle (the customer runs 11.2). job extract information there using microsoft sql server integration services (or ssis). so, we're using attunity drivers oracle (default odbc slow).

i added new columns existing package today, appending them @ tail of existing query. surprise when tried joining new column new table, revealed no results whatsoever. turns out, values in column not values expected. lengthy troubleshooting session later, found following.

most of our ifs objects contain 3 columns @ end; objid, objversion, , objkey. sinister happening these columns, though. pretty selected in above order:

enter image description here

querying oracle yields valid columns , data:

enter image description here

however, reason objid not recognized valid column in ssis, , refuses show column. note how data oracle make way resultset; not in right column. actual data column apparently dismissed altogether (in above screenshot column looks blank. might have chosen bad column screenshot; stil proves point , highlights core of issue, though):

enter image description here

when checking "column" tab in ssis, rowid there present, checkbox not checked. checking manually nothing.

enter image description here

we import column called objid sap, using ssis, , works fine. therefore suspecting issue might attunity drivers, cannot seem figure out going on.

i'm hoping might have encountered before, , has work around.

it's interesting issue, had me stumped few hours. working around it, have no immediate need resolution; question purely try , satisfy own curiosity.

i'd thankful/grateful hints :)

i have had share of bizzare issues popping when using attinuity connectors , have abandoned them once , when proved non-reliable. packages work sometimes, stops working next run. tweak dft , down goes system, have recreate scratch sometimes.

the issue facing may direct result of well. highly recommend move on 'oracle provider ole db' can download link - http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html.

it painful task understand if there lot of pacakges worth it.





wiki

Comments

Post a Comment

Popular posts from this blog

Asterisk AGI Python Script to Dialplan does not work -

-
i'm stuck project have check database of sip extension incoming caller id , dial sip extension. below receive when run script on asterisk cli. -- registered sip '9125' @ 192.168.1.102:50142 > saved useragent "zoiper rv2.8.40" peer 9125 [2017-08-22 13:53:33] notice[5095]: chan_sip.c:24558 handle_response_peerpoke: peer '9125' reachable. (17ms / 2000ms) == using sip rtp tos bits 184 == using sip rtp cos mark 5 -- executing [0112617769@from-trunk:1] answer("sip/obitrunk1-0000000d", "") in new stack > 0x1ca50d0 -- probation passed - setting rtp source address 192.168.1.98:16834 -- executing [0112617769@from-trunk:2] agi("sip/obitrunk1-0000000d", "test.py") in new stack -- launched agi script /var/lib/asterisk/agi-bin/test.py args: ['/var/lib/asterisk/agi-bin/test.py'] env line: agi_request: test.py env line: agi_channel: sip/obitrunk1-0000000d env line: agi_language: en env line: a...
Read more

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -

-
i start using kotlin , defined interface this: interface aadapter<vh : recyclerview.viewholder> { fun oncreateaviewholder(parent: viewgroup): vh fun onbindaviewholder(v: vh, position: int) } and when try use on code: class klasa ( private val adapter: aadapter<*> ) { fun dosth(){ //... val vh = this.adapter.oncreateaviewholder(parent) //on below line error adapter.onbindaviewholder(v, position) //... } } i error out-projected type 'aadapter<*>' prohibits use of 'public abstract fun onbindaviewholder(v: t, position: int): unit i tied add "in" or "out" definition i'm confused. how allow it. replace aadapter<*> aadapter<recyclerview.viewholder> . class klasa ( private val adapter: aadapter<recyclerview.viewholder> ) { // ... because have declared aadapter has type parameter vh type subclass of recyclerview....
Read more

python - Read npy file directly from S3 StreamingBody -

-
i have many .npy (numpy) , .json files saved in s3, need download , load these files. for json files downloading files , loading dictionary using following code: obj = s3.object(bucket, key) response = obj.get() body = response['body'].read().decode('utf-8') data = json.loads(body) that way avoid writing .json file disk , reading it. now want same .npy files, equivalent? currently downloading file, saving temp file on disk , loading np.load avoid if possible. following https://stackoverflow.com/a/28196540/3509999 : obj = s3.object(bucket, key) io.bytesio(obj.get()["body"].read()) f: # rewind file f.seek(0) arr = np.load(f) wiki
Read more