Powerplay and impromptu 7.0 does not wait when run from a dos batch file.
Tim Cummings
tim.cummings@frequencymarketing.com
Mon, 1 Jul 2002 10:32:53 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_005E_01C220EA.A86B0FE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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\oh
io -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\oh
io -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\oh
io -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\oh
io -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\oh
io -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\oh
io -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
------=_NextPart_000_005E_01C220EA.A86B0FE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C220EA.A83273B0">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:10.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US style=3D'tab-interval:.5in'>
<div class=3DSection1>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>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.<span
style=3D"mso-spacerun: yes"> </span>It appears that under version =
7.0 of Transformer
that this is not the case.<span style=3D"mso-spacerun: yes"> =
</span>If I
run the following batch file it will launch 6 copies of Transformer all =
at the
same time.<span style=3D"mso-spacerun: yes"> </span>I also noticed =
that
Impromptu works the same way.<span style=3D"mso-spacerun: yes"> =
</span>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?<span style=3D"mso-spacerun: yes"> =
</span></span></font><font size=3D2
color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'><![if =
!supportEmptyParas]> <![endif]></span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>I opened a ticket with Cognos but I have not =
received
an answer yet.</span></font><font size=3D2 color=3Dblack face=3D"Courier =
New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New";color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'><![if =
!supportEmptyParas]> <![endif]></span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>Has anyone out there experienced =
this?</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'><![if =
!supportEmptyParas]> <![endif]></span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>Below is a portion of my .bat file that is =
used to
create some of my powercubes.<span style=3D"mso-spacerun: yes"> =
</span></span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'><![if =
!supportEmptyParas]> <![endif]></span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>rem</span></font><font size=3D2 color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>rem<span style=3D"mso-spacerun: yes"> =
</span>Now
that all customer data has been loaded and the summary tables are =
complete</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>rem<span style=3D"mso-spacerun: yes"> =
</span>we
will build the customer powercubes.</span></font><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>rem</span></font><font size=3D2 color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>"C:\Program =
Files\Cognos\cer1\bin\trnsfrmr.exe"
-dLogFileDirectory=3Dc:\dolly\prod\logs\ohio -r4 -i -n -k"Dolly
Database=3Dohio/ohio" =
c:\dolly\prod\cubes\ohio\customer_btn_cube1.mdl</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe"
-dLogFileDirectory=3Dc:\dolly\prod\logs\ohio -r4 -i -n -k"Dolly =
Database=3Dohio/ohio"
c:\dolly\prod\cubes\ohio\customer_btn_cube2.mdl</span></font><font =
size=3D2
color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe"
-dLogFileDirectory=3Dc:\dolly\prod\logs\ohio -r4 -i -n -k"Dolly
Database=3Dohio/ohio" =
c:\dolly\prod\cubes\ohio\customer_btn_cube3.mdl</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>"C:\Program =
Files\Cognos\cer1\bin\trnsfrmr.exe"
-dLogFileDirectory=3Dc:\dolly\prod\logs\ohio -r4 -i -n -k"Dolly
Database=3Dohio/ohio" =
c:\dolly\prod\cubes\ohio\customer_btn_cube4.mdl</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe"
-dLogFileDirectory=3Dc:\dolly\prod\logs\ohio -r4 -i -n -k"Dolly
Database=3Dohio/ohio" =
c:\dolly\prod\cubes\ohio\customer_btn_cube5.mdl</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>"C:\Program
Files\Cognos\cer1\bin\trnsfrmr.exe"
-dLogFileDirectory=3Dc:\dolly\prod\logs\ohio -r4 -i -n -k"Dolly
Database=3Dohio/ohio" =
c:\dolly\prod\cubes\ohio\customer_btn_cube6.mdl</span></font><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier =
New";color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal =
style=3D'mso-layout-grid-align:none;text-autospace:none'><font
size=3D2 color=3Dblack face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:
"Courier New";color:black'>exit</span></font><font size=3D2 =
color=3Dblack
face=3D"Courier New"><span =
style=3D'font-size:10.0pt;font-family:"Courier New";
color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3Dblack
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'><![if =
!supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3Dblack
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Tim Cummings<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3Dblack
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Cummings Consulting<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3Dblack
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>Cincinnati, Ohio<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3Dblack
face=3DArial><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial'>513-576-1182<o:p></o:p></span></font></span></p>
</div>
</body>
</html>
------=_NextPart_000_005E_01C220EA.A86B0FE0--