Has the property glide.cache.size.syscache_table_descriptor change to a new name in Jarkarta?

chenelle · ‎08-27-2018

Regarding Servicenow and ODBC ServiceNow Driver error message

We recently had some users install the ODBC driver, but they get they got the message error below and a screenshot of is attached.

ERROR [HY000] [SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot create schema.Cannot retrieve a DB schema. Please run <instance>?SCHEMA in your browser and try again. Also make sure that the table descriptor cache can hold all your tables and DB views. You can check the table descriptor stats runing <instance>/xmlstats.do in your browser.[1050]

For the resolve it had a KB article from 2016. However the property glide name looks to have changed or i can't locate it from the KB link below.

Does any one know how to get to this property so I can increase the value of the property glide.cache.size.syscache_table_descriptor to a value greater than the number of tables + the number of database views??

https://hi.service-now.com/kb_view.do?sysparm_article=KB0595630

chenelle · ‎09-04-2018

OK, so these resolves were not necessary. What was necessary in this case was that I had to create a local ODBC usernane and password. As ODBC driver does not use SSO. Once I created a local user account for ODBC and gave it the ODBC role which includes the soap_query and itil roles, then we were able to sign on successfully. However, you all are correct that new properties can be created.

View solution in original post

SanjivMeher · ‎08-27-2018

If the property is not there in sys_property table, you can just create it yourself in the property table.

Please mark this response as correct or helpful if it assisted you with your question.

Michael Ritchie · ‎08-27-2018

System properties typically don’t change as the server side code has these hard coded. Not all system properties are in the sys_properties table so you may need to create it if it doesn’t exist. What is happening is server side it has a default value and will be overwritten if it exists in the table.

chenelle · ‎08-27-2018

Ok, thank you! So i can just create it then? As I dont see it.

Michael Ritchie · ‎08-27-2018

Yes follow steps in Hi KB article so you know what value to use, but yes create a new entry for it with the value. I would expect the type to be an integer.