Forum

Some 1C SQL queries generate wrong PostgreSQL queries

Nov 04, 2014 09:05 AM

Active user

Points:: 0
Joined:: May 15, 2013

Code

Platform: 1C:Enterprise 8.3 (8.3.5.1248)
Configuration: AccountingSuite, v 1.1 (1.1.32.76) (accountingsuite.com)
AccountingSuite (TM) owned by 1C LLC. All rights reserved.
(accountingsuite.com)
Mode: Server (compression: enhanced)
Application: Thin client
Localization: Infobase: Lithuanian (Lithuania), Session: Lithuanian (Lithuania)
Interface mode: Taxi

Errors:
--------------------------------------------------------------------------------
2014-11-04 17:51:42
Unrecoverable error
Error executing the query POST to resource /e1cib/logForm:
because:
DBMS error:
ERROR:  column t1.q_001_f_000_type does not exist at character 8

PostgreSQL version: 9.3.4-1.1C (amd64, deb) on Ubuntu 14.04 64-bit
64-bit 1C server on the same Ubuntu server.

How to reproduce:
Open attached epf file with a simplified query and press the button.
PostgreSQL query from the error log is also attached.

The problem exists in every configuration I tried, if the Compatibility mode is 8.3.1 or higher and the query is similar to the attached one (FULL JOIN, Balance, GROUP BY).

We noticed this bug when we tried to increase compatibility mode in our configuration.

Profile

Aurimas Fišeras	#2 Nov 04, 2014 09:23 AM
Active user Points:: 0 Joined:: May 15, 2013	Just finished setting up PostgreSQL 9.2.4-1.1C (amd64, deb) on the same Ubuntu 64-bit server. Reran the test. The problem is exactly the same as with 9.3.4-1.1C.
	Profile

Timofey Bugaevsky	#3 Nov 05, 2014 02:07 AM
Guest Points:: Joined::	Hello, Aurimas Fišeras. Please, try to update 1C:AccountingSuite to the latest version. As for now it is 1.1.40.01.
	Profile

Aurimas Fišeras

Nov 05, 2014 02:40 AM

Active user

Points:: 0
Joined:: May 15, 2013

Hello,
as I mentioned before configuration is not relevant:

Code

Platform: 1C:Enterprise 8.3 (8.3.5.1248)
Configuration: AccountingSuite, v 1.1 (1.1.40.01) (accountingsuite.com)
AccountingSuite (TM) owned by 1C LLC. All rights reserved.
(accountingsuite.com)
Mode: Server (compression: enhanced)
Application: Thin client
Localization: Infobase: Lithuanian (Lithuania), Session: Lithuanian (Lithuania)
Interface mode: Taxi

Errors:
--------------------------------------------------------------------------------
2014-11-05 11:28:41
Unrecoverable error
Error executing the query POST to resource /e1cib/logForm:
because:
DBMS error:
ERROR:  column t1.q_001_f_000_type does not exist at character 8

I had to modify the query for this new version of AccountingSuite:

Code

SEL ECT
   Data.Column
FR OM
   (SELECT
      NULL AS Column
   FR OM
      AccumulationRegister.OrdersDispatched.Balance AS OrdersDispatchedBalance
         FULL JOIN AccumulationRegister.OrdersRegistered.Balance AS OrdersRegisteredBalance
         ON OrdersDispatchedBalance.Product = OrdersRegisteredBalance.Product
   
   GROUP BY
      OrdersDispatchedBalance.Product) AS Data

What is more the new configuration exhibits this behavior when I simply open it with user Admin and select Quick menu -> Items.

Code

Platform: 1C:Enterprise 8.3 (8.3.5.1248)
Configuration: AccountingSuite, v 1.1 (1.1.40.01) (accountingsuite.com)
AccountingSuite (TM) owned by 1C LLC. All rights reserved.
(accountingsuite.com)
Mode: Server (compression: enhanced)
Application: Thin client
Localization: Infobase: Lithuanian (Lithuania), Session: Lithuanian (Lithuania)
Interface mode: Taxi

Errors:
--------------------------------------------------------------------------------
2014-11-05 11:38:37
Unrecoverable error
Error executing the query POST to resource /e1cib/logForm:
because:
DBMS error:
ERROR:  column t8.q_001_f_000rref does not exist at character 2017

Profile

Timofey Bugaevsky	#5 Nov 05, 2014 07:37 AM
Guest Points:: Joined::	Okay, thank you for the information, I have sent it to the developer team.
	Profile

Aurimas Fišeras	#6 Nov 12, 2014 08:31 AM
Active user Points:: 0 Joined:: May 15, 2013	Hello, are there any news? Did you at least manage to reproduce the problem? If not, I can actively participate in resolving this problem and provide any information you may require.
	Profile

Timofey Bugaevsky	#7 Nov 12, 2014 11:22 PM
Guest Points:: Joined::	Hello, Aurimas Fišeras! Thank you for your cooperation! Our developers are working on this issue, so far they require no additional information. Hope your problem will be solved soon.
	Profile

Timofey Bugaevsky	#8 Nov 19, 2014 01:37 AM
Guest Points:: Joined::	Thank you for your information, Aurimas Fišeras! Your problem will be solved in 8.3.6 version of 1C:Enterprise platform.
	Profile

Aurimas Fišeras	#9 Nov 19, 2014 01:47 AM
Active user Points:: 0 Joined:: May 15, 2013	Great. Is it already known when 8.3.6 will be released for testing?
	Profile

Timofey Bugaevsky	#10 Nov 19, 2014 02:49 AM
Guest Points:: Joined::	There will be a notification on this forum.
	Profile