Имя: Пароль:
1C
1С v8
Переполнение в процессе преобразования числового типа данных. Книга покупок. DB2
0 Amiralnar
 
26.09.11
11:49
Проблема: при вводе нового документа "Формирование записей книги покупок", при попытке заполнить табличную часть, появляется сообщение об ошибке.

Ошибка:
{Документ.ФормированиеЗаписейКнигиПокупок.МодульОбъекта(266)}: Ошибка при вызове метода контекста (Выполнить)      Возврат Запрос.Выполнить().Выгрузить();по причине:
по причине:Ошибка выполнения запросапо причине:Ошибка при выполнении операции над данными:htype=SQL_HANDLE_STMT hndl=0x20001, line=4129, file=Src\DB2Connection.cppSQLSTATE=22003, native=-413, '[IBM][CLI Driver][DB2/NT] SQL0413N  Переполнение в процессе преобразования числового типа данных.  SQLSTATE=22003'

Платформа: 1С:Предприятие 8.2 (8.2.14.519)

Конфигурация: Бухгалтерия предприятия, редакция 2.0 (2.0.24.9)

СУБД:
Идентификатор продукта           SQL09072
Идентификатор уровня             08030107
Уровень                          DB2 v9.7.200.358
Уровень компиляции               s100514PTF                              IP23083

Я в DB2 ни ногой. Как исправить проблему?

Перевод в файловый режим признан крайней мерой.
1 Amiralnar
 
26.09.11
13:49
Ап
2 pavlika
 
26.09.11
13:53
3 Amiralnar
 
26.09.11
16:02
Актуально
4 pavlika
 
26.09.11
16:09
(3) Ну так и спроси на форуме по db2, вот почти твоя ошибка: http://www.ibm.com/developerworks/forums/thread.jspa?threadID=224310
Там подскажут как посмотреть на каком запросе падает и что ему не нравится.
5 Amiralnar
 
26.09.11
16:23
1. На форуме про дб2 мне предложат изучить дб2. Мне нужно починить 1с, а не дб2.
2. Это почти такая же ошибка, но она совсем другая. Я читал эту тему. Там проблема с обработкой строк, в операторе ВЫРАЗИТЬ. У меня проблема переполнения при преобразовании типа, не связанная с  оператором.

Может у кого-то есть бп на дб2, и он сжалится, проверит и отрапортует...
6 Базис
 
naïve
26.09.11
16:33
На файловой или MS SQL ошибка повторяется?
7 Amiralnar
 
27.09.11
01:09
(6) см. в (0)
8 Amiralnar
 
27.09.11
13:26
Ап...
9 МихаилМ
 
27.09.11
14:54
Вы не внимательно читали (4)
там в тему вез придурок со своей проблемой

как быстрое решение, не выгоняя пользователей : увеличте разрядность проблемного  поля
в дб2

затем
монопольно в конфигураторе.
10 Amiralnar
 
27.09.11
16:30
(9) Да, действительно, невнимательно читал.

Снял показания сервера:


Sql="SELECT
T1.Fld7457RRef,
T1.Fld7458_TYPE,
T1.Fld7458_RTRef,
T1.Fld7458_RRRef,
T1.Fld7459RRef,
T1.Fld7460RRef,
T1.Fld7461RRef,
T1.Fld7462RRef,
T1.Fld7463_,
CASE WHEN (COALESCE(CAST(ROUND(SUM(T61.Fld7465Balance_), 8) AS NUMERIC(31, 8)),0) = 0) THEN 0 ELSE (CAST(ROUND(CAST(ROUND((CAST(ROUND(((COALESCE(CAST(ROUND(SUM(T61.Fld7465Balance_), 8) AS NUMERIC(31, 8)),0) - COALESCE(CAST(ROUND(T53.Fld7430Balance_, 8) AS NUMERIC(31, 8)),0)) - COALESCE(CAST(ROUND(T57.Fld7481Balance_, 8) AS NUMERIC(31, 8)),0)) * COALESCE(CAST(ROUND(T1.Fld7465Balance_, 8) AS NUMERIC(31, 8)),0), 8) AS NUMERIC(31, 8))), 8) AS NUMERIC(23, 8)) / COALESCE(CAST(ROUND(SUM(T61.Fld7465Balance_), 8) AS NUMERIC(31, 8)),0), 8) AS NUMERIC(31, 8))) END,
CASE WHEN (COALESCE(CAST(ROUND(SUM(T61.Fld7466Balance_), 8) AS NUMERIC(31, 8)),0) = 0) THEN 0 ELSE (CAST(ROUND(CAST(ROUND((CAST(ROUND(((COALESCE(CAST(ROUND(SUM(T61.Fld7466Balance_), 8) AS NUMERIC(31, 8)),0) - COALESCE(CAST(ROUND(T57.Fld7482Balance_, 8) AS NUMERIC(31, 8)),0)) - COALESCE(CAST(ROUND(T53.Fld7431Balance_, 8) AS NUMERIC(31, 8)),0)) * COALESCE(CAST(ROUND(T1.Fld7466Balance_, 8) AS NUMERIC(31, 8)),0), 8) AS NUMERIC(31, 8))), 8) AS NUMERIC(23, 8)) / COALESCE(CAST(ROUND(SUM(T61.Fld7466Balance_), 8) AS NUMERIC(31, 8)),0), 8) AS NUMERIC(31, 8))) END,
COALESCE(CASE WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000CB' AS CHAR(4) FOR BIT DATA) THEN T113.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'00000063' AS CHAR(4) FOR BIT DATA) THEN T114.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'00000074' AS CHAR(4) FOR BIT DATA) THEN T115.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000CE' AS CHAR(4) FOR BIT DATA) THEN T116.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'00000077' AS CHAR(4) FOR BIT DATA) THEN T117.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000B6' AS CHAR(4) FOR BIT DATA) THEN T118.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000B1' AS CHAR(4) FOR BIT DATA) THEN T119.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000B9' AS CHAR(4) FOR BIT DATA) THEN T120.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000B2' AS CHAR(4) FOR BIT DATA) THEN T121.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'0000008B' AS CHAR(4) FOR BIT DATA) THEN T122.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000B3' AS CHAR(4) FOR BIT DATA) THEN T123.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'0000008C' AS CHAR(4) FOR BIT DATA) THEN T124.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'0000006B' AS CHAR(4) FOR BIT DATA) THEN T125.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'0000009A' AS CHAR(4) FOR BIT DATA) THEN T126.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000CF' AS CHAR(4) FOR BIT DATA) THEN T127.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'0000009C' AS CHAR(4) FOR BIT DATA) THEN T128.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000B7' AS CHAR(4) FOR BIT DATA) THEN T129.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000B0' AS CHAR(4) FOR BIT DATA) THEN T130.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000BD' AS CHAR(4) FOR BIT DATA) THEN T131.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'0000006C' AS CHAR(4) FOR BIT DATA) THEN T132.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'00000098' AS CHAR(4) FOR BIT DATA) THEN T133.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'00000099' AS CHAR(4) FOR BIT DATA) THEN T134.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'0000008E' AS CHAR(4) FOR BIT DATA) THEN T135.Date_Time WHEN T1.Fld7458_TYPE = CAST(x'08' AS CHAR(1) FOR BIT DATA) AND T1.Fld7458_RTRef = CAST(x'000000AF' AS CHAR(4) FOR BIT DATA) THEN T136.Date_Time ELSE CAST(NULL AS TIMESTAMP) END,TIMESTAMP('20110927235959'))
FROM (SELECT
T2.Fld7457RRef AS Fld7457RRef,
T2.Fld7458_TYPE AS Fld7458_TYPE,
T2.Fld7458_RTRef AS Fld7458_RTRef,
T2.Fld7458_RRRef AS Fld7458_RRRef,
T2.Fld7459RRef AS Fld7459RRef,
T2.Fld7460RRef AS Fld7460RRef,
T2.Fld7461RRef AS Fld7461RRef,
T2.Fld7462RRef AS Fld7462RRef,
T2.Fld7463_ AS Fld7463_,
SUM(T2.Fld7466Balance_) AS Fld7466Balance_,
SUM(T2.Fld7465Balance_) AS Fld7465Balance_
FROM (SELECT
T3.Fld7457RRef AS Fld7457RRef,
T3.Fld7458_TYPE AS Fld7458_TYPE,
T3.Fld7458_RTRef AS Fld7458_RTRef,
T3.Fld7458_RRRef AS Fld7458_RRRef,
T3.Fld7459RRef AS Fld7459RRef,
T3.Fld7460RRef AS Fld7460RRef,
T3.Fld7461RRef AS Fld7461RRef,
T3.Fld7462RRef AS Fld7462RRef,
T3.Fld7463 AS Fld7463_,
SUM(T3.Fld7466) AS Fld7466Balance_,
SUM(T3.Fld7465) AS Fld7465Balance_
FROM AccumRgT7471 T3
LEFT OUTER JOIN Document203 T4
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T4.IDRRef
LEFT OUTER JOIN Document99 T5
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T5.IDRRef
LEFT OUTER JOIN Document116 T6
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T6.IDRRef
LEFT OUTER JOIN Document206 T7
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T7.IDRRef
LEFT OUTER JOIN Document119 T8
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T8.IDRRef
LEFT OUTER JOIN Document182 T9
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T9.IDRRef
LEFT OUTER JOIN Document177 T10
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T10.IDRRef
LEFT OUTER JOIN Document185 T11
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T11.IDRRef
LEFT OUTER JOIN Document178 T12
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T12.IDRRef
LEFT OUTER JOIN Document139 T13
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T13.IDRRef
LEFT OUTER JOIN Document179 T14
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T14.IDRRef
LEFT OUTER JOIN Document140 T15
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T15.IDRRef
LEFT OUTER JOIN Document107 T16
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T16.IDRRef
LEFT OUTER JOIN Document154 T17
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T17.IDRRef
LEFT OUTER JOIN Document207 T18
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T18.IDRRef
LEFT OUTER JOIN Document156 T19
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T19.IDRRef
LEFT OUTER JOIN Document183 T20
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T20.IDRRef
LEFT OUTER JOIN Document176 T21
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T21.IDRRef
LEFT OUTER JOIN Document189 T22
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T22.IDRRef
LEFT OUTER JOIN Document108 T23
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T23.IDRRef
LEFT OUTER JOIN Document152 T24
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T24.IDRRef
LEFT OUTER JOIN Document153 T25
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T25.IDRRef
LEFT OUTER JOIN Document142 T26
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T26.IDRRef
LEFT OUTER JOIN Document175 T27
ON T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T3.Fld7458_RRRef = T27.IDRRef
WHERE T3.Period = CAST(? AS TIMESTAMP) AND ((((T3.Fld7457RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (NOT (((T3.Fld7459RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))))))) AND CASE WHEN (T3.Fld7459RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))) THEN CASE WHEN (T3.Fld7463 <> CAST(? AS TIMESTAMP)) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END WHEN (T3.Fld7459RRef IN (CAST(? AS CHAR(16) FOR BIT DATA))) THEN CASE WHEN (COALESCE(CASE WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T4.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T5.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T6.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T7.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T8.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T9.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T10.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T11.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T12.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T13.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T14.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T15.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T16.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T17.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T18.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T19.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T20.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T21.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T22.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T23.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T24.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T25.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T26.Date_Time WHEN T3.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T3.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T27.Date_Time ELSE CAST(NULL AS TIMESTAMP) END,CAST(? AS TIMESTAMP)) < CAST(? AS TIMESTAMP)) THEN CASE WHEN (T3.Fld7463 <> CAST(? AS TIMESTAMP)) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END ELSE CAST(? AS CHAR(1) FOR BIT DATA) END ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CAST(? AS CHAR(1) FOR BIT DATA)))
GROUP BY T3.Fld7457RRef,
T3.Fld7458_TYPE,
T3.Fld7458_RTRef,
T3.Fld7458_RRRef,
T3.Fld7459RRef,
T3.Fld7460RRef,
T3.Fld7461RRef,
T3.Fld7462RRef,
T3.Fld7463
HAVING (SUM(T3.Fld7466)) <> CAST(? AS NUMERIC(1, 0)) OR (SUM(T3.Fld7465)) <> CAST(? AS NUMERIC(1, 0))
UNION ALL SELECT
T28.Fld7457RRef AS Fld7457RRef,
T28.Fld7458_TYPE AS Fld7458_TYPE,
T28.Fld7458_RTRef AS Fld7458_RTRef,
T28.Fld7458_RRRef AS Fld7458_RRRef,
T28.Fld7459RRef AS Fld7459RRef,
T28.Fld7460RRef AS Fld7460RRef,
T28.Fld7461RRef AS Fld7461RRef,
T28.Fld7462RRef AS Fld7462RRef,
T28.Fld7463 AS Fld7463_,
CAST(ROUND(SUM(CASE WHEN T28.RecordKind = 0 THEN -T28.Fld7466 ELSE T28.Fld7466 END), 2) AS NUMERIC(27, 2)) AS Fld7466Balance_,
CAST(ROUND(SUM(CASE WHEN T28.RecordKind = 0 THEN -T28.Fld7465 ELSE T28.Fld7465 END), 2) AS NUMERIC(27, 2)) AS Fld7465Balance_
FROM AccumRg7456 T28
LEFT OUTER JOIN Document203 T29
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T29.IDRRef
LEFT OUTER JOIN Document99 T30
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T30.IDRRef
LEFT OUTER JOIN Document116 T31
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T31.IDRRef
LEFT OUTER JOIN Document206 T32
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T32.IDRRef
LEFT OUTER JOIN Document119 T33
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T33.IDRRef
LEFT OUTER JOIN Document182 T34
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T34.IDRRef
LEFT OUTER JOIN Document177 T35
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T35.IDRRef
LEFT OUTER JOIN Document185 T36
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T36.IDRRef
LEFT OUTER JOIN Document178 T37
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T37.IDRRef
LEFT OUTER JOIN Document139 T38
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T38.IDRRef
LEFT OUTER JOIN Document179 T39
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T39.IDRRef
LEFT OUTER JOIN Document140 T40
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T40.IDRRef
LEFT OUTER JOIN Document107 T41
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T41.IDRRef
LEFT OUTER JOIN Document154 T42
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T42.IDRRef
LEFT OUTER JOIN Document207 T43
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T43.IDRRef
LEFT OUTER JOIN Document156 T44
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T44.IDRRef
LEFT OUTER JOIN Document183 T45
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T45.IDRRef
LEFT OUTER JOIN Document176 T46
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T46.IDRRef
LEFT OUTER JOIN Document189 T47
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T47.IDRRef
LEFT OUTER JOIN Document108 T48
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T48.IDRRef
LEFT OUTER JOIN Document152 T49
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T49.IDRRef
LEFT OUTER JOIN Document153 T50
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T50.IDRRef
LEFT OUTER JOIN Document142 T51
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T51.IDRRef
LEFT OUTER JOIN Document175 T52
ON T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) AND T28.Fld7458_RRRef = T52.IDRRef
WHERE T28.Period > CAST(? AS TIMESTAMP) AND T28.Period < CAST(? AS TIMESTAMP) AND T28.Active = CAST(? AS CHAR(1) FOR BIT DATA) AND ((((T28.Fld7457RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (NOT (((T28.Fld7459RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))))))) AND CASE WHEN (T28.Fld7459RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))) THEN CASE WHEN (T28.Fld7463 <> CAST(? AS TIMESTAMP)) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END WHEN (T28.Fld7459RRef IN (CAST(? AS CHAR(16) FOR BIT DATA))) THEN CASE WHEN (COALESCE(CASE WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T29.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T30.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T31.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T32.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T33.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T34.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T35.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T36.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T37.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T38.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T39.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T40.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T41.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T42.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T43.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T44.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T45.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T46.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T47.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T48.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T49.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T50.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T51.Date_Time WHEN T28.Fld7458_TYPE = CAST(? AS CHAR(1) FOR BIT DATA) AND T28.Fld7458_RTRef = CAST(? AS CHAR(4) FOR BIT DATA) THEN T52.Date_Time ELSE CAST(NULL AS TIMESTAMP) END,CAST(? AS TIMESTAMP)) < CAST(? AS TIMESTAMP)) THEN CASE WHEN (T28.Fld7463 <> CAST(? AS TIMESTAMP)) THEN CAST(? AS CHAR(1) FOR BIT DATA) ELSE CAST(? AS CHAR(1) FOR BIT DATA) END ELSE CAST(? AS CHAR(1) FOR BIT DATA) END ELSE CAST(? AS CHAR(1) FOR BIT DATA) END = CAST(? AS CHAR(1) FOR BIT DATA)))
GROUP BY T28.Fld7457RRef,
T28.Fld7458_TYPE,
T28.Fld7458_RTRef,
T28.Fld7458_RRRef,
T28.Fld7459RRef,
T28.Fld7460RRef,
T28.Fld7461RRef,
T28.Fld7462RRef,
T28.Fld7463
HAVING (CAST(ROUND(SUM(CASE WHEN T28.RecordKind = CAST(? AS NUMERIC(1, 0)) THEN -T28.Fld7466 ELSE T28.Fld7466 END), 2) AS NUMERIC(27, 2))) <> CAST(? AS NUMERIC(1, 0)) OR (CAST(ROUND(SUM(CASE WHEN T28.RecordKind = CAST(? AS NUMERIC(1, 0)) THEN -T28.Fld7465 ELSE T28.Fld7465 END), 2) AS NUMERIC(27, 2))) <> CAST(? AS NUMERIC(1, 0))) T2
GROUP BY T2.Fld7457RRef,
T2.Fld7458_TYPE,
T2.Fld7458_RTRef,
T2.Fld7458_RRRef,
T2.Fld7459RRef,
T2.Fld7460RRef,
T2.Fld7461RRef,
T2.Fld7462RRef,
T2.Fld7463_
HAVING (SUM(T2.Fld7466Balance_)) <> CAST(? AS NUMERIC(1, 0)) OR (SUM(T2.Fld7465Balance_)) <> CAST(? AS NUMERIC(1, 0))) T1
LEFT OUTER JOIN (SELECT
T54.Fld7423_TYPE AS Fld7423_TYPE,
T54.Fld7423_RTRef AS Fld7423_RTRef,
T54.Fld7423_RRRef AS Fld7423_RRRef,
T54.Fld7424RRef AS Fld7424RRef,
T54.Fld7425RRef AS Fld7425RRef,
T54.Fld7426RRef AS Fld7426RRef,
SUM(T54.Fld7430Balance_) AS Fld7430Balance_,
SUM(T54.Fld7431Balance_) AS Fld7431Balance_
FROM (SELECT
T55.Fld7423_TYPE AS Fld7423_TYPE,
T55.Fld7423_RTRef AS Fld7423_RTRef,
T55.Fld7423_RRRef AS Fld7423_RRRef,
T55.Fld7424RRef AS Fld7424RRef,
T55.Fld7425RRef AS Fld7425RRef,
T55.Fld7426RRef AS Fld7426RRef,
SUM(T55.Fld7430) AS Fld7430Balance_,
SUM(T55.Fld7431) AS Fld7431Balance_
FROM AccumRgT7437 T55
WHERE T55.Period = CAST(? AS TIMESTAMP) AND (((((T55.Fld7421RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T55.Fld7427 = CAST(? AS CHAR(1) FOR BIT DATA))) AND (NOT (((T55.Fld7424RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))))))) AND (T55.Fld7429 = CAST(? AS CHAR(1) FOR BIT DATA))))
GROUP BY T55.Fld7423_TYPE,
T55.Fld7423_RTRef,
T55.Fld7423_RRRef,
T55.Fld7424RRef,
T55.Fld7425RRef,
T55.Fld7426RRef
HAVING (SUM(T55.Fld7430)) <> CAST(? AS NUMERIC(1, 0)) OR (SUM(T55.Fld7431)) <> CAST(? AS NUMERIC(1, 0))
UNION ALL SELECT
T56.Fld7423_TYPE AS Fld7423_TYPE,
T56.Fld7423_RTRef AS Fld7423_RTRef,
T56.Fld7423_RRRef AS Fld7423_RRRef,
T56.Fld7424RRef AS Fld7424RRef,
T56.Fld7425RRef AS Fld7425RRef,
T56.Fld7426RRef AS Fld7426RRef,
CAST(ROUND(SUM(CASE WHEN T56.RecordKind = 0 THEN -T56.Fld7430 ELSE T56.Fld7430 END), 2) AS NUMERIC(27, 2)) AS Fld7430Balance_,
CAST(ROUND(SUM(CASE WHEN T56.RecordKind = 0 THEN -T56.Fld7431 ELSE T56.Fld7431 END), 2) AS NUMERIC(27, 2)) AS Fld7431Balance_
FROM AccumRg7420 T56
WHERE T56.Period > CAST(? AS TIMESTAMP) AND T56.Period < CAST(? AS TIMESTAMP) AND T56.Active = CAST(? AS CHAR(1) FOR BIT DATA) AND (((((T56.Fld7421RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (T56.Fld7427 = CAST(? AS CHAR(1) FOR BIT DATA))) AND (NOT (((T56.Fld7424RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))))))) AND (T56.Fld7429 = CAST(? AS CHAR(1) FOR BIT DATA))))
GROUP BY T56.Fld7423_TYPE,
T56.Fld7423_RTRef,
T56.Fld7423_RRRef,
T56.Fld7424RRef,
T56.Fld7425RRef,
T56.Fld7426RRef
HAVING (CAST(ROUND(SUM(CASE WHEN T56.RecordKind = CAST(? AS NUMERIC(1, 0)) THEN -T56.Fld7430 ELSE T56.Fld7430 END), 2) AS NUMERIC(27, 2))) <> CAST(? AS NUMERIC(1, 0)) OR (CAST(ROUND(SUM(CASE WHEN T56.RecordKind = CAST(? AS NUMERIC(1, 0)) THEN -T56.Fld7431 ELSE T56.Fld7431 END), 2) AS NUMERIC(27, 2))) <> CAST(? AS NUMERIC(1, 0))) T54
GROUP BY T54.Fld7423_TYPE,
T54.Fld7423_RTRef,
T54.Fld7423_RRRef,
T54.Fld7424RRef,
T54.Fld7425RRef,
T54.Fld7426RRef
HAVING (SUM(T54.Fld7430Balance_)) <> CAST(? AS NUMERIC(1, 0)) OR (SUM(T54.Fld7431Balance_)) <> CAST(? AS NUMERIC(1, 0))) T53
ON (((((T1.Fld7458_TYPE = T53.Fld7423_TYPE AND T1.Fld7458_RTRef = T53.Fld7423_RTRef AND T1.Fld7458_RRRef = T53.Fld7423_RRRef) AND (T1.Fld7459RRef = T53.Fld7424RRef)) AND (T1.Fld7460RRef = T53.Fld7425RRef)) AND (T1.Fld7461RRef = T53.Fld7426RRef)) AND ((T53.Fld7430Balance_ + T53.Fld7431Balance_) > CAST(? AS NUMERIC(1, 0))))
LEFT OUTER JOIN (SELECT
T58.Fld7475_TYPE AS Fld7475_TYPE,
T58.Fld7475_RTRef AS Fld7475_RTRef,
T58.Fld7475_RRRef AS Fld7475_RRRef,
T58.Fld7478RRef AS Fld7478RRef,
T58.Fld7479RRef AS Fld7479RRef,
T58.Fld7480RRef AS Fld7480RRef,
SUM(T58.Fld7482Balance_) AS Fld7482Balance_,
SUM(T58.Fld7481Balance_) AS Fld7481Balance_
FROM (SELECT
T59.Fld7475_TYPE AS Fld7475_TYPE,
T59.Fld7475_RTRef AS Fld7475_RTRef,
T59.Fld7475_RRRef AS Fld7475_RRRef,
T59.Fld7478RRef AS Fld7478RRef,
T59.Fld7479RRef AS Fld7479RRef,
T59.Fld7480RRef AS Fld7480RRef,
SUM(T59.Fld7482) AS Fld7482Balance_,
SUM(T59.Fld7481) AS Fld7481Balance_
FROM AccumRgT7488 T59
WHERE T59.Period = CAST(? AS TIMESTAMP) AND (((T59.Fld7474RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (NOT (((T59.Fld7478RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))))))))
GROUP BY T59.Fld7475_TYPE,
T59.Fld7475_RTRef,
T59.Fld7475_RRRef,
T59.Fld7478RRef,
T59.Fld7479RRef,
T59.Fld7480RRef
HAVING (SUM(T59.Fld7482)) <> CAST(? AS NUMERIC(1, 0)) OR (SUM(T59.Fld7481)) <> CAST(? AS NUMERIC(1, 0))
UNION ALL SELECT
T60.Fld7475_TYPE AS Fld7475_TYPE,
T60.Fld7475_RTRef AS Fld7475_RTRef,
T60.Fld7475_RRRef AS Fld7475_RRRef,
T60.Fld7478RRef AS Fld7478RRef,
T60.Fld7479RRef AS Fld7479RRef,
T60.Fld7480RRef AS Fld7480RRef,
CAST(ROUND(SUM(CASE WHEN T60.RecordKind = 0 THEN -T60.Fld7482 ELSE T60.Fld7482 END), 2) AS NUMERIC(27, 2)) AS Fld7482Balance_,
CAST(ROUND(SUM(CASE WHEN T60.RecordKind = 0 THEN -T60.Fld7481 ELSE T60.Fld7481 END), 2) AS NUMERIC(27, 2)) AS Fld7481Balance_
FROM AccumRg7473 T60
WHERE T60.Period > CAST(? AS TIMESTAMP) AND T60.Period < CAST(? AS TIMESTAMP) AND T60.Active = CAST(? AS CHAR(1) FOR BIT DATA) AND (((T60.Fld7474RRef = CAST(? AS CHAR(16) FOR BIT DATA)) AND (NOT (((T60.Fld7478RRef IN (CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA), CAST(? AS CHAR(16) FOR BIT DATA))))))))
GROUP BY T60.Fld7475_TYPE,
T60.Fld7475_RTRef,
T60.Fld7475_RRRef,
T60.Fld7478RRef,
T60.Fld7479RRef,
T60.Fld7480RRef
HAVING (CAST(ROUND(SUM(CASE WHEN T60.RecordKind = CAST(? AS NUMERIC(1, 0)) THEN -T60.Fld7482 ELSE T60.Fld7482 END), 2) AS NUMERIC(27, 2))) <> CAST(? AS NUMERIC(1, 0)) OR (CAST(ROUND(SUM(CASE WHEN T60.RecordKind = CAST(? AS NUMERIC(1, 0)) THEN -T60.Fld7481 ELSE T60.Fld7481 END), 2) AS NUMERIC(27, 2))) <> CAST(? AS NUMERIC(1, 0))) T58
GROUP BY T58.Fld7475_TYPE,
T58.Fld7475_RTRef,
T58.Fld7475_RRRef,
T58.Fld7478RRef,
T58.Fld7479RRef,
T58.Fld7480RRef
HAVING (SUM(T58.Fld7482Balance_)) <> CAST(? AS NUMERIC(1, 0)) OR (SUM(T58.Fld7481Balance_)) <> CAST(? AS NUMERIC(1, 0))) T57
ON (((((T1.Fld7458_TYPE = T57.Fld7475_TYPE AND T1.Fld7458_RTRef = T57.Fld7475_RTRef AND T1.Fld7458_RRRef = T57.Fld7475_RRRef) AND (T1.Fld7459R
11 Amiralnar
 
27.09.11
16:33
Миста съела пол сообщения.

Повторю: оригинальный запрос:

       "ВЫБРАТЬ
       |    НДСПредъявленныйОстатки.Организация,
       |    НДСПредъявленныйОстатки.СчетФактура КАК СчетФактура,
       |    НДСПредъявленныйОстатки.ВидЦенности,
       |    НДСПредъявленныйОстатки.СтавкаНДС,
       |    НДСПредъявленныйОстатки.СчетУчетаНДС,
       |    НДСПредъявленныйОстатки.Поставщик,
       |    НДСПредъявленныйОстатки.ДатаОплаты,
       |    ВЫБОР
       |        КОГДА ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.СуммаБезНДСОстаток), 0) = 0
       |            ТОГДА 0
       |        ИНАЧЕ (ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.СуммаБезНДСОстаток), 0) - ЕСТЬNULL(НДСпоОСиНМАОстатки.СуммаБезНДСОстаток, 0) - ЕСТЬNULL(НДСПредъявленныйРеализация0Остатки.СуммаБезНДСОстаток, 0)) * ЕСТЬNULL(НДСПредъявленныйОстатки.СуммаБезНДСОстаток, 0) / ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.СуммаБезНДСОстаток), 0)
       |    КОНЕЦ КАК СуммаБезНДС,
       |    ВЫБОР
       |        КОГДА ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.НДСОстаток), 0) = 0
       |            ТОГДА 0
       |        ИНАЧЕ (ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.НДСОстаток), 0) - ЕСТЬNULL(НДСПредъявленныйРеализация0Остатки.НДСОстаток, 0) - ЕСТЬNULL(НДСпоОСиНМАОстатки.НДСОстаток, 0)) * ЕСТЬNULL(НДСПредъявленныйОстатки.НДСОстаток, 0) / ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.НДСОстаток), 0)
       |    КОНЕЦ КАК НДС,
       |    ЕСТЬNULL(НДСПредъявленныйОстатки.СчетФактура.Дата, &Дата) КАК СчетФактураДата
       |ИЗ
       |    РегистрНакопления.НДСПредъявленный.Остатки(
       |            &ДатаГраница,
       |            Организация = &Организация
       |                И (НЕ ВидЦенности В (&ИсключаемыеВидыЦенностей))
       |                И ВЫБОР
       |                    КОГДА ВидЦенности В (&ВидыЦенностейОплата)
       |                        ТОГДА ДатаОплаты <> ДАТАВРЕМЯ(1, 1, 1)
       |                    КОГДА ВидЦенности В (&ВидыЦенностей_ОплатаПоНДССМР)
       |                        ТОГДА ВЫБОР
       |                                КОГДА ЕСТЬNULL(СчетФактура.Дата, &Дата) < ДАТАВРЕМЯ(2009, 1, 1)
       |                                    ТОГДА ДатаОплаты <> ДАТАВРЕМЯ(1, 1, 1)
       |                                ИНАЧЕ ИСТИНА
       |                            КОНЕЦ
       |                    ИНАЧЕ ИСТИНА
       |                КОНЕЦ) КАК НДСПредъявленныйОстатки
       |        ЛЕВОЕ СОЕДИНЕНИЕ РегистрНакопления.НДСпоОСиНМА.Остатки(
       |                &ДатаГраница,
       |                Организация = &Организация
       |                    И НДСВключенВСтоимость = ЛОЖЬ
       |                    И (НЕ ВидЦенности В (&ИсключаемыеВидыЦенностей))
       |                    И НеВлияетНаВычет = ЛОЖЬ) КАК НДСпоОСиНМАОстатки
       |        ПО НДСПредъявленныйОстатки.СчетФактура = НДСпоОСиНМАОстатки.СчетФактура
       |            И НДСПредъявленныйОстатки.ВидЦенности = НДСпоОСиНМАОстатки.ВидЦенности
       |            И НДСПредъявленныйОстатки.СтавкаНДС = НДСпоОСиНМАОстатки.СтавкаНДС
       |            И НДСПредъявленныйОстатки.СчетУчетаНДС = НДСпоОСиНМАОстатки.СчетУчетаНДС
       |            И (НДСпоОСиНМАОстатки.СуммаБезНДСОстаток + НДСпоОСиНМАОстатки.НДСОстаток > 0)
       |        ЛЕВОЕ СОЕДИНЕНИЕ РегистрНакопления.НДСПредъявленныйРеализация0.Остатки(
       |                &ДатаГраница,
       |                Организация = &Организация
       |                    И (НЕ ВидЦенности В (&ИсключаемыеВидыЦенностей))) КАК НДСПредъявленныйРеализация0Остатки
       |        ПО НДСПредъявленныйОстатки.СчетФактура = НДСПредъявленныйРеализация0Остатки.СчетФактура
       |            И НДСПредъявленныйОстатки.ВидЦенности = НДСПредъявленныйРеализация0Остатки.ВидЦенности
       |            И НДСПредъявленныйОстатки.СтавкаНДС = НДСПредъявленныйРеализация0Остатки.СтавкаНДС
       |            И НДСПредъявленныйОстатки.СчетУчетаНДС = НДСПредъявленныйРеализация0Остатки.СчетУчетаНДС
       |            И (НДСПредъявленныйРеализация0Остатки.СуммаБезНДСОстаток + НДСПредъявленныйРеализация0Остатки.НДСОстаток > 0)
       |        ЛЕВОЕ СОЕДИНЕНИЕ РегистрНакопления.НДСПредъявленный.Остатки(
       |                &ДатаГраница,
       |                Организация = &Организация
       |                    И (НЕ ВидЦенности В (&ИсключаемыеВидыЦенностей))
       |                    И ВЫБОР
       |                        КОГДА ВидЦенности В (&ВидыЦенностейОплата)
       |                            ТОГДА ДатаОплаты <> ДАТАВРЕМЯ(1, 1, 1)
       |                        КОГДА ВидЦенности В (&ВидыЦенностей_ОплатаПоНДССМР)
       |                            ТОГДА ВЫБОР
       |                                    КОГДА ЕСТЬNULL(СчетФактура.Дата, &Дата) < ДАТАВРЕМЯ(2009, 1, 1)
       |                                        ТОГДА ДатаОплаты <> ДАТАВРЕМЯ(1, 1, 1)
       |                                    ИНАЧЕ ИСТИНА
       |                                КОНЕЦ
       |                        ИНАЧЕ ИСТИНА
       |                    КОНЕЦ) КАК НДСПредъявленныйОстаткиИтог
       |        ПО НДСПредъявленныйОстатки.СчетФактура = НДСПредъявленныйОстаткиИтог.СчетФактура
       |            И НДСПредъявленныйОстатки.ВидЦенности = НДСПредъявленныйОстаткиИтог.ВидЦенности
       |            И НДСПредъявленныйОстатки.СтавкаНДС = НДСПредъявленныйОстаткиИтог.СтавкаНДС
       |            И НДСПредъявленныйОстатки.СчетУчетаНДС = НДСПредъявленныйОстаткиИтог.СчетУчетаНДС
       |            И НДСПредъявленныйОстатки.Организация = НДСПредъявленныйОстаткиИтог.Организация
       |            И НДСПредъявленныйОстатки.Поставщик = НДСПредъявленныйОстаткиИтог.Поставщик
       |ГДЕ
       |    (НДСПредъявленныйОстатки.СуммаБезНДСОстаток > 0
       |            ИЛИ НДСПредъявленныйОстатки.НДСОстаток > 0)
       |
       |СГРУППИРОВАТЬ ПО
       |    НДСПредъявленныйОстатки.Организация,
       |    НДСПредъявленныйОстатки.СчетФактура,
       |    НДСПредъявленныйОстатки.ВидЦенности,
       |    НДСПредъявленныйОстатки.СтавкаНДС,
       |    НДСПредъявленныйОстатки.СчетУчетаНДС,
       |    НДСПредъявленныйОстатки.Поставщик,
       |    ЕСТЬNULL(НДСПредъявленныйОстатки.СчетФактура.Дата, &Дата),
       |    НДСПредъявленныйОстатки.ДатаОплаты,
       |    НДСпоОСиНМАОстатки.СуммаБезНДСОстаток,
       |    НДСПредъявленныйРеализация0Остатки.СуммаБезНДСОстаток,
       |    НДСПредъявленныйОстатки.СуммаБезНДСОстаток,
       |    НДСПредъявленныйРеализация0Остатки.НДСОстаток,
       |    НДСпоОСиНМАОстатки.НДСОстаток,
       |    НДСПредъявленныйОстатки.НДСОстаток
       |
       |ИМЕЮЩИЕ
       |    СУММА(ЕСТЬNULL(НДСПредъявленныйОстатки.СуммаБезНДСОстаток, 0) - ЕСТЬNULL(НДСпоОСиНМАОстатки.СуммаБезНДСОстаток, 0) - ЕСТЬNULL(НДСПредъявленныйРеализация0Остатки.СуммаБезНДСОстаток, 0) + ЕСТЬNULL(НДСПредъявленныйОстатки.НДСОстаток, 0) - ЕСТЬNULL(НДСПредъявленныйРеализация0Остатки.НДСОстаток, 0) - ЕСТЬNULL(НДСпоОСиНМАОстатки.НДСОстаток, 0)) > 0
       |
       |УПОРЯДОЧИТЬ ПО
       |    СчетФактураДата";


(9) Не ясно следующее: в каком поле нужно увеличить разрядность?
Может проблема в полях запроса "СуммаБезНДС" и "НДС"? Проверю ка я значения исходных данных и этапы вычисления...
12 Amiralnar
 
27.09.11
16:48
Формирование записей книги покупок на сумму НДС в 14 миллионов - это же нормально? Почему-то 29 числа заполняет, а 30 - уже ошибка. Посмотрел поступления - за 30-е число есть фактура на 7,5 миллионов. Отменил проведение - все равно ошибка.
Блин, что дальше делать?
13 Живой Ископаемый
 
27.09.11
16:55
Максимальная длина числовых данных – 31 знак (а не 38);
Максимальная длина ресурсов регистров накопления и бухгалтерии – 25 знаков (а не 32);

http://gilev.ru/1c/81/db2/
14 Живой Ископаемый
 
27.09.11
16:56
то есть не увеличить тут разрядность...
15 Живой Ископаемый
 
27.09.11
16:57
И не испольузй 9.7.2; используй или 9.7.1 с сайта 1С или 9.7.4 с сайта АйБиМ
16 hohol
 
27.09.11
16:59
жлобы наставят параши, типо постгре или дб там всякого халявного, нет чтобы просто ск..ть.

у тебя там деление на ноль в запросе.
17 hohol
 
27.09.11
17:00
только у меня такие глюки в форуме?
18 shuhard
 
27.09.11
17:03
(12)[Блин, что дальше делать?]
сформировать книгу в файловой/MS SQL версии и загрузить её в DB2?

сделать пустую базу и проверить что будет с суммой в миллиард, если упадёт, то предложить руководству сменить СУБД
19 Живой Ископаемый
 
27.09.11
17:03
2(10) Это с ТЖ?
2(17) это не глюки, это правильное отображение сообщения (10)
20 Amiralnar
 
27.09.11
17:10
(16) И не говори. Еще и УТ вместо УПП для целей УУ внедряем. Нет слов.
21 pavlika
 
27.09.11
17:14
(20) Если тебе лень спросить на форуме db2 и не лень апать тут, то возникает подозрение, что это и не проблема которую нужно решить.
22 Живой Ископаемый
 
27.09.11
17:17
2(21) на том форуме попросят прикрепить db2diag... Это можем и мы сделать. :)
23 Amiralnar
 
27.09.11
17:24
(16) К стати, там не может быть деления на 0. Ибо ВЫБОР КОГДА 0 ТОГДА 0 ИНАЧЕ делить не на 0.
24 Amiralnar
 
27.09.11
17:24
(22) Какой диаг? Как его запустить?
25 Amiralnar
 
27.09.11
17:26
(21) Я завтра уже наверное его разверну в файл, и посмотрю. Чую чем-то задним - это дело не в ДБ2...
26 Живой Ископаемый
 
27.09.11
17:36
2(24) это файл. посмотри последние записи перед валением запроса
27 Amiralnar
 
27.09.11
17:43
итак, опытным путем,  проблема в:


ВЫБОР
       |        КОГДА ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.СуммаБезНДСОстаток), 0) = 0
       |            ТОГДА 0
       |        ИНАЧЕ (ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.СуммаБезНДСОстаток), 0) - ЕСТЬNULL(НДСпоОСиНМАОстатки.СуммаБезНДСОстаток, 0) - ЕСТЬNULL(НДСПредъявленныйРеализация0Остатки.СуммаБезНДСОстаток, 0)) * ЕСТЬNULL(НДСПредъявленныйОстатки.СуммаБезНДСОстаток, 0) / ЕСТЬNULL(СУММА(НДСПредъявленныйОстаткиИтог.СуммаБезНДСОстаток), 0)
       |    КОНЕЦ КАК СуммаБезНДС
28 Amiralnar
 
27.09.11
17:45
Тоесть, А * Б / С = ошибка переполнения.

При этом, если сделать Б / С * А - то выполняется без ошибок.
29 shuhard
 
27.09.11
17:48
(27) вот и (сказочке) DB2  конец
30 Живой Ископаемый
 
27.09.11
17:49
клево, молодец.
31 shuhard
 
27.09.11
17:50
(28) ну а теперь бегом к профессионалам
http://www.sql.ru/forum/actualtopics.aspx?bid=5

только запрос нужен в том виде, в каком он СУБД выполняется
2 + 2 = 3.9999999999999999999999999999999...