- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2018 12:34 PM
I have a weird issue I'm wondering if someone can help me with.
I'm unable to select the User [sys_user] table from any Table Name dropdowns. See attached screenshots. One screenshot is trying to create a business rule on User [sys_user] in our TEST instance, which works fine, the other screenshot is trying to do the same from our DEV instance, where the problem can clearly be seen. This is also happening on our PROD instance (so a clone from PROD down to DEV probably won't fix this).
I'm also unable to select User [sys_user] from Table Name dropdowns when trying to create automated test steps. For instance, trying to create a client-side test step that opens an existing form, I can't pick User [sys_user] as the table.
Weird, right? Any ideas?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2018 08:51 AM
As it turns out, somehow the Dictionary [sys_dictionary] record for the User table had been marked active = false. I'm a little freaked as this seems to have happened when we reviewed our upgrade history during our Kingston upgrade, but we've corrected it now and all is back to normal. Thanks for the suggestions everyone. Cheers!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2018 12:59 PM
It is strange. In the environments were you cannot see it can you find it if you go to System Definition > Tables and search for name is sys_user? If you go system security > Users and Groups > Users and then right click on the top of the list and choose configure business rules. Does it have the table already selected if you choose New? And finally when you are in a business rule can you right click at the top and choose Configure > Client scripts and see if there are any custom client scripts that may be removing options from the table drop down? It looks like OOB there are 15 client scripts.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-29-2018 01:08 PM
Did you try flushing the cache? It sounds like a cache corruption issue, although I would not expect that to surface in Dev and Prod at the same time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-30-2018 08:51 AM
As it turns out, somehow the Dictionary [sys_dictionary] record for the User table had been marked active = false. I'm a little freaked as this seems to have happened when we reviewed our upgrade history during our Kingston upgrade, but we've corrected it now and all is back to normal. Thanks for the suggestions everyone. Cheers!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-08-2023 07:22 PM
I'm not able to see the sys_user fields in the dropdowns either!
