Chinese characters being sent to TmpV2: Difference between revisions
Jump to navigation
Jump to search
TOstryzniuk (talk | contribs) |
TOstryzniuk (talk | contribs) |
||
| Line 8: | Line 8: | ||
#August 20.13 | #August 20.13 | ||
#*GRA/MED-N3-Batch#32 | #*GRA/MED-N3-Batch#32 | ||
#**Pagasa made changes to [[ Centralized data.mdb]] and [[Re-sending data | | #**[[Pagasa Torres]] made changes to [[ Centralized data.mdb]] and [[Re-sending data | RESENT]] the data herself from backup of GRA_N3 ccmdb.data.mdb that is store on the [[Regional Server]] in the output folder. She also [[Clean-up required when re-sending | Cleaned up other database]] where duplicate were sent to. | ||
#***emailed Stephanie to find out if she has any idea why. Ttenbergen 09:25, 2013 August 22 (CDT) | #***emailed [[Stephanie Cortilet]] to find out if she has any idea why. Ttenbergen 09:25, 2013 August 22 (CDT) | ||
#August 14.13 | #August 14.13 | ||
#*HSC/B3-D5 Batch#33 | #*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) | #**no problems for a while, but today [[Louise Lemoine | 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. | #***comment from [[Louise Lemoine | 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? | ||
#July 3.13 | #July 3.13 | ||
#*STB_CICU & HSC_B3/D5: | #*STB_CICU & HSC_B3/D5: | ||
Revision as of 13:04, 2013 August 22
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
- Pagasa Torres made changes to Centralized data.mdb and RESENT the data herself from backup of GRA_N3 ccmdb.data.mdb that is store on the Regional Server in the output folder. She also Cleaned up other database where duplicate were sent to.
- emailed Stephanie Cortilet to find out if she has any idea why. Ttenbergen 09:25, 2013 August 22 (CDT)
- Pagasa Torres made changes to Centralized data.mdb and RESENT the data herself from backup of GRA_N3 ccmdb.data.mdb that is store on the Regional Server in the output folder. She also Cleaned up other database where duplicate were sent to.
- 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)