Question

Workspace hangs while reading from MS SQL Server

  • 20 October 2016
  • 6 replies
  • 4 views

In my workspace I am reading from a table in SQL Server. There is a huge amount of records, so I limit the number of records to read (per feature type) to 100k for testing purposes. When the number of features read gets to about 99000, the workspace does not proceed for about 15 minutes. Is there anything I can change here?


6 replies

Badge +16

Lower the number of features to read?

Userlevel 4

Are there any clues in the FME log?

Lower the number of features to read?

When I lower the number of features to read, for example 10k, it stalls before it reaches that number.

Are there any clues in the FME log?

The log only shows "Reading source feature # 100000"
Badge +11

Are you just reading features and nothing else in the workspace? Or is there something else (another transformer) causing the delay? If so disable anything after the reader to isolate that it is indeed just the reader.

Badge +16

A good place to give your debugging effort a start and structure is the following article:

https://knowledge.safe.com/articles/19301/root-cause-analysis-guide.html

Reply