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?
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.