Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

UDC and Postgres

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



0 Replies