2 questions

View Only

Back to discussions

Expand all | Collapse all

1. 2 questions

Like

manueldomingo manueldomingo.oreiro

Posted 06-08-2020 04:47

C1-Non sensitive

Hello

I'm creating a chained script (3 queries and 1 transaction).

Question 1: For each query/transaction, is it necessary to validate the Log On for SAP? Is it not possible to validate once?

Question 2: I'd like to have a message box with the message [Transaction Finished] or something like that, because while the script is running we can't know if it's finished or not. Is it possible?

Thanks so much!!

image001.png@01D193D3.0D03A420

Un saludo / Cordialement

Manuel OREIRO

DI/PME/DMFG/IS4P

S4 PROJECT Migration ov pcd - new equipment

+33 966667749 (Int 277749) // Mobile : +34 669492879

manueldomingo.oreiro@mpsa.com

Site de Vigo

2. RE: 2 questions

Like

jan ketele

Posted 06-09-2020 08:14

Hola Manuel,

SAP login is needed only once within a chain of scripts.
Go to chain settings (screenshot) and then to ALC.

When I run chained scripts, Winshuttle studio 12.1 gives me the message 'All scrips ran succesfully'.
Furthermore, the log table of the last script is filled out, so that's another sign all scrips within the chain have finished.

------------------------------
jan ketele | Sr engineer release mgt
Xeikon Manufacturing NV | +3234431875
------------------------------

Original Message

3. RE: 2 questions

Like

manueldomingo manueldomingo.oreiro

Posted 06-09-2020 10:50

Thank you Jan

I've done what you say, but it works only when you are chaining only queries or only transactions. In my case I have both and it's necessary to validate the Log On for each one... The custom option is not available... :(

Concerning the message box, I didn't say before that I run the scripts embebed into the Excel File and with the most of the pages hiden, for user's appearence reasons... In this case it's difficult to realize if the scripts have finished or not... I need a real message box. I can do it directly by an Excel Macro in VB, but the problem is that the message is shown before the script has finished. I launch by VB the starting of the Winshuttle and the message appears inmediately. I need something into the winshuttle script...

------------------------------
manueldomingo.oreiro |
PSA Groupe |
------------------------------

Original Message

4. RE: 2 questions

Like

Jan van Asseldonk

Posted 06-09-2020 14:38

Hi Manuel,

if you start your script from vb then you can check in vb if the last row of the log filecolumn is filled.
Don't show the message box until this is filled.
Or make check the log header and check if the Execution time has a value. That should work for both Transaction and Query.

regards

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Original Message

5. RE: 2 questions

Like

Employee

Sigrid Kok

Posted 06-11-2020 14:27

Hi Manuel

As you've found out, chaining transaction and query scripts does not allow you to carry through the initial login between them. Once you switch between the two, i.e. from query to transaction or transaction to query, it will prompt for another login.

I would suggest you open a support ticket requesting our product team consider an enhancement for a single login to work. I think it should work with one login, as well. :)

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message