Error while importing metadata

[xyz_chatter]

Hi Guys,

We have created a DSN and we are successfully able to connect using the new DSN name. But when we try to import the matadata of any of the tables we get the following error:

http://imageupload.org/?d=4DA759A31

I am very new to dataStage and i have no clue why the error is coming. Please assist..

Thanks in advance

[antonyraj.deva]

The image you had given in the link is too unclear to read.

Please post the SQL State Code which you get in the error message.

[chulett]

Generate the error again, check the 'Copy to clipboard' option before dismissing it and then paste the contents here.

[xyz_chatter]

Sorry about that, here's the error:


DSR.MetaGeta(GET.COLUMNS)(SQLColumns('merch_analytics','dbo','Calendar_dim','%')) : BCI Error :
SQLSTATE=10104,CODE=103,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]The number that starts with '05000050000500005001050010500105002050020500205003050030500305004050040500405005050050500505006050060500605007050070500705008050' is too long. Maximum length is 128.
SQLSTATE=10103,CODE=102,[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '05000050000500005001050010500105002050020500205003050030500305004050040500405005050050500505006050060500605007050070500705008050'.

[xyz_chatter]

Btw, the table contains no data, its only the table definition we are trying to import...

[ajay.vaidyanathan]

Hi,
Is it a decimal column ??? Your error message seems to be something like a value exceeding the available limit of the size in DataStage column level. Check that first.

Regards,
Ajay

[xyz_chatter]

We even created a sample table with 1 int column for testing purpose, but it keeps throwing the same error