Tiempo aproximado para lectura: 00:03:00 min
Ocurrencia
Al intentar guardar un asiento contable, se presenta el siguiente error log:
Error en la preparacion del archivo de trabajo para que procedure actualice saldos.
Efectuar el reprocesamiento de los saldos
Error : 2628 (37000) (RC=-1) - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]String or binary data would be truncated in table 'C4LCYB_164853_PR_PD.dbo.TRW010_SP', column 'CT2_CLVLDB'. Truncated value: '100098462'.
Error : 3621 (00000) (RC=-1) -
( From tDBServer::ROP_SQLEXEC )
Thread ID [8160] User [Administrador] IO [8126] Tables [140] MaxTables [141] Comment [MATA465N - TCPIP - ThreadID(7136)] SP [ ] Traced [No] SQLReplay [No] InTran [Yes] DBEnv [MSSQL/C4LCYB_164853_PR_PD] DBThread [(SPID 72,73,65)] Started [27/02/2024 08:56:26] IP [10.0.2.4:7600] IDLE [ ] InTransact [0 s.] Memory [0] Running [ROP_SQLEXEC for 0 s.] RCV [395052] SND [3457607] TCBuild [20230303-20231110] TCVersion [23.1.1.1] ARCH [64] OS [WINDOWS] BUILD [RELEASE]
Insert Into TRW010_SP ( CT2_FILIAL, CT2_DATA, CT2_LOTE, CT2_SBLOTE, CT2_DOC, CT2_MOEDLC, CT2_TPSALD, CT2_DC, CT2_DEBITO, CT2_CREDIT, CT2_VALOR, CT2_CCD, CT2_CCC, CT2_ITEMD, CT2_ITEMC, CT2_CLVLDB, CT2_CLVLCR, CT2_EMPORI, CT2_FILORI, CT2_LINHA, CT2_ATIVDE, R_E_C_N_O_ ,CT2_EC05DB, CT2_EC05CR ) Values ( '01', '20240227', '008810', 'NCC', '000001', '01', '1', '1', '4115145101 ', ' ', 5000000.00, '003 ', ' ', ' ', ' ', '1000984620 ', ' ', '01', '01', '001', '0000000000000000000000000000000000007136', 37 ,'1000984620 ' , ' ' ) on CTBGRVCT2(CTBXATU.PRW) 15/09/2023 12:19:26 line : 1728
Ambiente
Cross Segmentos - TOTVS BackOffice (Línea Protheus) - MI - Contabilidad de Gestión (SIGACTB) - a partir de la versión 12.1.2210
Solución
Desinstale y vuelva a instalar el store procedure 06
0 Comentarios