This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I can't tell without more detailed info, but it sounds like your VBScript is hanging while trying to create the file if it's already there. Is there any way the the script file can check if the file is already there and exit with a non-zero error code if it is? The error code should stop the workflow from proceeding any further.
thank you very much , Please find the detailed information
when workflow runs , Its create the lock file with the help of VBA Script
Dim fdObj As Object Application.ScreenUpdating = False Set fdObj = CreateObject("Scripting.FileSystemObject") If fdObj.FileExists("G:\Team Drives\GBL IPM IT BACKUP\Alteryx\04. Wacker\1. App_Transformation of Auswertung Accounting Files\app.lock") Then
Call Err.Raise(vbObjectError + 10, "My Application", "App is running and locked by other user")
fdObj.CreateTextFile ("G:\Team Drives\GBL IPM IT BACKUP\Alteryx\04. Wacker\1. App_Transformation of Auswertung Accounting Files\app.lock") End If Application.ScreenUpdating = True End Sub
This create the file successfully when one user try to run the workflow through app .Now what i want is when other user try to run the workflow an finds this file in the folder , for second or other user the app should not run the or abort but now what is happening is , the other user wait for the completion of 1st run . Please find the pic , where i call my script of creation .
can you tell me ,How can we achieve this functionality in alteryx ?