I upgraded to 3.2.4 from 2.1.1 and now my UDC fails to sync.
Error when validating tables: One or more of the expected tables qlik_users and qlik_groups are not present a8a56ec4-3a0e-434c-9f30-8d3eb9527f6f
36 20171021T204735.794+0200 WARN QlikServer UserManagement.Repository.Repository.Users.Factories.UserDirectoryFactory 30 0f32edce-40a8-4988-ba57-d17e876c5e2c NT AUTHORITY\SYSTEM Setting up UDC'test' of type Repository.UserDirectoryConnectors.ODBC.ODBC unsuccessful One or more of the expected tables qlik_users and qlik_groups are not present??Error when validating tables: One or more of the expected tables qlik_users and qlik_groups are not present at Repository.UserDirectoryConnectors.ODBC.DataBaseConnector.TestTables()????Server stack trace: ?? at Repository.UserDirectoryConnectors.ODBC.DataBaseConnector.TestTables()?? at Repository.UserDirectoryConnectors.ODBC.DataBaseConnector.Setup(Logger logger)?? at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)?? at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)????Exception rethrown at [0]: ?? at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)?? at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)?? at System.Func`1.EndInvoke(IAsyncResult result)?? at Repository.Users.SafeUserDirectoryConnector.Setup(Logger logger)?? at Repository.Users.Factories.UserDirectoryFactory.TrySetupUserDirectory(UserDirectory userDirectory) 0f32edce-40a8-4988-ba57-d17e876c5e2c
This used to work
Driver={PostgreSQL Unicode(x64)};Server=x.x.x.x;Database=slwarehouse;Uid=xxx;Pwd=xxxx;
Tried the following, based on some other posts.
Driver={PostgreSQL Unicode(x64)};Server=x.x.x.x;Database=slwarehouse;Uid=xxx;Pwd=xxxx;Connect Timeout=60;
dsn=slwarehouse64;
dsn=slwarehouse32;
The DSN connection test is successful and I can build an application on the tables in question. Seems like a bug or some other, new configuration, is required.
Anyone comes across this ?
Thanks,
Mark
