SmartList Builder lists not populating
We have both SmartList and SmartView at a customer site. Generic, out-of-the-box SmartLists are operational, but newly created SmartLists are not running – columns are visible in the right side box, but when we launch the report we get 'The multi-part identifier T1.XXXX could not be bound'.
We are logged in as 'sa' and have run the 3 maintenance tasks (Create/Update Views; Update Field Cache; Update missing physical names) and have exited and relaunched Smart View.
These lists are all operational in SmartList
Is there any sort of SQL Table/View level security that we need to grant?
I know that SmartView creates a SQL user named SmartView and on the GP DB that should be assigned to the DYNGRP group and thus have all rights. Is the SLB list only looking at the tables in the current GP company or are you accessing tables in a different database? if you are accessing tables in a different database I found that you need to map the SmartView SQL user to that DB with the appropriate security rights.
The manual states that the DYNGRP security group needs to be mapped but that didn’t work in my testing.
If you would like to submit an answer or comment, please sign in to the eOne portal.