Histórico da Página
...
What
...
What should I do if the following error.log occurs when executing the Results Calculation routine:
THREAD ERROR (ZZZZZZ, XXXXX) 06/03/2012 15:18:26
Error updating balances in CTU010
...
Proccess Cancelledo
Error : 2601 (23000)
...
(RC=-1)
...
-
...
[Microsoft
...
]
...
[SQL
...
Native
...
Client
...
]
...
[SQL
...
Server
...
]Cannot
...
insert
...
duplicate
...
key
...
row
...
in
...
object
...
‘dbo.CTU010‘ with unique index ‘CTU010_UNQ‘. ( From tDBServer::SQLExec
...
)
...
...
Thread
...
ID
...
[4084
...
] User
...
[Antonio
...
] IO
...
[24638
...
] Tables
...
[29
...
]
...
MaxTables
...
[29
...
]
...
Comment
...
[CTBA210
...
-
...
TCPIP
...
] Status
...
[
...
] SP
...
[
...
] Traced
...
[No
...
] InTran
...
[No
...
]
...
DBEnv
...
[MSSQL/DADOS10
...
] DBThread
...
[(SPID:
...
65)
...
] Started
...
[06/03/2012
...
15:10:24
...
] LastIO
...
[06/03/2012
...
15:18:26
...
] IP
...
[172.30.202.81
...
] RCV
...
[1710827
...
]
...
SND
...
[3316310
...
] TCBuild
...
[20100602
...
]
...
UPDATE CTU010 SET CTU_LP =
...
‘S‘, CTU_DTLP =
...
‘20111231‘ WHERE CTU_FILIAL =
...
‘01‘ AND CTU_MOEDA =
...
‘01‘ AND CTU_TPSALD =
...
‘1‘ AND CTU_DATA >=
...
‘20110101‘ AND CTU_DATA <=
...
‘20111231‘ AND CTU_LP IN (
...
‘N‘,‘ ‘) AND D_E_L_E_T
...
_<>‘*
...
‘ AND R_E_C_N_O_>= 415904 AND R_E_C_N_O_<= 430464 on CT190FLGLP(CTBA190.PRW) 14/09/2010 15:38:58 line : 2329
...
...
...
[TOTVS
...
build:
...
7.00.100601A-20100727
...
]
...
Called from CT211FLGLP(CTBA211.PRW) 22/12/2010 15:08:02 line : 2620
Called from CTB211PROC(CTBA211.PRW) 22/12/2010 15:08:02 line : 1255
Called from { |OSELF| IF(MV_PAR29==1 .AND. !EMPTY(XFILIAL("CT2")),
CTB211FIL(NIL,OSELF,MV_PAR30,MV_PAR31) ,
CTB211PROC(OPROCESS,OSELF) ) }(CTBA211.PRW) 22/12/2010
Usually, when this error occurs, the inconsistency is in the structure of the tables (field sizes) and/or is related to the data in the database.
To help you understand and solve this, here are the verification procedures in your environment:
Procedure for changing the size of accounting entities – 23592
Extending the number of decimal places in other currencies – 23593
Extension of the Entity Code in SigaCTB – 11346
It is essential to check the points mentioned above and, if you still encounter problems when executing the routine, please contact the HelpDesk team.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas