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
