04-15-2019 10:52 AM
Error I'm receiving in Diagnostics Console on the AppServer:
Failed to generate key for 'WkstEntryNum'.
The UPDATE permission was denied on the object 'maxnumkeys', database 'Database', schema 'hsi'.
I've verified that the permission is correct on the table in the database.
04-15-2019 11:45 AM
Hi Dale,
These type of issues has been noticed since we switch to using ADO.NET in order to connect to the database whereas previous versions of the software prior to OnBase 18 used ODBC connections. With ADO.NET, you can either specify the user connecting to the database in the connection string or user integrated security which would use the account running the Application Server.
My assumption is that the user which is configured within the connection string doesn't have the necessary permissions to make the mentioned database change. You can review your connection string for your Application Server by using the Web Application Management Console.
Best wishes.
04-15-2019 11:54 AM
Hi Dale,
What OnBase clients are you trying to login to use?
i.e., OnBase Thick/Config? Unity? Briefcase? Studio? Outlook Integration? Web? and of those, are you trying to access via a machine that has IIS installed on it?
04-15-2019 11:45 AM
Hi Dale,
These type of issues has been noticed since we switch to using ADO.NET in order to connect to the database whereas previous versions of the software prior to OnBase 18 used ODBC connections. With ADO.NET, you can either specify the user connecting to the database in the connection string or user integrated security which would use the account running the Application Server.
My assumption is that the user which is configured within the connection string doesn't have the necessary permissions to make the mentioned database change. You can review your connection string for your Application Server by using the Web Application Management Console.
Best wishes.
04-15-2019 02:25 PM
I've redone the ADO .NETConnection string and still produces the same error, even after a AppServer restart. An additional error is showing now: The UPDATE permission was denied on the object 'maxnumkeys', database 'OnBase18Prod', schema 'hsi'. Both seem to be related.
04-15-2019 02:25 PM
I should add I'm using integrated security.
04-15-2019 09:00 PM
We have found an issue with the ADO.NET connections as well. Granted we are using the Thick Client, but I would try switching it to a hard coded instead of integrated. We currently have an SCR for our issue, but this might at least give you a workaround to go with.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.