我有一个Azure自动化作业,每天都会将BACPAC文件导入到Azure SQL数据库中.一天可以正常工作,第二天不导入. (请参见下面的错误).当您通过单击运行该作业时,效果很好.所以BACPAC没什么问题 文件.似乎是Azure问题,不想每月支付100美元的支持费用,让他们解决自己的问题.
I have a Azure Automation job that imports a BACPAC file to a Azure SQL Database on a daily basis. One day it works fine, the next day it doesn't import. (See Error below). Works fine when you run the job by clicking on it. So nothing is wrong with the BACPAC file. Seems to be an Azure issue, hate to pay $100 a month for supportto have them fix their own issue.
任何见解都会有所帮助.
Any insights would be helpful.
谢谢
Donnie
错误消息:
服务操作期间遇到错误. 无法导入软件包. 警告SQL0:将SQL Server 2016指定为目标平台的项目可能会遇到与Microsoft Azure SQL数据库v12的兼容性问题. 错误SQL72014:.Net SqlClient数据提供程序:消息42019,级别16,状态4,行1创建数据库操作失败.内部服务错误. 错误SQL72045:脚本执行错误.执行的脚本: 创建数据库[$(DatabaseName)]收集SQL_Latin1_General_CP1_CI_AS (EDITION ='标准',SERVICE_OBJECTIVE ='S2',MAXSIZE = 20 GB) 错误SQL72014:.Net SqlClient数据提供程序:消息0,级别20,状态0,行0在当前命令上发生了严重错误.结果(如果有的话)应丢弃. 错误SQL72045:脚本执行错误.执行的脚本: 创建数据库[$(DatabaseName)]收集SQL_Latin1_General_CP1_CI_AS (EDITION ='Standard',SERVICE_OBJECTIVE ='S2',MAXSIZE = 20 GB)
Error encountered during the service operation. Could not import package. Warning SQL0: A project which specifies SQL Server 2016 as the target platform may experience compatibility issues with Microsoft Azure SQL Database v12. Error SQL72014: .Net SqlClient Data Provider: Msg 42019, Level 16, State 4, Line 1 CREATE DATABASE operation failed. Internal service error. Error SQL72045: Script execution error. The executed script: CREATE DATABASE [$(DatabaseName)] COLLATE SQL_Latin1_General_CP1_CI_AS (EDITION = 'Standard', SERVICE_OBJECTIVE = 'S2', MAXSIZE = 20 GB) Error SQL72014: .Net SqlClient Data Provider: Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Error SQL72045: Script execution error. The executed script: CREATE DATABASE [$(DatabaseName)] COLLATE SQL_Latin1_General_CP1_CI_AS (EDITION = 'Standard', SERVICE_OBJECTIVE = 'S2', MAXSIZE = 20 GB)
推荐答案
Hello,
这可能是由瞬态网络问题引起的.您能否尝试为运行本配置重试时间,例如15分钟或30分钟 分钟后.
This may be caused by transient network issues. Could you try to configure a retry for your runbook like 15 minutes or 30 minutes later.
azure.microsoft/zh-cn/updat es/automation-configure-activity-retry-in-graphical-runbooks/
azure.microsoft/en-us/updates/automation-configure-activity-retry-in-graphical-runbooks/
希望这会有所帮助.
Hope this helps.
关于
阿尔贝托·莫里洛 SQLCoffee
Alberto Morillo SQLCoffee
更多推荐
自动数据库导入在一天而不是第二天有效
发布评论