We could not obtain the data because the database connection or warehouse table is changed. Encountered error: Execute Query failed. Error Type: Odbc error. Odbc operation attempted: SQLExecDirect. [][Strategy][ODBC PostgreSQL Wire Protocol driver][PostgreSQL] ERROR:column "" does not exist
CAUSE:Typically, the "We could not obtain the data because the database connection or warehouse table is changed" error is suppressed when there is an issue with either the database connection or there is an alteration made to the table being sourced. However, when another error occurs, such as a missing column error, the above error will be unsuppressed and thrown in conjunction with the second error describing the actual problem occurring. In the instance above, the following refers to the actual error:
Odbc error. Odbc operation attempted: SQLExecDirect. [][Strategy][ODBC PostgreSQL Wire Protocol driver][PostgreSQL] ERROR:column "" does not exist
In one scenario seen by Support, this issue was caused by a modification of one of the columns that was referenced in the initial creation of the cube. Any change made to the column, would yield this error when attempting to publish or modify the cube. Consequently, the change made in the database results in a cube in an inconsistent state that cannot be modified or published.
ACTION:Contact the database administrator to see what changes have been made in the database to the column(s) that have been referenced in the cube.
