Latest Contributions by MarkMcCart

‎10-03-2016

I was able to make the view using Toad, so there must be some syntax issue with the way I am using the 'Create View' tool in catalog. Can anyone give me a working example on how to create a view with that tool?

‎10-03-2016

I tried removing the semicolon in the Create View tool like this: And it threw the following Errors: ORA-00936: missing expression - DBMS table not found ORA-04043: object schemaowner.REALTIME_CRUMBS does not exist.

‎10-03-2016

I am trying to create a view in our Oracle 12C SDE instance. I've tried a Python script, the Create View Tool in ArcCatalog and CREATE NEW>View by right-clicking in ArcCatalog and I get the following errors: ORA-00928: missing SELECT keyword ORA -00942: table or view does not exist. DBMS table not found We are using ArcGIS 10.4.1 and SDE 10.4.1 on an Oracle 12C instance. Our geometry type is ST_Geometry. The view I am trying to create has point geometry. The script I am using inside the 'CREATE NEW>VIEW' in ArcCatalog is: CREATE VIEW REALTIME_CRUMB_V55 AS SELECT (OBJECTID, LABEL, LOGDT, SHAPE) FROM schemaowner.TRUCK_HISTORY_3HR WHERE OBJECTID > 0; I am logged in as 'schemaowner' when I try to create the view so I know there's not a privilege issue. I've also confirmed that the 'schemaowner' has 'CREATE_VIEW' privilege granted to it. I've also confirmed that our st_shapelib.dll file and path are confirmed correct in Oracle. Any suggestions? Thanks, Mark

‎09-13-2016

How can I register a custom coordinate system .prj file with ArcServer that does not have a WKID/WKT? I am using Server 10.4.1. I have a .prj file, and I can use for custom geoprocessing services. But we're running into issues with Roads and Highways. Thanks, Mark

‎07-14-2016

After some testing and looking at our trace files. We determined that a change had to be made to our sqlnet.ora file in our Oracle client. We added the line 'DEFAULT_SDE_SIZE= 512'. Once that change was made, data loaded much faster. Thanks for everyone's advice to help us solve this include Jim at Esri. -Mark

‎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: Cannot Create SDE View 10.4.1

Re: Cannot Create SDE View 10.4.1

Cannot Create SDE View 10.4.1

ArcServer Custom Coordinate .prj

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

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

Re: SDE Taking Too Long To Load Data

Re: Can't register Oracle SDE database with ArcSer...

File/Record Limits/Restrictions for GeoJSON Files ...

SDE Taking Too Long To Load Data

Re: SDE Taking Too Long To Load Data

Web AppBuilder Custom Widgets