09-06-2011 06:21 AM
When pulling information through Campus Manger, User Tracking and pulling Device or Device Name for IP Phones, the following error is generated.
"Application error: SQL Anywhere Error -143: Column 'DeviceName' not found.".
All othe functions work.
Any suggestions?
1. | Campus Manager | 5.2.2 | 23 May 2011, 09:59:29 CDT | |
2. | CiscoView | 6.1.9 | 23 Feb 2010, 08:57:28 CST | |
3. | CiscoWorks Assistant | 1.2.0 | 23 Feb 2010, 08:57:28 CST | |
4. | CiscoWorks Common Services | 3.3.1 | 23 May 2011, 09:59:29 CDT | |
5. | Device Fault Manager | 3.2.1 | 23 May 2011, 09:59:29 CDT | |
6. | Health and Utilization Monitor | 1.2.2 | 23 May 2011, 09:59:30 CDT | |
7. | Integration Utility | 1.9.0 | 23 Feb 2010, 08:57:29 CST | |
8. | LMS Portal | 1.2.1 | 23 May 2011, 09:59:30 CDT | |
9. | Resource Manager Essentials | 4.3.2 | 23 May 2011, 09:59:30 CDT |
09-06-2011 02:16 PM
Hi William,
Hav you installed any Device packages for Campus Manager ?. If yes, kindly try deleting it and then restart the daemon manager again with the command :-
net stop crmdmgtd
net start crmdmgtd (wait for 20 minutes before logging to CiscoWorks)
Also, kindly share the pdshow output along with ani.log
Many Thanks,
Gaganjeet
09-07-2011 04:15 AM
William,
did you get the error when you created a custom reports for IP Phone using the Report Designer? If not, please explain how you pulled the information.
Svetlana
09-07-2011 04:52 AM
There has been no changes, this is from pulling a User Tracking Report, Quick Report for IP Phones. If you use anything other than Device and Device Name, information is there, to include information in the Device and Device Name columns. So the information is in the database. The error occurs whrn you try to pull information using Device or Device Name. Pulling reports this way has worked with no issues in the past.
Here is what is in the ani.log
2011/09/07 06:39:23 NewMACPoller ani MESSAGE DBConnection: Created new Database connection [hashCode = 30335449]
2011/09/07 06:40:51 DBConnecton-Reaper ani MESSAGE DBConnection: Closed Database connection [hashCode = 30335449]
2011/09/07 06:43:05 DFMPoller ani MESSAGE DFMPollerTimeBaseImpl: Starting performScheduleFunction of DFM Poller Wed Sep 07 06:43:05 CDT 2011
2011/09/07 06:43:05 DFMPoller ani MESSAGE DFMPollerTimeBaseImpl: Result from isDFMDataRefreshRequired(): False
2011/09/07 06:43:05 DFMPoller ani MESSAGE DFMPollerTimeBaseImpl: Result from TopoClientFinder.anyN_HopViewOpen(): False(checking topo necessary)
2011/09/07 06:43:05 DFMPoller ani MESSAGE DFMPollerTimeBaseImpl: Result from TopoClientFinder.anyTopoClientOpen(): false
2011/09/07 06:43:05 DFMPoller ani MESSAGE DFMPollerTimeBaseImpl: Not executing DFMPoller because neither Topology clients nor N Hop clients are open
2011/09/07 06:43:05 DFMPoller ani MESSAGE DFMPollerTimeBaseImpl: ....so not updating Poll Time, as poll didnt actually happen
Here is the PDShow:
Process= UPMDbEngine
State = Program started - No mgt msgs received
Pid = 2564
RC = 0
Signo = 0
Start = 9/6/2011 1:15:35 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= UPMDbMonitor
State = Running normally
Pid = 3004
RC = 0
Signo = 0
Start = 9/6/2011 1:15:39 PM
Stop = Not applicable
Core = Not applicable
Info = DbMonitor Running Normally.
Process= Tomcat
State = Program started - No mgt msgs received
Pid = 3020
RC = 0
Signo = 0
Start = 9/6/2011 1:15:42 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= TomcatMonitor
State = Running normally
Pid = 2920
RC = 0
Signo = 0
Start = 9/6/2011 1:15:46 PM
Stop = Not applicable
Core = Not applicable
Info = Tomcat Server up
Process= Apache
State = Program started - No mgt msgs received
Pid = 2304
RC = 0
Signo = 0
Start = 9/6/2011 1:16:43 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= RMEDbEngine
State = Program started - No mgt msgs received
Pid = 5136
RC = 0
Signo = 0
Start = 9/6/2011 1:16:45 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= Proxy
State = Program started - No mgt msgs received
Pid = 5264
RC = 0
Signo = 0
Start = 9/6/2011 1:16:49 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= ProcSysBus
State = Program started - No mgt msgs received
Pid = 5272
RC = 0
Signo = 0
Start = 9/6/2011 1:16:52 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= OpsxmlDbEngine
State = Program started - No mgt msgs received
Pid = 5324
RC = 0
Signo = 0
Start = 9/6/2011 1:16:58 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= OpsXMLRuntime
State = Program started - No mgt msgs received
Pid = 5392
RC = 0
Signo = 0
Start = 9/6/2011 1:17:04 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= CWAPublisher
State = Administrator has shut down this server
Pid = 0
RC = 0
Signo = 0
Start = 9/6/2011 1:17:08 PM
Stop = 9/6/2011 1:22:18 PM
Core = Not applicable
Info = Server started by admin request
Process= NameServer
State = Program started - No mgt msgs received
Pid = 5468
RC = 0
Signo = 0
Start = 9/6/2011 1:17:08 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= NameServiceMonitor
State = Running normally
Pid = 5900
RC = 0
Signo = 0
Start = 9/6/2011 1:17:12 PM
Stop = Not applicable
Core = Not applicable
Info = NameServer is fully up now !
Process= EDS
State = Running normally
Pid = 6080
RC = 0
Signo = 0
Start = 9/6/2011 1:17:16 PM
Stop = Not applicable
Core = Not applicable
Info = Initialization complete
Process= LicenseServer
State = Program started - No mgt msgs received
Pid = 6164
RC = 0
Signo = 0
Start = 9/6/2011 1:18:37 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= INVDbEngine
State = Program started - No mgt msgs received
Pid = 6900
RC = 0
Signo = 0
Start = 9/6/2011 1:18:39 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= FHPurgeTask
State = Transient terminated
Pid = 0
RC = 0
Signo = 0
Start = 9/7/2011 12:00:00 AM
Stop = 9/7/2011 12:00:01 AM
Core = Not applicable
Info = DPS Task FHPurgeTask completed at Wed Sep 07 00:00:01 CDT 2011. For status check Job Browser UI.
Process= FHDbEngine
State = Program started - No mgt msgs received
Pid = 6932
RC = 0
Signo = 0
Start = 9/6/2011 1:18:45 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= ESS
State = Program started - No mgt msgs received
Pid = 6856
RC = 0
Signo = 0
Start = 9/6/2011 1:18:49 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= EssMonitor
State = Running normally
Pid = 6608
RC = 0
Signo = 0
Start = 9/6/2011 1:18:53 PM
Stop = Not applicable
Core = Not applicable
Info = ESS is fully up now !
Process= EventFramework
State = Program started - No mgt msgs received
Pid = 6224
RC = 0
Signo = 0
Start = 9/6/2011 1:19:00 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= PMServer
State = Running normally
Pid = 1172
RC = 0
Signo = 0
Start = 9/6/2011 1:19:01 PM
Stop = Not applicable
Core = Not applicable
Info = PMServer is up and running
Process= SyslogCollector
State = Program started - No mgt msgs received
Pid = 7408
RC = 0
Signo = 0
Start = 9/6/2011 1:19:05 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= EPMDbEngine
State = Program started - No mgt msgs received
Pid = 7416
RC = 0
Signo = 0
Start = 9/6/2011 1:19:07 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= EPMServer
State = Running normally
Pid = 7760
RC = 0
Signo = 0
Start = 9/6/2011 1:19:11 PM
Stop = Not applicable
Core = Not applicable
Info = EPMServer is up and running
Process= FHServer
State = Running normally
Pid = 8048
RC = 0
Signo = 0
Start = 9/6/2011 1:19:15 PM
Stop = Not applicable
Core = Not applicable
Info = FHServer started.
Process= diskWatcher
State = Running normally
Pid = 8076
RC = 0
Signo = 0
Start = 9/6/2011 1:19:15 PM
Stop = Not applicable
Core = Not applicable
Info = diskWatcher initialized OK.
Process= DFMMultiProcLogger
State = Program started - No mgt msgs received
Pid = 8084
RC = 0
Signo = 0
Start = 9/6/2011 1:19:15 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= DFMLogServer
State = Program started - No mgt msgs received
Pid = 8116
RC = 0
Signo = 0
Start = 9/6/2011 1:19:15 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= DFMCTMStartup
State = Administrator has shut down this server
Pid = 0
RC = 0
Signo = 0
Start = 9/6/2011 1:19:15 PM
Stop = 9/6/2011 1:22:19 PM
Core = Not applicable
Info = Server started by admin request
Process= DfmBroker
State = Program started - No mgt msgs received
Pid = 7548
RC = 0
Signo = 0
Start = 9/6/2011 1:19:15 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= DfmServer
State = Running normally
Pid = 7284
RC = 0
Signo = 0
Start = 9/6/2011 1:19:19 PM
Stop = Not applicable
Core = Not applicable
Info = DfmServer initialized OK.
Process= DfmServer1
State = Running normally
Pid = 7840
RC = 0
Signo = 0
Start = 9/6/2011 1:19:19 PM
Stop = Not applicable
Core = Not applicable
Info = DfmServer1 initialized OK.
Process= DCRDevicePoll
State = Never started
Pid = 0
RC = 0
Signo = 0
Start = N/A
Stop = Not applicable
Core = Not applicable
Info = Not applicable,
Process= CSSCPServer
State = Program started - No mgt msgs received
Pid = 7880
RC = 0
Signo = 0
Start = 9/6/2011 1:19:19 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= CSRegistryServer
State = Running normally
Pid = 7044
RC = 0
Signo = 0
Start = 9/6/2011 1:19:19 PM
Stop = Not applicable
Core = Not applicable
Info = CSRegistryServer is running in other process
Process= CSDiscovery
State = Transient terminated
Pid = 0
RC = 0
Signo = 0
Start = 9/7/2011 1:00:04 AM
Stop = 9/7/2011 3:23:08 AM
Core = Not applicable
Info = Server started by admin request
Process= CmfDbEngine
State = Program started - No mgt msgs received
Pid = 7040
RC = 0
Signo = 0
Start = 9/6/2011 1:19:21 PM
Stop = Not applicable
Core = Not applicable
Info = Application started by administrator request.
Process= CmfDbMonitor
State = Running normally
Pid = 8744
RC = 0
Signo = 0
Start = 9/6/2011 1:19:25 PM
Stop = Not applicable
Core = Not applicable
Info = DbMonitor Running Normally.
Process= DCRServer
State = Running normally
Pid = 8852
RC = 0
Signo = 0
Start = 9/6/2011 1:19:26 PM
Stop = Not applicable
Core = Not applicable
Info = DCRServer is up and running
Process= CMFOGSServer
State = Program started - No mgt msgs received
Pid = 7692
RC = 0
Signo = 0
Start = 9/6/2011 1:20:10 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= CampusOGSServer
State = Program started - No mgt msgs received
Pid = 2172
RC = 0
Signo = 0
Start = 9/6/2011 1:20:14 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= EssentialsDM
State = Running normally
Pid = 9076
RC = 0
Signo = 0
Start = 9/6/2011 1:20:15 PM
Stop = Not applicable
Core = Not applicable
Info = RME Device Management started.
Process= ConfigMgmtServer
State = Program started - No mgt msgs received
Pid = 8872
RC = 0
Signo = 0
Start = 9/6/2011 1:20:20 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= ICServer
State = Running normally
Pid = 9256
RC = 0
Signo = 0
Start = 9/6/2011 1:20:20 PM
Stop = Not applicable
Core = Not applicable
Info = ICServer started.
Process= RMEOGSServer
State = Program started - No mgt msgs received
Pid = 9264
RC = 0
Signo = 0
Start = 9/6/2011 1:20:20 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= PMCOGSServer
State = Program started - No mgt msgs received
Pid = 9624
RC = 0
Signo = 0
Start = 9/6/2011 1:20:24 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= TISServer
State = Program started - No mgt msgs received
Pid = 9672
RC = 0
Signo = 0
Start = 9/6/2011 1:20:25 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= DFMOGSServer
State = Program started - No mgt msgs received
Pid = 10208
RC = 0
Signo = 0
Start = 9/6/2011 1:20:29 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= InventoryCollector
State = Running normally
Pid = 9288
RC = 0
Signo = 0
Start = 9/6/2011 1:20:33 PM
Stop = Not applicable
Core = Not applicable
Info = InventoryCollector is up and running
Process= Interactor
State = Program started - No mgt msgs received
Pid = 10496
RC = 0
Signo = 0
Start = 9/6/2011 1:20:37 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= InventoryCollector1
State = Program started - No mgt msgs received
Pid = 10504
RC = 0
Signo = 0
Start = 9/6/2011 1:20:37 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= Interactor1
State = Program started - No mgt msgs received
Pid = 11004
RC = 0
Signo = 0
Start = 9/6/2011 1:20:41 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= NOSServer
State = Running normally
Pid = 11012
RC = 0
Signo = 0
Start = 9/6/2011 1:20:41 PM
Stop = Not applicable
Core = Not applicable
Info = NOSServer is up and running
Process= PTMServer
State = Running normally
Pid = 11024
RC = 0
Signo = 0
Start = 9/6/2011 1:20:41 PM
Stop = Not applicable
Core = Not applicable
Info = Started Successfully
Process= UPMProcess
State = Administrator has shut down this server
Pid = 0
RC = 1
Signo = 0
Start = 9/6/2011 1:20:41 PM
Stop = 9/6/2011 1:22:19 PM
Core = Not applicable
Info = UPMProcess started successfully.
Process= EDS-GCF
State = Running normally
Pid = 11176
RC = 0
Signo = 0
Start = 9/6/2011 1:20:41 PM
Stop = Not applicable
Core = Not applicable
Info = GCF Initialization complete at Tue Sep 06 13:21:51 CDT 2011
Process= jrm
State = Running normally
Pid = 11208
RC = 0
Signo = 0
Start = 9/6/2011 1:20:41 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= 1012
State = Never started
Pid = 0
RC = 0
Signo = 0
Start = N/A
Stop = Not applicable
Core = Not applicable
Info = Not applicable,
Process= 1425
State = Never started
Pid = 0
RC = 0
Signo = 0
Start = N/A
Stop = Not applicable
Core = Not applicable
Info = Not applicable,
Process= 2072
State = Never started
Pid = 0
RC = 0
Signo = 0
Start = N/A
Stop = Not applicable
Core = Not applicable
Info = Not applicable,
Process= 3886
State = Never started
Pid = 0
RC = 0
Signo = 0
Start = N/A
Stop = Not applicable
Core = Not applicable
Info = Not applicable,
Process= CTMJrmServer
State = Running normally
Pid = 12068
RC = 0
Signo = 0
Start = 9/6/2011 1:22:00 PM
Stop = Not applicable
Core = Not applicable
Info = CTMJrmServer started.
Process= ChangeAudit
State = Program started - No mgt msgs received
Pid = 11680
RC = 0
Signo = 0
Start = 9/6/2011 1:22:10 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= SyslogAnalyzer
State = Program started - No mgt msgs received
Pid = 11504
RC = 0
Signo = 0
Start = 9/6/2011 1:22:10 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= DataPurge
State = Administrator has shut down this server
Pid = 0
RC = 0
Signo = 0
Start = 9/6/2011 1:22:10 PM
Stop = 9/6/2011 1:22:49 PM
Core = Not applicable
Info = DataPurge initialization completed at Tue Sep 06 13:22:49 CDT 2011.
Process= ANIDbEngine
State = Program started - No mgt msgs received
Pid = 5384
RC = 0
Signo = 0
Start = N/A
Stop = Not applicable
Core = Not applicable
Info = Service was already running
Process= ANIServer
State = Running with busy flag set
Pid = 6708
RC = 0
Signo = 0
Start = 9/6/2011 1:22:14 PM
Stop = Not applicable
Core = Not applicable
Info = ANIServer started.
Process= UTMajorAcquisition
State = Transient terminated
Pid = 0
RC = 0
Signo = 0
Start = 9/6/2011 6:00:00 PM
Stop = 9/7/2011 3:31:19 AM
Core = Not applicable
Info = Server started by admin request
Process= MACUHIC
State = Running normally
Pid = 6280
RC = 0
Signo = 0
Start = 9/6/2011 1:22:18 PM
Stop = Not applicable
Core = Not applicable
Info = Started.
Process= UTLITE
State = Running normally
Pid = 6344
RC = 0
Signo = 0
Start = 9/6/2011 1:22:18 PM
Stop = Not applicable
Core = Not applicable
Info = Started.
Process= UTManager
State = Running normally
Pid = 6620
RC = 0
Signo = 0
Start = 9/6/2011 1:22:18 PM
Stop = Not applicable
Core = Not applicable
Info = Started.
Process= VNMServer
State = Program started - No mgt msgs received
Pid = 11672
RC = 0
Signo = 0
Start = 9/6/2011 1:22:18 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= WlseUHIC
State = Running normally
Pid = 11768
RC = 0
Signo = 0
Start = 9/6/2011 1:22:18 PM
Stop = Not applicable
Core = Not applicable
Info = Started.
Process= AdapterServer1
State = Program started - No mgt msgs received
Pid = 10852
RC = 0
Signo = 0
Start = 9/6/2011 1:22:18 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Process= AdapterServer
State = Program started - No mgt msgs received
Pid = 844
RC = 0
Signo = 0
Start = 9/6/2011 1:22:18 PM
Stop = Not applicable
Core = Not applicable
Info = Server started by admin request
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide