2 Replies Latest reply on Jan 24, 2011 8:29 PM by dodiy.m

    MDM error - "Cannot create a row of size 8273 which is greater than the allowable maximum of 8060"

    Apprentice

      Hi,

       

      I'm doing Metadata Manager for Service Desk v7.3.2 but got this error "Cannot create a row of size 8273 which is greater than the allowable maximum of 8060".

      This is in metadata manager log file said:

      <MetadataLogEntry xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

      <Sql>UPDATE im_incident_resolution SET mdm_temp_column = im_description</Sql>
      <Result>Failure</Result>
      <ErrorMessage>Cannot create a row of size 8273 which is greater than the allowable maximum of 8060.
      The statement has been terminated.</ErrorMessage>
      </MetadataLogEntry>
      <FatalError>
      <Description>Cannot create a row of size 8273 which is greater than the allowable maximum of 8060.
      The statement has been terminated.</Description>
      <CallStack>   at Touchpaper.Framework.Data.Metadata.MetadataLog.ExecuteNonQuery(IDbCommand cmd, Boolean ignoreErrors)
         at Touchpaper.Framework.Data.Metadata.Tools.TableBuilder.ExecuteStatements(Boolean ignoreErrors, IList listStatements, DataSource ds, IDbConnection cnxn)
         at Touchpaper.Framework.Data.Metadata.Tools.TableBuilder.ExecuteStatements(IMetadataCatalog catalog, IDictionary mapStatements, Boolean ignoreErrors)
         at Touchpaper.Framework.Data.Metadata.Manager.MetadataManager.DoConversion(MetadataCatalog metadata)
         at Touchpaper.Framework.Data.Metadata.Manager.MetadataManager.SetupDatabase(MetadataCatalog metadata)</CallStack>
      </FatalError>

       

      I check rows in table "im_incident_resolution" is only 5363 rows. I don't know how to solve this, is that anyone have workaround?

       

      Regards,

      Dodi