MS SQL Realtime datasource trigger works but nothing update through service.
Syed asked 8 years ago
Hi,
I have checked the Realtime datasource. The trigger is working and I have checked through adding log in this.
But after that the wcf service not hit or works as required. I need to update some extended fields through this.
Please check any setting required to run the wcf service which we missed. This issues is appears after restoring the database and before that it works but it gives issue on document task assemble compilation.
Please check for both the issue and provide solution.
ALTER TRIGGER [dbo].[eOneR__tr_CM_Customer_U]
ON [dbo].[CM_Customer]
AFTER UPDATE
AS
SET NOCOUNT ON
IF ( UPDATE(ApprovedBy) OR UPDATE(ApprovedDt))
BEGIN
declare @parameter nvarchar (MAX)
select @parameter = (SELECT *
FROM [CM_vw_GETAPPROVEDSUTOMER] for xml path(‘row’),ROOT(‘rows’))
END
BEGIN
EXECUTE eOneMssqlRealTimeStoredProcedure
‘http://localhost:5557/SmartConnect.svc’,’gpadmin’,’QW3UmcPZGK89hw77JhoWTw==’,’SupremeOil’,’288eb1b0-1ba3-426f-9fb6-a425001ac12c’,’Update’, @parameter
END
I have checked the Realtime datasource. The trigger is working and I have checked through adding log in this.
But after that the wcf service not hit or works as required. I need to update some extended fields through this.
Please check any setting required to run the wcf service which we missed. This issues is appears after restoring the database and before that it works but it gives issue on document task assemble compilation.
Please check for both the issue and provide solution.
ALTER TRIGGER [dbo].[eOneR__tr_CM_Customer_U]
ON [dbo].[CM_Customer]
AFTER UPDATE
AS
SET NOCOUNT ON
IF ( UPDATE(ApprovedBy) OR UPDATE(ApprovedDt))
BEGIN
declare @parameter nvarchar (MAX)
select @parameter = (SELECT *
FROM [CM_vw_GETAPPROVEDSUTOMER] for xml path(‘row’),ROOT(‘rows’))
END
BEGIN
EXECUTE eOneMssqlRealTimeStoredProcedure
‘http://localhost:5557/SmartConnect.svc’,’gpadmin’,’QW3UmcPZGK89hw77JhoWTw==’,’SupremeOil’,’288eb1b0-1ba3-426f-9fb6-a425001ac12c’,’Update’, @parameter
END