Chinese characters being sent to TmpV2
Intermittently, contents of all the com_var field (eg Postal code or overstay color) in TMPV2 are corrupted/scrambled into "Chinese characters" on send.
This started 2013-06-05. Initially the thought was that doing a compact on the data file before sending would fix the problem. CCMDB.mdb was updated as part of CCMDB.mdb_Change_Log_2013#ver_2013-06-10 to compact/repair to run each time the program is started. However, there appear to have been cases where the problem has happened even right after a compact.
Occurrence Log
- August 20.13
- GRA/MED-N3-Batch#32
- IPagasa made changes to centralized.mdb and resent from backup herself. deleted duplicates from other database.
- emailed Stephanie to find out if she has any idea why. Ttenbergen 09:25, 2013 August 22 (CDT)
- IPagasa made changes to centralized.mdb and resent from backup herself. deleted duplicates from other database.
- GRA/MED-N3-Batch#32
- August 14.13
- HSC/B3-D5 Batch#33
- no problems for a while, but today Lou had a chinese character in her send... I emailed her and Pagasa to find out if they have any idea why there were chinese characters... Ttenbergen 15:54, 2013 August 15 (CDT)
- comment from Lou: "When I came in to work Wed, I remember now that I did not fully shut down computer but just did my “News and Backup” and logged off.[Went to the biffy and forgot to totally shut down] (I only noticed when I came in next day and didn’t have such a long start up time.) Maybe this was the issue as it wouldn’t have booted up with the latest changes in CMDB or server .?
- no problems for a while, but today Lou had a chinese character in her send... I emailed her and Pagasa to find out if they have any idea why there were chinese characters... Ttenbergen 15:54, 2013 August 15 (CDT)
- HSC/B3-D5 Batch#33
- July 3.13
- STB_CICU & HSC_B3/D5:
- Trish and Sheila R have Resent the files from backup for:
- STB CICU batch 21
- HSC B3/D5 batch 27
- Deleted files with chinese in comment in tmpV2.
- Trish and Sheila R have Resent the files from backup for:
- STB_CICU & HSC_B3/D5:
- June 11.13
- GRA_N3, HSC_B3/D5
- June 6.13
- VIC_S4
- June 5.13
- HSC_SICU,(not sure why SICU affected),
- GRA_N3, STB_E5
Pharmacy Duplication??
- "will check with Julie how to handle more duplicate in pharmacy.mdb.--Trish Ostryzniuk 17:21, 2013 July 9 (CDT)"
- I picked this comment up from somewhere else where it was written between chinese character problem description. It seems unrelated. Is this an issue, and if so, what is the problem? Ttenbergen 09:53, 2013 July 15 (CDT)
- It has nothing to do with TmpV2, it has to do with resending files and how Pagasa actually handles duplicates in pharmacy.mdb or what the practice is.12:29, 2013 July 15 (CDT)
- Is it addressed and documented then? Just want to be sure before I just delete it from here. Ttenbergen 13:09, 2013 July 15 (CDT)
- Pagasa is back next Tuesday and will have to review it with Julie.Trish Ostryzniuk 14:26, 2013 July 15 (CDT)
- Is it addressed and documented then? Just want to be sure before I just delete it from here. Ttenbergen 13:09, 2013 July 15 (CDT)
- It has nothing to do with TmpV2, it has to do with resending files and how Pagasa actually handles duplicates in pharmacy.mdb or what the practice is.12:29, 2013 July 15 (CDT)
- I picked this comment up from somewhere else where it was written between chinese character problem description. It seems unrelated. Is this an issue, and if so, what is the problem? Ttenbergen 09:53, 2013 July 15 (CDT)