Unreadable error message from Datastage

tonystark622 · Post by **tonystark622** » Wed Sep 15, 2004 8:38 am

DataStage writes some of it's error info into files in the &PH& directory in the Project directory. You may find a more meaningful message if you look through files that have a time/date near the time that is logged in the Job Log for that error.

Good Luck,
Tony

roy · Post by **roy** » Sat Sep 18, 2004 10:50 am

Hi,
what do you see when you run the same sql via a sql editor?
this is probably a configuration problem or some wierd data in your table.
do you by any chance have unusual columns? (like binary objects or somthing similar)

if all other tables are read fine, find out what is special in this table.

is there any chance you "copy & paste" the query from the sql editor to a user defined sql in DS? if so you might got in some wierd characters making your sql invalid and some how you get this wierd message.

IHTH,

saprebv · Post by **saprebv** » Mon Sep 20, 2004 3:19 am

I found the bug.. :D

It was problem with data types. Table had one column changed to Char(1) from Integer and table defn remained unchanged.

But it was really wierd to get such error message.