Hi,
I have a workbench setup, it reads a database connection, does some transformations, then write to our Enterprise GIS Portal. The writer is setup to overwrite/truncate the feature layer data, and it has been running successfully for months, but I have now noticed it is failing. I had some issues getting the workbench setup, I think I had some forums post about it as we had to rename some fields and use replace some strings as some characters were causing problems.
But all them got sorted and it was working fine. The error message is:
ArcGIS Portal Feature Service Writer: Could not retrieve metadata for layer/table ID 0 of Feature Service at 'https://maps.middlesbrough.gov.uk/server/rest/services/Hosted/ReportIT_Firmstep/FeatureServer'. The error code from the server was '500' and the message was: 'Connection to IT-ARCGIS-ENT.MBRODOM.NET:9876 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.'
I thought it may be a firewall or proxy issue, so got our Infrastructure to allow full access out, but the error persists.
In the main workbench I changed the dataset name to see if it could write it as a new feature layer, and it publishes it, and doesn't report any errors, but the feature layer seems corrupt, as when I tried to preview it in the workbench, it doesn't work, and when I try open it in Portal, it returns 'There was an error'. So something seems to be going wrong when writing to Portal.
As a final test I created a new workbench and tested my connection to Portal, and connects fine and can see my data. So I can reach our Portal. But when publishing, it seems to be corrupt. As I can't open the dataset in Portal or preview it in FME. I checked the ArcGIS Server, where the workbench and Portal is trying to access, and it doesn't seem like the service has been created, which is very odd as FME completes as it it has written it.
Any ideas please?