Table Conversion not correctly finding data after upgrade from Xe to 8.12

altquark

altquark

Legendary Poster
Hi Guys

ok - I have a customer who I've upgraded from Xe to 8.12.8.96.2.2 on Intel (SQL 2005). Note that the implementation is unicode - but I don't think that is necessarily the factor.

I have a table conversion I've brought over from Xe - when I go into design aid, everything looks fine. It is reading a standard text tab-delimited ascii file and inserting data into the F0911Z1 based on some event rules.

However, when I run this on a fat client (or the app server - but I am debugging on the fat client) - the file is being read in as gobblygook.

Here is the output log (everything turned on) :

[ QUOTE ]

Opening UBE Log for report R55SDSLSZ1, version TEST0001
TCEngine Level 11 \builds\8.96.02.02.07\Rels\common\TCEngine\tcdump.c : Fetched Format \\jde-depl\Legacy\SCDAILYSALES,1,"††††††††††††‰††††††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰††††‰†††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††‰†††††††††††††††††††††††††‰††††‰††††††††††††‰†††††††††††††††††††††††††‰††††‰††††††††††††‰†††††††††††††††††††††††††‰††††‰††††††††††††‰†††††††††††††††††††††††††††‰††††‰††††††††††††‰†††††††††††††††††††††††††‰††††‰††††††††††††‰†††††††††††††††††††††††††††‰††††‰††††††††††††‰†††††††††††††††††††††††††††‰††††††††††††††††‰†††††††††††††††††††††††††‰††††††††††††††††‰†††††††††††††††††††††††††‰††††††††††††††††‰†††††††††††††††††††††††††††††‰‰††††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰††††‰†††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††‰†††††††††††††††††††††††††††††††††††††††††††‰††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††††"
TCEngine Level 11 \builds\8.96.02.02.07\Rels\common\TCEngine\tcdump.c : Insert Row Format F0911Z1,1,"SCHDLYSLS","††††††††",,4/21/2008,"0","A","J","14055","",,"††††"," 200.","1","$$$$$$$"," 200","$$$$$$"," ","AA","",0,"††††††††††","††††††††††","††††††","††††"," ","JDE","R55SDSLSZ1","JDEVMWS001",4/21/2008,95432,"D",
UBE Job Finished SuccessFully.


[/ QUOTE ]

Here is the original file when I open it in notepad :

[ QUOTE ]

49633 000000104080800000001372266-SXL 103 1110 COST OFFSET FOR 103 04/08/08 00200CAD
49633 000000204080800000001327709-SXL 103 5000 BRAND PRODUCT TYPE FOR 103 04/02 1000200CAD
49633 000000304080800000000030822-SXL 103 5000 BRAND PRODUCT TYPE FOR 103 04/04 1000200CAD
49633 000000404080800000000169691-SXL 103 5000 BRAND PRODUCT TYPE FOR 103 04/06 1000200CAD
49633 000000504080800000000059415-SXL 103 5000 BRAND PRODUCT TYPE FOR 103 04/08 1000200CAD
49633 000000604080800000000020821-SXL 103 5000 BRAND PRODUCT TYPE FOR 103 04/14 1000200CAD
49633 000000704080800000000872068-SXL 103 5000 BRAND PRODUCT TYPE FOR 103 04/18 1000200CAD
49633 0000008040808000000000014210SXL 103 5000 DISCOUNT TOTAL FOR 103 04/08/0 00200CAD
49633
.
.
.
.
etc


[/ QUOTE ]

Anyone know why the file is being read as gobblygook ? It seems that there is some wierd text conversion going on - but I can't find anywhere in TC aid that might refer to that ?!
 
Ha

JDE support isn't too shabby sometimes ! Obviously, this was my ignorance of the P93081 !

So, for all references in the future - if you are seeing gobblygook being read in by mistake - check to make sure there is an entry in the P93081. Windows ASCII format requires CP1252 as the default conversion type.

Its monday morning. What more can I say...(!)
 
John,

You asked, I told you - you didn't listen... Next time, just have me take
the Jeep to Montana so I can take some pix.

P93081 - it catches us ALL from time to time! In addition, make sure
you remind everyone to make the change 'Active' once they add a record

(db)




--
 
Back
Top