"ALTER TABLE SDE_layers" after upgrade 10.7.1

[Javier_Pintos]

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!

[George_Thompson]

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.

[YuvrajAdagale89]

Hi,

We are also facing similar kind of issue. Just want to know that you sure that these sql commands are getting triggered after you upgraded your ArcGIS Enterprise from 10.6.1 to 10.7.1.  

Thanks,

Yuvraj