AutoIT script error - The requested action with this object has failed

[Alexandru_Cociorva]

Hi everyone,

When trying to call a compiled AutoIT script (executable file) from Access mdb, VBA module (through specific environment parameters) I receive the following error message: "The requested action with this object has failed", as seen in the attached image. The au3 script is used in the purpose of connecting to SAP One and extracting data from the layers. The AutoIT script is called using the following command lines (taken from the VBA module):  

 cmd = """" & mypath & ScriptsDir & "\MUS_ZVBAK_2.exe"" """ & envdir & """  """ & flagfile & """ " & dal & " " & al

 Sessions(session).AutoITID = Shell(cmd)

All script calling parameters are correctly defined and the paths have been verified. The executable file can run only using above cmd script calling line.

I have this integration (AutoIT-VBA) functional in another environment and, as I verified the compatibility parameters between the production environment and the new test environment (in which I must make the integration functional), I installed the same AutoIT version (AutoIt v3.3.14.5). Even though I have the same AutoIT version I get the reported error.

 

Taking into account the presented aspects, the following assumptions arise:

1. MS Office incompatibility (since in the functional production server I have MS Office 2007 and in the UAT I have MS Office 365)

2. Operating system incompatibility

3. Some environment variables not properly set (libraries, registered dlls, etc.)

 

Since this AutoIT error represents a blocking point at the moment, could you please help me in solving this issue?

 

Thank you very much!

Alexandru Cociorva

[Jos]

21 minutes ago, Alexandru_Cociorva said:

Since this AutoIT error represents a blocking point at the moment, could you please help me in solving this issue?

Well did you check line 4874? It sounds like a good place to start.  

Jos

[Alexandru_Cociorva]

33 minutes ago, Jos said:

Well did you check line 4874? It sounds like a good place to start.  

Jos

Hi Jos,

Line 4874 cannot be visualized because it make reference to the compiled executable file. When trying to run just the MUS_ZVBAK_2.au3 I receive environment variables not properly set, but the same error is shown in production, therefore the only way to call the script is through the cmd line presented above, from the VBA module, calling the executable file; while in production, it works.

Or maybe there is another way to debug this error, but I am not aware of.

Kindly help me in solving this issue.

Thank you very much,

Alexandru Cociorva

[Jos]

You can determine the linenumber easily when you have au3stripper installed as that has a /MO /MergeOnly option, which will merge all include files in the same way as AutoIt3 does. 

Either way: You must appreciate the fact that we can't support this unless we see some sourcecode!

JOs

[Alexandru_Cociorva]

19 hours ago, Jos said:

You can determine the linenumber easily when you have au3stripper installed as that has a /MO /MergeOnly option, which will merge all include files in the same way as AutoIt3 does. 

Either way: You must appreciate the fact that we can't support this unless we see some sourcecode!

JOs

Hi Jos,

 

I have installed au3stripper but I am not familiar on the way of working with AutoIT technology. Unfortunately I can provide only pieces from the code.

Could you please guide me in the process of investigation?

Thank you,

Alexandru Cociorva

[Jos]

There is a seperate helpfile available for SciTE4AutoIt3 and you simply run the master script through au3stripper with the /MergeOnly parameter and check the produced scriptname_stripped.au3 for the linenumber in the error.

Jos