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

KB294292: MicroStrategy Intelligence Server 10.3 Crashes when running an element prompt whose source table can not be found in Teradata warehouse


Community Admin

• Strategy


SYMPTOM
In Strategy 10.3, when running reports against Teradata database, if a report contains an element prompt, and the source table of the prompt can not be found in database, the Intelligence Server will crash.
In DSSErrors.log, following error message can be found:


2016-05-05 03:35:04.126 [HOST:YEFZHOU103][PID:1496][THR:6188][Database Classes][Error] Execute Query failed.Error type: Odbc error. Odbc operation attempted: SQLExecDirect. 
[42S02:-3802: on SQLHANDLE][Teradata][ODBC Teradata Driver][Teradata Database] Database 'zzz' does not exist.  Connection String: DSN=115395_Test;UID=YEF6MAY4U3;
SQL Statement: select    a11.REGION_ID  REGION_ID,
 a11.REGION_DESC  REGION_DESC
 from    zzz.LU_REGION_T    a11
 order by        1 asc.
2016-05-05 03:35:10.967 [HOST:YEFZHOU103][PID:7048][THR:2716][MultiProcess][Error] The child process is terminating because the parent process died.

CAUSE:
This is a known issue in Strategy Intelligence Server 10.3.
ACTION:
This issue is fixed in Strategy 10.3 Hotfix2.


Comment

0 comments

Details

Knowledge Article

Published:

June 7, 2017

Last Updated:

June 7, 2017