Essbase error 1042006

При работе с утилитами использующие Essbase API на платформе Windows   возможна  ситуация ошибок соединения – это лечится настройкой реестра

  • TcpTimedWaitDelayDetermines the time that must elapse before TCP can release a closed connection and reuse its resources. This interval between closure and release is known as the TIME_WAIT state or 2MSL state. During this time, the connection can be reopened at much less cost to the client and server than establishing a new connection.Registry key=HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
    Data type=REG_DWORD
    Default value=0xF0 (240 seconds = 4 minutes)
    Valid values=0x1E to 0x12C (30 to 300 seconds)
  • MaxUserPortDetermines the highest port number TCP can assign when an application requests an available user port from the system. Typically, ephemeral ports (those used briefly) are allocated to port numbers 1024 through 5000.Registry key=HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
    Data type= REG_DWORD
    Default value=5000
    Valid values= 5,000 to 65,534 (port numbers)

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters]
“MaxUserPort”=dword:0000fffe
“TcpTimedWaitDelay”=dword:0000001e

Essbase Compare Data with Database (Delta Detective)

По мотивам  Introducing Data Detective

Утилита проверки данных между двумя кубами essbase. Использует в качестве провайдера данных Essbase Spread Sheet for Excel.

К несчастью я не нашел сайт автора (Dave Farnsworth), если кто знает – напишите мне, что бы я указал источник.

Выдержка из ReadMe.doc
Continue reading “Essbase Compare Data with Database (Delta Detective)”