Solved

Business Unit_ODX , Error with _R tables


How can I solve extension _R tables failing to create? 

I am working on the old project Now.

This project was copied from another project repository.

Environment: Sandbox

Version: 20.10.36.64

Data Source: Business unit

Provider: SQL Server Data Source

The connection with the Data source is good and synchronized well.

When I am deploying the tables in ODX storage getting an Error.

An error occurred during create a table. See exception details for the failing object: Create failed for Table 'BSA.BSA_dbo_Inspection_R'.
An exception occurred while executing a Transact-SQL statement or batch.
The specified schema name "BSA" either does not exist or you do not have permission to use it.

 

 

 

 

icon

Best answer by Christian Hauggaard 7 May 2023, 06:32

View original

2 replies

Userlevel 6
Badge +5

Hi @sguntupalli 

Can you please try deploying your schema?

 

Userlevel 6
Badge +5

Hi @sguntupalli did this resolve your issue? If so please help us by marking the best answer above. Please let me know if you have follow up questions

Reply