span8
span4
span8
span4
Hi,
Has anyone had an error when writing to sql server from FME Cloud,when I run locally it runs fine.
Transferring input attributes onto output feature,this may take several minutes... |
COM.亚搏在线safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response.The connection has been closed. |
COM.亚搏在线safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response.The connection has been closed. |
Destination Feature Type Routing Correlator(RoutingFactory): COM.亚搏在线safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response.The connection has been closed. |
COM.亚搏在线safe.fme.jdbc.TranslationFailureException: com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: SQL Server did not return a response.The connection has been closed. |
2018-06-04 15:15:55| 924.6| 0.0|ERROR | |
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed. |
Feature output statistics for `MSSQL_JDBC_SPATIAL' writer using keyword `MSSQL_JDBC_SPATIAL_1': |
Features Written |
_dsg_combined 596 |
Total Features Written 596 |
A fatal error has occurred.Check the logfile above for details |
Translation FAILED with 7 error(s) and 0 warning(s) (596 feature(s) output) |
FME Session Duration: 15 minutes 28.0 seconds.(CPU: 804.5s user,120.2s system) |
END - ProcessID: 26813,peak process memory usage: 819628 kB,current process memory usage: 85253 kB |
Yes,let's make sure you have poked a hole in the firewall.I spoke with Stewart and learned about this Doc:https://docs.亚搏在线safe.com/fme_cloud/FME_Cloud/Content/About_Instances/Configuring_Security.htm
This should help if you haven't already done this.
Are you sure that the FME Cloud system can reach (through all the firewall/security rules) the hosted SQL Server or Postgres databases?
I'm getting the impression that the Desktop environment is able to access the database systems as the rules for access to those database systems have been properly configured...but I'm not sure if the FME Cloud Engine (the system it runs on) can access these same systems.
Can you read from these databases with FME Cloud?
Ran the sql trace for the desktop version (1st image which works) and the cloud run version (2nd image),just appears not to even try to write the output.
Finished trying with postgis on fmecloud,same result.PostGIS is set to do a bulk insert as well and there is no connection timeout settings.very odd,as it works perfectly on my desktop.
Full log:
Opening POSTGIS writer for dataset 'dsg_grids'... |
PostGIS client encoding: 'UTF8' |
PostgreSQL 9.6.8 on x86_64-pc-linux-gnu,compiled by gcc (GCC) 4.8.2 20140120 (Red Hat 4.8.2-16),64-bit |
2.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 |
Testing for the existence of table 'dsg_grids_schema.dsg_combined'... |
Using existing table 'dsg_grids_schema.dsg_combined' |
POSTGIS Writer: Creating 'unquoted WKB' geometry processor for feature type 'dsg_grids_schema.dsg_combined' |
POSTGIS Writer: Creating 'streaming Bulk Copy' feature type processor for feature type 'dsg_grids_schema.dsg_combined' |
PolygonDissolveFactory: Group 4 of 15: Completed 100% of processing on pass 7. |
PolygonDissolveFactory: Group 4 of 15: Completed 66.66% of processing on pass 8. |
PolygonDissolveFactory: Group 4 of 15: Completed 100% of processing on pass 8. |
Sorting 570 features... |
Constructing donuts from 570 features... |
PolygonDissolveFactory: Group 4 of 15: Completed 100% of processing on pass 9. |
Transferring input attributes onto output feature,this may take several minutes... |
FME Configuration: Using FME Reprojection Engine |
Transferring input attributes onto output feature,this may take several minutes... |
PolygonDissolveFactory: Group 7 of 15: Completed 56.66% of processing on pass 5. |
PolygonDissolveFactory: Group 7 of 15: Completed 100% of processing on pass 5. |
PolygonDissolveFactory: Group 7 of 15: Completed 73.33% of processing on pass 6. |
PolygonDissolveFactory: Group 7 of 15: Completed 100% of processing on pass 6. |
PolygonDissolveFactory: Group 7 of 15: Completed 100% of processing on pass 7. |
PolygonDissolveFactory: Group 7 of 15: Completed 100% of processing on pass 8. |
Sorting 748 features... |
Constructing donuts from 748 features... |
Completed intersection processing,phase #3.2 new nodes were generated among 1207 intermediate lines |
Finish splitting 1208 lines into 1209 intermediate lines for phase 3 |
Sorting 919 features... |
Constructing donuts from 919 features... |
Transferring input attributes onto output feature,this may take several minutes... |
Bulk copy failed on table 'dsg_grids_schema.dsg_combined' using delimiter ':'.Error was 'server closed the connection unexpectedly |
This probably means the server terminated abnormally |
before or while processing the request. |
A fatal error has occurred.Check the logfile above for details |
...Last line repeated 2 times ... |
2018-06-04 19:17:31| 916.2| 0.0|ERROR | |
Bulk copy failed on table 'dsg_grids_schema.dsg_combined' using delimiter ':'.Error was 'server closed the connection unexpectedly |
This probably means the server terminated abnormally |
before or while processing the request. |
A fatal error has occurred.Check the logfile above for details |
...Last line repeated 2 times ... |
Translation FAILED with 6 error(s) and 0 warning(s) (514 feature(s) output) |
FME Session Duration: 15 minutes 47.0 seconds.(CPU: 800.4s user,115.9s system) |
END - ProcessID: 2368,peak process memory usage: 1203418 kB,current process memory usage: 86396 kB |
thank you,I am trying increasing the timeout now to 600.I am also going to try with PostGIS to see if it works.Looking forward to 2018.1 for the performance improvements.
© 2019 亚搏在线Safe Software Inc |Legal