Feature(s) impacted
I’m not able to add tables my project as they are not in the DBO schema in my MSSQL Database
Observed behavior
When setting up the project I get the following error
An error occurred, when deploying Agent: Forest Admin Cloud introspection error: The object ‘[xxxx]’ does not exist in database ‘yyyy’ or is invalid for this operation.
Expected behavior
It should detect all the tables in the non “DBO” schema"
Failure Logs
I used SQL Profiler and found the SQL statement returning the message.
exec sp_executesql @statement=N’EXEC sys.sp_helpindex @objname = N’‘[TABLENAME]’‘;’
I think the schema name may need to be in the TABLENAME space along with the table name.
Context
- Project name: Company Editor
- Team name: Operations
- Environment name: Dev
- Agent (forest package) name & version: Hosting
- Database type: MSSQL 15.0.4236
- Recent changes made on your end if any: None