Error with account plan

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.

Pages: 1

Mikhail Ivanenko

People who like this: 0 Yes / 0 No

Jan 21, 2015 10:06 PM

Active user

Rating: 6
Joined: Mar 20, 2012
Company: Abaco Soluciones S.A.

Hello.
When I try to change ExtDimension in account I got this error:

Code
Microsoft SQL Server Native Client 11.0: Cannot insert value NULL in to column '_Fld1013RRef', table 'XXXX.dbo._AccRgAT0343'.

The query which leads to this:

Code

exec sp_executesql N'INSERT INTO dbo._AccRgAT0343 WITH(SERIALIZABLE) (_Period, _AccountRRef, _Fld334RRef, _Fld335, _TurnoverDt344, _TurnoverCt345, _Turnover346, _Fld336, _TurnoverDt347, _TurnoverCt348, _Turnover349, _Fld337, _TurnoverDt350, _TurnoverCt351, _Turnover352, _Fld338, _TurnoverDt353, _TurnoverCt354, _Turnover355, _Splitter)

It's easy to see that in the query column '_Fld1013RRef' isn't specified.
This field corresponds to the common attribute. I tried to disable it for accounting register, but I got a message:

Code
Registers that affect the sequence must have all separators for documents included in the sequence

Platform version is 8.3.5.1119
DBMS is Microsoft SQL Server Standard (64-bit) 11.0.5058.0

Edited: Mikhail Ivanenko - Jan 21, 2015 11:25 PM

Timofey Bugaevsky	#2 People who like this: 0 Yes / 0 No Jan 21, 2015 11:26 PM
Timofey Bugaevsky Guest Joined: Company:	Hello, Mikhail! First, try to update 1C:Enterprise platform. As for now, the latest version is 8.3.5.1383.

Mikhail Ivanenko	#3 People who like this: 0 Yes / 0 No Feb 19, 2015 11:54 PM
Active user Rating: 6 Joined: Mar 20, 2012 Company: Abaco Soluciones S.A.	Hello. In 8.3.5.1443 still exists. The manual creation of column in SQL server helps, but only until the next configuration update Edited: Mikhail Ivanenko - Feb 19, 2015 11:56 PM

Timofey Bugaevsky	#4 People who like this: 0 Yes / 0 No Feb 20, 2015 07:49 AM
Timofey Bugaevsky Guest Joined: Company:	Hello, Mikhail! We have published 8.3.5.1460 version of 1C:Enterprise platform today, please check, does this version solve this issue?

Pages: 1

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