Error Accessing Fast Export Utility

Tools
Enthusiast

Error Accessing Fast Export Utility

Hii ppl,

I am using v12.0 and unable to login into Fast Export/Fast Load utility and its giving "RDBMS error: 3002, Invalid logon account" as the error. I am attaching 2 screenshots. First screenshot indicates the values that i have given for logon and Second screenshot contains the error after logging in.

I am unable to understand the meaning of "Account Id" when loging into Fastload.

My host file has following entry: 127.0.0.1 localhost localtdcop1 dbccop1

Please Note: At the same time i am able to log into BTEQ utility using dbc/dbc.

Please help me out.
5 REPLIES
Enthusiast

Re: Error Accessing Fast Export Utility

Hi Sudheer,

I think the problem in your case is you haven't provided the complete details for table xyz. I used like this

.logtable Samples.shri;
.logon localtd/tduser,tduser;

after this I got below information

**** 17:02:50 UTY2411 Processing start date: TUE AUG 11, 2009
========================================================================
= =
= Logon/Connection =
= =
========================================================================
.logtable samples.shri
;
0001 .logtable samples.shri
;
.logon localtd/tduser, tduser;
0002 .logon localtd/tduser,;
**** 17:03:21 UTY8400 Teradata Database Release: 12.00.00.10
**** 17:03:21 UTY8400 Teradata Database Version: 12.00.00.10
**** 17:03:21 UTY8400 Default character set: ASCII
**** 17:03:21 UTY8400 Current RDBMS has UDT support
**** 17:03:21 UTY8400 Current RDBMS has Large Decimal support
**** 17:03:21 UTY8400 Maximum supported buffer size: 1M
**** 17:03:21 UTY8400 Data Encryption supported by RDBMS server
**** 17:03:21 UTY6215 The restart log table has NOT been dropped.
**** 17:03:21 UTY2410 Total processor time used = '0.15625 Seconds'
. Start : 17:02:50 - TUE AUG 11, 2009
. End : 17:03:21 - TUE AUG 11, 2009
. Highest return code encountered = '12'.
Press any key to continue . . .

Hope this helps
Enthusiast

Re: Error Accessing Fast Export Utility

Hey, thanks for the reply. Please see the attached JPEG files in my previous message.
The first image(Login Details.jpeg) is asking for all details like username, password, Account Id, etc. I just need the details regarding the "Account Id" mentioned in that image.

That would be of great help.
Enthusiast

Re: Error Accessing Fast Export Utility

I also not sure about the account id, but you can leave this blank and check
Teradata Employee

Re: Error Accessing Fast Export Utility

Leave that field blank.
-- SteveF
Enthusiast

Re: Error Accessing Fast Export Utility

Hi,

I have identified the problem ppl, Thanks for giving your valuable suggestions. The super user dbc is not having create privileges on the retail database, where i am instructing the utility to create a log table. Hence, it was not allowing me to login successfully. I have given create privileges to dbc and i was successful.