sdeintercept GetstreamError

[DamianSchroder]

I am trying to track down the cause of an AcrMap application freeze. I am able to replicate the issue using a very complex mxd with mxdperfstat93 with default scale parameters. We were targeting the OS because the tests had no issues on Windows 2008 sp2 where it was failing on Windows 2008R2. Unfortunately, the OS was not the only variable. The 2008 sp2 machine is situated right next to the database (1 hop with a tracert). The 2008R2 machine is connected to the database with 1000 Mbps fiber line and has 4 hops with using  tracert to the database. To test the OS being the cause, we built a VM with Windows 2008 sp2 and placed it in the same data center as the 2008R2 machine. We expected the mxdperfstat test to succeed but it failed the same as the 2008R2 machine. Because, we are not testing apples to apples (VM vs a physical server and different memory/cpu allocations) we do not want to jump to the conclusion that it is the network.

I am doing  client-side sdeintercept logging using direct connect. There are 2 logs that are output during the operation. Below is a snippet from each one before failure. Included is the end of the logs. The log ends abruptly without any error message.

sdeinitercept.001
========================================
[W 54:49] Command:      SetSpatialConstraints
[W 54:49] Long:         616
[W 54:49] Short:        2
[W 54:49] Long:         0
[W 54:49] Filter Array: [1]
Table:        IGC.TRANSMISSIONMAIN
Column:       SHAPE
SearchMethod: SM_ENVP
Truth:        Must Pass
FilterType:   SE_SHAPE_FILTER
          FilterShape:
          Feature Number:        0
          Feature Entity Type:   Area       
          Number of Points:      5
          Feature Envelope:
            MinX:    990331.42421, MaxX:   1010976.70210
            MinY:    824805.01608, MaxY:    843366.96063
          Polygon Perimeter:         78414.44488
          Polygon Area:          383216503.43924
---------------------------------------------------------------
Point          X                Y               2D Distance
---------------------------------------------------------------
    1     990331.42421     824805.01608
    2    1010976.70210     824805.01608        20645.278
    3    1010976.70210     843366.96063        18561.945
    4     990331.42421     843366.96063        20645.278
    5     990331.42421     824805.01608        18561.945

[R 54:49] Long:         0
========================================
[W 54:49] Command:      ExecuteSpatialQuery
[W 54:49] Long:         616
[R 54:49] Long:         0
========================================
[W 54:49] Command:      NextBuffer
[W 54:49] Long:         616
========================================
[W 54:49] Command:      GetstreamError      <<<<<<< this is the end of the log

-------------------------------------------------------------------------------------------------------------------------------
sdeintercept.002
========================================
[R 54:49] Command:      SetSpatialConstraints
[R 54:49] Long:         616
[R 54:49] Short:        2
[R 54:49] Long:         0
[R 54:49] Filter Array: [1]
Table:        IGC.TRANSMISSIONMAIN
Column:       SHAPE
SearchMethod: SM_ENVP
Truth:        Must Pass
FilterType:   SE_SHAPE_FILTER
          FilterShape:
          Feature Number:        0
          Feature Entity Type:   Area       
          Number of Points:      5
          Feature Envelope:
            MinX:    990331.42421, MaxX:   1010976.70210
            MinY:    824805.01608, MaxY:    843366.96063
          Polygon Perimeter:         78414.44488
          Polygon Area:          383216503.43924
---------------------------------------------------------------
Point          X                Y               2D Distance
---------------------------------------------------------------
    1     990331.42421     824805.01608
    2    1010976.70210     824805.01608        20645.278
    3    1010976.70210     843366.96063        18561.945
    4     990331.42421     843366.96063        20645.278
    5     990331.42421     824805.01608        18561.945

[W 54:49] Long:         0
========================================
[R 54:49] Command:      ExecuteSpatialQuery
[R 54:49] Long:         616
[W 54:49] Long:         0
========================================
[R 54:49] Command:      NextBuffer
[R 54:49] Long:         616
[W 54:49] Long:         0 <<<<<<<<<<<< this is the end of the log


Additional information:
Client: ArcMap 9.3.1
ArcSDE: 9.3.1
Database:Oracle 11g (11.1.0.7.0) 64bit

Error generated in DOS window by mxdperfstat:
buffer_alloc stream buffer block: errno = 8

There are 3 mxds that I test. The 2nd mxd has scale dependencies on some of the major feature classes and fails in at a different spot but with the same errors. The third has scale dependencies set for all major feature classes (1:50,000) and succeeds in all tests on any platform tested.

Research on both the mxdperfstat and sdeintercept errors have yielded nothing (I have not found the descriptions for these errors). I don't want to make assumptions about these errors. Any insight would be appreciated. Thanks

[VinceAngelo]

Have you tried contacting Tech Support?  They're the only folks who can make productive
use of trace output (and only when its really needed).

Four network hops is a *lllooonnnggg* way to go for spatial data in a production environment.

- V