It looks like the "slow link" was a red herring, so I'm going to leave the extra load on Oracle for now (with all the TM1 servers individually connecting to it) in order to avoid a complicated, ex-TM1 scheme. It's more work and moving parts (but not by much) but it gets around anything that might be peculiar to how TM1 handles a slow ODBC. Let the 3rd party tool dump a text file export of the query locally then load the text file with TI. Then ftp the text file(s) to the satellites and once the ftp is complete then load the text files.Ģ/Run the ODBC query via a 3rd party tool with a command line interface that you can pass params to and run with ExecuteCommand. Lotsaram wrote:To get around the ODBC hanging have you thought about either separating the ODBC run from the data load or else encapsulating it within another process? Just thinking aloud here but what about the following 2 approaches:ġ/ Run the ODBC query only once on a server with close proximity to the Oracle DB. These boxes are running TM1 9.5.1 x86 and Oracle Instant Client 10.2.0.4. I'm opening a PMR with IBM, but if anyone has had a similar experience I'd appreciate hearing about it. I've tried putting dummy SQL in which should return zero rows, still locks indefinitely. The only way to clear the fault is to bounce the daemon. And it locks up HARD, although TM1Top shows up incrementing timer (so it's not a hung server per se), the server has a global lock so nothing else can be done, no one can log in, etc, and the locks never clear. But, when I preview the data in TI the system locks up indefinitely. But I haven't been able to get AU, CN, or SG to work.Īll of them test out fine when setting up the connection via the Data Sources (ODBC) applet. The Oracle server is in San Francisco, and I was able to establish connections w/o issue from the UK and France TM1 servers. Anyone else experienced problems with TI ODBC over "slow" connections? I'm trying to eliminate as much data from my replications as possible (let's just say that IBM made it pretty clear that I shouldn't expect any progress/improvement), so I'm establishing direct links from all of my planets to Oracle.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |