Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP SQL Anywhere, on-demand edition 1.0 SP 6 » Troubleshooting and additional resources

How do I fix a cloud object that is in an undesirable state?

A cloud object has an expected status and a current status.

The expected status reflects the state the object is expected to be in, and the current status reflects the state that the object is actually in.

If the current status and the expected status do not match, then the object is in an undesirable state. For example, if the expected status of the object is run, but its current status is starting, then the object is not in its expected state, and it must be diagnosed and repaired.

Generally, an object's current status shows either running, stopped, or disconnected. Diagnosing a cloud object by running the relevant diagnose task provides a more specific status. For example, diagnosing an object that has the current status disconnected may show a status of failed if the object is not running.

If an object is in an undesirable state when it is being started or stopped, it is automatically repaired. However, you can repair cloud objects manually by running the relevant repair task.

Note If you are repairing a cloud server that has numerous tenant databases running on it, restarting all the databases may take a significant amount of time.

If the object cannot be repaired to a desirable state, and cannot be dropped from the cloud, you have the option of forgetting the object. Forgetting a cloud object does not delete its corresponding files but removes the metadata from the object and makes the object inaccessible from the cloud.

Note Forgetting a cloud object should only be done if the object cannot be repaired or dropped from the cloud. Whenever possible, use the Delete button in the Console to remove the object from the cloud.
Valid expected status values
  • Running

    The object is expected to be running.

  • Stopped

    The object is expected to be stopped.

  • Maintenance

    The object is currently being modified by a task.

Valid current status values
  • Stopped

    The object is not running.

  • Starting

    The object is in the process of being started.

  • Running

    The object is running and responding to requests.

  • Stopping

    The object is in the process of being stopped.

  • Disconnected

    The object is inaccessible to the cloud, but is expected to be running.

  • Dropping

    The object is in the process of being deleted.

  • Dropped

    The object has been deleted.

  • Waiting_for_uid_pwd

    The database is waiting for the correct user ID and/or password to be provided.

  • Stopped_unconditionally

    The object was stopped when its parent object was stopped unconditionally.

    For example, if a cloud server is successfully stopped with the unconditionally parameter set, then all tenant database running on that cloud server are stopped as a result.

  • Failed

    The object has failed and is not running.

    For example, if a cloud server process is terminated, then the cloud server status shows that the cloud server is failed.

  • Unresponsive

    The object is running, but is not responding to requests.

    This status may occur if an object is restarting as part of a task.