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.
