Publishing MapService to ArcGIS Server problem (Slow and cannot publish data from SQLDatabase)

[AlexanderBykov]

I am trying to publish a map to ArcGIS Server with one layer from SQL Server.

We have:

1. Data:

• SQL Database with data
• Most of Feature Classes are stored in Feature Sets

2. SQL Server (sqlsrv) with Data

3. Machine with ArcGIS Server agserver

• This is a virtual machine
• ArcGIS Server 10.3 installed
• ArcGIS Server is running using domain account (agsacc)
• agsacc account is an Administrator on agserver machine (Can access any folder)
• Database (sqlsrv) is registered and verified (using Operational System Authentification)
• I can see and use data from SQL sqlsrv in ArcMap on 'agserver' machine

Problems:

1. When I am trying to publish a shapefile (150kb)
   • Service published successfully, but takes 1-2 hrs to publish this service.
2. When I am trying to publish anything from sqlsrv, it takes also about 2 hrs, but:
   • Publishing process failed with the error:

ERROR 001369: Failed to create the service. Failed to execute (Publish Service Definition). Failed at Thu Mar 24 18:46:18 2016 (Elapsed Time: 5 minutes 23 seconds) Failed. ERROR: the server's publishing job didn't succeed. Failed to execute (UploadServiceDefinition).

• I can see in ArcGIS Server Manager that my service is "stopping"
• When I am trying to stop it and run again, I have the following error:

Failed to construct instance of service 'test4.MapServer'. Can not open file C:\arcgisserver\directories\arcgissystem\arcgisinput\test4.MapServer\extracted\v101\test4.msd. The system cannot find the path specified. Probable cause: The file is inaccessible to Server.

• There is nothing (0 files) in this service folder

**What I have tried:**

-Set log level to Verbose (couldn't find anything). I am not sure what should I be looking for.

-Repaired ArcGIS Server Installation

-Reinstalled ArcGIS Server (still doesn't work)

**Update, 160328 1500**

    Just turned off Antivirus and shapefile published for a couple of seconds.

    However, map with data from sqlserver still cannot be published

    Got the following errors in the Log:

    -Core server call to create service failed.

    -Error executing tool.: ERROR 001369: Failed to create the service. Failed to execute (Publish Service Definition).

    -Failed to create the service.: ERROR: Service failed to start, Internal server error.

    -Failed to construct instance of service 'test20160328_2.MapServer'. Service startup timeout

Is there is a way to understand where is the problem?

[EphraimMuya]

Hi,

Try this:

1. Export your shapefile(s) to the .sde.

2. Register your  .sde geodatabase with ArcGIS Server (That is if you have not done that already)

3. Publish.

You might also want to restart ArcGIS Server publishing tools.

[AlexanderBykov]

Hi,

1. I've exported the shapefile (which I was able to publish) to sde

2. Database is registered with ArcGIS Server and validated

Restarted publishing tools.

3. No success.

[MatthewLofgren]

I had similar error messages while publishing, but it never took 2 hours. Turned out I ran out of virtual memory (not RAM but paging file). Worth a shot to look into.

[AlexanderBykov]

Hi Matthew,

Are you referring to pagefile.sys on MSSQL Server or ArcGIS Server Machine?

Here is what I have for ArcGIS Server machine:

And for SQL Server:

Also, SQL Server has only 10GB free space on C drive, will it make a difference for pagefile?

[MatthewLofgren]

That actually looks OK. Probably not related then. Sorry...

[AlexanderBykov]

No worries.

Thank you for idea!

[AndrewKeith3]

When you click on File > Share As > Service.  Click the option to create a service definition file.  Then use the Upload Service Definition tool to publish it to Server.  I have found this to work when I get publishing errors.

[MarkBenishek]

Thank you!  This method worked for me!

[Anonymous User]

Hello,

Please use below link and alos upgrade your current AGS version to 10.4.1.

https://community.esri.com/thread/181345 

Thanks.