Latest Contributions by George_Thompson

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

Hi Jenny, Here is some more information on coping data: Copying feature datasets, classes, and tables to another geodatabase—ArcGIS Help | ArcGIS for Desktop About loading data into existing feature classes and tables—ArcGIS Help | ArcGIS for Desktop ... View more

Hi Jenny, It looks like you were sent some of the contents of a file geodatabase. Try creating a folder called "test.gdb" and placing the files in that folder. Then attempt to connect in DT 10.3. As a test, I just created a new file geodatabase and it had 40 files in it. I would recommend having the sender send all the contents of the *.gdb folder in a zip file and re-testing. -George ... View more

I would recommend talking to your local account manager. As far as I know the only way to log issues with Esri (when outside of the US) is through a distributor. Hope this helps...... Esri Technical Support​ ... View more

To add to what Sam has said here are some KB articles that are useful: 44687 - Issues related to Oracle 11.2.0.3 42983 - In Oracle, why does it take a long time to build statistics on large ST_GEOMETRY data? George Geodatabase​ Enterprise GIS​ ... View more

HI Roxana, Can you provide a little more information for this issue: -What version of Data Interop is being used? Is ArcGIS Desktop at the same version? -What version is the Oracle database? Is it a geodatabase (with and SDE schema)? -Are you using the Oracle full client or Oracle Instant Client? -Are you able to connect to the Oracle database with SQLPlus or SQLDeveloper? -Are you able to make a connection in ArcCatalog (outside of the Data Interop extension) and see the expected data? This will help shed some light on the possible issue. George GISGISGIS ... View more

Here are a few observations: -The version of SQL Server is not a SP3 (to meet the min. support requirements) Microsoft SQL Server database requirements for ArcGIS 10.3.x—Help | ArcGIS for Desktop -Have you closed ArcCatalog and then tried the upgrade process again? -Does the SDE user (the user performing the upgrade) have the SQL Server SYSADMIN fixed server role? SDE needs to have the db_owner role for that database. I am guessing that this is a SDE schema geodatabase, correct? -Is this a multiple geodatabase model geodatabase? -George ... View more