Skip to main content
Question

Workspace hangs while reading from MS SQL Server


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

itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • October 20, 2016

Lower the number of features to read?


david_r
Celebrity
  • October 20, 2016

Are there any clues in the FME log?


  • Author
  • October 20, 2016
itay wrote:

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.

  • Author
  • October 20, 2016
david_r wrote:

Are there any clues in the FME log?

The log only shows "Reading source feature # 100000"

steveatsafe
Safer
Forum|alt.badge.img+12
  • Safer
  • October 20, 2016

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.


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • October 21, 2016

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings