You’re offline. This is a read only version of the page.
Announcements
Dear Experts,
One of my end users reported that he's unable to create resource group due to an error below:
"Cannot create a record in Resources (WrkCtrTable). Resource: XYZ, XYZ. The record already exists."
Well the message clearly says whats causing the issue and there's "XYZ" record in AOT - WrkCtrTable. However it's not showing in Resource groups form. Any ideas? Is there any other form i need to check to enable "XYZ" resource group to be visible in Resource Groups form?
Regards,
V
*This post is locked for comments
Hi Fredrik,
Thanks for your reply. We were unable to add resources to resource group XYZ that's hidden. Both marked correctly in WrkCtrTable.
We managed to fix current issue by adding new line on WrkCtrResourceGroup table.
Regards,
V
Are they marked as Groups or Resources?
Both reside in the same table.
You might have a resource not connected to a group and so it is not showing up anywhere.
Vilmos,
I`m just thinking if data was messed during the implementation period and nobody noticed it/fixed it when we went LIVE. We had this issue last year, but it wasn't major request to fix it as the hidden resource groups weren't used for production at the time.
I`m not 100% sure if its the right decision, but adding missing data in AOT WrkCtrResourceGroup table seems to fix the issue I`m having at the moment.
Regards,
V
If people who should not have access to the AOT are messing around in the Table browser, it is possible indeed that they have deleted a record.
I do not allow my technical staff to do anything in Production be it posting a transaction, editing parameters, etc. which is not pre-authorized or documented. Consider revising who has access to which part of the system.
Otherwise AX does handle deletion very well through delete actions, preventing unintended record removal - however, that is not 100% bullet proof, it is not set up as restricted always.
Hi Vilmos,
I looked at the query range and checked the tables in AOT.
There's resource groups missing (the ones I`m unable to add in resource group form) in WrkCtrResourceGroup table.
By adding the "hidden" resource groups in WrkCtrResourceGroup table they start to appear in Resource Groups form. Would it be possible that someone deleted the data from WrkCtrResourceGroup table and didn't notice, therefore I`m having trouble to see all resource groups?
Regards,
V
Hi V,
Is it possible to share some screenprints that illustrate the issue?
Best regards,
Ludwig
Ludwig,
Tried that, didn't work. Neither other end users can see hidden resource groups.
I tried to remove one of the hidden resource groups from AOT table in our test environment and re-adding it back to resource groups form - was working fine.
However I`m not keen to remove data from AOT tables.
I`m wondering if there's any other solutions on how to enable hidden resource groups apart from removing the data from AOT table or creating prefix for XYZ resource group.
Regards,
V
If records from a table does not show, it is due a couple of reasons:
- there is a query range applied to filter the record out
- there is a joined (inner/exist) datasource and the records are filtered out
- there is XDS set up to filter out records
- the record is broken due to some unintended manipulation directly from SQL or other means
You could check the query on your form in the Personalization menu to rule out the first two.
Security for the rows does not apply with System administrator accounts.
Hi V,
Have you tried resetting your usage data?
Best regards,
Ludwig
Hi Ludwig,
Thanks for your reply. As far as I know there's no customization done to resources/resource groups form, neither any table linked to them.
Just curious how some of the resource groups are hidden in actual resource group form and showing in AOT WrkCtrTable.
Regards,
V
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
232,996
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
