PCS Troubleshooting

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.

If the model in question had user security enabled after the 'Require authenticated and secure connection' option was enabled in the Pro Cloud Server get the system administrator to turn off and then back on again the 'Require secure and authenticated connection' option, making sure to save the Database Manager each time.  This will reset the internal flag that Pro Cloud Server retains so that it can validate user credentials.

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 that is shown in the Pro Cloud Server Configuration Client. For the Alias see the Configure Database Manager Help topic.

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:

• 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 at the start of this topic

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 at the start of this topic

12031 - The connection with the server was reset

This can occur if you are attempting to connect with the Protocol HTTP, but the Port you have entered is configured for HTTPS (e.g 805).

• If you have selected the Protocol HTTP, confirm that the Port which you entered is configured for HTTP access
• If you have selected the Protocol HTTPS, confirm that the Port which you entered is configured for HTTPS access

See the Port Configuration Help topic for details.

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. If the default Firewall exception had been adjusted (after the original install) to suit your environment, these changes would have be lost by the re-install process. 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.

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 particularly 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 that 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 concurrently, and the 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 include:

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

This means that the server attempted to open a connection 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.