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
Error while importing metadata
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Fri Oct 26, 2007 7:15 pm
- Location: India
-
- Premium Member
- Posts: 138
- Joined: Wed Jul 16, 2008 9:51 pm
- Location: Kolkata
-
- Participant
- Posts: 47
- Joined: Fri Oct 26, 2007 7:15 pm
- Location: India
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'.
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'.
-
- Participant
- Posts: 47
- Joined: Fri Oct 26, 2007 7:15 pm
- Location: India
-
- Participant
- Posts: 53
- Joined: Fri Apr 18, 2008 8:13 am
- Location: United States
Error while importing metadata
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
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
Regards
Ajay
Ajay
-
- Participant
- Posts: 47
- Joined: Fri Oct 26, 2007 7:15 pm
- Location: India