Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

Pro Cloud Server Troubleshooting

Browser Test

For a simple check that the Pro Cloud Server is operating on the specified Ports defined in the configuration file, you can enter this address into a web browser:

     <protocol>://<machineName>:<port>

For example, using the default settings on the machine with Pro Cloud Server installed:

     http://localhost:804/

Or

     https://sparxcloud.com

If the port is enabled this message is returned:

     Sparx Systems Pro Cloud Server vX.X.XX

     Congratulations, your server is now ready to host your models. Connect through the

     configuration client to add or remove models.

If this message is not displayed, confirm the server name and port, check for other services listening on the specified port, check the server log file for error messages, check any firewalls between the client and the server to confirm there is connectivity and the relevant port(s) are open.

Errors shown in Enterprise Architect System Output

Error Message

Meaning

Http Status Code: 503 Service Unavailable

Indicates that the Pro Cloud Service is not running on the Server.

  • Check you have the correct Server Name and Port
  • Check that the 'Sparx Systems Professional Cloud' Service is currently running on the server.

HTTP Status 401 Access Denied

Indicates a failure to authenticate with the server.

With the built-in web server, this error will occur if an invalid username or password was provided, or no username or password were provided.

HTTP Status 403

Indicates an attempt to access a model that is marked on the server as 'Require authenticated and secure connection'.

This might indicate that you are connecting using an http protocol instead of https, or that the port you are using is not providing authentication to the model you are connecting to.

Check that you are using https.

Check with the system administrator that the security authentication option is pointing to a model with security enabled.

HTTP Status 500 Unable to connect to service

The connection is not being accepted.

  • Check the server name
  • Check the firewall settings on the client and server
  • Check the ports the server is listening on

The database manager for this database was shut down

Enterprise Architect established a connection to a Pro Cloud Server, and requested to connect to a known repository, but the repository is currently disabled.

Ask your system administrator to check the 'Enabled' option for the database manager in question.

There is no database manager configured for the requested repository

Enterprise Architect established a connection to a Pro Cloud Server, but the model name requested does not match any defined database on the server.

When accessing the model using the Enterprise Architect Cloud Connection screen, ensure that the Model Name entered matches the Alias which is shown in the Pro Cloud ServerConfiguration Client.

Unable to connect to Database

Enterprise Architect established a connection to a Pro Cloud Server and requested to connect to a known repository; however, when the server attempted to open a connection to the database using the supplied details, it failed.

Note: Whenever this error occurs, a Warning-level message that contains more detailed information will be written to the Pro Cloud Server logs.

If the repository is:

  • If Using ODBC, ask your System Administrator to check that an ODBC connection is defined as a System DSN (and not a User DSN) on the server, that all connection parameters are correct, and that the database username and password have been saved into the ODBC DSN or the connection string
  • Oracle, ask your System Administrator to verify that the user name and password were saved with the connection string and that all other options in the connection are correct
  • SQL Server connecting via OLE DB and Windows authentication, ask your System Administrator to verify that the user name the Pro Cloud Server service is running and has been granted permission to the SQL Server database (at a minimum it will need the roles db_datareader and db_datawriter) and that all other options in the connection are correct
  • SQL Server connecting via OLE DB and SQLServer authentication, ask your System Administrator to verify that the defined user name has been granted permission to the SQL Server database (at a minimum it will need the roles db_datareader and db_datawriter), that the option to save the password with the connection string was enabled, and that all other options in the connection are correct

12007 - The server name or address could not be resolved

Indicates the server name (or IP address) is incorrect.

  • Check that the server name is correct.
  • Attempt the Browser Test described above.

12029 - A connection with the server could not be established

This could indicate that the Pro Cloud Server is not installed, the Service is not running, or an incorrect Port was entered.

  • Confirm the Pro Cloud Server is installed.
  • Check that the 'Sparx Systems Professional Cloud' Service is running.
  • Check that you entered a valid Port (I.e. It should match one defined in the Configuration Client).
  • Attempt the Browser Test described above.

After Reinstall Enterprise Architect no longer works

Your environment was working correctly, then you updated to the latest version of the Pro Cloud Server and now Enterprise Architect clients are not able to connect to your Cloud models.

During the reinstall process the Pro Cloud Server installer actually uninstalls the original version and then installs the new one.  As a result of this the Firewall exception that is automatically added by the installer is removed and re-created. The problem with this is if someone manually adjusted the Firewall exception (after the original install) any manually changes are lost when the installer re-creates the Firewall exception. One method of stopping this from occurring in the future is to create a completely new firewall exception (with a different name) that is a copy of the one created by the installer, and make any manual changes to that exception.

Reading Server Logs

As mentioned earlier the Sparx Systems Pro Cloud Server is a Windows Services application and as such it needs to conform to some basic rules.  When it comes to troubleshooting the most important rule for Windows Services is that they can be run independently of user input/interaction and as such do not contain screens/GUI of any kind.  For this reason the Sparx Systems Pro Cloud Server writes any potential message to Log files.

The Pro Cloud Server configuration file contains a number of settings that control where, how many and how large log files can be.  By default the Pro Cloud Server will save all log files to a \Logs\ folder under \Services\ (C:\Program Files (x86)\Sparx Systems\Pro Cloud Server\Service\Logs), and it will keep up to 3 files.  A new file will be created whenever the Cloud Service is started or whenever the maximum file size if reached.  Filename 'SparxCloudServicesLog-1.log' will always be the most recent log file and each time a new file is created the older ones are renamed by increasing the number.  ie SparxCloudServicesLog-2.log is renamed to SparxCloudServicesLog-3.log.

The configuration file also contains a setting that controls the level of logging that is performs, see the logging related options in 'Global Server Options' for more details.  When troubleshooting, it is recommended that the Pro Cloud Server LOG_LEVEL property be set to the highest level, SYSTEM.

When trouble shooting it is recommended to set the LOG_LEVEL property to the highest level.

Each log entry will consist of the Time, Log Level and Message, if an error occurs the Message will normally contain a description of the problem and from this the appropriate action can be undertaken.

Log Message

Explanation

Log File Header

Each time new Log file is created the Pro Cloud Server will write out a summary of the main settings, this information is particular useful if you are requesting support from Sparx Systems.

Started database managers

When a Pro Cloud Server is initially started, and the Log Level is set to INFO (or lower) it will log out a summary of each configured model which includes the connection string of the model.

     [INFO]: Added database manager - ConnectionStr:  'eaexample --- Connect=Provider=MSDASQL.1;...

If the Log level is lower than INFO, additional log entries will be written for each model, for example:

     [SYSTEM]: SUCCESS Started database manager firebird:anonymous@eaexample

House keeping

The Pro Cloud Server performs regular 'house keeping' tasks, the frequency of which is controlled by the AUDIT_TIME_PERIOD setting in the Pro Cloud Server configuration file. 

When the log level is set to INFO, each time house keeping is performed the Pro Cloud Server will log out a summary of connections for each defined database manager and report how many are currently available, the maximum number used concurrent and total number of uses since the last audit.

      [AUDIT] firebird:anonymous@eaexample        | Free:   0 | Max Active:   3 | Acquisitions:    192 |

Normally these entries can be ignored as they are purely reference information only.

Open port list

When a Pro Cloud Server is initially started, and the Log Level is set to SYSTEM, it will log out a success message for each configured port, which includes the management port (803) and any http/https ports, you should see a line such as:

     [SYSTEM] SUCCESS Bound and listening on port 804.

If the log file is missing any lines, or if the message doesn't read 'SUCCESS' this might indicate a problem with the server port.

A common error here is:

     Unable to create secure server on port 443.

Possible causes of this are:

  • Certificate/Private Key file not found at C:\Program Files (x86)\Sparx Systems\Pro Cloud Server\Service\server.pem
  • The server.pem file does not contain a valid certificate and private key
  • Certificate Authority file not found or invalid at C:\Program Files (x86)\Sparx Systems\Pro Cloud Server\Service\cacert.pem

Unable to connect to database

During general operations, the Pro Cloud Server will write entries to its log file, which include any failed attempts to open a model. This will generally not occur until a user attempts to connect to the database. Errors that can occur here are:

    REQUEST_CONNECT FAIL. Error (5): Unable to connect to database

This means that the server attempted to open a connect but it failed. If you see this message, review the list of potential reasons outlined in the Errors shown in Enterprise Architect System Output table.