Article ID: 123973, created on Dec 18, 2014, last review on Dec 18, 2014

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Subscription creation task failed:

Unsupported database type: 'mssql'

Cause

Orphaned database records.

Table psa.DatabaseServers contains the record pointing to non existent database server.

Most probably, this is the result of improper removing of MSSQL database server.

Resolution

  1. Create the backup of 'psa' database.

  2. Find the record about non existent database server:

    mysql> select id, host, type from DatabaseServers;
    +----+-------------+------------+
    | id | host        | type       |
    +----+-------------+------------+
    |  1 | localhost   | mysql      |
    |  2 | localhost   | postgresql |
    |  8 | 203.0.113.2 | mssql      |       << Not in the infrastructure 
    +----+-------------+------------+
    
  3. Delete unnecessary record:

    mysql> delete from DatabaseServers where id=8;
    
  4. Restart the failed task.

Search Words

Unsupported database type: 'mssql'

Unsupported database type

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF