Obiee 11g w/ Teradata: CREATE TABLE priv fail after upgrade

Rafael Korablikovas-Oracle

Hi Fellows,

After a successful upgrade from OBIEE 11.1.1.7.x to 11.1.1.9.x, we started to have problems with reports using Teradata ConnectionPool.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59044] Unable to create table "TT2QEDIO0OCK5BB15000A0H0J012". [nQSError: 16001] ODBC error state: 37000 code: -3524 message: [Teradata][ODBC Teradata Driver][Teradata Database] The user does not have CREATE TABLE access to database IIGCOD001_ACC. . [nQSError: 16014] SQL statement preparation failed. (HY000)

Looking for it, I could find a solution, within the article "An OBIEE 10g report not working on 11g after upgrade: [NCR][ODBC Teradata Driver][Teradata Database] The user does not have CREATE TABLE access to database (Doc ID 1268451.1)". Although it says that the issue would appear on a 10g > 11g migration, the proposed solution solved my issue.

The question is: Why? Even before the upgrade, the option was already enabled, and nothing has changed on DB side. Same user, same privs, same odbc driver. So, customer is asking why just on the new version, the lack of permissions of the user configured on the datasource became an issue? He is afraid that changing this may cause other unexpected behaviour.

I coulnd't find anything related to it on KB or product documentation.

Any ideas?

Regards,
Rafael Korablikovas