Today we've got an error at the our client's server:
Quote
Unrecoverable error Error executing the query POST to resource /e1cib/logForm: because: SDBL error: Field Fld236 in table DocumentChngR3623 cannot have NULL value
It happens when we try to write document. The document is used very frequently, so now they couldn't work normally, so the problem is very urgent.
I tried to run database repairing and veryfication, but without any result.
The table now is empty.
They are using:
1C server 32-bit version 8.2.17.143 PostgreSQL 9.1.2-1.1C
There were no any platform and hardware updates recently.
As I found, error is caused by this line of code:
Code
ExchangePlans.RecordChanges(Nodes,ThisObject);
in the OnWrite handler of document. Nodes - is an array of references to exchange plan nodes, actually consists from 1 element.
As a temporary solution i turned on autoregistration in exchange plan and remove this line from code. But i need to control in what nodes this document should be sent.
Rating:
27
Joined: Apr 5, 2012
Company: 1TÇ Şirketi - Merv Bilgi İşlem Otomasyonu Yazılım Ltd. Şti.
Mikhail Ivanenko
Such errors appear when you change Platform and didn't verify and repair . It is related with standard fields of platform. So, I suggest you in Designer Mode Verify and Repair after changing platform version and may it will solved itself.