Hi,
we are recreating some triggers that have the function to write the changes in tables, like an audit table that compares if NEW.value is different from OLD.value then we insert that in some table.
something like:
VAR AGORA TIMESTAMP;
SET AGORA = NOW();
TRY
IF NEW.CFOP != OLD.CFOP THEN
INSERT INTO DBUSER.SYSHISTORICO (DATA_OCORRENCIA, OPERACAO, MY_OBJETO, ID_CLASSE, ID_CAMPO, INT_ANTIGO) VALUES (:AGORA, 2, :OLD.OID, 3001, 2, :OLD.CFOP);
CATCH
IF $RC != 100
THEN STOP ($RC, 'unexpected error');
then today, when we dropped all triggers and reacreated with some new attributes (more IFs sentences as we added new fields to application), we are getting the error:
: System error: bd_page_collision
I cant find anything about it inside documentation or on this forum, the MaxDB version is 7.6.06.10
any idea?
Best regards
Clóvis