Pull Request and Release are successful, but the result in production database doesn't modify in Azure Synapse Analytics

Zhuoqiong Mo 40

Hello, I have modified my SQL Script in the develop hub, made a commit in the develop branch. Later, I have make a pull request (from develop branch to production branch). The release status indicates 'production' successful. The modification in database in the development branch is changed, but the database in the production branch doesn't. But when I look up my SQL script in develop branch and production branch, both of them are updated. What is the reason the database in the production branch is not updated? Best wishes, Joan

Harishga 5,990 Reputation points Microsoft Vendor

2024-02-07T12:06:53.6733333+00:00
Hi @Zhuoqiong Mo

Welcome to Microsoft Q&A platform and thanks for posting your question here.

There could be several reasons why the modification in the database in the development branch is changed, but the database in the production branch doesn't change even though the SQL script in both the develop branch and production branch are updated.

Here are some possible reasons and solutions:

Due to asynchronous object synchronization in Azure Synapse Analytics, it may take a few seconds or minutes for new databases and tables to show up in the SQL context. Once they appear, you can use them, but you can't make any changes to them right away. So, you might need to wait a little bit before you can see any updates you make to the database.

Having the necessary roles assigned in the Access control (IAM) tab of the Azure portal is crucial to modify the production database in Azure Synapse Analytics, as permissions are checked at the file system level. it's important to ensure that you have the required roles assigned to make any modifications to the production database.

Review the SQL script for completeness and correctness to ensure that changes reflect in the production database.

Ensure that changes are made in the correct branch and merged into the production branch.

Check deployment logs for any errors or warnings that might indicate why changes were not applied to the production database.

I hope this information helps you. Let me know if you have any further questions or concerns.
Zhuoqiong Mo 40 Reputation points

2024-02-08T08:36:52.8066667+00:00
Hi @Harishga,

Thanks for the reply.

I have waited over a week, and it's the same.

I check my role as well, I have the owner and contributor right in both branches.

The SQL in production branch is correct

also the changes are made correctly.

The deployment logs without any error message.

I still have the issue.

to correct my question, changes are updated in both branches, but it doesn't update the production environment.
Harishga 5,990 Reputation points Microsoft Vendor

2024-02-08T11:00:16.6666667+00:00
Hi @Zhuoqiong Mo

Thank you for providing more information. Since you have already checked the possible reasons and solutions I mentioned earlier, here are some additional steps you can take to troubleshoot the issue:

Check if there are any triggers or stored procedures that might be preventing the changes from being applied to the production database. You can review the code and disable them temporarily to see if that resolves the issue.

Verify that the connection string used in the deployment process is correct and points to the production database. If the connection string is incorrect, the changes will not be applied to the production database.

Check if there are any locks on the production database that might be preventing the changes from being applied. You can use the SQL Server Management Studio to view the locks and release them if necessary.

Try to manually execute the SQL script in the production environment to see if the changes take effect. If the changes are applied when you execute the script manually, it might indicate an issue with the deployment process.

I hope this helps you resolve the issue. Let me know if you have any further questions or concerns.
Harishga 5,990 Reputation points Microsoft Vendor

2024-02-09T04:25:15.42+00:00

Hi @Zhuoqiong Mo
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Harishga 5,990 Reputation points Microsoft Vendor

2024-02-12T03:52:07.94+00:00

Hi @Zhuoqiong Mo
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Pull Request and Release are successful, but the result in production database doesn't modify in Azure Synapse Analytics

Your answer