Latest Contributions by DiegoLlamas

Hello Kelly, I am getting an error with a hosted Feature service in AGOL with over 1.5 million parcels for Puerto Rico. When we search for a parcel number it gives me error the first or the second time we search for a parcel number. the third time we get the parcel. So we know that over 10k records AGOL do not works that good. So we are thinking in create a geocoder service. Can we use a geocode service in AGOL? can we publish and use our geocoder in AGOL? I want to do this so I can workaround the search error I am getting in AGOL if I search for a parcel. Thanks for your help! Diego Llamas ... View more

Hello George, Happy new year. I was able to get up and running the new Oracle geodatabase. Now I am re configuring DBTune so I can have the same configuration keywords in the new GDB.  I have seen several changes. For example in version 10.4 I have this: BND_STORAGE                "PCTFREE 0 INITRANS 4 STORAGE ( INITIAL 409600) " and in  version 10.6 I have this :BND_STORAGE                "PCTFREE 0 INITRANS 4" this in default section.  So what I am doing is copy and paste in the new version so then I can update dbtune in new geodatabase. I am checking this page to confirm that it is compatible with version 10.6 Oracle configuration parameters—Help | ArcGIS Desktop  so my question is, is it ok to add the STORAGE ( INITIAL 409600) for this new version, right? Regards, DLL ... View more

Nop, after change to any and recompile, I had the exact same error.  Do you know how can I find out if the database is corrupted or something of I did wrong the ST compatibility. If I recreate the database and use create new enterprise geodatabase, i just need to modify the extproc file, copy the library to bin folder, and run this command SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB'; CREATE OR REPLACE LIBRARY ST_SHAPELIB AS 'E:\app\DLLAMAS\product\12.1.0\client_1\bin\st_shapelib.dll'; ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS; are those the steps? all this before I add any data or this should work with data in the database? Regards, DLL ... View more

Hello George,  I run the recompile But after running select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual; My situation with the database is serious. Thanks for your help! Diego  ... View more

Hello George, I got an error in my database server when I run %ORACLE_HOME%\bin so I look for it and I put it here Do you have the specific path where I need to copy the library. Regards, DLL ... View more

Hello, Yes, I use Enable Enterprise geodatabase tool, so If I run the create spatial type tool it does not affect my database right, if we already had the ST because I used the create database, create spatial should not affect i assume.  I installed VC_REDSTTx64 you mention. this was a new database, so I did not have any st_shapelib.dll from before, i copied the 10.6 server version file from the server machine to the db machine for the fist time, i did not have one before, so do i needed to use library? I put the last part. I will re run the SQL statement after I installed VC++ I do not think I did this FAQ: Can the execute privilege be removed from public on Oracle packages?  is this necessary It this necessary? what user need to have those public packages? REgards, DLL ... View more

I also checked George Thompson's Blog‌ the privileges for sde user and it has all of them suggested by esri. ... View more

Hello George Thompson's Blog After your help I was able to create the database and create roles and user gisadmin, giseditor and gisviewer, the users has their privileges set. So I started to copy paste data sets from an old database to the new one. In the middle of the process of migrating the data I remember that I did not configure the ST_Geometry type to the new database, so I copied the st_shapelib.dll from server to the database server, modify the extproc.ora file as shown in Configure the extproc to access ST_Geometry in Oracle—Help | ArcGIS Desktop  run this on the SQL Developer SELECT file_spec FROM user_libraries WHERE library_name = 'ST_SHAPELIB'; CREATE OR REPLACE LIBRARY ST_SHAPELIB AS 'C:\Oracle_ST_GeometryLIB\st_shapelib.dll'; ALTER PACKAGE sde.st_geometry_shapelib_pkg COMPILE REUSE SETTINGS; and run the create spatial type geoprocessing tool.  After I did that, I tried to copy and paste the rest of the data sets and I got this erros If I add the existed data from the database to arcmap I got this error. If I try to create a new feature class If I try to delete something from the database, it erase but once refreshed it come again. I run one procedure in one of your post and I got this Any suggestion, What did I do wrong?  Regards, DLL ... View more