ChewCheeLim

How to fix this error "Internal Query Exceution Failure" ?

Discussion created by ChewCheeLim on Feb 3, 2014
Latest reply on Feb 5, 2014 by ChewCheeLim
Hi. I am writing a simple query to return a list of elementAttributes for a given element by name. But I am getting the following error. Could you someone help me as how to fix this error? My Query select * from RBCDailyRounds.Asset.Element e inner join RBCDailyRounds.Asset.ElementAttribute ea on e.id = ea.ElementID where e.name = 'Master' Internal query execution failure. Details: [PI SQL (AF) Service] [Microsoft SQL Server Native Client 10.0] Violation of PRIMARY KEY constraint 'PK__GetHiera__3214EC278C77F71F'. Cannot insert duplicate key in object 'AfSql.GetHierarchyTempTablePool'. The duplicate key value is (5). The statement has been terminated.

Outcomes