At a lost here, we are calling them SDE Gremlins. Still at SDE 9.3 (other app limits us to move on). When a 10.1 GDB feature was attempted to be added via the “LOAD” command into the SDE, failed. Even though we can not see it in Catalog, SQL knows the attempted file as being still there. Meanwhile the SQL DBA can not see it either. So now the SDE thinks the file is there and we can not use that naming convention) auto adds the”_1”. (Had to LOAD to a 9.3.1 GDB then LOAD to 9.3.1 SDE). No we have these unsightly naming features. No can not create a new feature and LOAD allover the dataset as SQL still knows somehow what you are up to.
... View more
I'm not a power user, just the person whom has be giving the responsibility . I come here hoping the the real GIS masters hear my plea and can help, or at least point the way. Looking to see if other SDE users have run across this potential problem. In an effort to isolate; Our organization is still in a 9.3 (no laughing please) SDE environment due to limited outside vendor limitations. Our SDE Raster has recently been experiencing user wide locked out, frozen failures. This affects our user base city wide to include our emergency response and dispatch. Timing coincides with using Spotlight 10.5 to run table diagnostics to the table indexes and fragmentation checks. Appears to timeout which in turn seems to degrade the server’s performance vastly. Not locking or crashing, just reads cycle continuously with no improvements once a threshold is hit (86%). Originally thought was Hardware failure was pending, as a test Spotlight was turned off over the weekend. All reports of errors and or malfunctions have stopped. I know "It hurts when I poke it", ... "So quite poking it!". Has any other run across this in the past?
... View more