Runtime Error

Nagasudheerkumar · Post by **Nagasudheerkumar** » Tue Nov 09, 2010 4:31 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 09, 2010 4:33 am

Find out what the invalid character is and get rid of it.

Nagasudheerkumar · Post by **Nagasudheerkumar** » Tue Nov 09, 2010 5:04 am

Hi Ray which things I need to see for my error.

ArndW · Post by **ArndW** » Tue Nov 09, 2010 5:36 am

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.

Nagasudheerkumar · Post by **Nagasudheerkumar** » Tue Nov 09, 2010 5:47 am

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

nitkuar · Post by **nitkuar** » Tue Nov 09, 2010 6:41 am

This also doesn't looks sufficiant information for debugging

. Please explain your job design, database etc.

Nagasudheerkumar · Post by **Nagasudheerkumar** » Tue Nov 09, 2010 11:16 pm

Oracle Enterprise Stage--->Transformer--->Dataset

when Iam viewing data iam getting the error

ray.wurlod · Post by **ray.wurlod** » Wed Nov 10, 2010 12:28 am

We know that. Repeating it does not help. What IS the illegal character?

natashab · Post by **natashab** » Wed Nov 10, 2010 1:36 am

Table name has additional characters like space at the end of it.so check the table name given in the oracle stage.

Nagasudheerkumar · Post by **Nagasudheerkumar** » Wed Nov 10, 2010 7:43 am

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

chulett · Post by **chulett** » Wed Nov 10, 2010 7:45 am

Post the actual SQL you are attempting to use, where clause and all.

Nagasudheerkumar · Post by **Nagasudheerkumar** » Thu Nov 11, 2010 4:04 am

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

karrisuresh · Post by **karrisuresh** » Thu Nov 11, 2010 5:03 am

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

Nagasudheerkumar · Post by **Nagasudheerkumar** » Thu Nov 11, 2010 5:16 am

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.

karrisuresh · Post by **karrisuresh** » Thu Nov 11, 2010 7:57 am

try with like'xx' instead of ='xx'