Failed to deploy project. For more information, query the operation_messages view
来源:互联网 发布:淘宝突然没有访客了 编辑:程序博客网 时间:2024/06/06 14:06
遇到同样的错误,查到这个是微软的一个BUG,网上有解决办法。原文来自:http://capstonebi.blogspot.de/2012/09/ssis-2012-deployment-frustrations.html
I went to deploy a large SSIS project recently and received this error from the Deployment Wizard:
Failed to deploy project. For more information, query the operation_messages view for the operation identifier ’219′. (Microsoft SQL Server, Error: 27203)
Hoping that I would find out more I queried the catalog.operation_messages table in the SSISDB database.
The message column reads as follows:
Failed to deploy the project. Fix the problems and try again later.:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The statement has been terminated.
As the person deploying the project, I can’t “help” the Deployment Wizard with tweaking any queries, but I could see what it was doing using SQL Profiler. The query that caught my attention is the following:
exec [internal].[sync_parameter_versions] @project_id=2,@object_version_lsn=10
Notice the number of reads(1.7M) and the duration(30 seconds). I acquired the query plan for this stored procedure and found that it would run much faster if the following two indexes are applied to the SSISDB database.
USE [SSISDB]GOCREATE NONCLUSTERED INDEX [ix1_internal_object_parameters_inc] ON [internal].[object_parameters]( [project_id] ASC , [project_version_lsn] ASC)INCLUDE ( [parameter_id], [object_type], [object_name], [parameter_name], [parameter_data_type], [required], [sensitive]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF , ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GOCREATE NONCLUSTERED INDEX [ix2_internal_object_parameters_inc] ON [internal].[object_parameters]( [project_id] ASC , [project_version_lsn] ASC , [object_type] ASC , [object_name] ASC , [parameter_data_type] ASC , [required] ASC , [sensitive] ASC)INCLUDE ( [parameter_name], [default_value], [sensitive_default_value], [value_type], [value_set], [referenced_variable_name]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF , ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]GO
After these indexes were applied the deployment wizard had no more issues.
- Failed to deploy project. For more information, query the operation_messages view
- Failed to place enough replicas, still in need of 1 to reach 3. For more information。。。。
- VMware 打开.ova文件,提示Failed to query source for information的解决办法
- Failed to instantiate the default view controller for UIMainStoryboardFile
- Failed to instantiate the default view controller for UIMainStoryboardFile
- Failed to instantiate the default view controller for UIMainStoryboardFile
- Failed to instantiate the default view controller for UIMainStoryboardFile 'MainStoryboard'
- Failed to instantiate the default view controller for UIMainStoryboardFile
- Failed to instantiate the default view controller for UIMainStoryboardFile 'Main'
- Failed to instantiate the default view controller for UIMainStoryboardFile 'Main'
- Failed to instantiate the default view controller for UIMainStoryboardFile
- SQL Server Setup failed to obtain system account information for the ASPNET
- SQL Server Setup failed to obtain system account information for the ASPNET
- deploy the war project
- Loadrunner连接负载机失败,提示"Failed to connect to the load generator.Check the output window for more detail
- Setup failed to configure the server. Refer to the server error logs and setup error logs for more i
- loadrunner 连接负载机时"Failed to connect to the load generator.Check the output window for more details"
- Failed to load properties file for project
- 利用bastille配置安全的linux系统
- qt学习:四种方法实现界面的显示功能
- GRE写作必备句型
- 一、状态压缩dp(3)炮兵阵地
- redis 数据持久化
- Failed to deploy project. For more information, query the operation_messages view
- NYOJ 35 表达式求值(栈的压入与弹出)
- Swift_tableView创建及其实现协议
- #定位系统性能瓶颈# perf
- 最伟大的俄罗斯人
- C++的XML编程经验――LIBXML2库使用指南
- CDockablePane使用心得
- LabVIEW用户事件使用方法
- 如何将LabVIEW的VI转换为C语言代码