Unable to create Lake database in Azure Synapse Studio with a Name "GOLD"

Question

Unable to create Lake database in Azure Synapse Studio with a Name "GOLD"

Murali Jillellamudi 5

I am able to create a lake database with any other names except "anything beginning with GOLD"

I am getting the following error when I click publish my changes

Error while publishing: Failure with code: 403, message: {

"Code": "SasOcMismatch",

"Message": "OC mismatch. Request entity: [Name: 'DATABASE-gold', OC 'SPARK'] OC mismatch with [Name: 'DATABASE-GOLD', OC 'SQLOD']"

}

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-08-03T06:26:32.5366667+00:00

@Murali Jillellamudi - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
sy 0 Reputation points

2024-10-22T16:13:56.0766667+00:00

@PRADEEPCHEEKATLA
The solution does not help, I'm also facing the same issue. I believe the issue was due to accidentally using the "CREATE DATABASE ... " command first before using the built in feature to add a new Lake Database.

1 answer

Your answer

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-08-03T06:26:32.5366667+00:00

@Murali Jillellamudi - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
sy 0 Reputation points

2024-10-22T16:13:56.0766667+00:00

@PRADEEPCHEEKATLA
The solution does not help, I'm also facing the same issue. I believe the issue was due to accidentally using the "CREATE DATABASE ... " command first before using the built in feature to add a new Lake Database.

Answer 1

PRADEEPCHEEKATLA 90,641 Moderator

@Murali Jillellamudi - Thanks for the question and using MS Q&A platform.

Please confrm if you have a Lake database with name: DATABASE-GOLD as per the error message it looks the name mismatch with the enitity already existed with the same name?

Could you please share the screenshot of the Data tab which contains Lake database and SQL database as shown below?

User's image

As per the repro from my end, I'm able to create lake database with name: Database-Gold as shown below:

LakeDatabase-Gold

Hope this helps. Do let us know if you any further queries.

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2023-08-07T06:54:41.6+00:00

@Murali Jillellamudi - Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Unable to create Lake database in Azure Synapse Studio with a Name "GOLD"

1 answer

Your answer