Failed to deploy project. For more information, query the operation_messages view for operation ID "20132"?
The packages were deployed fine. Initially I made a few changes and will try to deploy it again. I am getting the following error:
Failed to deploy project. For more information, request the operation_messages view for operation ID "20132"
When I query the SSIS database with select * from catalog.operations_messages
no rows are returned, only the column headers are displayed in the column. Please, help
source to share
First , referring to this Microsoft Link . This view requires one of the following permissions:
- READ permission for the operation
- Membership in the ssis_admin database role
- Membership in the sysadmin server role
Make sure you have permission to access this view
Second , the table SSISDB.catalog.operation_messages
keeps a log of the package execution. If there is no package on this server, the table SSISDB.catalog.operation_messages
will be empty.
And the package deployment log is kept in table [internal].[packages]
and [internal].[projects]
table
You can use a similar query to read information from these tables:
select * from internal.packages a inner join internal.projects b on a.project_id = b.project_id
source to share
take a look at the SQL Server logs
I had a similar problem yesterday with no messages in the table catalog.operation_messages
.
I only had a row in the table catalog.operations
related to deployment.
Googling on the internet today I discovered that it might be a memory issue.
In the log mentioned earlier, I received these messages (see below) at the time I deployed my integration ... and WOW! I realized that my VM box has 2 GB (total RAM) , max 1 GB for ms sql server ... :(
This is the machine we only use for SSIS management and testing purposes ... anyway, do you think 2 GB for the machine and 1 GB for the server is enough?
I tried deployment again today and luckily (or accidentally) worked with it with the same number of bars and the same messages (less than yesterday for the same deployment).
01/17/2018 15:25:10,spid22s,Unknown,AppDomain 5 (SSISDB.dbo[runtime].4) unloaded.
01/17/2018 15:25:09,spid14s,Unknown,AppDomain 5 (SSISDB.dbo[runtime].4) is marked for unload due to memory pressure.
01/17/2018 15:24:54,spid69,Unknown,Unsafe assembly 'microsoft.sqlserver.integrationservices.server<c/> version=11.0.0.0<c/> culture=neutral<c/> publickeytoken=89845dcd8080cc91<c/> processorarchitecture=msil' loaded into appdomain 5 (SSISDB.dbo[runtime].4).
01/17/2018 15:24:54,spid69,Unknown,Unsafe assembly 'microsoft.sqlserver.integrationservices.server<c/> version=11.0.0.0<c/> culture=neutral<c/> publickeytoken=89845dcd8080cc91<c/> processorarchitecture=msil' loaded into appdomain 5 (SSISDB.dbo[runtime].4).
01/17/2018 15:24:54,spid69,Unknown,AppDomain 5 (SSISDB.dbo[runtime].4) created.
01/16/2018 17:25:07,spid27s,Unknown,AppDomain 4 (SSISDB.dbo[runtime].3) unloaded.
01/16/2018 17:25:06,spid27s,Unknown,AppDomain 4 (SSISDB.dbo[runtime].3) is marked for unload due to memory pressure.
01/16/2018 17:24:03,spid69,Unknown,Unsafe assembly 'microsoft.sqlserver.integrationservices.server<c/> version=11.0.0.0<c/> culture=neutral<c/> publickeytoken=89845dcd8080cc91<c/> processorarchitecture=msil' loaded into appdomain 4 (SSISDB.dbo[runtime].3).
01/16/2018 17:24:03,spid69,Unknown,Unsafe assembly 'microsoft.sqlserver.integrationservices.server<c/> version=11.0.0.0<c/> culture=neutral<c/> publickeytoken=89845dcd8080cc91<c/> processorarchitecture=msil' loaded into appdomain 4 (SSISDB.dbo[runtime].3).
01/16/2018 17:24:03,spid69,Unknown,AppDomain 4 (SSISDB.dbo[runtime].3) created.
01/16/2018 17:24:02,spid15s,Unknown,AppDomain 3 (SSISDB.dbo[runtime].2) unloaded.
01/16/2018 17:24:02,spid15s,Unknown,AppDomain 3 (SSISDB.dbo[runtime].2) is marked for unload due to memory pressure.
01/16/2018 17:23:57,spid69,Unknown,Unsafe assembly 'microsoft.sqlserver.integrationservices.server<c/> version=11.0.0.0<c/> culture=neutral<c/> publickeytoken=89845dcd8080cc91<c/> processorarchitecture=msil' loaded into appdomain 3 (SSISDB.dbo[runtime].2).
01/16/2018 17:23:57,spid69,Unknown,Unsafe assembly 'microsoft.sqlserver.integrationservices.server<c/> version=11.0.0.0<c/> culture=neutral<c/> publickeytoken=89845dcd8080cc91<c/> processorarchitecture=msil' loaded into appdomain 3 (SSISDB.dbo[runtime].2).
01/16/2018 17:23:57,spid69,Unknown,AppDomain 3 (SSISDB.dbo[runtime].2) created.
source to share