Skip to Content
0

IDT - cannot detect canges

Nov 09, 2017 at 04:28 PM

59

avatar image

Hi,

I have recently upgraded to Information Design Tool V4.1 SP6

I'm using Teradata V15.0 ODBC Drivers for my connection.

When I retrieve a Universe (.blx) from our repository with a view to adding new columns it can no longer detect any of my tables.

However, if I try and count the rows in a 'missing' table it brings the count back.

That doesn't make sense

I can bring tables in again by starting from scratch but that is a long drawn out process.

The Owner is the database name; the qualifier is null and cannot be changed.

Any advice appreciated

thanks

idt
10 |10000 characters needed characters left characters exceeded

have you refreshed the structure to get the newly added column in the table?

or you can see the new column in Data foundation but not available in the Business layer?

0

Hi,

My new column is in a table in the existing Data foundation. (.dfx)

When I use refresh/detect it cannot find this table.

If I look for it manually via the connection I can see the table and new column.

A colleague of mine is having the same issue. He says there may be some sort of workaround by changing some of the internal switches rgarding qualifiers and owner but I don;t know the detail.

Fortunately someone else has V4.0 which works but it is not an ideal situation

Thanks for any insight

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

BI Customer May 01 at 08:52 PM
0

Hi,

a follow-up to this problem.

A work-around was found by renaming all the names of the objects to uppercase.

Somehow, with the last upgrade, the refresh/detect feature became casespecific.

The underlying phyical tablenames are a mixture of upper and lowercase

Share
10 |10000 characters needed characters left characters exceeded