topic Re: Problem calling VBSscript in Application Development and Automation Discussions

Problem calling VBSscript

former_member736811 — Mon, 22 Mar 2021 12:28:40 GMT

Hi,

I have a problem calling an external command via CALL FUNCTION 'SXPG_CALL_SYSTEM'.

the command I execute is a visual basic script that opens an html file and exports it as a microsoft word file.
The same script, if executed directly from the server (command line) using the same SAP user (SAPserviceSID) is executed correctly.

Therefore the authorization permission problems are already solved.

Below the log of the function:

The script runs but crashes on the Documents.OPEN statement. Below the instruction (row 42):

would anyone be able to give me suggestions to solve the problem?

Regards,

Davide

Re: Problem calling VBSscript

Sandra_Rossi — Mon, 22 Mar 2021 16:27:03 GMT

Are you telling us that you have MS Word installed on the server?

Re: Problem calling VBSscript

former_member736811 — Mon, 22 Mar 2021 17:06:15 GMT

yes, microsoft office is reg. installed on the server. As I said before, if I run the script.vbs from command promt, the script works fine. Only if I run it from SAP (abap or .... test script via SM69) it doesn't work.

Regs.,

Davide

Re: Problem calling VBSscript

Sandra_Rossi — Mon, 22 Mar 2021 19:11:10 GMT

Did you make sure there is only one application server?

Are you sure you are passing the parameters correctly? Did you pass quotes around Word file parameter in case it contains spaces (see note 1152084 - Parameter for external commands)

Did you test with a very simple VBS file without any parameter/variable, do you create a Word document?

Re: Problem calling VBSscript

former_member736811 — Tue, 23 Mar 2021 08:17:39 GMT

below all the tests I did:

- created simple script and executed correctly
- verified that the parameters are correctly executed with quotation marks
- the same script, if executed hardcoded on SAP, goes in error. via Promt command works correctly

Server side, the only behavior I see is that WINWORD.EXE appears in the task management ...... but it stays in "running" state .... without doing anything.

Line 43 is the one that does not execute correctly .... it goes into error .. and I don't know what to do anymore.

Re: Problem calling VBSscript

former_member736811 — Tue, 23 Mar 2021 08:19:40 GMT

another useful information. On another project | Client, the same ABAP tool calling the same script .... run correctly.