AnsweredAssumed Answered

Importing data into FM via ODBC and a query issue

Question asked by yodavish on Jan 31, 2019
Latest reply on Feb 6, 2019 by beverly

Hello FM Community,

 

I'm trying to import data and match a unique ID to update a 1 column. The query itself only produces around 100k records. In my FM table, it has 63 million records. Every time I run this (twice so far), initially I see the progress of the matching records, I monitor it until around 1/3 of the way and start to do other tasks not related to FM.

 

After an hour or so, FM becomes non-responsive and I'm no longer able to see the progress bar, I'm sure it just running the process in the background. However, after 24 hours it's still non-responsive and I ungracefully kill the service. I check a few of the columns and some of them are updated but not all of them. Is there a better way to import (recurring) data into FM without it taking so long and becoming non-responsive?  The FM server has completely new upgraded hardware, with an SSD and new RAM, so hardware shouldn't be an issue.

Outcomes