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