Unable to create Resource Group

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (13)

Answers (3)

Suggested answer

Fredrik Sætre 12,644 on at

Like (0)

Report

Remember that both groups and resources are in the same table, so you can not create a resource with the same ID as a group. It is a special data model thing where some tables are a subset of an actual common table that also share indexes.

Try adding a plural designation to your group like Welders or CNCs

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Fredrik,

Thanks for you reply. I`m not actually trying to create new resources. Resources are working fine. I`m having trouble to add new resource group but for whatever reasons it's there in AOT table, but not showing in actual resource group form. Any ideas how some of the resource groups are hidden? Or how to solve it by not deleting the resource group in AOT and re-adding it after?

Regards,

V

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi V,

Can this be caused by some form customizations (inquiries, filters, ...) that you applied?

Have you tried to reset the form customizations?

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi V,

Have you tried resetting your usage data?

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi V,

Is it possible to share some screenprints that illustrate the issue?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No