I am currently working on a project using Qlikview on top of Teradata.
We are trying to use the QVX_TPTConnector (specific connector to Qlikview) to avoid ODBC connection and see if performances are better.
I got the TTU 15.0 installed with ODBC Driver, FastLoad, FastExtract, BTEQ, SQL Assistant.
ODBC connection works great but FastLoad doesn't.
I have the higher error code = 12 and the following log :
Is it an access right issue on the DB? a connector issue? if you have any clue please advise as I'd really like to make it work.
Thanks in advance for your help.
You mention that you are using "QVX_TPTConnector", but the output shows FastExport. FastExport is not part of any TPT connector. They are different products.
However, for this particular FastExport problem, the error is clear:
RDBMS failure: 3524, The user does not have CREATE TABLE access to database SEMANTICDB.
You specified a log table name of: SEMANTICDB.QVConnectorLogTable_2572_1;
That table does not exist when the job begins, so FastExport will try to create it.
And the user does not have the correct access rights to create the table.
As indicated in the documentation, the user must have CREATE TABLE rights on any database named in the script in order to use FastExport.
Yes you are quite right. The DBA insured me that I have CREATE TABLE rights but it's obviously not the case. I had a try just before...
Ok so it sounds like it was a stupid question but thanks anyway for your answer.