Error "Export failure _com_error, Unspecified error, -2147467259" in Opalis Integration Server Client when exporting policies

Article
02/03/2011

When attempting to export a large structure of Policies and/or Global Resources (Variables, Counters, Schedules and Computer Groups), the following error is returned in the Opalis Integration Server Client:

"Export operation failed. Please see the Opalis Client and Management Server logs for more information. Additional information: Export failure _com_error, Unspecified error, -2147467259"

Exceptions like the following are recorded in the Management Server logs:

2011-01-04 10:03:28 [2632] 1 DBDataStore: ::Exception caught in long __thiscall CODBDataStore::InternalLoadObject(unsigned short *,long,struct IXMLDOMNode ** ,unsigned short *):
C:\Platform\DBDataStore\ODBDataStore.cpp(3529)
<Exception><Type>_com_error</Type><ErrorMessage>Unspecified error</ErrorMessage><Description>[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.</Description><HResult>-2147467259</HResult></Exception>

2011-01-04 10:03:28 [2632] 1 DBDataStore: ::Error #-2147467259
Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Source: Microsoft OLE DB Provider for SQL Server

2011-01-04 10:03:28 [2632] 1 DBDataStore: ::Exception caught in long __stdcall CODBDataStore::GetFolderContents(unsigned short *,struct tagVARIANT *):
C:\Platform\DBDataStore\ODBDataStore.cpp(1788)
<Exception>
<Type>Opalis::Exception</Type>
<Location>
long __stdcall CODBDataStore::GetFolderContents(unsigned short *,struct tagVARIANT *)
C:\AutomatedBuild\IS5.Platform\Branches\6.2_Sanitized\Platform\DBDataStore\ODBDataStore.cpp(1767)
</Location>
<MsgCode>_com_error</MsgCode>
<Params>
<Param>Unspecified error</Param>
<Param></Param>
<Param>-2147467259</Param>
</Params>
</Exception>

Cause

This can occur when there are a large volume of connections opened on the Opalis Integration Server Management Server that consume all the available ephemeral ports causing an inability to connect to the database server.

Resolution

Increase the available ephemeral ports by following the steps below:

1. Start Registry Editor.

2. Locate the following subkey in the registry and then click Parameters:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

3. If the value MaxUserPort does not exist, create a new DWORD value called MaxUserPort.

4. Set the value of MaxUserPort to a desired value above 5000 (decimal) up to a maximum value of 65534 (decimal). The higher the value, the more ports that can be created.

5. Exit Registry Editor and then restart the computer for the settings changes to take effect.

Jeff Fanjoy | Senior Support Escalation Engineer

Error "Export failure _com_error, Unspecified error, -2147467259" in Opalis Integration Server Client when exporting policies

Cause

Resolution

Additional resources