Cross Segmentos - TOTVS BackOffice (Línea Protheus) - MI - Configurador (SIGACFG) - -CFGX051-There is already an object named 'TRB14SPSG1_PK' in the database.

Tiempo aproximado para lectura: 00:02:00 min

Ocurrencia
En el módulo Configurador (SIGACFG) al intentar actualizar las stored procedures se genera el siguiente error.log:

"THREAD ERROR ([9976], h450065, HIC024686) 10/11/2022 11:45:21
TRB14SPSG1: Error : 2714 (S0001) (RC=-1) - [Microsoft][SQL Server Native Client 11.0][SQL Server]There is already an object named 'TRB14SPSG1_PK' in the database.
Error : 1750 (37000) (RC=-1) - [Microsoft][SQL Server Native Client 11.0][SQL Server]Could not create constraint or index. See previous errors.
Error : 1750 (00000) (RC=-1) -
( From tDBServer::ROP_CREATEFILE )
Thread ID [9240] User [Administrador] IO [369419] Tables [131] MaxTables [132] Comment [CFGX051 - TCPIP - ThreadID(9976)] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [MSSQL/MPMIGGPERD] DBThread [(SPID 57,59)] Started [10/11/2022 11:03:53] IP [10.195.27.0:7602] IDLE [ ] InTransact [ ] Memory [-21709584] Running [ROP_CREATEFILE for 0 s.] RCV [51890035] SND [36310605] TCBuild [20220303-20221005] TCVersion [22.1.1.0] ARCH [64] OS [WINDOWS] BUILD [RELEASE]
CREATE TABLE dbo.TRB14SPSG1(G1_FILIAL VARCHAR(2) NOT NULL CONSTRAINT TRB14SPSG1_G1_FILIAL_DF DEFAULT ' ',G1_COD VARCHAR(15) NOT NULL CONSTRAINT TRB14SPSG1_G1_COD_DF DEFAULT ' ',G1_COMP VARCHAR(15) NOT NULL CONSTRAINT TRB14SPSG1_G1_COMP_DF DEFAULT ' ',G1_TRT VARCHAR(3) NOT NULL CONSTRAINT TRB14SPSG1_G1_TRT_DF DEFAULT ' ',G1_QUANT FLOAT NOT NULL CONSTRAINT TRB14SPSG1_G1_QUANT_DF DEFAULT 0,G1_PERDA FLOAT NOT NULL CONSTRAINT TRB14SPSG1_G1_PERDA_DF DEFAULT 0,G1_INI VARCHAR(8) NOT NULL CONSTRAINT TRB14SPSG1_G1_INI_DF DEFAULT ' ',G1_FIM VARCHAR(8) NOT NULL CONSTRAINT TRB14SPSG1_G1_FIM_DF DEFAULT ' ',G1_OBSERV VARCHAR(45) NOT NULL CONSTRAINT TRB14SPSG1_G1_OBSERV_DF DEFAULT ' ',G1_FIXVAR VARCHAR(1) NOT NULL CONSTRAINT TRB14SPSG1_G1_FIXVAR_DF DEFAULT ' ',G1_GROPC VARCHAR(3) NOT NULL CONSTRAINT TRB14SPSG1_G1_GROPC_DF DEFAULT ' ',G1_OPC VARCHAR(4) NOT NULL CONSTRAINT TRB14SPSG1_G1_OPC_DF DEFAULT ' ',G1_REVINI VARCHAR(3) NOT NULL CONSTRAINT TRB14SPSG1_G1_REVINI_DF DEFAULT ' ',G1_REVFIM VARCHAR(3) NOT NULL CONSTRAINT TRB14SPSG1_G1_REVFIM_DF DEFAULT ' ',G1_NIV VARCHAR(2) NOT NULL CONSTRAINT TRB14SPSG1_G on FWDBCREATE(FWDBCREATE.PRW) 04/10/2022 11:41:04 line : 51"



Ambiente
Cross Segmentos - TOTVS BackOffice (Línea Protheus) - MI - Configurador (SIGACFG) - a partir de la versión 12.1.2210


Solución

Para solucionar esa ocurrencia, realice los siguientes pasos:

1. Acceda a la base de datos a través de Management Studio;
2. Realice un respaldo de su base de datos;
3. Realice el drop table de la tabla TRB14SPSG1, si la tabla no existe, elimine el objeto: TRB14SPSG1_PK.
4. Reinicie DBAccess y valide si el problema persiste, es importante validen sin personalizaciones, funciones de usuario y puntos de entrada desactivados.