Jfreyre
Active Member
Hi guys, I'm facing some strange issues with the TC for F49002 table in an upgrade from Xe to E812, (1 Enterprise Server Merged with the Oracle database server running in HPUX, 1 windows 2003 Deployment Server)
As far I've been searching on the logs for that TC I'm having some issues inserting the current registries for F49002 into the F49002TCTEMP table, as you can see in the next line from the Log:
TCEngine Level 0 \builds\8.96.03.02.07\Rels\common\TCEngine\tcapi.c : TCE9000 - ITCEAlterTable - JDB_InsertFromSelect failed on input table F49002, temporary table F49002TCTEMP..
After seing that I tried to made a Describe for that tables, and I've found something pretty odd, the Table F49002TCTEMP has two columns with an incorrect datatype, the TXDGCP and the TXDSRC are NUMERIC instead of CHAR(1) as it should be, even worse If I look for those values in DD they are parametrized as It should be CHAR(1).
Does anyone have any clues?
As far I've been searching on the logs for that TC I'm having some issues inserting the current registries for F49002 into the F49002TCTEMP table, as you can see in the next line from the Log:
TCEngine Level 0 \builds\8.96.03.02.07\Rels\common\TCEngine\tcapi.c : TCE9000 - ITCEAlterTable - JDB_InsertFromSelect failed on input table F49002, temporary table F49002TCTEMP..
After seing that I tried to made a Describe for that tables, and I've found something pretty odd, the Table F49002TCTEMP has two columns with an incorrect datatype, the TXDGCP and the TXDSRC are NUMERIC instead of CHAR(1) as it should be, even worse If I look for those values in DD they are parametrized as It should be CHAR(1).
Does anyone have any clues?