Analyzing UCCX CLI logs

From DocWiki

(Difference between revisions)
Jump to: navigation, search

Revision as of 09:40, 25 November 2009

Analyzing UCCX CLI logs

Problem Summary Analyzing UCCX CLI logs
Error Message NA
Possible Cause NA
Recommended Action To analyze issue with a specific CLI command follow the below mentioned steps after collecting the logs
  • Find the point where the command was issued. For ex for a 'run uccx sql' command, the log statement would look like
2009-11-23 18:36:03,129 INFO [main] - running command -> [run uccx sql db_cra select * from crsuser]
  • As part of the execution of the command, there would be messages such as the ones mentioned below. The important part to note here is the format of the log statement. The information which is mentioned in the log statement is as follows - Timestamp, Log level, Thread Id and then the log statement. After the command has been invoked the flow of the command can be traced using the ThreadId as the commands are executed in a single thread environment. Here the thread is is 'ClassExecutionThread'
2009-11-23 18:36:03,202 DEBUG [ClassExecutionThread] - cmdUccxDbRunSql::executeCmd - with database = db_cra SQL="select * from crsuser "
2009-11-23 18:36:03,233 DEBUG [ClassExecutionThread] - cmdUccxDbRunSql::executeCmd - Building SQL with array.length()=4, startIndex=0, endIndex=4
2009-11-23 18:36:03,233 DEBUG [ClassExecutionThread] - cmdUccxDbRunSql::executeCmd - Generated SQL='select * from crsuser'
  • After the completion of the command as success message is displayed.
2009-11-23 18:36:09,494 INFO [ClassExecutionThread] - cmdUtils: RESOURCEID PROFILEID RESOURCELOGINID RESOURCEFIRSTNAME RESOURCELASTNAME EXTENSION CAPABILITIES PRIMARYEXTENSION KEYPADMAPPING RESOURCENAME RESOURCEGROUPID RESOURCETYPE RESOURCESKILLMAPID ASSIGNEDTEAMID PRIVATEDATA CREATEDATETIME ACTIVE DATEINACTIVE
2009-11-23 18:36:09,495 INFO [ClassExecutionThread] - cmdUccxDbRunSqlNo records found
2009-11-23 18:36:09,496 INFO [ClassExecutionThread] - cmdUccxDbRunSql Command successful.
2009-11-23 18:36:09,496 INFO [ClassExecutionThread] - The Command Status: command successful.
  • If there is an error while executing the command the cause of the error and the details would be logged.
  • Another command is being run
2009-11-23 18:39:07,079 INFO [main] - running command -> [run uccx sql db_cra select sessionid,sessionseqno,startdatetype,enddatetime from ContactCallDetail order by startdatetime desc]
2009-11-23 18:39:07,139 DEBUG [ClassExecutionThread] - cmdUccxDbRunSql::executeCmd - with database = db_cra SQL="select sessionid,sessionseqno,startdatetype,enddatetime from ContactCallDetail order by startdatetime desc "
2009-11-23 18:39:07,139 DEBUG [ClassExecutionThread] - cmdUccxDbRunSql::executeCmd - Building SQL with array.length()=8, startIndex=0, endIndex=8
2009-11-23 18:39:07,139 DEBUG [ClassExecutionThread] - cmdUccxDbRunSql::executeCmd - Generated SQL='select sessionid,sessionseqno,startdatetype,enddatetime from ContactCallDetail order by startdatetime desc'
  • The command fails because of an invalid SQL statement (invalid column) which is clearly mentioned below.
2009-11-23 18:39:07,156 ERROR [ClassExecutionThread] - SQL Exception while accessing DB.
java.sql.SQLException: Column (sessionseqno) not found in any table in the query (or SLV is undefined).
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3171)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3484)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2328)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2244)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1142)
at com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java:318)
at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:298)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:168)
at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5939)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:2020)
at com.cisco.iptplatform.cli.cmdUccxDbRunSql.runQueryAndGenerateResults(cmdUccxDbRunSql.java:315)
at com.cisco.iptplatform.cli.cmdUccxDbRunSql.executeCmd(cmdUccxDbRunSql.java:214)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.cisco.iptplatform.cli.cmdClassThread.run(cmdClassThread.java:110)
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:395)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3489)
... 15 more
  • The message which is printed on the CLI console is displayed below. The investigation can also be started by searching for the error message which is displayed on the console.
2009-11-23 18:39:07,158 INFO [ClassExecutionThread] - cmdUccxDbRunSqlInternal CLI Error: java.sql.SQLException: Column (sessionseqno) not found in any table in the query (or SLV is undefined).
  • The command fails
2009-11-23 18:39:07,158 INFO [ClassExecutionThread] - cmdUccxDbRunSql Command failed.
2009-11-23 18:39:07,158 INFO [ClassExecutionThread] - The Command Status: command failed.
2009-11-23 18:39:07,158 INFO [ClassExecutionThread] - message: Command failed.
Release Release 8.0(1)
Associated CDETS #

Rating: 0.0/5 (0 votes cast)

Personal tools