"Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [HYT00:0: on SQLHANDLE] [MicroStrategy][ODBC Oracle Wire Protocol driver]Timeout expired" is shown when executing reports from Web When users are trying to execute some reports in MicroStrategy web in particular, they may receive the Error āSQL Generation Complete Index out of rangeā and āTimeout expiredā error as shown below: Possible Causes: One possible cause is that the MicroStrategy Intelligence Server using a cached database connection that was already dropped by the RDBMS. To resolve this: Admin should delete the database connection caches and create a new DSNs in case they are sharing DSNs to connect to different databases. In addition, change the settings for the āConnection lifetimeā and the āConnection idle time outā. Follow the steps below to perform the mentioned changes and verify the report after each step and some of the settings require i-server r...
Microstrategy Business Intelligence knowledge sharing platform
Such a nice blog with the attractive reference links which give the basic ideas on the topic.
ReplyDeleteData Science vs Business Analytics
Business Data Analytics
Nice and good article. It is very useful for me to learn and understand easily. Thanks for sharing
ReplyDeleteMicro Strategy Certification
Micro Strategy Training Online
nice information thanks for sharing..!
ReplyDeletemicro strategy certification training
Hi Thanks For Sharing We are the best Digital Marketing Agency at Lebynd
ReplyDelete