Qlikview TPT Connector

Tools

Qlikview TPT Connector

Hi everybody, 

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 :

========================================================================

001141 2014-06-27T16:57:35.144+02:00  Error            =                                                                      =

001142 2014-06-27T16:57:35.144+02:00  Error            =          FastExport Utility    Release FEXP.15.00.00.00              =

001143 2014-06-27T16:57:35.144+02:00  Error            =          Platform WIN32                                              =

001144 2014-06-27T16:57:35.144+02:00  Error            =          PID      2196                                               =

001145 2014-06-27T16:57:35.144+02:00  Error            =                                                                      =

001146 2014-06-27T16:57:35.144+02:00  Error            ========================================================================

001147 2014-06-27T16:57:35.144+02:00  Error            =                                                                      =

001148 2014-06-27T16:57:35.144+02:00  Error            =     Copyright 1990-2014 Teradata Corporation. ALL RIGHTS RESERVED.   =

001149 2014-06-27T16:57:35.160+02:00  Error            =                                                                      =

001150 2014-06-27T16:57:35.160+02:00  Error            ========================================================================

001151 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY2411 Processing start date: FRI JUN 27, 2014

001152 2014-06-27T16:57:35.160+02:00  Error            ========================================================================

001153 2014-06-27T16:57:35.160+02:00  Error            =                                                                      =

001154 2014-06-27T16:57:35.160+02:00  Error            =          Logon/Connection                                            =

001155 2014-06-27T16:57:35.160+02:00  Error            =                                                                      =

001156 2014-06-27T16:57:35.160+02:00  Error            ========================================================================

001157 2014-06-27T16:57:35.160+02:00  Error       0001 .LOGTABLE SEMANTICDB.QVConnectorLogTable_2572_1;

001158 2014-06-27T16:57:35.160+02:00  Error       0002 .DATEFORM ANSIDATE;

001159 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY1200 DATEFORM has been set to ANSIDATE.

001160 2014-06-27T16:57:35.160+02:00  Error       0003 .LOGON 10.7.182.11/JDAU,;

001161 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Teradata Database Release: 13.10.03.07

001162 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Teradata Database Version: 13.10.03.07

001163 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Default character set: ASCII                         

001164 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Current RDBMS has UDT support

001165 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Current RDBMS has Large Decimal support

001166 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Current RDBMS has Statement Info Parcel support

001167 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Current RDBMS has FEXP w/o Spooling support

001168 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Current RDBMS has TASM support

001169 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Maximum supported buffer size: 1M

001170 2014-06-27T16:57:35.160+02:00  Error       **** 16:55:51 UTY8400 Data Encryption supported by RDBMS server

001171 2014-06-27T16:57:35.176+02:00  Error       **** 16:55:51 UTY1008 RDBMS failure: 3807, Object 'SYSLIB.DBSRETRYABLEERRORS'

001172 2014-06-27T16:57:35.176+02:00  Error            does not exist.

001173 2014-06-27T16:57:35.176+02:00  Error       **** 16:55:51 UTY6687 Warning: The job will use its internal retryable error

001174 2014-06-27T16:57:35.176+02:00  Error            codes.

001175 2014-06-27T16:57:35.176+02:00  Error       **** 16:55:51 UTY1008 RDBMS failure: 3524, The user does not have CREATE TABLE

001176 2014-06-27T16:57:35.176+02:00  Error            access to database SEMANTICDB.

001177 2014-06-27T16:57:35.176+02:00  Error       **** 16:55:51 UTY2410 Total processor time used = '0.125 Seconds'

001178 2014-06-27T16:57:35.176+02:00  Error            .       Start : 16:55:51 - FRI JUN 27, 2014

001179 2014-06-27T16:57:35.176+02:00  Error            .       End   : 16:55:51 - FRI JUN 27, 2014

001180 2014-06-27T16:57:35.176+02:00  Error            .       Highest return code encountered = '12'.

001181 2014-06-27T16:57:35.176+02:00  Error       QVX_UNEXPECTED_END_OF_DATA: The connection failed to connect.    The FastExport script execution failed. return code = 12  Please see the TPT Connector log file for more information.

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. 

Cheers

John

2 REPLIES
Teradata Employee

Re: Qlikview TPT Connector

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.

-- SteveF

Re: Qlikview TPT Connector

Hi Steve,

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.

Cheers

Jonathan