Hi,
Confirmed, the upload worked when at 2.7.4
Incidentally, to help someone else who may be struggling with a manual upgrade from 2.7.3.1 to 2.7.4 you might get see an error thrown when trying to upgrade the SP. eg:
[root@sntc info]# /opt/LCM/tmp/install.sh SP /opt/LCM/tmp/sp-30.0.4-0-0-lnx64.zip
Appliance will auto reboot once the patch installation is completed. Press [y/Y] to proceed for installation, any other key to exit :y
Installing SP patch...
Patch installation in-progress, system will auto reboot once the patch installation is completed.
Kindly refer the logs in /opt/LCM/logs/ directory for more information.
[root@sntc info]# no such table: UPDATES
while executing
"db eval "UPDATE UPDATES SET PACKAGE_STATUS='Apply-in-progress', APPLY_START='$start_timestamp', APPLY_END='' WHERE PACKAGE_TYPE='$sw_type' AND CURRENT..."
invoked from within
"if {$output != ""} {
set env(QUERY) "UPDATE UPDATES SET PACKAGE_STATUS='Apply-in-progress', APPLY_START='$start_timestamp', APPLY_END='' WHERE PACKAG..."
(file "/opt/LCM/bin/lcmagent-apply.tcl" line 1047)
Looking at updates.db we see there is no updates table, but the file exists. In lcmagent-apply.tcl there is some code to make the updates table if the file doesnt exist. But even if you delete / rename the updates file, lcmagent-apply.tcl doesnt create the table, but still creates the db file. Heres how I fixed it
[root@sntc info]# cd /opt/LCM/info
[root@sntc info]# sqlite3
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>
sqlite> attach "updates.db" as db1;
sqlite> .databases
seq name file
--- --------------- ----------------------------------------------------------
0 main
2 db1 /opt/LCM/info/updates.db
sqlite> SELECT * FROM db1.sqlite_master WHERE type='table';
sqlite>
sqlite> CREATE TABLE db1.UPDATES (PACKAGE_TYPE TEXT NOT NULL, MESSAGE_ID TEXT, MESSAGE_RESPONSE TEXT, CURRENT_VERSION TEXT NOT NULL, AVAILABLE_VERSION TEXT, PACKAGE_LOCATION TEXT, PACKAGE_STATUS TEXT, DOWNLOAD_PERCENTAGE TEXT, PACKAGE_DESCRIPTION TEXT, PACKAGE_SIZE INTEGER, DOWNLOAD_START TEXT, DOWNLOAD_END TEXT, APPLY_START TEXT, APPLY_END TEXT, APPLY_DETAILS TEXT, PRIMARY KEY (PACKAGE_TYPE, CURRENT_VERSION, AVAILABLE_VERSION));
sqlite>
sqlite> SELECT * FROM db1.sqlite_master WHERE type='table';
table|UPDATES|UPDATES|2|CREATE TABLE UPDATES (PACKAGE_TYPE TEXT NOT NULL, MESSAGE_ID TEXT, MESSAGE_RESPONSE TEXT, CURRENT_VERSION TEXT NOT NULL, AVAILABLE_VERSION TEXT, PACKAGE_LOCATION TEXT, PACKAGE_STATUS TEXT, DOWNLOAD_PERCENTAGE TEXT, PACKAGE_DESCRIPTION TEXT, PACKAGE_SIZE INTEGER, DOWNLOAD_START TEXT, DOWNLOAD_END TEXT, APPLY_START TEXT, APPLY_END TEXT, APPLY_DETAILS TEXT, PRIMARY KEY (PACKAGE_TYPE, CURRENT_VERSION, AVAILABLE_VERSION))
sqlite>
then exit sqlite and try your SP install again...
Fixed it for me anyway.
Sandy
