Page 1 of 2
Runtime Error
Posted: Tue Nov 09, 2010 4:31 am
by Nagasudheerkumar
Hi All,
Fatal Error: Invalid character encountered in table
When I run the a Job it is giving me the above error.
Please suggest me.
Posted: Tue Nov 09, 2010 4:33 am
by ray.wurlod
Find out what the invalid character is and get rid of it.
Posted: Tue Nov 09, 2010 5:04 am
by Nagasudheerkumar
Hi Ray which things I need to see for my error.
Posted: Tue Nov 09, 2010 5:36 am
by ArndW
You can't expect the forum members to guess your table name, column names, and data contents. Or the database type and stage you are using and any or all of those will play a role. In addition, the complete error message would also help in helping you.
Posted: Tue Nov 09, 2010 5:47 am
by Nagasudheerkumar
I checked all the datatypes,table names,column names and data contents still Iam getting the same error.
##F IIS-DSEE-TDOR-00491 06:40:53(007)<main_program>: Fatal Error: Invalid character encountered in table S17_DLPTGF_TLF
Posted: Tue Nov 09, 2010 6:41 am
by nitkuar
This also doesn't looks sufficiant information for debugging
. Please explain your job design, database etc.
Posted: Tue Nov 09, 2010 11:16 pm
by Nagasudheerkumar
Oracle Enterprise Stage--->Transformer--->Dataset
when Iam viewing data iam getting the error
Posted: Wed Nov 10, 2010 12:28 am
by ray.wurlod
We know that. Repeating it does not help. What IS the illegal character?
Posted: Wed Nov 10, 2010 1:36 am
by natashab
Table name has additional characters like space at the end of it.so check the table name given in the oracle stage.
Posted: Wed Nov 10, 2010 7:43 am
by Nagasudheerkumar
I have taken out the where clause "column name='xx' " then it is working fine.Just wanted to give column name='xx' I should not get any errors. How to do that any suggestions
Posted: Wed Nov 10, 2010 7:45 am
by chulett
Post the actual SQL you are attempting to use, where clause and all.
Posted: Thu Nov 11, 2010 4:04 am
by Nagasudheerkumar
SELECT IM_ITEM_NBR, IM_MAKE_BUY_CODE, IM_ENG_REV_DATE, IM_ITEM_STATUS, IM_COST_CTL_CODE, IM_PLANNER, IM_ITEM_DESC, IM_UNIT_MEAS, IM_ITEM_TYPE FROM S07_IMF_DLPIMF where IM_ITEM_NBR='xx'
Please suggest me
Posted: Thu Nov 11, 2010 5:03 am
by karrisuresh
Hi
I am assuming the datatype as varchar for the column IM_ITEM_NBR please confirm
did u try executing in oracle,if u get out put then in ds also is should not be a prob
please send a few records with data
I guess the problem is with the kind of data the table has
put the condition
IM_ITEM_NBR <> 'xx' and check in both oracle and datastage if it is working on oracle and not in ds means ds is not able to recognize the data or sp chars
Posted: Thu Nov 11, 2010 5:16 am
by Nagasudheerkumar
Bingo..Iam using varchar Datatype.But it is working fine in Toad(with no records) if I give IM_ITEM_NBR <> 'xx' it is giving me the whole data and ds is also behaving like oracle.
Posted: Thu Nov 11, 2010 7:57 am
by karrisuresh
try with like'xx' instead of ='xx'