Unicontsoft

[Momchil]

Здравейте,
При създаване или редакция на продукт, след въвеждане или промяна на съставен материал, програмата дава - The column 'GrpName' in table 'dbo.v_nom_ItemsParts' cannot be null - грешка. Пробвах да върна стара версия, но не стана.

Моля за помощ:

Това е пълния текст на грешката:

The column 'GrpName' in table 'dbo.v_nom_ItemsParts' cannot be null.

Call stack:
[DESKTOP-8674NMO] DreemNom15.frmItemsDetails({B30159BA-65B6-4B4D-9FAC-862130028CE4}@Dreem15_Personal, m_sID=, 1892).m_oForm_Save(4775)
[DESKTOP-8674NMO] DreemContainer15.cHost(cHost, 22).RemoteExec(1807)
[DESKTOP-8674NMO] DreemContainer15.cTransProxy(frmItemsDetails@2024.07.29 10:25:09.681, 5719).BeginExec(1158)
[DESKTOP-8674NMO] DreemTrans15.cAdm_Nomenclatures.UpdNomItemsDetails(2804)
[DESKTOP-8674NMO] DreemTrans15.UpdateWithTempTableHelper(RealBaseTable=nom_ItemsParts, TargetTable=v_nom_ItemsParts, cUpdateFields=Collection({"Itm_ID":"Itm_ID","PartItm_ID":"PartItm_ID","Quantity":"Quantity","Measure_ID":"Measure_ID","SeqNo":"SeqNo","LU":"LU","LD":"LD"}), sSql=DELETE [dbo].[v_nom_ItemsParts]
WHERE EXISTS (SELECT *
FROM [#Tmp_v_nom_ItemsParts] t
WHERE t.[ID] = [v_nom_ItemsParts].[ID]
AND (t.[__RowStatus] & 4) <> 0)

UPDATE [dbo].[v_nom_ItemsParts]
SET [Itm_ID] = (SELECT t.[Itm_ID] FROM [#Tmp_v_nom_ItemsParts] t WHERE t.[ID] = [v_nom_ItemsParts].[ID] AND (t.[__RowStatus] & 3) <> 0)
, [PartItm_ID] = (SELECT t.[PartItm_ID] FROM [#Tmp_v_nom_ItemsParts] t WHERE t.[ID] = [v_nom_ItemsParts].[ID] AND (t.[__RowStatus] & 3) <> 0)
, [Quantity] = (SELECT t.[Quantity] FROM [#Tmp_v_nom_ItemsParts] t WHERE t.[ID] = [v_nom_ItemsParts].[ID] AND (t.[__RowStatus] & 3) <> 0)
, [Measure_ID] = (SELECT t.[Measure_ID] FROM [#Tmp_v_nom_ItemsParts] t WHERE t.[ID] = [v_nom_ItemsParts].[ID] AND (t.[__RowStatus] & 3) <> 0)
, [SeqNo] = (SELECT t.[SeqNo] FROM [#Tmp_v_nom_ItemsParts] t WHERE t.[ID] = [v_nom_ItemsParts].[ID] AND (t.[__RowStatus] & 3) <> 0)
, [LU] = (SELECT t.[LU] FROM [#Tmp_v_nom_ItemsParts] t WHERE t.[ID] = [v_nom_ItemsParts].[ID] AND (t.[__RowStatus] & 3) <> 0)
, [LD] = (SELECT t.[LD] FROM [#Tmp_v_nom_ItemsParts] t WHERE t.[ID] = [v_nom_ItemsParts].[ID] AND (t.[__RowStatus] & 3) <> 0)
WHERE EXISTS (SELECT *
FROM [#Tmp_v_nom_ItemsParts] t
WHERE t.[ID] = [v_nom_ItemsParts].[ID]
AND t.[__IsPresent] = 1
AND (t.[__RowStatus] & 3) <> 0)

INSERT [dbo].[v_nom_ItemsParts]([ID]
, [Itm_ID]
, [PartItm_ID]
, [Quantity]
, [Measure_ID]
, [SeqNo]
, [CU]
, [CD]
, [LU]
, [LD])
SELECT [ID]
, [Itm_ID]
, [PartItm_ID]
, [Quantity]
, [Measure_ID]
, [SeqNo]
, [CU]
, [CD]
, [LU]
, [LD]
FROM [#Tmp_v_nom_ItemsParts] t
WHERE t.[__IsPresent] = 0
AND (t.[__RowStatus] & 3) <> 0
, sInsertSql=).mdDAL(3133)
[DESKTOP-8674NMO] DreemTrans15.mdDAL.pvHandleDalError((local)\UCS / Dreem15_Personal)
__RowStatus,__SeqNo,__IsPresent,__RowStatus,ID,Itm_ID,PartItm_ID,Quantity,Measure_ID,SeqNo,CU,CD,LU,LD
0,1,0,1,'{79BD7FBF-67D9-4CFE-BF74-BBAF173D38C5}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{45899286-D152-47A0-BB40-E4DE1D6D489B}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',2,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,2,0,1,'{DC1B10B7-2415-4621-BAA3-A5EA90BD73D2}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{D0FA972E-AD83-4B25-9334-E53A45531E0D}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',4,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,3,0,1,'{55E50B12-49D3-4CD9-B526-461256BA6647}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{99BB7C26-D9BD-45D0-BACC-2C3192812D7E}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',6,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,4,0,1,'{45B339B1-A981-4597-9CA1-C9EC4BBDD252}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{C8885060-ADDB-4EB6-8786-5F8116E105A2}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',7,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,5,0,1,'{F9A5A9D6-F41C-4A54-A6E6-60BE9BF72A43}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{926A8ECC-2DDB-4706-BE6C-D78ECA34BE42}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',5,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,6,0,1,'{F3BE9BD2-A099-44C2-A8FF-DD77BBECD153}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{BB82038C-5013-4D4B-8D3B-A25044BDD956}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',3,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,7,0,1,'{8E48C554-C4C6-4581-871D-B616C9DB120E}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{5EA235E9-9619-49A4-80D5-69860E5C8750}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',1,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,8,0,1,'{BBC17CF3-FE18-4FB6-B9E1-46BFD8B818D9}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{D1823298-CD27-4042-9648-B6AFE33E0B92}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',8,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,9,0,1,'{BBCD4AD3-CE32-42C3-8A27-95E1765C8618}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{1E3B9E02-0C70-4FFE-9106-BA97A4FA90BD}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',9,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,10,0,1,'{BFFCD730-35D8-494F-B8CF-DE9F9F9F5C97}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{2F0674A9-BF96-4668-B9CC-4DB04395BD81}',1.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',13,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,11,0,1,'{24C05E10-8CC9-42AA-B55F-18FA3189AD93}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{4F4D0C77-9FE9-4F7E-9525-471ADFFD763C}',2.0,'{1F9C7DB5-2CEF-46E5-88C0-50504C663024}',11,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,12,0,1,'{D94244B6-E4CF-4250-9762-FBD6A762D00C}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{75549283-0B78-471E-BE3A-AB2A02D3D7CD}',3.0,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',14,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,13,0,1,'{BE9C78CA-779A-4164-A013-8A1B5EDAD3A3}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{6B270DEC-1C92-481E-B0C0-7465D4D1D3D7}',2.7,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',16,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,14,0,1,'{EAFFDEE9-02C6-45AB-824A-D2A959452C9F}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{7CD8C5E8-FC21-4221-808B-6BD7044F7CD7}',2.5,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',15,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,15,0,1,'{A37AD603-6DB0-4AD9-B0F0-8FC4BA596A3A}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{919824FD-0C81-423D-8BD1-3FE0B1CF9620}',1.95,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',12,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,16,0,1,'{B4E71B38-F491-4D75-A54C-6999AB5CDA1E}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{BFF1D5B7-8000-429F-9F3D-D5AD66529E63}',1.8,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',10,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,17,0,1,'{2E15DB19-3F90-4393-A15E-3354D8631223}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{A26A49B9-70E0-4BA7-8DF9-BB1EDE28B38D}',0.1,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',17,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,18,0,1,'{D642E837-38C6-4987-A550-79440A02BDDB}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{22E69347-0440-4CEC-A447-DD8C8CA5C564}',0.45,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',18,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'
0,19,0,1,'{D0CA7714-8675-4E52-9CD8-9DE2ED701851}','{65CF5BB5-59C3-494A-A6B8-69A31D1976A0}','{0EB59F91-0D72-4F3C-9990-7F894D7D516F}',1.35,'{AA9BCCBC-20CD-446D-8A0E-E7C889DD498A}',19,'Dreem','20240729 10:24:15','Dreem','20240729 10:24:15'

&H80040E2F

[wqw]

Пробвайте да инсталирате последната реализация. Ако не се оправя с последната реализация пробвайте от меню Файл->Нова регистрация... (Alt+F2) след като натиснете бутона с трите точки да изберете опция Прилагане на текуща версия на база данни във формата за поддръжка на системни бази данни.



cheers,
</wqw>

[Momchil]

Направих го! Няма промяна! Продължава да дава същата грешка

[wqw]

[Momchil]

Проблема се появи след ъпгрейд в средата на юни (нямам идея, коя е била последната версия тогава) и след това пробвам с всяка нова версия, но резултата е един и същ - упорито си пише нулата. Дори при създаване на изцяло нов продукт, пак дава същата грешка

[wqw]

[Momchil]

Да. С последната версия съм - 2024.7.2

[wqw]

Да, това е проблем, който е отстранен в последната реализация 2024.7.29 от днес.

cheers,
</wqw>

[Momchil]

Mnogo Благодаря.