Notes

#wait_timeout = 30
#interactive_timeout = 30

http://192.168.0.213:7070/mobiledoc/jsp/catalog/xml/CheckServerVersion.jsp
http://10.123.50.72:9090/mobiledoc/jsp/catalog/xml/CheckDBConnection.jsp

http://192.168.0.213:7070/mobiledoc/jsp/dbtools/upgradesqlsrv.jsp

SELECT * FROM upgrade_sqlversions ORDER BY id DESC;
SELECT * FROM upgradekeys ORDER BY id DESC;
SELECT * FROM itemkeys WHERE NAME='enableRxHub';
SELECT * FROM itemkeys WHERE NAME='MaxClaims';
SELECT * FROM serverdetails;
SELECT * FROM itemkeys WHERE NAME='MACADDRESSForAPPSERVER';
SELECT * FROM itemkeys WHERE NAME='icd10EffectiveDate';
SELECT * FROM itemkeys WHERE NAME='ICD9ToIcd10GemsInHostedSErver';
SELECT * FROM itemkeys WHERE NAME='enableicd10forsmartsearchicd';
SELECT * FROM itemkeys WHERE NAME='enableicd9toicd10mapping';
SELECT COUNT(*) FROM hcfa_fields_map;
SELECT * FROM itemkeys WHERE NAME='EnableDefaultWebPageControl';
SELECT * FROM itemkeys WHERE NAME='IpadSecurityType';
SELECT COUNT(*) FROM loincmaster;
SELECT COUNT(*) FROM ebocaldate;
SELECT COUNT(*) FROM x12837mapper5010;
SELECT COUNT(*) FROM x12837imapper5010;
SELECT COUNT(*) FROM x12837dmapper5010;
SELECT COUNT(*) FROM x12270mapper5010;
SELECT * from itemkeys where name='voicejobserver';
SELECT * from itemkeys where name='EnableVoiceInterface';



Upgrade_SQLVersions: 1211 jsp.10.0.80.SP1C-5.6
UpgradeKeys: 54 CCMRProblemTeplateMappingInsert


insert into patchesfiles (patchid,filename,FixType,FileType,FilePath,FileVersion,fileDir,filesize,displayname) values (3088,'10080 SP1C-20.8_AU_Client.zip',NULL,'Client','','10.0.80 SP1C-20.8','20160918',222389199,'962016');
insert into patchesfiles (patchid,filename,FixType,FileType,FilePath,FileVersion,fileDir,filesize,displayname) values (3088,'10080 SP1C-20.8_AU_Server.zip',NULL,'Server','','10.0.80 SP1C-20.8','20160918',22,'962016');
insert into patchesfiles (patchid,filename,FixType,FileType,FilePath,FileVersion,fileDir,filesize,displayname) values (3088,'10080 SP1C-20.8_AU_Tool.zip',NULL,'Tool','','10.0.80 SP1C-20.8','20160918',22,'962016');

insert into patcheslist (id,ecwpatchid,status,patchdescription,Messages,patchversion,seriesid) values (63,3088,'complete','10.0.80 SP1C-20.8 ','10.0.80 SP1C-20nnnWe have enabled you for your SP1C20 update.nnAction Required by Customern------------------------------------nnIf you have been running APU yourself on a Single Server architecture, please accept this patch (#3088) by running APU. nnIn case of Multiple Server or Linux or Cloud hosted architecture, please contact eClinicalWorks to get this update scheduled. ',' ',1014);