MSTR: DataMart: Execute Query failed: identifier is too long

=========
QUESTION
———
When attempting to execute a DataMart in MicroStrategy, it fails with the following error:


The following History List delivery was not successful.
Delivery/update and destination information:
Run at: <DATE> <TIME>
Error message: (QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:972: on HSTMT] [MicroStrategy][ODBC Oracle Wire Protocol driver][Oracle]ORA-00972: identifier is too long    …

 

=========
ANSWER
———
The Table Name you specified in the Configure Data Mart dialog is too many characters in length.

From the editor window in MSTR, select Data, Configure Data Mart…
Shorten the length of the text in the Table name field to whatever length your DBA has told you is a good length
(30 characters or less has worked for us in most instances)

 

=========
EXAMPLES
———

 

=========
APPLIES TO / KEY WORDS
———
MSTR
ODBC
Errors
Export
DataMart
Data Mart

 

=========
REF
———

 


http://www.anysitesupport.com/mstr-datamart-execute-query-failed-identifier-is-too-long/
http://anySiteHosting.com

By | 2012-01-09T08:35:22+00:00 January 9th, 2012|Computers, Documentation, MicroStrategy|0 Comments