Product:
Cognos Planning 8.4

Symptom:
Error when doing synchronize with Planning Analyst in Cognos Planning Contributor Administrator Console from a macro.
If you do it manually it works fine.


Message:

{3A9A7B10-F0A6-4A75-8517-6E9967C319BA}    1    2010-05-26 11:03:53.974 UTC +120    MacroUtilities_84    8.4.2721.0    AFWHelper        ReportAFWError    140    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    None\None    None\None    4244    2604
{3A9A7B10-F0A6-4A75-8517-6E9967C319BA}    2    2010-05-26 11:03:53.974 UTC +120    MacroUtilities_84    8.4.2721.0    AFWHelper        LoggedOnAFW    150    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    4244    2604
{3A9A7B10-F0A6-4A75-8517-6E9967C319BA}    3    2010-05-26 11:03:53.974 UTC +120    MacroUtilities_84    8.4.2721.0    AFWHelper        GetLibraryNames    100    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    4244    2604
{3A9A7B10-F0A6-4A75-8517-6E9967C319BA}    4    2010-05-26 11:03:53.974 UTC +120    EAdminDB_84    8.4.2721.0    iDB        AnalystGetLibraryNames    100    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    4244    2604
{3A9A7B10-F0A6-4A75-8517-6E9967C319BA}    5    2010-05-26 11:03:54.005 UTC +120    MacroAControls_84    8.4.2721.0    frmSelectBatchJob        SetupForm    160    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{3A9A7B10-F0A6-4A75-8517-6E9967C319BA}    6    2010-05-26 11:03:54.021 UTC +120    MacroAControls_84    8.4.2721.0    peBatchJob        cmdConfigure_Click    120    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824

Above message in Planningerrorlog.csv is found when executing the macro.

{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    1    2010-05-26 11:22:37.052 UTC +120    MacroUtilities_84    8.4.2721.0    AFWHelper        ReportAFWError    140    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    None\None    None\None    4244    3968
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    2    2010-05-26 11:22:37.068 UTC +120    MacroUtilities_84    8.4.2721.0    AFWHelper        LoggedOnAFW    150    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    4244    3968
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    3    2010-05-26 11:22:37.068 UTC +120    MacroUtilities_84    8.4.2721.0    AFWHelper        GetLibraryNames    100    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    4244    3968
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    4    2010-05-26 11:22:37.068 UTC +120    EAdminDB_84    8.4.2721.0    iDB        AnalystGetLibraryNames    100    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    4244    3968
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    5    2010-05-26 11:22:37.099 UTC +120    MacroAControls_84    8.4.2721.0    peLibraryList        PopulateListOfLibraries    130    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    6    2010-05-26 11:22:37.099 UTC +120    MacroAControls_84    8.4.2721.0    peLibraryList        RenderSimpleParameter    120    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    7    2010-05-26 11:22:37.115 UTC +120    MacroSControls_84    8.4.2721.0    ocxLabelAndBox        RenderParameter    160    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    Unable to set parameter object for 'ParameterRendererspecifylibraryname' with ProgID of 'MacroAControls_84.peLibraryList'~~~~E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    8    2010-05-26 11:22:37.115 UTC +120    MacroSControls_84    8.4.2721.0    ocxOptionPE        RenderParameter    580    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    Unable to set parameter object for 'ParameterRendererspecifylibraryname' with ProgID of 'MacroAControls_84.peLibraryList'~~~~E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    9    2010-05-26 11:22:37.130 UTC +120    MacroSControls_84    8.4.2721.0    AdvContainer        Add    130    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    Unable to set parameter object for 'ParameterRendererspecifylibraryname' with ProgID of 'MacroAControls_84.peLibraryList'~~~~E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    10    2010-05-26 11:22:37.130 UTC +120    EAdminUI_84    8.4.2721.0    ocxParameters        RenderParameters    420    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    Unable to render parameter 'libraryname'~~~~Unable to set parameter object for 'ParameterRendererspecifylibraryname' with ProgID of 'MacroAControls_84.peLibraryList'~~~~E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{EDED3F30-E2F5-4BF4-B943-EA9083F27678}    11    2010-05-26 11:22:37.146 UTC +120    EAdminUI_84    8.4.2721.0    frmMacroStepEditor        RenderMacroStepScript    230    MacroUtilities_84.AFWHelper.ReportAFWError    -2147219667    Unable to render parameter 'libraryname'~~~~Unable to set parameter object for 'ParameterRendererspecifylibraryname' with ProgID of 'MacroAControls_84.peLibraryList'~~~~E1008 Failed to logon to CAM. Logon aborted.. The return code was 1008.    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824
{4155F309-465C-4A51-A725-018AFE311328}    1    2010-05-26 11:22:37.146 UTC +120    EAdminUI_84    8.4.2721.0    pgMacros        CreateNewMacroStep    320        0    Unable to create new macro step.~~~~    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    None\None    None\None    3140    2824
{4155F309-465C-4A51-A725-018AFE311328}    2    2010-05-26 11:22:37.146 UTC +120    EAdminUI_84    8.4.2721.0    pgMacros        cmdMacroStepAdd_Click    150        5    Unable to create new macro step.~~~~    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    PLANNINGSERVERNAME\UserName    CD\PLANNINGSERVERNAME    3140    2824

Above error is found in planningerrorlog.csv when try to create a macro that access analyst files.

Cause:
The Cognos 8 Planning service is run as local system on the Windows server
Or the filesys.ini file is not using UNC path to the applications.

Solution:

Check the filesys.ini file on the Cognos planning servers, ensure that they use UNC path to the Cognos planning applications. You may need to register the planning applications again in Cognos Planning Analyst with UNC path to get this to work correctly.

Create a windows domain account that is used for the Cognos services. he windows account must be local administrator on all Cognos servers in the solution.

Steps
1. Stop the Cognos 8 Planning service
2. Stop the Cognos 8 Bi service
3. Change the user from local system to the created windows service account.
4. Enter the password and click apply.
5. Start the Cognos 8 Bi service
6. Start the Cognos 8 Planning service
7. Start CAC (Contributor Administration Console) and test again your macro.

www.cogknowhow.com