Hi everyone,
I am troubleshooting a Timer error in my OutSystems 11 environment and need help identifying which application or eSpace contains a particular entity.
The Timer fails with the following error:
The DELETE statement conflicted with the REFERENCE constraint"OSFRK_OSUSR_IJE_EMPLOYEE_OSSYS_USER_USERID".The conflict occurred in database "QDGOLH020",table "dbo.OSUSR_IJE_EMPLOYEE", column 'USERID'.
The Timer is running in the TESTAPP module (eSpace ID: 3279), and the stack trace indicates that the error occurs while executing the DeleteUser action.
My environment contains many applications and modules, so I am trying to identify which module owns the physical database table OSUSR_IJE_EMPLOYEE.
My questions:
How can I map the physical table name OSUSR_IJE_EMPLOYEE to its owning eSpace/module and application?
Is there a supported way to find the eSpace ID using Service Studio or Service Center?
Is there a recommended way to search the platform metadata without directly querying or modifying internal system tables?
Is the IJE prefix useful for identifying the owning module?
I understand that the error occurs because an Employee record references a User record that is being deleted. My immediate goal is to identify the module containing the Employee entity so I can investigate the relationship and correct the deletion logic.
Any guidance would be appreciated.
Thanks!
Hello.
You are correct.
Are you sure Employee is not a public entity? Would be easier.
Thank you for the explanation.
I will check the table prefix and the OSSYS_ENTITY metadata to identify the owning module.
Regarding your question, I am not sure whether Employee is a Public entity. I am trying to identify which application/module contains this entity because my environment has many applications.
Thanks for your help!