|
Archives of the TeradataForumMessage Posted: Wed, 12 Feb 2004 @ 02:42:33 GMT
Hi All, I am trying to test TDQM Scheduler option on the Teradata Demo Software on my laptop and getting the following error message 1|SREXE|000948|ServerC:SetDbCntxt|Logon |00000|000|04-02-11 17:52:10 DB Error: Function=DbmsC:Logon, Stmt#=0, Code=3002, Info=0 Invalid logon account. and also I have enabled the trace option of the TDQM and got the following from the trace. ************************************************************************* ************************************************************************* ****************************************** 21175008: comm DLL attach process = 948 21175008: shm base ptr = 006a0000(x) 21175008: heap ptr = 006a0000(x) 21175008: global ptr = 006a0030(x) 21175018: server DLL attach process = 948 21175018: shm base ptr = 00830000(x) 21175018: heap ptr = 00830000(x) 21175018: host ptr = 00830030(x) 21175018: qmdexec:main 21175018: 101127 0 21175018: job id = 101127 21175018: exec now = 0 21175018: req id = 64275 21175018: min time = 175100 21175018: max time = 175100 21175018: QmsDb:Logon : Teraprd1/dbqrymgr, 21175248: ContextC:Init 21175248: ContextC:Complete 21175248: check rules ... 21175248: ----- 21175248: ReqstC:ProcQuery 21175248: QmsDb:ChangeDfltDb : DBC 21175268: stmt : SEL COUNT(*) FROM DBC.ACCOUNTS 21175268: len = 30 21175268: last stmt = 1 21175268: parser path : C:\Program Files\NCR\Teradata DQM\server\ 21175288: parser status = 0 21175288: node type : QMParStmt 21175288: adding db : DBC 21175288: adding obj : ACCOUNTS 21175288: node type : QMParQuery 21175288: query type : SELECT 21175288: node type : QMParOption 21175288: node type : QMParItemDesc 21175288: node type : QMParCountStar 21175288: parsed last stmt as SEL = 1 21175288: parsed last stmt as MAC = 0 21175288: ReqstC:ProcOneQry 21175288: PerformQA : Explain SELECT COUNT(*) FROM DBC.ACCOUNTS ; 21175328: 1) First, we lock DBC.ACCOUNTS for access. 21175328: 2) Next, we do an all-AMPs SUM step to aggregate from DBC.ACCOUNTS by 21175328: way of an all-rows scan with no residual conditions. Aggregate 21175328: UpdateTableOps = 2 21175328: UpdateTableOps : ACCOUNTS 21175328: Intermediate Results are computed globally, then placed in Spool 3. 21175328: AssocSpoolObj = 3 21175328: AssocSpoolObj : ACCOUNTS 21175328: The size of Spool 3 is estimated with high confidence to be 1 row. 21175328: rows = 1 21175328: The estimated time for this step is 0.04 seconds. 21175328: time = 1 21175328: 3) We do an all-AMPs RETRIEVE step from Spool 3 (Last Use) by way of 21175328: FindSpoolObj = 3 21175328: an all-rows scan into Spool 1 (group_amps), which is built locally 21175328: AssocSpoolObj = 1 21175328: AssocSpoolObj : ACCOUNTS 21175328: on the AMPs. The size of Spool 1 is estimated with high 21175328: confidence to be 1 row. The estimated time for this step is 0.03 21175328: rows = 1 21175328: seconds. 21175328: time = 1 21175328: 4) Finally, we send out an END TRANSACTION step to all AMPs involved 21175328: in processing the request. 21175328: -> The contents of Spool 1 are sent back to the user as the result of 21175328: statement 1. 21175328: last rows = 1 21175328: max rows = 1 21175328: cum time = 2 21175328: estimated time = 2 21175328: total est time = 2 21175328: UserC:CheckRestrs : SA03052C 21175328: GroupC:CheckRestrs : DBA 21175328: ReqC:Find&CheckObj : ACCOUNTS 21175328: ReqC:Find&CheckObj : db not restricted 21175328: QmsDb:ChangeDfltDb : dbqrymgr 21175358: vote=53000,stat=0,obj=0,usr=0,val=0,lim=0,fr=0,to=0,req=104,sch=021175358: new min time = 175100 21175358: parsed sql : SELECT COUNT(*) FROM DBC.ACCOUNTS ; 21175358: QmdDb:UpdJobStatus = 4 21175468: LOG: QmdDb:AddUpdEntry : CheckResponse : DB Error: Function=DbmsC:CheckResponse, Stmt#=1, Code=2802, Info=0Duplicate row error in dbqrymgr.sched_updates. 21175468: LOG: qmdexec:main : UpdateJobStatus : 2 21175468: QmsDb:Logoff 21175508: user logon : Teraprd1/SA03052C, 21175538: user logon error = 99999 21175538: LOG: ServerC:SetDbCntxt : Logon : DB Error: Function=DbmsC:Logon, Stmt#=0, Code=3002, Info=0 Invalid logon account. 21175538: LOG: qmdexec:main : UserLogon : 99999 21175538: qmdexec:FailJob = 6 21175538: QmsDb:Logon : Teraprd1/dbqrymgr, 21176500: QmdDb:UpdJobStatus = 6 21176500: DbErrorMsg.MsgText : DB Error: Function=DbmsC:Logon, Stmt#=0, Code=3002, Info=0 Invalid logon account. 21176640: QmsDb:Logoff 21176660: server DLL detach process = 948 21176660: comm DLL detach process = 948 ************************************************************************* ************************************************************************* ****************************************** When I looked up in the DBC.EventLog, This is what it shows up LogonDate LogonTime UserName SessionNo LogonSource Event 2004-02-11 174943 SA03052C 1029 (TCP-IP) 0D4D 127.0.0.1 TERAPRD1 3400 ADMINISTRATOR TDQMREQP 01 LSS Logoff 2004-02-11 174943 SA03052C 1029 (TCP-IP) 0D4D 127.0.0.1 TERAPRD1 3400 ADMINISTRATOR TDQMREQP logon 2004-02-11 175210 SA03052C 1032 (TCP-IP) 0D54 127.0.0.1 TERAPRD1 948 ADMINISTRATOR TDQMJOB 01 LSS Bad Account I would appreciate if someone can help me out to fix this. Thank You Arvind
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||