[progress Communities] [progress Openedge Abl] Forum Post: Re: Sql-92 Query Fail: Internal...

  • Thread starter Jyothi Sundaragiri
  • Start date
Status
Not open for further replies.
J

Jyothi Sundaragiri

Guest
We have a known issue with similar error to the one you encountered. And this occurs when we are updating a record which contains a varchar column of size ~31981. A simple repro would be : create table pub.t3 (id int, name varchar(31981)); create index i1t3 on pub.t3 (id); insert into pub.t3 values (10,repeat('c', 31981)); update pub.t3 set id=11 where substr(name,1,2) ='cc'; Update count = 0. === SQL Exception 1 === SQLState=HY000 ErrorCode=-219901 [DataDirect][OpenEdge JDBC Driver][OpenEdge] Internal error -1 (buffer too small for generated record) in SQL from subsystem RECORD SERVICES function rcUpgradeRecord called from stub_tpl_hdl_t::upgradeRecord on PUB.T3 for . Save log for Progress technical support. Is there any similarity with the scenario where you encountered the problem?

Continue reading...
 
Status
Not open for further replies.
Top