How is your experience with the OutSystems Community?
5
Views
2
Comments
Solved
 How to Identify the eSpace/Module Containing a Database Entity from Its Physical Tab

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:

  1. How can I map the physical table name OSUSR_IJE_EMPLOYEE to its owning eSpace/module and application?

  2. Is there a supported way to find the eSpace ID using Service Studio or Service Center?

  3. Is there a recommended way to search the platform metadata without directly querying or modifying internal system tables?

  4. 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!

2026-07-23 14-34-51
Nuno Reis
 
MVP
Solution

Hello.

You are correct.

  • That is the error.
  • A prefix is used in all the tables of one module. If you recognize any table with the same prefix, this one will be in the same module. You just need to go the SQL to see the OSSYS_Entity table. 


Are you sure Employee is not a public entity? Would be easier.

2026-07-28 03-26-02
Anurag Malviya

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!

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.