|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/7/2009 10:46:25 AM
Posts: 6,
Visits: 25
|
|
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.
Regards,
Sudheer.I
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/17/2009 11:56:55 AM
Posts: 7,
Visits: 31
|
|
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
Shrihari Saraf
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/7/2009 10:46:25 AM
Posts: 6,
Visits: 25
|
|
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.
Regards,
Sudheer.I
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/17/2009 11:56:55 AM
Posts: 7,
Visits: 31
|
|
I also not sure about the account id, but you can leave this blank and check
Shrihari Saraf
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/7/2009 10:46:25 AM
Posts: 6,
Visits: 25
|
|
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.
Regards,
Sudheer.I
|
|
|
|