Column in table already exist

An error was found in the database schema verification process.
Column CountryZip in table Country already exist
The reorganization process was not successfully completed.

Scope: All DBMS

Cause:

An attempt is made to create a New attribute in a table in which it already exists.

Solution: 

Open a backup version, confirm that such attribute does NOT exist in that table and rerun the reorg.

The reorg can be executed ignoring this verification, by adding the parameter - noverifydatabaseschema to the Reorganization Options property, but it isn’t the most advisable option for this particular case.

WARNING: Depending on the DBMS, this reorg is likely to fail (*)

If there isn’t a backup in that status (equal to the model in the GeneXus KB), another option is to manually fix the database so that it is synchronized with the GX model. In this case, it would involve deleting the attname attribute from the database table.

WARNING: This attribute could be used by another system (GeneXus or otherwise). The database model should not have to be unsynchronized with the model in the GeneXus KB. Examining why it was left in this status is advisable.  However, this maintenance should be left to GeneXus rather than making changes manually to the database.

(*) if the (-novi… ) verification is ignored and the reorg is executed anyway, for instance, against SQS Server, an error such as the following will be displayed:

\"C:\Program Files\Java\jdk1.6.0_17\bin\java.exe"  Reorganization -nogui -noverifydatabaseschema
Table Country has 0 records
Updating table Country .
Waiting for 1 submitted procs to end...Updating table Country . STARTED
 
java.sql.SQLException: Column names in each table must be unique. Column name 'CountryZip' in table 'Country' is specified more than once.
                at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
Updating table Country . FAILED at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
 
                at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
                at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
                at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
                at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
                at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:664)
                at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1120)
                at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1073)
                at com.genexus.db.driver.GXStatement.executeUpdate(Unknown Source)
                at com.genexus.db.DBConnectionManager.executeStatement(Unknown Source)
                at com.genexus.ExecuteDirectSQL.executeWithThrow(Unknown Source)
                at reorg.ReorganizeCountry(reorg.java:53)
                at reorg.submitReorg(reorg.java:208)
                at com.genexus.util.ReorgSubmitThread.run(Unknown Source)
The reorganization process was not successfully completed.
Reorganization Failed
error: Error in reorganization