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 ?!
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 ?!