KB442362: MicroStrategy Narrowcast errors "Error running pre-sql" and "Error Connecting to Database for Pre/Post SQL statement"

Senior Technical Account Manager I • MicroStrategy

MicroStrategy Narrowcast Subscriptions fail to load

SYMPTOM
Strategy Narrowcast Subscriptions fail to load, and when checking the DE.log file at the time of the reproduction, the following entries can be seen:


[XXXXXXX::SBM]:4980:[THR:0x918][12/08/2018 03:00:03.598][Level:Info (SBM)][Code:0x00002494]Error Connecting to Database for Pre/Post SQL statement: Before - Invalid authorization specification (User ID or Password is incorrect).

[XXXXXXX::DM]:1076:[THR:0x490][12/08/2018 03:00:07.717][Level:Moderate Error][Code:0x00000A98]Service ID [WWWWWWWWWWWWWWWWWWWWW] Execution ID [YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY] Segment ID [........]Error running pre-sql [Subscription Set ID: ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ]

[XXXXXXX::DM]:1076:[THR:0x490][12/08/2018 03:00:07.717][Level:Moderate Error][Code:0x00000963]Service ID [WWWWWWWWWWWWWWWWWWWWW] Execution ID [YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY] Segment ID [........]Service execution finished with error.

CAUSE
One or more of the Subscriptions sets defined to use that particular DSN might do not have its credential updated at the "SQL statements" configuration window.

ACTION
Update the credentials for the DSN(s) and connection information for the pre-execution SQL and post-execution SQL statement definitions in each of the Subscription Sets defined
And if you still encounter the following error, when testing it:


Unable to connect to the database. Please make sure the login, password, and database name are correct.

Please check with the Database Administrator if the connection for this particular user has been locked due to security measures like login attempts.
REFERENCES
Refer to the following Strategy Knowledge Base documents for more information:
KB8972 : What is the Pre- and Post-service execution SQL in Strategy Narrowcast Server 9.x - 10.x?
KB6833 : How is a service segmented in Strategy Narrowcast Server 9.x - 10.x?
KB7428 : Is Post-service execution SQL executed if the service does not complete successfully in Strategy Narrowcast Server 9.4.x - 10.x?
KB7936 : How to create a Segment Information Object for a Strategy Narrowcast Server 9.x - 10.x system?
KB17289 : Service execution fails with 'Error Connecting to Database for Pre/Post SQL statement: <statement name> - Invalid authorization specification' in Strategy Narrowcast Server 10.x
KB12721: ‘Failed to segment the subscription set …[Level:SEVERE ERROR][Code:0xa98]’ error message appears when using pre-SQL and/or post-SQL statements in a Strategy Narrowcast Server
KB442362

Comment

0 comments

Details

Knowledge Article

Published:

December 10, 2018

Last Updated:

January 3, 2019

[XXXXXXX::SBM]:4980:[THR:0x918][12/08/2018 03:00:03.598][Level:Info (SBM)][Code:0x00002494]Error Connecting to Database for Pre/Post SQL statement: Before - Invalid authorization specification (User ID or Password is incorrect). [XXXXXXX::DM]:1076:[THR:0x490][12/08/2018 03:00:07.717][Level:Moderate Error][Code:0x00000A98]Service ID [WWWWWWWWWWWWWWWWWWWWW] Execution ID [YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY] Segment ID [........]Error running pre-sql [Subscription Set ID: ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ] [XXXXXXX::DM]:1076:[THR:0x490][12/08/2018 03:00:07.717][Level:Moderate Error][Code:0x00000963]Service ID [WWWWWWWWWWWWWWWWWWWWW] Execution ID [YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY] Segment ID [........]Service execution finished with error.