Topic
  • 3 replies
  • Latest Post - ‏2013-05-16T05:07:52Z by AF-Mika
Cognos_help
Cognos_help
2 Posts

Pinned topic Unable to refresh cubes in Cognos 10.2

‏2013-03-06T03:38:55Z |
Hi All,

We just upgrade our Cognos from Ver 8 to Ver 10.2. In the Ver 10.2, we now are unable to refresh cubes using the batch job in Windows 2008 server. My bath job uses the command likes this:

cogtr.exe -n2 -g -s -m"C:\cube_models\My_Model.mdl"

90% of the time this works, but sometimes the bath job is unable to refresh cubes. I have disable antivirus scanning program in our server but no avail.

Previously in Cognos Ver 8, we used cubeswap utility and it works perfectly 100%. In Cognos Ver 10 this utility is no longer available so I used the above command to refresh the cube.

Anyone have the same issue? Any ideas how to fix this?

Pham
Updated on 2013-03-11T06:57:37Z at 2013-03-11T06:57:37Z by Cognos_help
  • Cognos_help
    Cognos_help
    2 Posts

    Re: Unable to refresh cubes in Cognos 10.2

    ‏2013-03-11T06:57:37Z  
    Hi,

    More information about this issue and it's quite strange: when I use the Windows Tasks Scheduler to schedule the batch job to rebuild the cube, it cannot (sometime it can) read the updated data source even thought there is no error in the log file. But if I log into the server (using the same user ID that I used to scheduled the above-mentioned job) and executed manually the job, it read the updated data source and refresh the cube perfectly.

    My Cognos is setup with SSO and I used domain user ID to carried out the mentioned tasks.

    My batch job calls and bat file as:

    ECHO ON
    C:
    cd "C:\Program Files (x86)\ibm\cognos\c10\bin"
    cogtr.exe -n2 -g -s -m"C:\PlanCubes\Models\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdl" -r4
    exit

    Please see the log file below the scheduled task, which is failed to refresh the updated data source.

    Any ideal how to fix this? I need to schedule the job as it needs to execute frequently and currently we have to do it mannually (-:

    Thx

    Pham

    ------------------------------Log File---------------------------------

    Transformer(10.2.1003.25) Sat Mar 09 18:42:00 2013

    LogFileDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\Logs\
    ModelSaveDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\Models\
    DataSourceDirectory=..\data\
    CubeSaveDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\
    DataWorkDirectory=..\temp\
    ModelWorkDirectory=..\temp\
    MaxTransactionNum=500000
    Product locale: English (en)
    Run locale: English (United States) (en-us)
    Codepage: windows-1252

    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Start cube update.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Initializing categories.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, INITIALIZING CATEGORIES,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Start processing data source 'C:\PlanCubes\source\GWP_Plan\AICS_MIS_BDU_Plan2012_CUBE.csv'.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Reading source data.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, OPEN DATA SOURCE,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 End processing 3134 records from data source 'C:\PlanCubes\source\GWP_Plan\AICS_MIS_BDU_Plan2012_CUBE.csv'.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, READ DATA SOURCE,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Marking categories used.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, MARKING CATEGORIES USED,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Updating category status.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Processing the work file.
    Sat 09 Mar 2013 6:42:01 PM 4 000000C9 Processing cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5' at location C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Timing, UPDATE CATEGORY AND PROCESS WORK FILE,00:00:01
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start metadata update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Marking categories needed.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube metadata.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 End metadata update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'. 63 categories were added to the cube.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Timing, METADATA,00:00:00
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 --- Performing Pass 0 with 3134 rows and 63 categories remaining.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start Write leaving 63 categories remaining.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube data.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube data.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Performing DataBase Commit at record number 3135.
    Sat 09 Mar 2013 6:42:03 PM 4 000000C9 End Write leaving 63 categories remaining..
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Timing, CUBE UPDATE,00:00:01
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Committing PowerCube(s).
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Timing, CUBE COMMIT,00:00:00
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Updating the PowerCube with optimized metadata.
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Start update of cube 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' with optimized metadata.
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 End update of cube 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' with optimized metadata.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 End cube update.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Timing, TOTAL TIME (CREATE CUBE),00:00:03
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Creating directory 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Copying 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' to 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Renaming 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5' to 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Deleting 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309093540.ver'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Creating version file 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204.ver'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Deployment 'MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309001518' has been removed from destination 'c:\plancubes\deployment'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 (TR3818) PowerCube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5' has been deployed to version 'MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1
    Transformer Sat Mar 09 18:42:04 2013
  • Douglas.Long
    Douglas.Long
    1 Post

    Re: Unable to refresh cubes in Cognos 10.2

    ‏2013-05-13T15:28:51Z  
    Hi,

    More information about this issue and it's quite strange: when I use the Windows Tasks Scheduler to schedule the batch job to rebuild the cube, it cannot (sometime it can) read the updated data source even thought there is no error in the log file. But if I log into the server (using the same user ID that I used to scheduled the above-mentioned job) and executed manually the job, it read the updated data source and refresh the cube perfectly.

    My Cognos is setup with SSO and I used domain user ID to carried out the mentioned tasks.

    My batch job calls and bat file as:

    ECHO ON
    C:
    cd "C:\Program Files (x86)\ibm\cognos\c10\bin"
    cogtr.exe -n2 -g -s -m"C:\PlanCubes\Models\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdl" -r4
    exit

    Please see the log file below the scheduled task, which is failed to refresh the updated data source.

    Any ideal how to fix this? I need to schedule the job as it needs to execute frequently and currently we have to do it mannually (-:

    Thx

    Pham

    ------------------------------Log File---------------------------------

    Transformer(10.2.1003.25) Sat Mar 09 18:42:00 2013

    LogFileDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\Logs\
    ModelSaveDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\Models\
    DataSourceDirectory=..\data\
    CubeSaveDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\
    DataWorkDirectory=..\temp\
    ModelWorkDirectory=..\temp\
    MaxTransactionNum=500000
    Product locale: English (en)
    Run locale: English (United States) (en-us)
    Codepage: windows-1252

    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Start cube update.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Initializing categories.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, INITIALIZING CATEGORIES,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Start processing data source 'C:\PlanCubes\source\GWP_Plan\AICS_MIS_BDU_Plan2012_CUBE.csv'.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Reading source data.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, OPEN DATA SOURCE,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 End processing 3134 records from data source 'C:\PlanCubes\source\GWP_Plan\AICS_MIS_BDU_Plan2012_CUBE.csv'.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, READ DATA SOURCE,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Marking categories used.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, MARKING CATEGORIES USED,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Updating category status.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Processing the work file.
    Sat 09 Mar 2013 6:42:01 PM 4 000000C9 Processing cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5' at location C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Timing, UPDATE CATEGORY AND PROCESS WORK FILE,00:00:01
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start metadata update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Marking categories needed.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube metadata.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 End metadata update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'. 63 categories were added to the cube.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Timing, METADATA,00:00:00
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 --- Performing Pass 0 with 3134 rows and 63 categories remaining.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start Write leaving 63 categories remaining.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube data.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube data.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Performing DataBase Commit at record number 3135.
    Sat 09 Mar 2013 6:42:03 PM 4 000000C9 End Write leaving 63 categories remaining..
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Timing, CUBE UPDATE,00:00:01
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Committing PowerCube(s).
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Timing, CUBE COMMIT,00:00:00
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Updating the PowerCube with optimized metadata.
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Start update of cube 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' with optimized metadata.
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 End update of cube 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' with optimized metadata.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 End cube update.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Timing, TOTAL TIME (CREATE CUBE),00:00:03
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Creating directory 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Copying 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' to 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Renaming 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5' to 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Deleting 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309093540.ver'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Creating version file 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204.ver'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Deployment 'MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309001518' has been removed from destination 'c:\plancubes\deployment'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 (TR3818) PowerCube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5' has been deployed to version 'MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1
    Transformer Sat Mar 09 18:42:04 2013

    Did you ever find a solution?

  • AF-Mika
    AF-Mika
    1 Post

    Re: Unable to refresh cubes in Cognos 10.2

    ‏2013-05-16T05:07:52Z  
    Hi,

    More information about this issue and it's quite strange: when I use the Windows Tasks Scheduler to schedule the batch job to rebuild the cube, it cannot (sometime it can) read the updated data source even thought there is no error in the log file. But if I log into the server (using the same user ID that I used to scheduled the above-mentioned job) and executed manually the job, it read the updated data source and refresh the cube perfectly.

    My Cognos is setup with SSO and I used domain user ID to carried out the mentioned tasks.

    My batch job calls and bat file as:

    ECHO ON
    C:
    cd "C:\Program Files (x86)\ibm\cognos\c10\bin"
    cogtr.exe -n2 -g -s -m"C:\PlanCubes\Models\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdl" -r4
    exit

    Please see the log file below the scheduled task, which is failed to refresh the updated data source.

    Any ideal how to fix this? I need to schedule the job as it needs to execute frequently and currently we have to do it mannually (-:

    Thx

    Pham

    ------------------------------Log File---------------------------------

    Transformer(10.2.1003.25) Sat Mar 09 18:42:00 2013

    LogFileDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\Logs\
    ModelSaveDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\Models\
    DataSourceDirectory=..\data\
    CubeSaveDirectory=C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\
    DataWorkDirectory=..\temp\
    ModelWorkDirectory=..\temp\
    MaxTransactionNum=500000
    Product locale: English (en)
    Run locale: English (United States) (en-us)
    Codepage: windows-1252

    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Start cube update.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Initializing categories.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, INITIALIZING CATEGORIES,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Start processing data source 'C:\PlanCubes\source\GWP_Plan\AICS_MIS_BDU_Plan2012_CUBE.csv'.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Reading source data.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, OPEN DATA SOURCE,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 End processing 3134 records from data source 'C:\PlanCubes\source\GWP_Plan\AICS_MIS_BDU_Plan2012_CUBE.csv'.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, READ DATA SOURCE,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Marking categories used.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Timing, MARKING CATEGORIES USED,00:00:00
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Updating category status.
    Sat 09 Mar 2013 6:42:01 PM 4 000000B1 Processing the work file.
    Sat 09 Mar 2013 6:42:01 PM 4 000000C9 Processing cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5' at location C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Timing, UPDATE CATEGORY AND PROCESS WORK FILE,00:00:01
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start metadata update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Marking categories needed.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube metadata.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 End metadata update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'. 63 categories were added to the cube.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Timing, METADATA,00:00:00
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start update of cube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 --- Performing Pass 0 with 3134 rows and 63 categories remaining.
    Sat 09 Mar 2013 6:42:02 PM 4 000000C9 Start Write leaving 63 categories remaining.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube data.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Updating the PowerCube data.
    Sat 09 Mar 2013 6:42:02 PM 4 000000B1 Performing DataBase Commit at record number 3135.
    Sat 09 Mar 2013 6:42:03 PM 4 000000C9 End Write leaving 63 categories remaining..
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Timing, CUBE UPDATE,00:00:01
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Committing PowerCube(s).
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Timing, CUBE COMMIT,00:00:00
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Updating the PowerCube with optimized metadata.
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 Start update of cube 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' with optimized metadata.
    Sat 09 Mar 2013 6:42:03 PM 4 000000B1 End update of cube 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' with optimized metadata.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 End cube update.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Timing, TOTAL TIME (CREATE CUBE),00:00:03
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Creating directory 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Copying 'C:\Users\cognos.AZSGDOM\Documents\Transformer\PowerCubes\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc' to 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdc'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Renaming 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5' to 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Deleting 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309093540.ver'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Creating version file 'c:\plancubes\deployment\MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204.ver'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 Deployment 'MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309001518' has been removed from destination 'c:\plancubes\deployment'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1 (TR3818) PowerCube 'MONTHLY_MIS_BDU_PLAN_CUBE_V5' has been deployed to version 'MONTHLY_MIS_BDU_PLAN_CUBE_V5__20130309104204'.
    Sat 09 Mar 2013 6:42:04 PM 4 000000B1
    Transformer Sat Mar 09 18:42:04 2013

    I have seen something like this several times in various environments (C10.1.1 and C10.2). There seems to be a bug in Transformer and how it handles SSO logins if you run it using "-n1" or "-n2" batch mode. Sometimes SSO login fails in these scenarios but I haven't figured out whether it is some permission problem in AD account or really a bug in C10 Transformer (probably bug in C10 Transformer).

    Anyway, please try to run your CMD script using -n parameter (ie. just -n without any numbers) and see how it goes with C10 Transformer. This "interactive" mode seems to work better as far SSO login is considered in C10 Transformer. Your case seems to use CSV text file inputs and not BI portal datasources, but maybe any datasource type has the same bug with -n option.

    cogtr.exe -n -g -s -i "C:\PlanCubes\Models\MONTHLY_MIS_BDU_PLAN_CUBE_V5.mdl"

    -n option is documented as follows:

       -n = Interactive mode. For example it may show some dialogboxes if your model has problems

       -n1 = Batch mode. Prevent dialogboxes. Run Transformer windows minimized

       -n2 = Batach mode. Prevent dialogboxes. Run Transformer window hidden

    Try -n1 option and if that doesn't work through WindowsScheduled CMD scripts then as a last resort try -n option. My experience is that -n has always worked in environments where -n1 or -n2 gives problems with BI datasources.

     

    Updated on 2013-05-16T05:15:59Z at 2013-05-16T05:15:59Z by AF-Mika