SAP Knowledge Base Article - Preview

2218272 - Error 213: Insert error: column name or number of supplied values does not match table definition after upgrade - SAP ASE

Symptom

  • After the patch SP134 was applied to a production ASE 15.7 SP110
  • Application started receiving the following error from a trigger execution:

Error 213: Insert error: column name or number of supplied values does not match table definition.

  • SQL code used by the trigger is as follows:

CREATE TRIGGER upd_mytable
on mytable
for update
as
begin
    DECLARE @c          int
    
    SELECT  @c = @@rowcount

    IF  (@c = 0)   -- nothing to do
        RETURN         
     
 if ( @c > 1 )
    begin
   
        insert into mytable_copy
        select *,getDate(),user from inserted i1     
       
 end
 else
    begin
   
        insert into mytable_copy
        select *,getDate(),user from inserted i1     
       
    end  
  
END

  • It used to work fine before the patch SP134 was applied
  • The issue was resolved by modifying the trigger to explicitly list columns during INSERT


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Trace flag, traceflag, 7798, procedure, deferred, compilation, re-resolution, CR756648, CR#756648, 756648 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.