Today we upgraded our second testing server from 8.3.5.1186 to 8.3.5.1248 and immediately started receiving errors from PostgreSQL.
After some investigation I determined that these errors are caused by one of our Scheduled Jobs.
I reproduced the error with a simplified query on the Accounting configuration with PostgreSQL 9.2.4-1.1C and 9.3.4-1.1C:
| Quote |
|---|
Platform: 1C:Enterprise 8.3 (8.3.5.1248)
Configuration: AccountingSuite, v 1.1 (1.1.40.01) (accountingsuite.com)
AccountingSuite ™ 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-14 09:12:29
Unrecoverable error
Error executing the query POST to resource /e1cib/logForm:
because:
DBMS error:
ERROR: CASE types integer and timestamp without time zone cannot be matched at character 48 |
Simplified 1C query to reproduce the error:
| Code |
|---|
SEL ECT
COUNT(CASE
WHEN ExchangeRates.Period IS NULL
THEN ExchangeRates.Period
ELSE 0
END) AS CNT
FR OM
InformationRegister.ExchangeRates AS ExchangeRates
|
PostgreSQL 9.2.4-1.1C log attached.
