· web viewsymptom from our wallboard : if we take a look at cuic it similar with the article...
TRANSCRIPT
Symptom from our wallboard :
If we take a look at CUIC it similar with the article written by Saurabh https://supportforums.cisco.com/blog/13119781/cscvb27878-uccxcuic-overflow-occurred-datetime-or-interval-operation
Resolution:
Tools: Putty and 3CDaemon
1. Configure 3CDaemon, tick on Upload, select user Directory (where you’re going to put ciscouccx.ReportFix.cop.sgn file) and save profile/apply
2. Put your file (ciscouccx.ReportFix.cop.sgn) into C:\Temp (your laptop directory), make sure you give Everyone full access on C:\Temp
3. Start your 3C Daemon FTP Server
4. I use Putty for Telnet into Publisher, here are the log
admin:utils system upgrade initiate
Warning: Do not close this window without first canceling the upgrade.
Source:
1) Remote Filesystem via SFTP
2) Remote Filesystem via FTP
3) Local DVD/CD
q) quit
Please select an option (1 - 3 or "q" ): 2
Directory: /
Server: 10.34.171.203 my laptop ip address which has 3cDaemon installed
User Name: valenet\riyada
Password: ************
Please enter SMTP Host Server (optional):
Checking for valid upgrades. Please wait...
Available options and upgrades in "10.34.171.203:/":
1) ciscouccx.ReportFix.cop.sgn
q) quit
Please select an option (1 - 1 or "q" ): 1
Accessing the file. Please wait...
A system reboot is required when the upgrade process completes or is canceled. This will ensure services affected by the upgrade process are functioning properly.
Downloaded: ciscouccx.ReportFix.cop.sgn
File checksum: ae:3d:f7:bb:de:ab:bb:97:53:65:84:cd:86:af:8d:5b
Start installation (yes/no): yes
The upgrade log is install_log_2016-10-07.09.31.48.log
Upgrading the system. Please wait...
10/07/2016 09:31:49 file_list.sh|Starting file_list.sh|<LVL::Info>
10/07/2016 09:31:49 file_list.sh|Parse argument method=remote_ftp|<LVL::Debug>
10/07/2016 09:31:49 file_list.sh|Parse argument source_dir=/|<LVL::Debug>
10/07/2016 09:31:49 file_list.sh|Parse argument dest_file=/var/log/install/downloaded_versions|<LVL::Debug>
10/07/2016 09:31:49 file_list.sh|Parse argument remote_host=10.34.171.203|<LVL::Debug>
10/07/2016 09:31:49 file_list.sh|Parse argument user_name=valenet\riyada|<LVL::Debug>
10/07/2016 09:31:49 file_list.sh|is_upgrade_lock_available: Upgrade lock is available.|<LVL::Debug>
10/07/2016 09:31:49 file_list.sh|acquire_upgrade_lock: Lock is free, creating lock (pid: 15594)|<LVL::Debug>
10/07/2016 09:31:49 file_list.sh|clear_upgrade_status: Status file does not exist|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|Parse argument fromVersion=9.0.2.11001-24|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|_set_upgrade_status_attribute: fromVersion set to 9.0.2.11001-24|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|Parse argument status=upgrade.stage.determining.files|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|_set_upgrade_status_attribute: status set to upgrade.stage.determining.files|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|Process remote FTP request|<LVL::Info>
10/07/2016 09:31:51 file_list.sh|Calling FTP command with metering off|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|FTP command complete (0)|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|List file (pre-filtered):|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|(CAPTURE) .|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|(CAPTURE) ..|<LVL::Debug>
10/07/2016 09:31:51 file_list.sh|(CAPTURE) -20160923-093714.log|<LVL::Debug>
I cut this part then finally we got
[16/10/07_09:33:11] locale_install.sh: Successful untarring of /common/download//ciscouccx.ReportFix.cop
IBM Informix Dynamic Server Version 11.50.UC9X7 -- On-Line -- Up 09:45:37 -- 254164 Kbytes
executing sql file: /opt/cisco/uccx/sql/SPutility.sql
executing sql file: /opt/cisco/uccx/sql/uccx_roles.sql
IBM Informix Dynamic Server Version 11.50.UC9X7 -- On-Line -- Up 09:45:39 -- 254164 Kbytes
executing sql file: /opt/cisco/uccx/sql/IDS_EEMtables.sql
executing sql file: /opt/cisco/uccx/sql/EEM_roles.sql
executing sql file: /opt/cisco/uccx/sql/EEM_roles2.sql
. . .
To view this log file, use the following cli command.
admin: file view install ciscouccx.ReportFix.cop.log
. . .
To download this log file, use the following cli command.
admin: file get install ciscouccx.ReportFix.cop.log
. . .
[16/10/07_09:33:45] locale_install.sh: Not running installdb.
[16/10/07_09:33:45] locale_install.sh: Successful running of copstart for /common/download//ciscouccx.ReportFix.cop
Successfully installed ciscouccx.ReportFix.cop.sgn
Locale ciscouccx.ReportFix.cop has been installed successfully. A reboot is not necessary for the changes to take effect.
5. Do the same thing for Subscriber
Testing the Resolution
Alhamdulillah we can see the dashboard now
admin: