dbptk-developer
dbptk-developer copied to clipboard
Problem with duplicate column name
Description: Cannot restore database: ERROR: column "OB_ID" specified more than once Call getNextException to see other errors in the batch.
If I check the initial dbptk-report-20170126124051360.txt for creation with older DBPTK, I see:
- Type conversion in import module: in `RPE.UL_.OB_ID` (format: schema.table.column) has original type `NUMBER(3,0)` and was converted to the standard type `DECIMAL(3)`
. . .
- Type conversion in import module: in `RPE.UL_.OB_ID` (format: schema.table.column) has original type `NUMBER(3,0)` and was converted to the standard type `DECIMAL(3)`
And db creation log dbptk-app.log.txt with 2.4.0:
CREATE TABLE "RPE"."UL_" (
. . .
"OB_ID" numeric(3) NOT NULL,
. . .
"OB_ID" numeric(3) NOT NULL,
. . .
was aborted: ERROR: column "OB_ID" specified more than once Call getNextException to see other errors in the batch.
Is it possible to have columns with duplicate names? Is the problem in old siard package or in export into database? Regards, Boris