Desktop version

Main > Forum > 1C:Enterprise Platform > Bugs and functionality requests to 1C:Enterprise platform > SDBL error - document changes table

Forum

Search UsersRules
SDBL error - document changes table
#1
Active user
Points:: 0
Joined:: Mar 20, 2012

Hello.

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.

Profile
#2
Guest
Points::
Joined::

Try to upgrade to 8.2.19.80.
Also try to enable and then disable 8.2.16 compatibility mode.
Don't forget about backup before both of these.

Profile
#3
Interested
Points:: 0
Joined:: Apr 5, 2012

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.

Profile
#4
Interested
Points:: 15
Joined:: Oct 27, 2011

Marat, we have not changed platform version. It was 8.2.17 and still is

Profile
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)



© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.