Not a valid win 32 application

酥糖公子

Hello,
I have this in the epilog of a process
NumericGlobalVariable('ProcessReturnCode');
If(ProcessReturnCode=ProcessExitNormal());
ExecuteCommand('D:ErrorEmail2.vbs',1);
Endif;
And I get a "Error: Epilog procedure line (17): %1 is not a valid Win32 application." in the message log.
The vbs file works in the command prompt but not as part of TI.
Anyone knows the solution?

sysease

My guess would be that in the ExecuteCommand function you need to pass the parameter to your vb script as a string not a value.

... but also, if the process exits normally without errors why would you want to send an email notification, surely you would want to do this only in the event of a process error log being generated?

cswing_5

No no  no...

This is not the right way to call VBScript from TI.

ExecuteCommand will need to call a exe or a cmd, bat file. It can't execute a VBS directly.

Do this instead to execute VBS:

ExecuteCommand('C:windowssystem32cscript.exe D:ErrorEmail2.vbs',1);

luozhongli

Hello,
To answer lotsaram, I used ProcessExitNormal() just to make sure the email section gets called so I can test if the email gets sent out.

I changed my code as suggested by kangkc and it worked!! thanks all....

wanglinyangling

  Hi Telula, would you mind sharing the vbs code too? not sure i can use automated email here but would be interesting to see how you are calling it, thanks

a23742212

You've got to call the vbs using the command shell like kangkc said.

香香公主的家

I think Steve refers to how to call the sending of the email - like in



(If Steve doesn't refer to how to make the mailing happen the link might be useful for someone who stumbles on this post via search  )
And kangkc might be the kc_kang credited at above mentioned link, that would explain why he knows how to get vbs-scripts running...

Oh - and because bihints tends to be unreachable exactly the moment you need it most - I attached the send-script. (And because I may not upload txt,vbs or invalid jpg I renamed it to zip, which it is - obvioously - not. rename to txt, vbs or any extension you associate with an editor capable of opening plain text format, which should be virtually anyone not limited to wysiwyg)
To quote the credits: "code from kc_kang (applix forum) and http://www.rondebruin.nl/cdo.htm"

PS.: it is definitely too hot here...

245317177

SKIPCHECK;;
['kangkc']=['kc_kang'];

FEEDERS;
['kc_kang'] => ['kangkc']


  

I used a fair bit of ExecuteCommand in my consultancy work involving TM1, and there are many possibilities in process automation. TI is a very dynamic and yet simple ETL tool.

maxhyip

kangkc wrote:SKIPCHECK;
['kangkc']=['kc_kang'];

FEEDERS;
['kc_kang'] => ['kangkc'];

In your case I would have created an alias - I really hate having hundreds of elements mirroring each other using rules
(So I could never work at government agency where one might be able to change his or her name (honestly, I have no clue how to call the place - not even in my language. But it doesn't matter) - "I'm sorry, I'm from the TM1-side, so you want to see someone from SAP; they can change your name, I can only offer you an alias")

libo600

Lukas Meyer wrote:[quote]kangkc wrote:SKIPCHECK;
['kangkc']=['kc_kang'];

FEEDERS;
['kc_kang'] => ['kangkc'];

In your case I would have created an alias - I really hate having hundreds of elements mirroring each other using rules
(So I could never work at government agency where one might be able to change his or her name (honestly, I have no clue how to call the place - not even in my language. But it doesn't matter)
[/quote]

If I had to guess (about both the language and the name) it would be "Standesamt" or in English, "Registry Office".

(Or, in my own case if I revert to my former Applix Forums persona, "the Project Treadstone office at CIA Langley". Although of course I don't remember any of that...)

Lukas Meyer wrote: - "I'm sorry, I'm from the TM1-side, so you want to see someone from SAP; they can change your name, I can only offer you an alias")

No, it is possible to change a name in TM1... as long as you don't mind going via the old version 6, pre-alias method of exporting their personality into a text file, deleting their name, entering the new one into their ID dimension, recompiling the dimension and re-importing their personality.

Might take a while, though.   

(For the technically pedantic, yes, I know that you're really deleting the old element and creating a new one rather than "renaming" the original, but in version 6 it was as close as you got to it...)