Upon execution of a query or other use of a table and/or view you may receive an error such as:
itgendid177
Provide a data container alias when using tables using distributed databases.
Add an at-sign plus an alias after the table name ‘…’. Choose the alias from the following: …
The itgendid177 message occurs when a database with multiple data containers is used, but no alias is specified with a table name. There is no need to add an alias when a database has solely a single data container.
For example, suppose you are connected to an Invantive SQL database with three data containers:
- Yuki (alias for instance “yuki”)
- ActiveCampaign (alias “ac”)
- Teamleader (alias “myteamleader”)
The itgendid177 error will occur when the following query is executed:
select *
from Teamleader.V1.Projects
The query will succesfully execute when rewritten to include the data container alias:
select *
from Teamleader.V1.Projects@myteamleader