Powerplay and impromptu 7.0 does not wait when run from a dos batch file.

[Markus Grossrieder]

Tim,

if the problem is just the synchonization, try START /W to launch the jobs in
your batchfile (but I don't know if this command/option exists in W2K ...). In
Win98, there are the following options for START:

    C:\WINDOWS>start /?
    Runs a Windows program or an MS-DOS program.

    START [options] program [arg...]
    START [options] document.ext

    /m[inimized] Run the new program minimized (in the background).
    /max[imized] Run the new program maximized (in the foreground).
    /r[estored]  Run the new program restored (in the foreground). [default]
    /w[ait]      Does not return until the other program exits.

So your 1st launch would be:

    start /w "C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube1.mdl
    start /w ...

However, if this option is not available, you could create 1 master batch, and
then CALL the sub-batches, like:
(A:BAT)
rem
rem  Now that all customer data has been loaded and the summary tables are
complete
rem  we will build the customer powercubes.
rem
CALL A1.BAT
CALL A2.BAT
...

(A1.BAT)
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube1.mdl
exit

(A1.BAT)
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube2.mdl
exit

HTH, regards,

Markus

----- Original Message -----
From: Tim Cummings
To: Powerh-L@Lists. Swau. Edu
Sent: Monday, July 01, 2002 4:32 PM
Subject: Powerplay and impromptu 7.0 does not wait when run from a dos batch
file.


Under Transformer version 6.6 and below on my Windows 2000 server, when I used a
batch file to create my powercubes the batch file would pause and wait for
Transformer to complete the build of the powercube(s) before it would move on to
the next batch file statement.  It appears that under version 7.0 of Transformer
that this is not the case.  If I run the following batch file it will launch 6
copies of Transformer all at the same time.  I also noticed that Impromptu works
the same way.  Is there a command line switch or something that will tell
Transformer not to return control until it is completed with the cube it is
supposed to build?

I opened a ticket with Cognos but I have not received an answer yet.

Has anyone out there experienced this?

Below is a portion of my .bat file that is used to create some of my powercubes.

rem
rem  Now that all customer data has been loaded and the summary tables are
complete
rem  we will build the customer powercubes.
rem
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube1.mdl
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube2.mdl
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube3.mdl
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube4.mdl
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube5.mdl
"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe" -dLogFileDirectory=c:\dolly\prod\logs\ohio -
r4 -i -n -k"Dolly Database=ohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube6.mdl
exit

Tim Cummings
Cummings Consulting
Cincinnati, Ohio
513-576-1182