"Base table:OA_TYPES not found.[10129]" Error Message

[DepthOfFocus]

Hi All - We currnently have our Microsoft SQL server connected to your ServiceNow instance through ODBC.

Every time we run a query, we get the following error:

"[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Base table:OA_TYPES not found.[10129]".

However the query runs fine/returns results on all subsequent (2nd, 3rd, 4th, etc) times without any errors.

Any idea what might be causing this?

Here's my connection string in the ODBC settings:

url=http://MyInstance.service-now.com;ServerDataSource=MyInstance.service-now.com

[Tushar Hirpurk1]

Hi,

   Please find below Knowledge article and follow the mentioned steps

Hope this will help.

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

https://knowledgebase.progress.com/articles/Article/OpenAccess-Base-table-OA-TYPES-not-found

Please mark reply as Correct/Helpful, if applicable. Thanks!

Regards,

Tushar

[Tushar Hirpurk1]

I just wanted to check-in on this and see how things were going for you.

If my reply above helped answer or guide you correctly, please mark it as Helpful & Correct.

Thanks!

[Ravi Vishwakarm]

Hi Tushar, I also have the same problem for quite some time. The only workaround was to re-run query multiple times. I followed the links you provided.

1. Value of property glide.cache.size.syscache_tabledescriptor is set to maximum.

2. url=http://my_instance.service-now.com;ServerDataSource=my_instance.service-now.com

Do you have any other suggestion now?