Table conversion failing

Hi list


I have designed a TC UBE, which maps JDE tables to foreign tables.


Everything is fine, only the insertions are failing. I used the same foreign userid/password combination, I use in the data source, through SQL plus and I am able to insert the data.


Please find the UBE.log attached.


I have given up!!!!!


Thanks in advance


Yogi



Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in
Change the way you talk. Indiatimes presents "Valufon", Your PC to Phone service with clear voice at rates far less than the normal ISD rates. Go to http://www.valufon.indiatimes.com. Choose your plan. BUY NOW.



Dep Svr: ERP 8.0, Win2K AS, SP19.1
Data Svr: Oracle, Sun
Ent Svr: ERP 8.0, SUN

where is the log file?

Re: Re: Table conversion failing

Strange!


I had the attached the log file. Bad times, come from here and there!


Yogi




[email protected] wrote:



where is the log file?
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=45320
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com
Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in
Change the way you talk. Indiatimes presents "Valufon", Your PC to Phone service with clear voice at rates far less than the normal ISD rates. Go to http://www.valufon.indiatimes.com. Choose your plan. BUY NOW.



Dep Svr: ERP 8.0, Win2K AS, SP19.1
Data Svr: Oracle, Sun
Ent Svr: ERP 8.0, SUN

Re: Re: Table conversion failing

Maybe a silly question, but have you got the 'Issue a write for this event' ticked? Or is maybe the 'insert row' command remmed out or in a location in your ER where it may not be executed?

Rgds,

Well. Have a issue write checked and it is not commented too.

I had forgotten to attach my logfile. Thats what it looks like, although I had mailed it as an attachment.
Regards
Yogi

Sorry Guys!

I guess I am a bad transporter!! Here is the logfile.

Hi List

I have finally solved my problem. Actually, JDe has got a column name restriction of 20 characters, which we already know. But, while insertion, it uses the truncated characters to insert data, which makes the insertion to fail.

So, I have switched to a temp table solution, because, I cant change my production table column names to suit JDEdwards convinience.

I am penning this, as this might be useful somewhere.

Ofcourse, not to forgot, JDEdwards support promptly provided me list of SAR's which were already on this issue, and promised GOOD DAYS, in the next version.

Warm Regards
Yogi