EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB483880: MicroStrategy 2021 Platform Analytics Consumer fails with server-specific error


Jing (Sally) Cheng

Senior Principal Consultant • MicroStrategy


This article explains why the MictoStrategy Platform Analytics Consumer fails due to an incorrect function on Microsoft Windows. This article also provides a solution to fix the error.

Description


When starting the Strategy 2021 Platform Analytics Consumer, users may receive the following error: "Windows could not start the Strategy Platform Analytics Consumer on Local Compute. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 1."

ka0PW00000012B3YAI_0EM2R000000nA8T.jpeg

In the Event Viewer, users can see the following error: "The Strategy Platform Analytics Consumer terminated with the following server-specific error: Incorrect function."

ka0PW00000012B3YAI_0EM2R000000nA8d.jpeg

Why is this happening? 


The root cause to this error is incorrect formatting in your PAconfiguration.yaml, such as a missing space between the key and value. 
 

Correct Format:


pgWarehouseDbConnection:
pgWhHost: "localhost"
pgWhUser: "mstr_pa"
pgWhPasswd: "YAGzHSfhFtcfKGhF/FMrt41PlkSp1DruotLz,EWRPZV6YmE04znSe"
pgWhPort: 5432
pgWhDb: "platform_analytics_wh"
pgWhSSLcert: ""
pgWhSSLkey: ""
pgWhSSLrootcert: ""
pgWhSSLmode: "disable"
 

Incorrect Format:


pgWarehouseDbConnection:
pgWhHost: "localhost"
pgWhUser: "mstr_pa"
pgWhPasswd:"YAGzHSfhFtcfKGhF/FMrt41PlkSp1DruotLz,EWRPZV6YmE04znSe"
pgWhPort: 5432
pgWhDb: "platform_analytics_wh"
pgWhSSLcert: ""
pgWhSSLkey: ""
pgWhSSLrootcert: ""
pgWhSSLmode: "disable"
 

Solution


You can solve this error by adding a blank space between the key and value, and then restarting the Strategy Platform Analytics Consumer. 

 


Comment

0 comments

Details

Knowledge Article

Published:

December 16, 2019

Last Updated:

March 4, 2024