"ALTER TABLE SDE_layers" after upgrade 10.7.1

170
1
04-21-2020 05:49 AM
Javier_Pintos
New Contributor III

Hello everyone,

I have a problem after updating ArcGIS Enterprise 10.6.1 to 10.7.1. The DBA area reports many ALTER TABLE in geodatabases one week after the updated server.

The queries are:
ALTER TABLE DB1.sde.SDE_layers ALTER COLUMN database_name NVARCHAR (128) NOT NULL
declare @ p1 int set @ p1 = NULL exec sp_prepexec @ p1 output, NULL, N'ALTER TABLE DB1.sde.SDE_layers ALTER COLUMN database_name NVARCHAR (128) NOT NULL 'select @ p1

And so on all geodatabases repetitively.

It appears to be a process of adapting the structure of the GDB from one version to another. But it continues to run after a long time and no matter how many services are restarted.

Has anyone had the same problem?

Thank you!

0 Kudos
1 Reply
George_Thompson
Esri Frequent Contributor

I would recommend opening a Esri Technical Support case and work with an analyst on this issue. They are better suited to understand and diagnose any issues at this low level.

I would also include the version of the RDBMS being used.

--- George T.
0 Kudos