Hi
I am doing migration testing from 2023.1.2 and 2024.0.3. It seems to completely fails on 2024.1.
I have tested it on 2023.1.2 and 2024.0.3, worked perfect - no issues.
It fails on FME Flow and FME Form on the server - but works OK on my local PC
on the server - oldeb 2019, clr 2019, are installed, as with .net 4.7, 4.8 and
It is just a simple sql server spatial reader - and a bit of reprojection - it fails on reading the reading the data
Cheers
Rudy
Hi
I have just tested FME Form on Windows Server 2019, and the above WB worked fine - not sure if there is a Windows Server 2016 issue. But the same WB runs fine in version 2024.0.3. In my opnion it seems like a big bug?
Hi
I have just tested FME Form on Windows Server 2019, and the above WB worked fine - not sure if there is a Windows Server 2016 issue. But the same WB runs fine in version 2024.0.3. In my opnion it seems like a big bug?
2016 is supported as per - https://support.safe.com/hc/en-us/articles/25407433729933-FME-Platform-Technical-Specifications
Try turning on debug logs in Tools>FME Options>Translation and see if that gives some more information.
If you suspect it is a bug, best to reach out to support and file a bug report
Hi
I have raised a support case, and it seems to be a critical bug, on Windows Server 2016. It seems to be fix, and will be released in next version update of 2024.1
We have the same issue on Windows server 2016 with several installations of Form.
Hi
The issue has been resolved - I have received confirmation of my support case. Please download the latest release of 2024.1. I have tested it on 2016, and seems to work.
It has been fixed in build 24619 (2024.1.1)
Regards, Rudy
Did this issue return in 2024.2.0?
I am having problems connecting to SQL Server Spatial (log from Data Inspector when trying to get a list of databases to chose from)
Worker 8132 > Failed to open reader
Worker 8132 > Failed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information
Worker 8132 > Failed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' reader
Edit: I am first checking with our DBadmin whether this may be due to a rights issue.
Hello Everyone,
I am also doing a migration test and it seems Microsoft SQL Reader is also having an issue on the current FME Form 2024.2 and 2024.1.3.
I will download 2024.1.1 24619 and wait once the latest version has been fixed
Hi,
I have 2 different machines with different versions of FME installed. One is Prod (older FME) and other is for migration (FME Test)
The below is a result table of my investigation. I have installed all versions (builds) of FME 2024 and unable to find one that can read both version of MSQL versions.
| Microsoft SQL Versions | FME Form 2023 | FME Form 2024 |
| Microsoft SQL Server 2017 - 14.0.3480.1 (x64) (WinServer 2019) | True | False |
| Microsoft SQL Server 2019 - 15.0.4410.1 (x64) (WinServer 2016) | False | True |