Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About MarceloMarques
MarceloMarques
Esri Regular Contributor
since
07-04-2014
Friday
780
Posts created
433
Kudos given
115
Solutions
719
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(6 Idea Submissions)Latest Contributions by MarceloMarques
|
IDEA
|
I am a database administrator responsible to setup enterprise geodatabases that store very large datasets (terabytes), the best practice is to separate tables and indexes to improve performance, this reduces database datafiles fragmentation and contention, thus database i/o improves which leads to better performance, also improves maintenance tasks such as rebuilding indexes and gather new statistics. The sde repository tables also grow quite large in very large enterprise geodatabases. Hence, after I create the sde repository tables I have to manually move the sde repository indexes to a separate tablespace. It would be nice if the GP Tool "Create Enterprise Geodatabase" had an optional input parameter for the sde dbtune file. The dbtune file has the ##DATA_DICTIONARY configuration keyword that controls the sde repository tables storage options. Hence by filling the dbtune with the proper tablespaces and passing it to the GP tool the sde repository tables and indexes can be created under the proper tablespaces. In a remote past, in older arcgis releases when the sde binary commands where still available the dbtune used to be one of the input parameters for the "sdesetup -o install..." command, since the sde binaries deprecation and introduction of the GP Tool the database administrator has to manually move the indexes to a separate tablespace. Example script to move sde repository tables and indexes.
... View more
04-16-2020
03:03 PM
|
0
|
0
|
588
|
|
DOC
|
Esri Coronavirus Recovery Solutions Ministério da Saúde Brasil - Painel Covid Esri Operations Dashboard for Brazil ( Imagem - Esri Official Distributor ) Planet. - Daily Satellite Imagery and Insights at the Speed of Change US Census Bureau COVID-19 Site New York Times Coronavirus Map - Tracking the Global Outbreak TED - Ideas worth spreading Bill Gates - The next outbreak? We are not ready? Alanna Shaikh - Why Covid 19 is hitting us now and how to prepare for the next outbreak Laurie Garret - Lessons from the 1918 Flu Esri Coronavirus Resources Esri Coronavirus Recovery Solutions Geographic Information Systems for Coronavirus Planning and Response (white paper) Locating COVID-19 Testing, Treatment, and Resource Distribution Sites (white paper) COVID-19 Response: CHIME Model Introduction (YouTube) Emergency Event Geospatial Security and Privacy Guidance COVID-19 GIS Hub Coronavirus GIS Community (GeoNet) Esri Provides Free Mapping Software for Organizations Fighting COVID-19 (announcement) ArcGIS Support for a Remote Workforce (GeoNet) Wikipedia 2020 Coronavirus Pandemic Brazil WHO Coronavirus Dashboard WHO Portal Johns Hopkins Dashboard Accelerator Weather Rate Covid Spread
... View more
03-26-2020
11:55 AM
|
0
|
0
|
821
|
|
POST
|
Resolution: Reinstall DRS binaries and redeploy DRS SOE, must do this step to install the new SOE manually. Open ArcGIS Server Manager > Site > Extensions > ESRI.ReviewerServer.soe > Action: Edit > Extension > Select File > "C:\Program Files\ArcGIS\ArcGISDataReviewerServer\Server10.8\Bin\ESRI.ReviewerServer.soe" Then, test each ArcGIS Server Service, stop/start each service manually and check the ArcGIS Server Logs for severe errors. If necessary redeploy DRS Services. https://enterprise.arcgis.com/en/data-reviewer/latest/help/publishing-arcgis-data-reviewer-for-server-services.htm If necessary reconfigure DRS Services using DRS Configuration Utility, see example below. 1. ArcGIS Server DRS Services > BatchValidation > reviewer Open the DRS Configuration Utility: Connect to ArcGIS Server: http://localhost:6080/arcgis/admin UserName: drsadmin Password: **** Add DRS extension: Select extension file C:\Program Files\ArcGIS\ArcGISDataReviewerServer\Server10.8\Bin\ESRI.ReviewerServer.soe Set Reviewer Workspace: Select Map Service - BatchValidation/reviewer.MapServer Select New Reviewer Workspace - F:\sqlexpressgdb\localhost_RevWorkspace.sde
... View more
02-25-2020
09:05 AM
|
0
|
0
|
350
|
|
POST
|
I have upgrade ArcGIS Server and Data Reviewer Server (DRS) binaries. ArcGIS Server is working fine but DRS services fail to start. What is the cause? Service failed to start BatchValidation.reviewer.MapServer: Could not load file or assembly 'ESRI.Reviewer.Public.Engine.Interop, Version=10.6.0.0, Culture=neutral, PublicKeyToken=49f88df635890024' or one of its dependencies. The system cannot find the file specified.
... View more
02-25-2020
09:00 AM
|
0
|
1
|
445
|
|
POST
|
FYI for the future: If you are using 10.7.1 or above software then you don’t need to run steps 3 and 4. They are fixed in the software and will be of no use to set it up. With 10.8 all we know is to perform step 2 on some OS and in cloud solutions where the security level is higher and therefore we need to add the machines as trusted sites. This is not Esri software issue but the OS security level issue.
... View more
02-07-2020
08:37 AM
|
0
|
0
|
3210
|
|
POST
|
Question: I am able to publish the scene service but I’m having issues with some textures being dropped. I don’t think it’s a problem related to this issue but I’m still troubleshooting. Any ideas by chance? Answer: Disregard, just needed to rebuild the cache. Everything appears to be working as normal now.
... View more
02-07-2020
08:35 AM
|
1
|
0
|
3210
|
|
POST
|
AWS EC2 Multi Machine Deployment - Workaround Details Portal+Server is in one ec2 instance and the Data Store (Relational & TileCache) is in another ec2 instance. For each ec2 instance make the same Internet Explorer changes logged as the local user “arcgis”, then reboot the ec2 instances. For each ec2 instance the Internet Explorer Trusted Sites has the HTTP & HTTPS URLs with the Private IP of each ec2 instance ( see below for details ). Open Internet Explorer as the “arcgis” local user Press and hold shift key and right-click IE shortcut. Run as Different User… This did not work. I was able to open IE but the IE Trusted Sites changes did not persisted. Workaround: granted "remote desktop user" role to the local “arcgis” user then logged in and verified IE settings. re-applied the settings logged off/in, opened IE and settings were fine now revoked “remote desktop user” from local “arcgis” user Internet Explorer > Internet Options > Security > Sites disabled the option to Require server verification (https:) for all sites in this zone add these HTTP URLs http://agi-dev-3.esri.com < ec2 instances Private IPs > http://172.31.17.247 ags-dev-portal-3 http://172.31.17.87 ags-dev-data-store-3 http://172.31.17.247 ags-dev-data-store-spatial-3 add these HTTPS URLs https://agi-dev-3.esri.com < ec2 instances Private IPs > https://172.31.17.247 ags-dev-portal-3 https://172.31.17.87 ags-dev-data-store-3 https://172.31.17.247 ags-dev-data-store-spatial-3 Internet Explorer > Internet Options > Advanced tab Use TLS 1.2 was already enabled Use SSL 3.0 was enabled Data Store Property ags-dev-data-store-3 – Data Store ( Relational & TileCache) Connected to the Tools folder in “C:\Program Files\ArcGIS\DataStore\tools” and ran describedatastore Ran changedbproperties --store tileCache --enablessl admin,data >> Operation completed successfully changedbproperties: https://enterprise.arcgis.com/en/data-store/latest/install/windows/data-store-utility-reference.htm#ESRI_SECTION1_5F78275E9F6A42D199FC7098DFF049AB enablessl: This parameter controls use of the Transport Layer Security (TLS) protocol when populating the tile cache data store. Supported options for the enablessl parameter are as follows: admin: This is the default option. Specify admin to use Transport Layer Security when creating the container for the tile cache data store. data: Specify data to use Transport Layer Security when writing scene layer data to the tile cache data store. admin,data: Specify admin,data to use Transport Layer Security when creating and writing data to the tile cache data store. none: Specify none to use HTTP communication from the hosting server when creating and writing to the tile cache data store.
... View more
02-07-2020
08:28 AM
|
0
|
2
|
3210
|
|
POST
|
Workaround ---------------------------------------------------------------------- How do I run Internet Explorer as a different user in Windows To run an app as a different user in Windows 10, do the following. Open File Explorer and go to the folder which contains the required app. Press and hold the Shift key and right-click on the file. In the context menu, select Run as different user. Enter the new credentials and click OK to run the app. ---------------------------------------------------------------------- 1. Open Internet Explorer as the “arcgis” local user Press and hold shift key and right-click IE shortcut\ 2. Internet Explorer > Internet Options > Security > Sites Disabled the option to Require server verification (https:) for all sites in this zone Added the http://mysite.domain.com URL for ArcGIS Server ( HTTP ) Added the https://mysite.domain.com URL for ArcGIS Server ( HTTPS ) Added the http://177.37.7.137 URL for ArcGIS Server ( HTTP ) ec2 instance Private IP – see the output of the command describedatastore.bat tile cache machines property, it uses the private IP) <== THIS SOLVED THE PROBLEM!!!! Added the https://177.37.7.137 URL for ArcGIS Server ( HTTPS ) 3. Internet Explorer > Internet Options > Advanced tab Use TLS 1.2 was already enabled Use SSL 3.0 was enabled per suggestion on this forum article https://community.esri.com/thread/194033-root-node-is-not-available-for-layer-open-published-scene 4. Data Store Property Connected to the Tools folder in “C:\Program Files\ArcGIS\DataStore\tools” and ran describedatastore Ran changedbproperties --store tileCache --enablessl admin,data >> Operation completed successfully changedbproperties: https://enterprise.arcgis.com/en/data-store/latest/install/windows/data-store-utility-reference.htm#ESRI_SECTION1_5F78275E9F6A42D199FC7098DFF049AB enablessl: This parameter controls use of the Transport Layer Security (TLS) protocol when populating the tile cache data store. Supported options for the enablessl parameter are as follows: admin: This is the default option. Specify admin to use Transport Layer Security when creating the container for the tile cache data store. data: Specify data to use Transport Layer Security when writing scene layer data to the tile cache data store. admin,data: Specify admin,data to use Transport Layer Security when creating and writing data to the tile cache data store. none: Specify none to use HTTP communication from the hosting server when creating and writing to the tile cache data store. 5. Reboot the ec2 instance
... View more
01-14-2020
10:16 AM
|
0
|
3
|
3210
|
|
POST
|
We’re trying to publish scenes and we have not been able to get past this “root node” error. Here is what I’ve tried. Recaching all layers in the scene Having enable SSL 3.0 in IE on the server (Suggestion from a GoeNet post) Validating hosting server for the portal and all data stores in ArcGIS manager – everything validates Checking permissions for the arcgis user in the datastore directory – looks good. Adding a new file datastore to verify connections and permissions – successful Recaching all layers again – caching succeeds, but the scene will not draw. Still get the “root node” error for all scene layers.
... View more
01-14-2020
10:10 AM
|
0
|
4
|
3611
|
|
BLOG
|
MCS Enterprise Databases Best Practices - Current Release ArcGIS Help Guide Books Previous Releases *Guide books are available in the ArcMap Help beginning with ArcGIS 10.2 release. ________________________________________________________________________________________________ Table of Contents An Esri ® Technical Reference Document • 2022 ________________________________________________________________________________________________ Guide Books Previous Releases The guide books are intended for database administrators to help establish the product workspaces in an Enterprise Geodatabase. ________________________________________________________________________________________________ ArcGIS Pro 2.x Note: Roads and Highways, Pipeline Referencing, GeoEvent, Indoors, Aviation, Nautical customers can follow the same best practices in the Production Mapping Guide Books ArcGIS Pro 2.x Production Mapping & Defense Mapping - Topographic Mapping Production Database Best Practices Production Mapping 2.x Workspace in Oracle® February, 2019 Best Practices Production Mapping 2.x Workspace in SQL Server® February, 2019 Best Practices Production Mapping 2.x Workspace in PostgreSQL® March 2020 Data Reviewer Best Practices Data Reviewer 2.x Workspace in Oracle® February, 2019 Best Practices Data Reviewer 2.x Workspace in SQL Server® February, 2019 Best Practices Data Reviewer 2.x Workspace in PostgreSQL® March 2020 Workflow Manager Best Practices Workflow Manager 2.x Workspace in Oracle® February, 2019 Best Practices Workflow Manager 2.x Workspace in SQL Server® February, 2019 Best Practices Workflow Manager 2.x Workspace in PostgreSQL® March 2020 ________________________________________________________________________________________________ ArcMap 10.8 Note: Roads and Highways, Pipeline Referencing, GeoEvent, Indoors, Aviation customers can follow the same best practices in the Production Mapping Guide Books ArcMap 10.8 Feb 20, 2020 Production Mapping Production Database Best Practices Production Mapping 10.8 Workspace in Oracle® Best Practices Production Mapping 10.8 Workspace in SQL Server® Best Practices Production Mapping 10.8 Workspace in PostgreSQL® Product Library Best Practices Product Library 10.8 Workspace in Oracle® Best Practices Product Library 10.8 Workspace in SQL Server® Best Practices Product Library 10.8 Workspace in PostgreSQL® Data Reviewer Best Practices Data Reviewer 10.8 Workspace in Oracle® Best Practices Data Reviewer 10.8 Workspace in SQL Server® Best Practices Data Reviewer 10.8 Workspace in PostgreSQL® Workflow Manager Best Practices Workflow Manager 10.8 Workspace in Oracle® Best Practices Workflow Manager 10.8 Workspace in SQL Server® Best Practices Workflow Manager 10.8 Workspace in PostgreSQL® Bathymetric Solution (BIS) - Maritime Best Practices Bathymetry Solution (BIS) 10.8 Workspace in Oracle® Best Practices Bathymetry Solution (BIS) 10.8 Workspace in SQL Server® Nautical Solution (NIS) - Maritime Best Practices Nautical Solution (NIS) 10.8 in Oracle® Best Practices Nautical Product Library 10.8 in Oracle® Best Practices Nautical Solution (NIS) 10.8 in SQL Server® Best Practices Nautical Product Library 10.8 in SQL Server® ArcMap 10.7 ArcMap 10.7 Mar 19, 2019 Production Mapping Production Database Best Practices Production Mapping 10.7 Workspace in Oracle® Best Practices Production Mapping 10.7 Workspace in SQL Server® Best Practices Production Mapping 10.7 Workspace in PostgreSQL® Product Library Best Practices Product Library 10.7 Workspace in Oracle® Best Practices Product Library 10.7 Workspace in SQL Server® Best Practices Product Library 10.7 Workspace in PostgreSQL® Data Reviewer Best Practices Data Reviewer 10.7 Workspace in Oracle® Best Practices Data Reviewer 10.7 Workspace in SQL Server® Best Practices Data Reviewer 10.7 Workspace in PostgreSQL® Workflow Manager Best Practices Workflow Manager 10.7 Workspace in Oracle® Best Practices Workflow Manager 10.7 Workspace in SQL Server® Best Practices Workflow Manager 10.7 Workspace in PostgreSQL® Bathymetric Solution (BIS) - Maritime Best Practices Bathymetry Solution (BIS) 10.7 Workspace in Oracle® Best Practices Bathymetry Solution (BIS) 10.7 Workspace in SQL Server® Nautical Solution (NIS) - Maritime Best Practices Nautical Solution (NIS) 10.7 in Oracle® Best Practices Nautical Product Library 10.7 in Oracle® Best Practices Nautical Solution (NIS) 10.7 in SQL Server® Best Practices Nautical Product Library 10.7 in SQL Server® ArcMap 10.6 ArcMap 10.6 Jan 09, 2018 Production Mapping Production Database Best Practices Production Mapping 10.6 Workspace in Oracle® Best Practices Production Mapping 10.6 Workspace in SQL Server® Best Practices Production Mapping 10.6 Workspace in PostgreSQL® Product Library Best Practices Product Library 10.6 Workspace in Oracle® Best Practices Product Library 10.6 Workspace in SQL Server® Best Practices Product Library 10.6 Workspace in PostgreSQL® Data Reviewer Best Practices Data Reviewer 10.6 Workspace in Oracle® Best Practices Data Reviewer 10.6 Workspace in SQL Server® Best Practices Data Reviewer 10.6 Workspace in PostgreSQL® Workflow Manager Best Practices Workflow Manager 10.6 Workspace in Oracle® Best Practices Workflow Manager 10.6 Workspace in SQL Server® Best Practices Workflow Manager 10.6 Workspace in PostgreSQL® Bathymetric Solution (BIS) - Maritime Best Practices Bathymetry Solution (BIS) 10.6 Workspace in Oracle® Best Practices Bathymetry Solution (BIS) 10.6 Workspace in SQL Server® Nautical Solution (NIS) - Maritime Best Practices Nautical Solution (NIS) 10.6 in Oracle® Best Practices Nautical Product Library 10.6 in Oracle® Best Practices Nautical Solution (NIS) 10.6 in SQL Server® Best Practices Nautical Product Library 10.6 in SQL Server® ArcMap 10.5 ArcMap 10.5 Jun 22, 2017 Production Mapping Production Database Best Practices Production Mapping 10.5 Workspace in Oracle® Best Practices Production Mapping 10.5 Workspace in SQL Server® Best Practices Production Mapping 10.5 Workspace in PostgreSQL® Product Library Best Practices Product Library 10.5 Workspace in Oracle® Best Practices Product Library 10.5 Workspace in SQL Server® Best Practices Product Library 10.5 Workspace in PostgreSQL® Data Reviewer Best Practices Data Reviewer 10.5 Workspace in Oracle® Best Practices Data Reviewer 10.5 Workspace in SQL Server® Best Practices Data Reviewer 10.5 Workspace in PostgreSQL® Workflow Manager Best Practices Workflow Manager 10.5 Workspace in Oracle® Best Practices Workflow Manager 10.5 Workspace in SQL Server® Best Practices Workflow Manager 10.5 Workspace in PostgreSQL® Bathymetric Solution (BIS) - Maritime Best Practices Bathymetry Solution (BIS) 10.5 Workspace in Oracle® Best Practices Bathymetry Solution (BIS) 10.5 Workspace in SQL Server® Nautical Solution (NIS) - Maritime Best Practices Nautical Solution (NIS) 10.5 in Oracle® Best Practices Nautical Product Library 10.5 in Oracle® Best Practices Nautical Solution (NIS) 10.5 in SQL Server® Best Practices Nautical Product Library 10.5 in SQL Server® ArcMap 10.4 ArcMap 10.4 February 25, 2016 Production Mapping Production Database Best Practices Production Mapping 10.4 Workspace in Oracle® Best Practices Production Mapping 10.4 Workspace in SQL Server® Product Library Best Practices Product Library 10.4 Workspace in Oracle® Best Practices Product Library 10.4 Workspace in SQL Server® Data Reviewer Best Practices Data Reviewer 10.4 Workspace in Oracle® Best Practices Data Reviewer 10.4 Workspace in SQL Server® Workflow Manager Best Practices Workflow Manager 10.4 Workspace in Oracle® Best Practices Workflow Manager 10.4 Workspace in SQL Server® Bathymetric Solution (BIS) - Maritime Best Practices Bathymetry Solution (BIS) 10.4 Workspace in Oracle® Best Practices Bathymetry Solution (BIS) 10.4 Workspace in SQL Server® Nautical Solution (NIS) - Maritime Best Practices Nautical Solution (NIS) 10.4 in Oracle® Best Practices Nautical Product Library 10.4 in Oracle® Best Practices Nautical Solution (NIS) 10.4 in SQL Server® Best Practices Nautical Product Library 10.4 in SQL Server® ArcMap 10.3 ArcMap 10.3 September 9, 2014 Production Mapping Production Database Best Practices Production Mapping 10.3 Workspace in Oracle® Best Practices Production Mapping 10.3 Workspace in SQL Server® Product Library Best Practices Product Library 10.3 Workspace in Oracle® Best Practices Product Library 10.3 Workspace in SQL Server® Data Reviewer Best Practices Data Reviewer 10.3 Workspace in Oracle® Best Practices Data Reviewer 10.3 Workspace in SQL Server® Workflow Manager Best Practices Workflow Manager 10.3 Workspace in Oracle® Best Practices Workflow Manager 10.3 Workspace in SQL Server® Bathymetric Solution (BIS) - Maritime Best Practices Bathymetry Solution (BIS) 10.3 Workspace in Oracle® Best Practices Bathymetry Solution (BIS) 10.3 Workspace in SQL Server® Nautical Solution (NIS) - Maritime Best Practices Nautical Solution (NIS) 10.3 in Oracle® Best Practices Nautical Product Library 10.3 in Oracle® Best Practices Nautical Solution (NIS) 10.3 in SQL Server® Best Practices Nautical Product Library 10.3 in SQL Server® ArcMap 10.2 ArcMap 10.2 December 26, 2013 Production Mapping Production Database Best Practices Production Mapping 10.2 Workspace in Oracle® Best Practices Production Mapping 10.2 Workspace in SQL Server® Product Library Best Practices Product Library 10.2 Workspace in an Oracle® Best Practices Product Library 10.2 Workspace in an SQL Server® Data Reviewer Best Practices Data Reviewer 10.2 Workspace in Oracle® Best Practices Data Reviewer 10.2 Workspace in SQL Server® Workflow Manager Best Practices Workflow Manager 10.2 Workspace in Oracle® Best Practices Workflow Manager 10.2 Workspace in SQL Server® Bathymetric Solution (BIS) - Maritime Best Practices Bathymetry Solution (BIS) 10.2 Workspace in Oracle® Best Practices Bathymetry Solution (BIS) 10.2 Workspace in SQL Server® Nautical Solution (NIS) - Maritime Best Practices Nautical Solution (NIS) 10.2 in Oracle® Best Practices Nautical Product Library 10.2 in Oracle® Best Practices Nautical Solution (NIS) 10.2 in SQL Server® Best Practices Nautical Product Library 10.2 in SQL Server® ________________________________________________________________________________________________ An Esri ® Technical Reference Document • 2022 ________________________________________________________________________________________________
... View more
08-28-2019
04:41 PM
|
0
|
0
|
315834
|
|
IDEA
|
For Database Administrators that manage a large number of Enterprise Geodatabases. It would be nice if the Pro Contents window had a different icon for the Connected, Disconnected and Broken Geodatabases connections, just like ArcMap does. This will help quite a lot when you manage hundreds of eGDBs and hundreds of connection files, Broken connection, when the connection fails due to the network or any other problem. Also when right click the connection file in Pro would be nice the context menu to have an option to Connect & Disconnect the Geodatabase.
... View more
02-01-2019
01:10 PM
|
35
|
1
|
945
|
|
POST
|
When the Reviewer Workspace is created the featureclasses and tables already have indexes that are automatically created, however if revtablemain or the revdataset featureclasses become very large with time then some SQL Queries might become slow, it depends on how the Reviewer application is been used by users, and how users are querying the Reviewer tables and attributes, in such situation is necessary to ask the database administrator to perform a SQL trace to capture, identify and tune the slow SQL queries, a possible result of the tuning might be to add additional indexes to improve performance. I hope this helps.
... View more
05-02-2018
03:15 PM
|
0
|
0
|
214
|
|
POST
|
My Oracle Support Compiling In SQL Developer Throws "PLS-00707: Unsupported Construct Or Internal Error" (Doc ID 1521171.1) To Bottom In this Document Symptoms Cause Solution APPLIES TO: Oracle SQL Developer - Version 3.2 and later Information in this document applies to any platform. SYMPTOMS sql developer version: 3.2.20.09 Database version: 11.2.0.3 Attempting to compile Function/Prucedure/Package in SQL Developer throws the following error: PLS-00707: unsupported construct or internal error [2603] This issue is not occuring in sqlplus. This issue occurs only for the 11g/11gr2 Database on SQL Developer. CAUSE It seems to be caused by the parameter PL/SCOPE variable when it uses the value "IDENTIFIERS:ALL". SQL Developer during connection establishing changes the session parameter PLSCOPE_SETTINGS from IDENTIFIERS:NONE (default) to IDENTIFIERS:ALL. Same error was received in SQL PLUS when issuing an "alter session set PLSCOPE_SETTINGS=IDENTIFIERS:ALL". More about PL/Scope can be found here: http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htm http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams178.htm SOLUTION 1. Go to Preferences in SQL Developer. 2. Then go to Tools -> Preferences -> Database -> PL/SQL Compiler 3. Change the "PLScope identifiers" from All to None 4. Restart the SQL Developer.
... View more
01-26-2016
10:25 AM
|
1
|
0
|
631
|
|
POST
|
My Oracle Support Compiling In SQL Developer Throws "PLS-00707: Unsupported Construct Or Internal Error" (Doc ID 1521171.1) To Bottom In this Document Symptoms Cause Solution APPLIES TO: Oracle SQL Developer - Version 3.2 and later Information in this document applies to any platform. SYMPTOMS sql developer version: 3.2.20.09 Database version: 11.2.0.3 Attempting to compile Function/Prucedure/Package in SQL Developer throws the following error: PLS-00707: unsupported construct or internal error [2603] This issue is not occuring in sqlplus. This issue occurs only for the 11g/11gr2 Database on SQL Developer. CAUSE It seems to be caused by the parameter PL/SCOPE variable when it uses the value "IDENTIFIERS:ALL". SQL Developer during connection establishing changes the session parameter PLSCOPE_SETTINGS from IDENTIFIERS:NONE (default) to IDENTIFIERS:ALL. Same error was received in SQL PLUS when issuing an "alter session set PLSCOPE_SETTINGS=IDENTIFIERS:ALL". More about PL/Scope can be found here: http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_plscope.htm http://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams178.htm SOLUTION 1. Go to Preferences in SQL Developer. 2. Then go to Tools -> Preferences -> Database -> PL/SQL Compiler 3. Change the "PLScope identifiers" from All to None 4. Restart the SQL Developer.
... View more
01-26-2016
10:21 AM
|
1
|
0
|
3654
|
|
POST
|
Hello Jennifer, My name is Marcelo. I am the author of the ArcGIS Help topic about database best practices for the Reviewer workspace. Introduction to storing the Reviewer workspace in a geodatabase in Oracle Yes, it is absolutely necessary and important to configure the Oracle Enterprise Geodatabase Log File tables or you might encounter performance issues. Log file tables configuration for the Reviewer workspace in Oracle Thanks, Marcelo Marques GIS Technical Manager, Oracle OCP Esri Production Mapping Team Esri Enteprise Mapping and Charting Databases Best Practices
... View more
05-11-2015
03:39 PM
|
0
|
1
|
335
|
- « Previous
- Next »
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 02-23-2024 12:49 PM | |
| 2 | Tuesday | |
| 1 | Tuesday | |
| 3 | Monday | |
| 1 | 01-29-2024 09:17 AM |
Activity Feed
- Kudoed Re: MSSQL Database Roles to make Schema Changes on a single Database but not on others? for George_Thompson. Friday
- Posted Re: MSSQL Database Roles to make Schema Changes on a single Database but not on others? on Data Management Questions. Friday
- Kudoed Re: How to create a view layer of a non hosted (i.e. Federated) feature layer in Portal for Scott_Tansley. Friday
- Posted Re: AWS RDS Postgresql Horizontal or Vertical Scaling on ArcGIS Enterprise in the cloud Questions. Thursday
- Posted Re: How to create a view layer of a non hosted (i.e. Federated) feature layer in Portal on ArcGIS Enterprise Portal Questions. Thursday
- Got a Kudo for Re: Does ArcGIS Enterprise 11.x support changing Portal's URL?. Thursday
- Kudoed What's new in ArcGIS Bathymetry for ArcGIS Pro at 3.3 for KristaCarlson. Wednesday
- Posted Re: SQL Query Performance Issues on Data Management Questions. Wednesday
- Posted Re: SQL Query Performance Issues on Data Management Questions. Wednesday
- Got a Kudo for Re: ArcGIS Enteprise 11.1 EGDB older Oracle versions usable?. Wednesday
- Got a Kudo for Re: SQL RDBMS use with file geodatabases in ArcGIS Pro 3.x. Tuesday
- Got a Kudo for Re: ArcGIS Enteprise 11.1 EGDB older Oracle versions usable?. Tuesday
- Posted Re: ArcGIS Enteprise 11.1 EGDB older Oracle versions usable? on ArcGIS Enterprise Questions. Tuesday
- Kudoed Esri Dev Summit 2024 - ArcGIS Monitor: Techniques for Analyzing Common Operational Scenarios for DerekLaw. Tuesday
- Got a Kudo for Re: ArcGIS Enteprise 11.1 EGDB older Oracle versions usable?. Tuesday
- Posted Re: ArcGIS Enteprise 11.1 EGDB older Oracle versions usable? on ArcGIS Enterprise Questions. Tuesday
- Posted Re: SQL RDBMS use with file geodatabases in ArcGIS Pro 3.x on Geodatabase Questions. Monday
- Got a Kudo for Re: SQL RDBMS use with file geodatabases in ArcGIS Pro 3.x. Monday
- Got a Kudo for Re: SQL RDBMS use with file geodatabases in ArcGIS Pro 3.x. Monday
- Posted Re: SQL RDBMS use with file geodatabases in ArcGIS Pro 3.x on Geodatabase Questions. Monday
User Groups for MarceloMarques
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
Friday
|