Microsoft OLE DB Provider for SQL Server: Invalid column name 'ipAddress'

Created:

2016-11-16 12:48:40 UTC

Modified:

2017-04-24 11:23:04 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Microsoft OLE DB Provider for SQL Server: Invalid column name 'ipAddress'

Applicable to:

  • Plesk 11.5 for Windows

Symptoms

Plesk Panel interface is not accessible:

ERROR: com_exception: <b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Invalid column name 'ipAddress'.

Additionally, an exception has occurred while trying to report this error: com_exception
&lt;b&gt;Source:&lt;/b&gt; Microsoft OLE DB Provider for SQL Server&lt;br/&gt;&lt;b&gt;Description:&lt;/b&gt; Invalid column name &#039;ipAddress&#039;. (db.php:47)

MSSQL engine is used for Plesk database provider:

HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\PLESK\\PSA Config\\Config\\PLESK_DATABASE_PROVIDER = MSSQL

Cause

psa.servicenodes table does not have ipAddress column.

Resolution

  1. Create psa database backup:

    "C:\\Program Files\\Microsoft SQL Server\\100\\Tools\\Binn\\SQLCMD.EXE" -E -S .\\ -Q "backup database psa to disk = 'C:\\psa_backup.sql'"
  2. Add missed ipAddress column to servicenodes table:

    "C:\\Program Files\\Microsoft SQL Server\\100\\Tools\\Binn\\SQLCMD.EXE" -E -S .\\ -d psa -Q "select * from servicenodes where ipAddress = 'local'"
    Msg 207, Level 16, State 1, Server PROV-WIN-01, Line 1
    Invalid column name 'ipAddress'.

    "C:\\Program Files\\Microsoft SQL Server\\100\\Tools\\Binn\\SQLCMD.EXE" -E -S .\\ -d psa -Q "alter table servicenodes add ipAddress varchar(255) NOT NULL DEFAULT 'local'"
Have more questions? Submit a request
Please sign in to leave a comment.