"ALTER TABLE SDE_layers" after upgrade 10.7.1

578
2
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
2 Replies
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
YuvrajAdagale89
New Contributor

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

 

0 Kudos