In this post, you’ll learn about the SQL error code 1947 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform
Error Code :
1947
Reason for the Error code 1947 in InterSystems IRIS DBMS
Index cannot be created on view ‘%.*ls’ because the view contains a self-join on ‘%.*ls’.