Add data tool is not displayed

Introduction

The Add Data tool is not displayed in the WebOffice Client, even though it has been activated in the project configuration. Since several system components must interact correctly, errors often occur in different places.

This article helps to identify the typical causes and shows the most important steps for solving the problem.

Log Messages

A warning like this often appears in WebOffice logging:

#2018-12-17 15:09:59,482 WARN  [ajp-nio-8009-exec-1] test 48D191B5C9FDAB29B8C818955C8D4927 16661056 E1363872468T5799489 

ValidateUpload :: Request FAILED :: Please check your Configuration
WebOffice Application Configuration:
- Availability of ArcGIS Publisher for your WebOffice Output Service (SynOutputService)
- Availability of correct ArcGIS Publisher Credentials :: consider that an ArcGIS Publisher needs Credentials for administrative Access to the ArcGIS Admin GUI for upload Validation
- Availability of ArcGIS Publisher administrative Server URL if working with a Web Adaptor
ArcGIS Server:
- Availability of Dynamic Feature AND Raster Workspaces for your WebOffice Output Service (SynOutputService)

Unable to perform operation on WebOffice Server Object Extension (SOE) on service <username>@https://server.domain.at/arcgis/SynOutputService/MapServer with user <username> :: please check your SOE status and your application configuration
      caused by failed to process SOE operation (message: failed to process SSC transaction (handlerAction: VALIDATE_UPLOAD), possible error codes: [UNKNOWN], details: [failed to process SSC transaction (handlerAction: VALIDATE_UPLOAD), FAILED :: validate upload request, failed to handle service config query, Connection timed out: connect]) 

Another common error message concerns SSL connections:

javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: 
PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException:
unable to find valid certification path to requested target

Possible causes

 1. Problems in the WebOffice application configuration

• No valid ArcGIS Publisher user defined
  An active Publisher user must be stored in the project configuration for the WebOffice Output Service (SynOutputService) (except in federated server operation).

• Incorrect or insufficient Publisher login information
  The configured user requires administrative access to the ArcGIS Admin GUI (ArcGIS Server Manager) so that the upload validation can be performed.

• Incorrect internal ArcGIS Server URL when using a Web Adaptor
  If a Web Adaptor is upstream, WebOffice requires an internal server URL to perform administrative queries.

2. Problems with ArcGIS Server

• Dynamic Feature Workspaces or Raster Workspaces are missing
  SynOutputService must have correctly configured dynamic workspaces - see chapter Add Dynamic Workspaces to SynOutputService.

• SSL certificate not present in the Java trust store of ArcGIS Server
  SSL errors often occur with HTTPS connections if the server certificate has not been imported into the trust store. The Java trust store of ArcGIS Server is usually located at: “C:\Program Files\ArcGIS\Server\framework\runtime\jre\lib\security\cacerts”. This problem often occurs after a certificate change or renewal.

3. Special feature in federated server operation (Portal for ArcGIS)

If WebOffice is operated together with ArcGIS Enterprise in federated server mode:

• NO service user (user + password) may be defined in the project configuration for SynOutputService.
• Access is exclusively via the named users of the portal.

Solutions

 1. Check ArcGIS Publisher user

• Is a valid Publisher user stored in the project?
• Does this user have admin rights to the ArcGIS Admin GUI?

2. Configure internal administrative ArcGIS Server URL

• This is particularly important when using a web adapter.

Example of an administrative ArcGIS Publisher login information. User name "siteadmin" has administrative access on the ArcGIS Admin GUI. Configuration of the internal Server URL using the suggested Web Adapter ("mapgis" for example)

3. Check Dynamic Feature & Raster Workspaces

• Are all workspaces correctly assigned to SynOutputService?
• Check paths and connection parameters.

4. Import the SSL certificate into the Java trust store of the ArcGIS Server

• Import the server certificate into the ArcGIS Server trust store and restart the ArcGIS Server service. 
• It may also be necessary to import the server certificate into the ArcGIS Server admin page - see https://enterprise.arcgis.com/en/server/latest/administer/windows/configuring-https-using-an-existing-ssl-certificate.htm 

5. Especially for federated server operation

• Ensure that no service users are entered in the WebOffice project.
• Authentication is performed exclusively via Portal Named User.