I have the same problem as described here: http://community.qlik.com/message/273996. In my case, I have a Configurable ODBC Directory pointing to a SQL Server database. If at any point, an issue occurs with the connection to SQL Server, the directory stops working and requires either a restart of the QlikView Directory Service Connector service or a re-apply of the settings on the directory.
Here is what the directory service log shows repeatedly once this has become an issue:
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at Database.DatabaseProvider.DoSearch(String pattern, eSearchType searchTypes, String otherAttribute)
It has been suggested to schedule a regular restart of the QlikView Directory Service Connector service. That is not satisfactory because a connectivity issue can occur anytime for various reasons and this results in failed authorizations--users cannot access QVW files when this occurs. The QlikView Directory Service Connector service should be designed to attempt to reconnect automatically. In my view this is a serious bug with the Configurable ODBC Directory functionality.
I am running an enterprise license of QlikView Server x64 v11.0.11282.0 (11 SR1) on Windows Server 2008. The post above relates to version 11 SR2 so obviously it was not fixed in SR2. I looked at the release notes for 11.2 and didn't see anything that would indicate that this was fixed.
Is this issue a known bug and/or are there plans to fix this in an upcoming service release?
Have you contacted support with this issue? This was reported as a bug in version 10 and was listed as being fix.
Bill - Designated Support Engineer at Qlik To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.