I was confronted with a strange Analytical Accounting error in one environment where Microsoft Dynamics GP 2010 with service pack 2 is deployed. Except for "sa" user, the rest of the users get an error whenever they try to open the dimension code lookup window. No results are displayed into the Dimension code.
The error is "cannot drop the table '##Validate TrxDimRelUser.CDB'" where User is to be replaced by the user name and CDB is the comany database ID. There is no issue with the dimension relationships and user security is also taken enough care to be setup properly.
I tried the service pack 3 to see if I can be lucky on this one. Yes, It did resolve the issue and the users could access the dimension code lookup window as normal.