We have a table "A" with duplicate values in some columns. Now created

We have a table "A" with duplicate values in some columns. Now created a new table "B" with same structure as "A" where "a_id" is default generated primary key (only in B table). Now I need to insert all data from table A into B. But i cant do it through insert query in sql because it is asking value for "a_id" column (getting error: cannot insert NULL into ("server"."B"."A_ID")).

So trying to fetch all records from table A through query rule, then storing in a cdt and writing that cdt into "B" table through write to data store entity smart service. But we are getting error : "Details: org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update: java.sql.BatchUpdateException: ORA-00957: duplicate column name Data"

But there is no duplicate column in this table, we have 80 columns in "A" table and 81 columns in "B" table (a_id is extra)
Even tried with Query DB node (fetching columns through sele...

OriginalPostID-203436

OriginalPostID-203436