Falha
Após atualizar o E-forms, ao abrir o Connector Settings ocorre o seguinte erro:
Unhandled exception has ocurrend in your application. If you click Continue, the application will ignore this error and attempt to continue. If your click Quit, the application will close immediately.
Columns 'PreserveRejecteds' does not belong to table Table.
Como resolver?
Solução
Este erro ocorre pois a coluna “PreserveRejecteds” não existe nas tabelas “TBLOGLIMPDOCS”, “TBPARLIMDOCS”.
Para resolver este problema, basta executar o script abaixo:
//TBLOGLIMPDOCS BEGIN
IF NOT EXISTS (SELECT
COLUMN_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'TBLOGLIMPDOCS'
AND COLUMN_NAME = 'PreserveRejecteds')
ALTER TABLE TBLOGLIMPDOCS ADD PreserveRejecteds INT NULL
END
//TBPARLIMDOCS BEGIN
IF NOT EXISTS (SELECT
COLUMN_NAME
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'TBPARLIMDOCS'
AND COLUMN_NAME = 'PreserveRejecteds')
ALTER TABLE TBPARLIMDOCS ADD PreserveRejecteds INT NOT NULL DEFAULT '1'
END
Outras informações
Fonte: Elcio Hintze