达梦数据库DmException: 变量空间溢出 [sql]: INSERT INTO,Microsoft.EntityFrameworkCore.DbUpdateException|C/S开发框架
![达梦数据库DmException: 变量空间溢出 [sql]: INSERT INTO,Microsoft.EntityFrameworkCore.DbUpdateException|C/S开发框架](/upload/image_spider/1/202411070008542354913.jpg)
达梦数据库DmException: 变量空间溢出 [sql]: INSERT INTO,Microsoft.EntityFrameworkCore.DbUpdateException
错误内容
![达梦数据库DmException: 变量空间溢出 [sql]: INSERT INTO,Microsoft.EntityFrameworkCore.DbUpdateException|C/S开发框架](/upload/image_spider/1/202411142254547823049.jpg)
Microsoft.EntityFrameworkCore.DbUpdateException:“An error occurred while saving the entity changes. See the inner exception for details.”
DmException: 变量空间溢出 [sql]: {
INSERT INTO "CSFrameworkV6_Normal"."_Demo_Customer" ("isid", "Address1", "Address2", "Address3", "Bank", "BankAccount", "BankAddress", "City", "CityCode", "ContactPerson", "Country", "CountryCode", "CreatedBy", "CreationDate", "CustomerCode", "Email", "EnglishName", "Fax", "InUse", "LastUpdateDate", "LastUpdatedBy", "NativeName", "PaymentTerm", "PostalCode", "Region", "Remark", "Tel", "WebAddress", "ZipCode")
VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15, :p16, :p17, :p18, :p19, :p20, :p21, :p22, :p23, :p24, :p25, :p26, :p27, :p28);
INSERT INTO "CSFrameworkV6_Normal"."_Demo_Customer" ("isid", "Address1", "Address2", "Address3", "Bank", "BankAccount", "BankAddress", "City", "CityCode", "ContactPerson", "Country", "CountryCode", "CreatedBy", "CreationDate", "CustomerCode", "Email", "EnglishName", "Fax", "InUse", "LastUpdateDate", "LastUpdatedBy", "NativeName", "PaymentTerm", "PostalCode", "Region", "Remark", "Tel", "WebAddress", "ZipCode")
VALUES (:p29, :p30, :p31, :p32, :p33, :p34, :p35, :p36, :p37, :p38, :p39, :p40, :p41, :p42, :p43, :p44, :p45, :p46, :p47, :p48, :p49, :p50, :p51, :p52, :p53, :p54, :p55, :p56, :p57);
INSERT INTO "CSFrameworkV6_Normal"."_Demo_Customer" ("isid", "Address1", "Address2", "Address3", "Bank", "BankAccount", "BankAddress", "City", "CityCode", "ContactPerson", "Country", "CountryCode", "CreatedBy", "CreationDate", "CustomerCode", "Email", "EnglishName", "Fax", "InUse", "LastUpdateDate", "LastUpdatedBy", "NativeName", "PaymentTerm", "PostalCode", "Region", "Remark", "Tel", "WebAddress", "ZipCode")
错误原因
使用 DmDbContext.AddRange()方法报错。
使用DmAdapter.Update(DataTable)方法报错。
解决方案
查看VM_STACK_SIZE参数值,256KB。
SELECT para_name,para_value from v$dm_ini WHERE para_name='VM_STACK_SIZE';
![达梦数据库DmException: 变量空间溢出 [sql]: INSERT INTO,Microsoft.EntityFrameworkCore.DbUpdateException|C/S开发框架](/upload/image_spider/1/202411142254550728789.jpg)
调整dm.ini中的VM_STACK_SIZE(静态参数)参数值为10240(10MB),重启达梦数据库服务,问题解决。
C:\Program Files\dmdbms\data\DAMENG\dm.ini
![达梦数据库DmException: 变量空间溢出 [sql]: INSERT INTO,Microsoft.EntityFrameworkCore.DbUpdateException|C/S开发框架](/upload/image_spider/1/202411142254553791233.jpg)
![达梦数据库DmException: 变量空间溢出 [sql]: INSERT INTO,Microsoft.EntityFrameworkCore.DbUpdateException|C/S开发框架](/upload/image_spider/1/202411142254556994432.jpg)

MySql MySqlBulkLoader批量导入数据(批导BulkInsert)|C/S开发框架
达梦数据库 | 获取表结构的SQL脚本|C/S开发框架
CSFramework框架数据库备份还原操作手册(MySql/Oracle/SqlServer/达梦)|C/S开发框架
达梦数据库使用DmBulkCopy批导数据解决方案|C/S开发框架
C/S架构快速开发框架SQL并发测试压力测试 | www.csframework.com
CSFrameworkV6软件开发框架+达梦数据库(国产数据库)测试报告|C/S开发框架
CSFrameworkV6软件开发平台主流数据库测试报告(SqlServer/MySql/Oracle/达梦)|C/S开发框架
达梦数据库备份、还原操作指南|C/S开发框架
MySql数据库备份、还原操作指南|C/S开发框架
达梦数据库入门基础|C/S框架网|C/S开发框架
.NETCore WebApi后端开发框架+达梦数据库测试报告|C/S开发框架
C#.NET调用达梦数据库的存储过程返回多张表|C/S开发框架
C#.NET 达梦数据库存储过程 获取OUT参数返回值|C/S开发框架
SqlConnectorV6.1 | 数据库连接工具|C/S开发框架
达梦数据库 | 使用DM数据迁移工具迁移CSFrameworkV6数据库|C/S框架网|C/S开发框架
CSFramework.EF 数据库框架 | 支持达梦数据库|C/S开发框架
什么是C/S结构? | C/S框架核心组成部分 | C/S框架-WebService部署图 | C/S框架-权限管理 | C/S结构系统框架 - 5.1旗舰版介绍 | C/S结构系统框架 - 功能介绍 | C/S结构系统框架 - 产品列表 | C/S结构系统框架 - 应用展示(图) | 三层体系架构详解 | C/S架构轻量级快速开发框架 | C/S框架网客户案例 | WebApi快速开发框架 | C/S框架代码生成器 | 用户授权注册软件系统 | 版本自动升级软件 | 数据库底层应用框架 | CSFramework.CMS内容管理系统 |
在线客服
