SDBL error - document changes table

This forum is intended for cases when a problem can not be solved due to restrictions of the platform: a bug or lack of functionality.

#1
People who like this:0Yes/0No
Active user
Rating: 6
Joined: Mar 20, 2012
Company: Abaco Soluciones S.A.

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.

Edited: Mikhail Ivanenko - Jan 09, 2014 05:57 AM
 
#2
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

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.

 
#3
People who like this:0Yes/0No
Interested
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.

 
#4
People who like this:0Yes/0No
Interested
Rating: 32
Joined: Oct 27, 2011
Company: Abaco Soluciones S.A.

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

 
Subscribe
Users browsing this topic (guests: 1, registered: 0, hidden: 0)
Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.