We have numerous Statistics workspaces analysing Oracle data on a daily basis.
After updating FME from Build 17259 to 17539 (also 17650), our Workspaces produced nothing anymore.
The results of the statistics are written to Excel-sheets, so I began debugging the workspaces and found the statistics calculators producing only null-values.
Even after creating new workspaces with simple example data (creator, randomnumbergenerator)
statisticscalculator outputs null-values.
I recreated your test workbench in 2017.1 (17539), and the output was as expected. Was the StatisticsCalculator placed within 17529 or 17539? Maybe there was an update to the transformer?
I had a similar issue with the StatisticsCalculator a while ago. Re-installing the software did the trick for me. Have you tried running your workspace on a different machine with the same FME Build?
Hi @reservoirdog
could you please share your translation log?
Have you tried running this workspace on build 17259 once again? Did you get the expected results?
@reservoirdog
could you please also check if Emailer or ChartGenerator work on your b.17539 or b.17650? StatiscticsCalculator, Emailer, and ChartGenerator are Python-based transformers. If something is wrong with Python on your machine/in your FME install, they all will fail... I hope.
Sadly it worked for me just fine as well (I just ran your workspace on a variety of builds, all produced correct output). This definitely smells like something is wrong with your python installation. I'd hope our log file might shed light on it, but I'd double check what Python you're set to use.
Thanks for all your inputs...
I have this on two different machines (Win Server 2008R2 and 2012R2) both "coming" from
Build 17259. On our productive machine I reverted back to 17291 (last 2017.0.1), and statistics work well as normal.
@LenaAtSafe
Logfile attached: statistics-problem.txt
Have you tried running this workspace on build 17259 once again? Did you get the expected results?
-> Yes, works fine again...
Seems I should try a clean re-install... well get back to you
@reservoirdog
could you please also check if Emailer or ChartGenerator work on your b.17539 or b.17650? StatiscticsCalculator, Emailer, and ChartGenerator are Python-based transformers. If something is wrong with Python on your machine/in your FME install, they all will fail... I hope.
I had a similar issue with the StatisticsCalculator a while ago. Re-installing the software did the trick for me. Have you tried running your workspace on a different machine with the same FME Build?
Yes, I have this problem on two different machines...
Both coming from 17259... will have to try a clean re-install...
I recreated your test workbench in 2017.1 (17539), and the output was as expected. Was the StatisticsCalculator placed within 17529 or 17539? Maybe there was an update to the transformer?
StatisticsCalculator works well (again) on 17259 and 17291
Hi @reservoirdog
could you please share your translation log?
Have you tried running this workspace on build 17259 once again? Did you get the expected results?
And yes, everything works well back on 17259 and 17291
Sadly it worked for me just fine as well (I just ran your workspace on a variety of builds, all produced correct output). This definitely smells like something is wrong with your python installation. I'd hope our log file might shed light on it, but I'd double check what Python you're set to use.
Did a clean re-install following https://knowledge.safe.com/articles/962/re-installing-fme-if-there-is-a-problem-with-the-i.html with success.
StatisticsCalculator back working with latest build 17650.
lesson learned: Don't do in-place updates anymore...
Thx for your support.
Did a clean re-install following https://knowledge.safe.com/articles/962/re-installing-fme-if-there-is-a-problem-with-the-i.html with success.
StatisticsCalculator back working with latest build 17650.
lesson learned: Don't do in-place updates anymore...
Thx for your support.
We have seen several clients with this issue. Upgrading FME to a newer build (2017+) causes the StatisticsCalculator to produce erroneous results. Unfortunately, the problem is not consistently reproducable (although I have managed to reproduce it on occasion). A simple re-install of FME is often not sufficient to fix the issue. Usually the affected computer needs to have all traces of FME removed before re-installing.
It would be good if Safe could do some more investigation into this issue as it's embarrasing to have to ask clients to uninstall and re-install and hope that fixes the problem...
We have seen several clients with this issue. Upgrading FME to a newer build (2017+) causes the StatisticsCalculator to produce erroneous results. Unfortunately, the problem is not consistently reproducable (although I have managed to reproduce it on occasion). A simple re-install of FME is often not sufficient to fix the issue. Usually the affected computer needs to have all traces of FME removed before re-installing.
It would be good if Safe could do some more investigation into this issue as it's embarrasing to have to ask clients to uninstall and re-install and hope that fixes the problem...
We have seen several clients with this issue. Upgrading FME to a newer build (2017+) causes the StatisticsCalculator to produce erroneous results. Unfortunately, the problem is not consistently reproducable (although I have managed to reproduce it on occasion). A simple re-install of FME is often not sufficient to fix the issue. Usually the affected computer needs to have all traces of FME removed before re-installing.
It would be good if Safe could do some more investigation into this issue as it's embarrasing to have to ask clients to uninstall and re-install and hope that fixes the problem...
Thanks @daleatsafe. I know this is going to be a tricky one to track down but it would be really nice to get it resolved.
Thanks @daleatsafe. I know this is going to be a tricky one to track down but it would be really nice to get it resolved.