--------------------------------------------------------
2025.05.06 (вторник) 11:42:14 1.56.0.0 sp0 Sm.Main
----- Прерывание работы программы -----
сообщение: "ORA-00979: выражение не является выражением GROUP BY"
исключение: Sm.Core.InteropException
hResult: 80040E14h; доп. код: 979
источник: OraOLEDB
----- Причина исключения, уровень вложения 1 -----
сообщение: "SELECT /*+ FIRST_ROWS*/
SP.SpecItem,SP.DisplayItem,SP.Article,CRD.Name,SP.Quantity,CRD.IDMeasurement,SP.QuantByDoc,SP.ItemPriceNoTax,SP.TotalPriceNoTax,(select SPVAT.TaxRate from SuperMag.SVSpecVatRateWI SPVAT where SPVAT.DocType=SP.DocType AND SPVAT.DocID=SP.DocID AND SPVAT.SpecItem = SP.SpecItem),(select SPVAT.TaxSum from SuperMag.SVSpecVatWI SPVAT where SPVAT.DocType = SP.DocType AND SPVAT.DocID = SP.DocID AND SPVAT.SpecItem = SP.SpecItem),SP.ItemPrice,SP.TotalPrice,SP.ItemPriceCur,SP.TotalPriceCur,SuperMag.ReadTaxesTblWI(SP.DocID, SP.SpecItem) as TaxesTbl,SP.UseVatBase,SP.ComplexArt,SP.ComplexQuantity,NULL as ComplexCompQuant,SP.CauseType||chr(9)||SP.CauseID||chr(9)||(select SC.DisplayItem from Supermag.SVSpecCauses SC where SC.DocType=SP.CauseType and SC.DocID=SP.CauseID and SC.SpecItem=SP.CauseSpecItem) as Cause,SP.ProducerID||' '||SP.Article,(select ManufacturersPrice from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as ManufacturersPrice,(select ExtraCharge from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as ExtraCharge,(select RetailPrice from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as RetailPrice,(select DeliverySum from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as DeliverySum,(select StateRegulation from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as StateRegulation,CRD.DataType FROM SuperMag.SVSpecWI SP, SuperMag.SVCardName CRD WHERE SP.DocType = 'WI' AND SP.DocID = 'ПН01015156' AND CRD.Article = SP.Article ORDER BY DisplayItem"
исключение: Sm.Core.InteropException
hResult: 80004005h; доп. код: 0
источник: SmLibaryBase trace
--------------------------------------------------------
2025.05.06 (вторник) 11:42:17 1.56.0.0 sp0 Sm.Main
----- Прерывание работы программы -----
сообщение: "Ошибка чтения спецификации документа"
исключение: Sm.Core.InteropException
hResult: 80004005h; доп. код: 0
источник: Накладные
----- Причина исключения, уровень вложения 1 -----
сообщение: "ORA-00979: выражение не является выражением GROUP BY"
исключение: Sm.Core.InteropException
hResult: 80040E14h; доп. код: 979
источник: OraOLEDB
----- Причина исключения, уровень вложения 2 -----
сообщение: "SELECT /*+ FIRST_ROWS*/
SP.SpecItem,SP.DisplayItem,SP.Article,CRD.Name,SP.Quantity,CRD.IDMeasurement,SP.QuantByDoc,SP.ItemPriceNoTax,SP.TotalPriceNoTax,(select SPVAT.TaxRate from SuperMag.SVSpecVatRateWI SPVAT where SPVAT.DocType=SP.DocType AND SPVAT.DocID=SP.DocID AND SPVAT.SpecItem = SP.SpecItem),(select SPVAT.TaxSum from SuperMag.SVSpecVatWI SPVAT where SPVAT.DocType = SP.DocType AND SPVAT.DocID = SP.DocID AND SPVAT.SpecItem = SP.SpecItem),SP.ItemPrice,SP.TotalPrice,SP.ItemPriceCur,SP.TotalPriceCur,SuperMag.ReadTaxesTblWI(SP.DocID, SP.SpecItem) as TaxesTbl,SP.UseVatBase,SP.ComplexArt,SP.ComplexQuantity,NULL as ComplexCompQuant,SP.CauseType||chr(9)||SP.CauseID||chr(9)||(select SC.DisplayItem from Supermag.SVSpecCauses SC where SC.DocType=SP.CauseType and SC.DocID=SP.CauseID and SC.SpecItem=SP.CauseSpecItem) as Cause,SP.ProducerID||' '||SP.Article,(select ManufacturersPrice from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as ManufacturersPrice,(select ExtraCharge from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as ExtraCharge,(select RetailPrice from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as RetailPrice,(select DeliverySum from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as DeliverySum,(select StateRegulation from Supermag.SVSpecBYWI B where B.DocType=SP.DocType and B.DocID = SP.DocID and B.SpecItem = SP.SpecItem) as StateRegulation,CRD.DataType FROM SuperMag.SVSpecWI SP, SuperMag.SVCardName CRD WHERE SP.DocType = 'WI' AND SP.DocID = 'ПН01015156' AND CRD.Article = SP.Article ORDER BY DisplayItem"
исключение: Sm.Core.InteropException
hResult: 80004005h; доп. код: 0
источник: SmLibaryBase trace
--------------------------------------------------------
Не исключено, что клиент столкнулся с багом Oracle:
https://www.cnblogs.com/killkill/archive/2010/08/02/1790381.html
https://murcode.ru/forum/3-oracle/699306-ora-00979-posle-perekhoda-na-x64/
https://community.oracle.com/mosc/discussion/2661485/complex-view-merging-in-10-2-0-4
Утверждают, что если установить скрытый параметр Oracle _complex_view_merging в false, то ошибка исчезает. Возможно, ошибка исправлена в 10.2.0.5, но мне не удалось в списке исправленных багов найти её.