Robin Moffatt • 10/16/2009

BI Server hung - nQSError 14054 / 15001 / 23005

This article details a specific bug in OBIEE 10.1.3.4 where a poorly written SQL init block returning a NULL value caused the BI Server to hang instead of gracefully failing. It explains the resulting nQSError codes (14054, 15001, 23005), symptoms experienced by users and admins, the diagnostic process, and the ultimate fix of correcting the SQL to handle NULL conditions. The post concludes with lessons on defensive SQL coding and considering data changes as a cause for sudden failures.

0 comments

#Obiee #Init Blocks #Repository Variable