Some 1C SQL queries generate wrong PostgreSQL queries

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: 2
Joined: May 15, 2013
Company:

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.

 
#2
People who like this:0Yes/0No
Active user
Rating: 2
Joined: May 15, 2013
Company:

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.

 
#3
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Hello, Aurimas Fišeras.
Please, try to update 1C:AccountingSuite to the latest version. As for now it is 1.1.40.01.

 
#4
People who like this:0Yes/0No
Active user
Rating: 2
Joined: May 15, 2013
Company:

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

 
#5
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Okay, thank you for the information, I have sent it to the developer team.

 
#6
People who like this:0Yes/0No
Active user
Rating: 2
Joined: May 15, 2013
Company:

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.

 
#7
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

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.

 
#8
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

Thank you for your information, Aurimas Fišeras! Your problem will be solved in 8.3.6 version of 1C:Enterprise platform.

 
#9
People who like this:0Yes/0No
Active user
Rating: 2
Joined: May 15, 2013
Company:

Great. Is it already known when 8.3.6 will be released for testing?

 
#10
People who like this:0Yes/0No
Timofey Bugaevsky
Guest

Joined:
Company:

There will be a notification on this forum.

 
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.