[SQL Sandbox] Invalid object name &39;OSUSR_WGMYEntity'

Back to Forums

IQ78

Solved

Question

Forge

Traditional Web

Application Type

Traditional Web

Hi there,

I try to use this sandbox. It works if i select the entity {User}, but i got this error

when select to entity "MYEntity " i created:

Invalid object name &39;OSUSR_WGMYEntity'

regards

21 Jun 2024

IQ78

Solution

Hi,

I found the answer myself:

In a premise server, now, when i create a module, there is a screen to choose DB catatog.

and i use this syntax and it works, where xxxDB is the DB catalog we choose when creating the module; for the {User} it works because when i select from the SQL advance using: SELECT DB_NAME(), it results Outsystems and i think it is the DB for the {User} as a default DB:

use xxxDB

select *

from {AuditTrail}