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.