Chinese characters being sent to TmpV2: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
→‎Pharmacy Duplication??: deleted because addressed in Clean-up required when re-sending, which Trish mentions further up, so I am sure Pagasa is aware of it.
Line 27: Line 27:
#*HSC_SICU,(not sure why SICU affected)  
#*HSC_SICU,(not sure why SICU affected)  
#*GRA_N3, STB_E5
#*GRA_N3, STB_E5
== Pharmacy Duplication?? ==
{{discussion}}
* "will check with Julie how to handle more duplicate in pharmacy.mdb.--[[User:TOstryzniuk|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.[[User:TOstryzniuk|Trish Ostryzniuk]] 14:26, 2013 July 15 (CDT)

Revision as of 09:58, 2013 August 29

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

  1. August 20.13
  2. 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?
  3. 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 column in tmpV2.
  4. June 11.13
    • GRA_N3, HSC_B3/D5
  5. June 6.13
    • VIC_S4
  6. June 5.13
    • HSC_SICU,(not sure why SICU affected)
    • GRA_N3, STB_E5
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Chinese_characters_being_sent_to_TmpV2&oldid=34835"