Latest Contributions by MarkMcCart

‎07-11-2016

When monitoring the data load in Toad, we noticed that Test and Prod are running different commands. Production is calling this statement a lot: SELECT table_name, time_last_modified FROM SDE.sde_tables_modified Test does not make this call.

‎07-11-2016

How can use the old 'Load-only' loading option in 10.4 now that SDE command line is gone?

‎07-11-2016

So we changed the ATTRBUFSIZE from 50,000 to 100,000 to match what we had on Test. It is still taking quite a while to load data. We're monitoring the data load in Toad and noticed once it loaded 56,000 records, it took about 3-4 minutes before it loaded any more.

‎07-11-2016

1. I am loading data from a FGDB. It is point data with attributes and quite a few domains we've set up. 2. No. There are no triggers setup. I assumed Esri handles that all in its code base.

‎07-11-2016

I've always dropped the spatial index prior to loading. And then create a new one and rebuild it. This isn't the issue.

‎07-11-2016

1. REST services are being consumed from Prod. I stopped all services that were tied to feature classes in that feature dataset. Also, I dropped the spatial index prior to loading the data. 2. Desktop version: 10.4.0, SDE 10.4.0 3. Having only tried to load via version 10.4.0. Did not try earlier version. After doing some digging, we did notice a difference between Test and Prod: ATTRBUFSIZE was different. In Test it was 100,000 in Prod it was 50,000. I am still trying to learn exactly what this means and does.

‎07-11-2016

George, 1. No, the data is not versioned. This is schema is not a transactional schema. Just a schema to serve out REST services. 2. No, it's always taken forever to load. The only caveat to that statement is that when we restart our old legacy, soon-to-be-retired, ArcServer stack, data seems to load faster. 3. No, there is no difference between the feature class structure in test vs. production. -Mark

‎07-11-2016

We are loading large amounts of data (1,000,000+ records) into a single feature classes into our Oracle 12c ArcSDE 10.4 instance. However, it is taking way too long to load that data. For example, I tried to load 550,000 records into a feature class using the Simple Data Loader in ArcCatalog on Sunday starting at 10:00 am, by 7:00 pm, it still wasn't done loading. I let it run all night, and it finally loaded. Our test environment does not have this same issue. Loading data into our test environment, with less resources, takes just a few minutes. Where can I start to troubleshoot this issue? Is it in Oracle, SDE set up? We have REST services being served out by these feature classes and tables in SDE, could that be an trouble area? Any help would be appreciated. Thanks, Mark

‎04-20-2016

We discovered we were using the wrong account to run services on the server. We were using a local account vs. a domain account. Problem solved.

‎04-19-2016

Done. Thanks for the help do some more checks before I submitted the ticket.

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by MarkMcCart

Re: SDE Taking Too Long To Load Data

Re: SDE Taking Too Long To Load Data

Re: SDE Taking Too Long To Load Data

Re: SDE Taking Too Long To Load Data

Re: SDE Taking Too Long To Load Data

Re: SDE Taking Too Long To Load Data

Re: SDE Taking Too Long To Load Data

SDE Taking Too Long To Load Data

Re: Can't register Oracle SDE database with ArcServer 10.4 with OS authentication

Re: Can't register Oracle SDE database with ArcServer 10.4 with OS authentication

Web AppBuilder Custom Widgets