Cchetty: 1 revision

2010-04-09T15:20:54Z

1 revision

← Older revision

Revision as of 15:20, 9 April 2010

Sakkumar at 09:40, 25 November 2009

2009-11-25T09:40:44Z

New page

== Analyzing UCCX CLI logs ==

{| border="1"
|-
! '''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 #'''
|
|-
|}

[[Category:Unified CCX, Release 8.0]]

Analyzing UCCX CLI logs - Revision history

Cchetty: 1 revision

Sakkumar at 09:40, 25 November 2009