Oracle ODBC intermitent connection failure

Post Reply
jed
Posts: 55
Joined: Wed Sep 02, 2009 11:33 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016
Location: Australia

Oracle ODBC intermitent connection failure

Post by jed » Fri Sep 06, 2019 5:17 am

We have a strange situation with Oracle (oracle 12cR2client 32bit) failing on connection.

2 identical servers (same OS, same ODBC drivers, same TM1 version (10.2.2), same TM1 data)...TI updates from ERP scheduled every 30 minutes. On one server some of the TI processes fail at every run (different processes failing each time) but on the other server it never fails.

This is currently causing a massive headache as the one failing is on our production server and IT are scratching their heads as to why and what the difference is between the 2 servers.

Any ideas of what we could look into?

Post Reply