KB441235:Error message “Invalid descriptor index” pops out when users run freeform SQL report with text prompt in MicroStrategy Developer

Senior Cloud Support Engineer III • MicroStrategy

When a freefrom SQL report is inserted a text prompt, users running the report get the error message “Invalid descriptor index” in MicroStrategy Developer.

SYMPTOM:
When a freefrom SQL report is inserted a text prompt, users running the report get the error message “Invalid descriptor index” in Strategy Developer, as showed below.

And in the DSSError.log , below information is logged:


2018-06-29 08:29:09.090 [HOST:LISHA1011][SERVER:CastorServer][PID:4592][THR:6524][Kernel][Error][UID:54F3D26011D2896560009A8E67019608][SID:8DA48810F2FD11094E94F6093A2A63E3][OID:9DBE72174C3AF4B647B3D4960B1617ED] [Human Resources Analysis Module][Administrator][JobID=1842] (SQL Generation CompleteQueryEngine encountered error: OdbcPreparedStatement::GetParameterDataTypes() failed.
Error type: Odbc error. Odbc operation attempted: SQLDescribeParam. [07009:0: on SQLHANDLE] [Strategy][ODBC Oracle Wire Protocol driver]Invalid descriptor index.. Error in Process method of Component: QueryEngineServer, Project Human Resources Analysis Module, Job 1842, Error Code= -2147212544.)

CAUSE:
There is a quotation beside the text prompt when insert the text prompt.

ACTION:
Remove the quotation, save and close this report, and run the report again.
KB441235

Comment

0 comments

Details

Knowledge Article

Published:

July 5, 2018

Last Updated:

November 9, 2018