0 Replies Latest reply: Oct 22, 2017 11:57 AM by Mark Rollins RSS

    UDC and Postgres

    Mark Rollins

      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