We have been developing for a long time on a single oracle DB Server (Development stage) and recently added a new integration server. Because of time constraints we decided to just copy the data from the Dev server using SQL (out DBA did that part), and since we moved to SDO_GEOMETRY the data can be transferred without the use of ArcDesktop utilities.
So the data was moved correctly and the registration went without a glitch. But when we tried to create a new line in the layer its coordinates moved from (35.5, 32.7) (in x,y) to (–324.4, 32.7). The first thing I checked was my code but there were no changes done and in the old environment everything worked fine.
Looking at the Layers table in the SDE schema that table looked like:
| EFLAGS | LAYER_MASK | GSIZE1 | GSIZE2 | GSIZE3 | MINX | MINY | MAXX | MAXY | LAYER_CONFIG |
| 138674317 | 128 | -2 | 0 | 0 | -400 | -400 | 471.3916 | 471.3916 | SDO_GEOMETRY |
My first thought was that the –400 somehow affected the data being inserted but the same values were in the old DB and they worked.
After many actions of unregister and register of that layer the problem was solved.
TODO: Add table border, it looks bad in the site
