My IRIS version is 2020.1. 

I will be grateful if you see any significant differences between my example and yours that cause this error. My Persistent class (this class created using 'CREATE TABLE'):

// Class Fixxer.DEcars Extends %Persistent [ ClassType = persistent, DdlAllowed, Final, Owner = {yploskyi}, ProcedureBlock, SqlRowIdPrivate, SqlTableName = DEcars ]{Property UniqueIdentifier As %Library.String(MAXLEN = 30) [ SqlColumnNumber = 2 ];Property brand As %Library.String(MAXLEN = 500) [ SqlColumnNumber = 3 ];
Property maxspeed As %Library.String(MAXLEN = 500) [ SqlColumnNumber = 4 ];Property color As %Library.String(MAXLEN = 500) [ SqlColumnNumber = 5 ];Parameter USEEXTENTSET = 1;/// Bitmap Extent Index auto-generated by DDL CREATE TABLE statement. Do not edit the SqlName of this index.Index DDLBEIndex [ Extent, SqlName = "%%DDLBEIndex", Type = bitmap ];
}

I  think so too. I also noticed that in IRIS 2020.1 documentation is nothing about 'ALTER COLUMN RENAME' syntax. May be there is another way to rename column name using SQL but i cant find it. Thanks for response.

Yes, I decided to use that approach. Thank you

If I understand correct. If I remove field repetition, I will lose data from field number "3().1" that was there before. My task is to catch all fields. May be you know how can I get a list of all properies numbers or paths from message/segment?

I saw that method, but I did not undarstand how it works. Thank you! It works for me

I started to investigate the Installation Manifest. Thank you!

I also met some difficulties in this approach and described them in the following post.

https://community.intersystems.com/post/installation-manifest

Where I have to put the Verbose property? I found it only in <Log> tag Level property value  in the documentation. But I did not specify any Log tags in my XData. If you mean pLogLevel parameter in the setup method, it is already = 3.

My setup method: 

ClassMethod setup(ByRef pVars, pLogLevel As %Integer = 3, pInstaller As %Installer.Installer, pLogger As %Installer.AbstractLogger) As %Status [ CodeMode = objectgenerator, Internal ]
{
   #; Let XGL document generate code for this method.
   Quit ##class(%Installer.Manifest).%Generate(%compiledclass,
      %code, "MyInstall")
}

Did you mead INSTALLERMANIFESTLOGLEVEL=3 in Command-Line Properties?

Hi Robert. The problem is that I am executing the query on the linked table, so I have to use IRIS SQL syntax and it does not support "LIMIT"