https://community.qlik.com/t5/Data-Quality/Error-multiple-default-values-for-a-column-in-table/m-p/2201932#M548 <P>Hello,</P><P>It seems that the column name "time_id" defined in the constraint clause of the CREATE or Alter Table syntax specifies multiple values.</P><P>Please check Action on table and Action on data in tDBOutput_1 (dimension_loading).</P><P>Best regards</P><P>Sabrina</P><P>&nbsp;</P> Thu, 19 Oct 2023 02:56:36 GMT Anonymous 2023-10-19T02:56:36Z https://community.qlik.com/t5/Data-Quality/Error-multiple-default-values-for-a-column-in-table/m-p/2201931#M547 <P>I am trying to populate the fact table using 6 dimension tables and one source table, It is throwing Error.</P><P>Error is as follows:</P><P>Exception in component tDBOutput_1 (dimension_loading)</P><P>org.postgresql.util.PSQLException: ERROR: multiple default values specified for column "time_id" of table "fact_talend"</P><P> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)</P><P> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)</P><P> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)</P><P> at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)</P><P> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)</P><P> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:310)</P><P> at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:296)</P><P> at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:273)</P><P> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:268)</P><P> at churn_project.dimension_loading_0_1.dimension_loading.tDBInput_1Process(dimension_loading.java:4696)</P><P> at churn_project.dimension_loading_0_1.dimension_loading.runJobInTOS(dimension_loading.java:10987)</P><P> at churn_project.dimension_loading_0_1.dimension_loading.main(dimension_loading.java:10825)</P><P></P><P></P><P>The same job works fine when the output component is tLogRow instead of tDBOutput</P><P></P><P></P><P>Snapshots of Job are attached for the reference. Please let me know how can I fix the above mentioned error. I had also tried to remove default value in tMap, created new table with serial primary key etc It didn't work</P> Fri, 15 Nov 2024 21:20:03 GMT https://community.qlik.com/t5/Data-Quality/Error-multiple-default-values-for-a-column-in-table/m-p/2201931#M547 TC1697460415 2024-11-15T21:20:03Z https://community.qlik.com/t5/Data-Quality/Error-multiple-default-values-for-a-column-in-table/m-p/2201932#M548 <P>Hello,</P><P>It seems that the column name "time_id" defined in the constraint clause of the CREATE or Alter Table syntax specifies multiple values.</P><P>Please check Action on table and Action on data in tDBOutput_1 (dimension_loading).</P><P>Best regards</P><P>Sabrina</P><P>&nbsp;</P> Thu, 19 Oct 2023 02:56:36 GMT https://community.qlik.com/t5/Data-Quality/Error-multiple-default-values-for-a-column-in-table/m-p/2201932#M548 Anonymous 2023-10-19T02:56:36Z