Hi Dears,
I´m trying to update my dataset with this instrunction inside a trigger:
EXEC @result = xp_CMDShell 'C:\"Program Files"\"ABBYY FlexiCapture 12 Servers"\FlexiBrSvc.exe please update dataset "http://localhost/20/TestSinProveedorSociedad" "Invoice ES" "BusinessUnits"'
But it returns as follows:
Access denied. Contact your Administrator.
I have checked Windows Event Viewer and I see the nex error:
ABBYY FlexiCapture Web Services
Access denied. Contact your Administrator.
Access denied. Contact your Administrator.
If I execute this command in cmd windows it works fine, but not from SQL trigger.
Can you help me?
Thanks in advance!
コメント
2件のコメント
This is probably an issue with account you're running the shell command under and not related to FlexiCapture.
https://stackoverflow.com/questions/10822464/access-denied-for-enabled-xp-cmdshell-for-the-admin-user/10823070
Hi Scott,
Thanks for your help.
Finally I could to execute the trigger adding the user to FlexiCapture. But now, I can see the task finish in error state. a time out error:
This is the trigger:
/****** Object: Trigger [dbo].[UPDATE_DATASET_BUSINESSUNITS] Script Date: 08/10/2021 12:07:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[UPDATE_DATASET_BUSINESSUNITS]
ON [dbo].[NLP_UNIDADES_NEGOCIO]
AFTER INSERT
AS
BEGIN
DECLARE @result int;
DECLARE @log nvarchar(50);
--EXEC @result = xp_CMDShell '\\localhost\Users\km\TestSinProveedorSociedad\"Update datasets"\update_business_units.bat';
EXEC @result = xp_CMDShell 'cd..';
if(@result = 0)
SET @log = 'Success'
else
SET @log = 'Error';
INSERT INTO NLP_UPDATE_LOG (LOG) VALUES (@log);
END
And the .bat file is like follows:
cd C:\Program Files\ABBYY FlexiCapture 12 Servers
FlexiBrSvc.exe please update dataset "http://localhost/20/TestSinProveedorSociedad" "Invoice ES" "BusinessUnits"
Have you any idea about what is wrong?
Thanks!
サインインしてコメントを残してください。