Latest Contributions by George_Thompson

There are limitations that ArcGIS has with enterprise geodatabases and length of the table name is one of them.... Do you have the geodatabase repository tables in this database or where all the table created outside of ArcGIS? ... View more

I do not know of a work around. When you add the ".course" to the name of the feature class that is where it seems to not work. I tested and tried to create a feature class with the name "student.course" and got an error during creation. -George ... View more

Hi Hani, Does the SQL Server Express service account have access to that folder? I would recommend placing the MDF/Log file in the database location that is specified in the SQL instance. Move a desktop or workgroup geodatabase—Help | ArcGIS for Desktop Let us know if that works.... -George ... View more

Hi Hanan, Can you please provide a screenshot of the table in ArcCatalog or SQL Server Management Studio? This will clarify the issue. Also what version of ArcGIS Desktop are you using and what version is the geodatabase in? But it looks like you are trying to create a feature class name with a "." in it? If so that is not supported. In SQL Server the normal naming convention is something like this: DatabaseName.DataOwner.TableName = ESRI.GIS.Polygons Adding an extra "." in the name is probably the issue. Here is a link to some of the limits and naming conventions within ArcGIS. Enterprise geodatabase size and name limits—ArcGIS Help | ArcGIS for Desktop -George Geodatabase​ Managing Data​ Enterprise GIS​ ... View more

You may want to look into Geodatabase Replication: Understanding distributed data—ArcGIS Help | ArcGIS for Desktop This could also be done from the ArcGIS Server using Geodata Services: Geodatabase replication and ArcGIS for Server—ArcGIS Help | ArcGIS for Desktop This should give you some more items to review and decide with. -George Geodatabase​ Managing Data​ Enterprise GIS​ ... View more

Hi Brian, Nope, the only supported way is to update the Enterprise GDB license with the ArcSDE command-line tools. You do not need to create an ArcSDE Application Server service, just install the PostgreSQL command-line tools from the MyEsri Portal. Hope this helps clarify any questions. -George ... View more

Hi Brian, You are able to update the license file with the ArcSDE commands. Here is a blog that covers this topic: Updating the license for ArcSDE enterprise geodatabases at 10.1 | Support Services Blog -George Geodatabase​ ... View more

Hi John, Here are some other GeoNet discussing this same question: Is it possible to georectify a raster image in ArcGIS Pro? Georeferencing in ArcGIS pro It looks like the full functionality is not there yet........ Hope this help. -George Imagery and Remote Sensing​ ... View more

Hi Stephen, How large is the geodatabase? I wonder if it is timing out because of all the data being sent across the VPN and network. Are there lots of feature classes? What is the authentication method used (DB or OS)? If the user gets connected do they have any other issues when previewing or editing the data? Is this the only user with the issue when using VPN? What happens if the users uses the VPN from a different internet connection? What version is the SQL Server, ArcGIS client and the geodatabase currently at? Another option is to collect client intercepts and SQL Server traces at the same time to review what is happening between the ArcGIS Client and the SQL Server geodatabase. Setting up an SDE Intercept trace. Updated | SDEINTERCEPT You may need to contact Esri Support and have the help with this issue and review the intercepts and traces. -George Enterprise GIS​ Managing Data​ ... View more

As Vince mentioned you must do some more "prep" work for 10.2.2 ArcSDE Services. Here is a direct link to the info Vince referenced about the ORACLE_SID or TWO_TASK variable in dbinit.sde ArcGIS Help (10.2, 10.2.1, and 10.2.2) Here is a link to the help documentation for Oracle on Linux: ArcGIS Help (10.2, 10.2.1, and 10.2.2) Just start at the top and work your way down......... -George Geodatabase Enterprise GIS Managing Data ... View more

Hi Tom, You can also use some SQL in SQL Server Management Studio (SSMS): SELECT * FROM sys.database_principals http://stackoverflow.com/questions/18866881/how-to-get-the-list-of-all-database-users Here is a link to a site that will list all permissions for all users in a database (in SQL): http://stackoverflow.com/questions/7048839/sql-server-query-to-find-all-permissions-access-for-all-users-in-a-database SELECT      [UserName] = CASE princ.[type]                     WHEN 'S' THEN princ.[name]                     WHEN 'U' THEN ulogin.[name] COLLATE Latin1_General_CI_AI                  END,     [UserType] = CASE princ.[type]                     WHEN 'S' THEN 'SQL User'                     WHEN 'U' THEN 'Windows User'                  END,      [DatabaseUserName] = princ.[name],           [Role] = null,          [PermissionType] = perm.[permission_name],           [PermissionState] = perm.[state_desc],           [ObjectType] = obj.type_desc,--perm.[class_desc],           [ObjectName] = OBJECT_NAME(perm.major_id),     [ColumnName] = col.[name] FROM        --database user     sys.database_principals princ  LEFT JOIN     --Login accounts     sys.login_token ulogin on princ.[sid] = ulogin.[sid] LEFT JOIN            --Permissions     sys.database_permissions perm ON perm.[grantee_principal_id] = princ.[principal_id] LEFT JOIN     --Table columns     sys.columns col ON col.[object_id] = perm.major_id                     AND col.[column_id] = perm.[minor_id] LEFT JOIN     sys.objects obj ON perm.[major_id] = obj.[object_id] WHERE     princ.[type] in ('S','U') UNION --List all access provisioned to a sql user or windows user/group through a database or application role SELECT      [UserName] = CASE memberprinc.[type]                     WHEN 'S' THEN memberprinc.[name]                     WHEN 'U' THEN ulogin.[name] COLLATE Latin1_General_CI_AI                  END,     [UserType] = CASE memberprinc.[type]                     WHEN 'S' THEN 'SQL User'                     WHEN 'U' THEN 'Windows User'                  END,     [DatabaseUserName] = memberprinc.[name],       [Role] = roleprinc.[name],          [PermissionType] = perm.[permission_name],           [PermissionState] = perm.[state_desc],           [ObjectType] = obj.type_desc,--perm.[class_desc],       [ObjectName] = OBJECT_NAME(perm.major_id),     [ColumnName] = col.[name] FROM        --Role/member associations     sys.database_role_members members JOIN     --Roles     sys.database_principals roleprinc ON roleprinc.[principal_id] = members.[role_principal_id] JOIN     --Role members (database users)     sys.database_principals memberprinc ON memberprinc.[principal_id] = members.[member_principal_id] LEFT JOIN     --Login accounts     sys.login_token ulogin on memberprinc.[sid] = ulogin.[sid] LEFT JOIN            --Permissions     sys.database_permissions perm ON perm.[grantee_principal_id] = roleprinc.[principal_id] LEFT JOIN     --Table columns     sys.columns col on col.[object_id] = perm.major_id                     AND col.[column_id] = perm.[minor_id] LEFT JOIN     sys.objects obj ON perm.[major_id] = obj.[object_id] UNION --List all access provisioned to the public role, which everyone gets by default SELECT      [UserName] = '{All Users}',     [UserType] = '{All Users}',     [DatabaseUserName] = '{All Users}',           [Role] = roleprinc.[name],          [PermissionType] = perm.[permission_name],           [PermissionState] = perm.[state_desc],           [ObjectType] = obj.type_desc,--perm.[class_desc],      [ObjectName] = OBJECT_NAME(perm.major_id),     [ColumnName] = col.[name] FROM        --Roles     sys.database_principals roleprinc LEFT JOIN            --Role permissions     sys.database_permissions perm ON perm.[grantee_principal_id] = roleprinc.[principal_id] LEFT JOIN     --Table columns     sys.columns col on col.[object_id] = perm.major_id                     AND col.[column_id] = perm.[minor_id]                   JOIN     --All objects       sys.objects obj ON obj.[object_id] = perm.[major_id] WHERE     --Only roles     roleprinc.[type] = 'R' AND     --Only public role     roleprinc.[name] = 'public' AND     --Only objects of ours, not the MS objects     obj.is_ms_shipped = 0 ORDER BY     princ.[Name],     OBJECT_NAME(perm.major_id),     col.[name],     perm.[permission_name],     perm.[state_desc],     obj.type_desc--perm.[class_desc] Hope some of this helps..... -George Geodatabase​ Enterprise GIS​ Managing Data ... View more

Hi Eric, The name of the server could be changed, it is just the database name on the SQL Server instance cannot be changed. You may have to update the connection files unless IT can re-name the new machine with the same name. As for suggestions on allocation space or requirements, that is a very tough question to answer. I would review the minimum requirements/best practices for MS SQL Server. ArcGIS Enterprise geodatabases typically do not care how or where the data is stored, this is all managed by the RDBMS software and not ArcGIS. ... View more

Hi Jenny, I was forwarded the email that you sent to the geonet email address. I think that the files that you were given will not work at all. I believe that you are missing many missing files that are required. As for copying data into the new file geodatabase. Make sure that you are copying/pasting data that you can preview in ArcCatalog. If you need more assistance, you may want to contact your local Esri contact and get a support case opened and have an analyst help you with this issue in more detail. -George ... View more

Hi Wenting, I think that is the reason for the error. When the database is created there are some tables/triggers/procedures that get hard coded in the geodatabase. If the name changes, then these items break. I think that if you restore the DB2 database to the new server with the same name, you should be able to connect after that. -George ... View more

Here is some help documentation on what Vince was referring to in his post. Methods to move a geodatabase in SQL Server—Help | ArcGIS for Desktop -George Geodatabase ... View more