Error "Export failure _com_error, Unspecified error, -2147467259" in Opalis Integration Server Client when exporting policies
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 Server2011-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
The App-V Team blog: https://blogs.technet.com/appv/
The WSUS Support Team blog: https://blogs.technet.com/sus/
The SCMDM Support Team blog: https://blogs.technet.com/mdm/
The ConfigMgr Support Team blog: https://blogs.technet.com/configurationmgr/
The SCOM 2007 Support Team blog: https://blogs.technet.com/operationsmgr/
The SCVMM Team blog: https://blogs.technet.com/scvmm/
The MED-V Team blog: https://blogs.technet.com/medv/
The DPM Team blog: https://blogs.technet.com/dpm/
The OOB Support Team blog: https://blogs.technet.com/oob/
The Opalis Team blog: https://blogs.technet.com/opalis
The Service Manager Team blog: http: https://blogs.technet.com/b/servicemanager
The AVIcode Team blog: http: https://blogs.technet.com/b/avicode