Chinese characters being sent to TmpV2: Difference between revisions
Ttenbergen (talk | contribs) →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. |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 3: | Line 3: | ||
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. | 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. | ||
== Troubleshooting Log == | |||
As of [[CCMDB.mdb_Change_Log_2013#ver_2013-08-12]] all data incl. tmp will be sent to [[Centralized_data.mdb]]. For the moment this is in duplication of sending to [[TmpV2_1.mdb]], but it will replace that process eventually. In the meantime I would be interested to see if, in the cases where Chinese characters are being sent, ''both'' targets get Chinese characters. Will check as I see an update in the occurrence log. Ttenbergen 11:03, 2013 August 29 (CDT) | |||
== Occurrence Log == | == Occurrence Log == | ||
#August 20.13 | #August 20.13 | ||
#*GRA/MED-N3-Batch#32 | #*GRA/MED-N3-Batch#32 | ||
Revision as of 10:03, 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.
Troubleshooting Log
As of CCMDB.mdb_Change_Log_2013#ver_2013-08-12 all data incl. tmp will be sent to Centralized_data.mdb. For the moment this is in duplication of sending to TmpV2_1.mdb, but it will replace that process eventually. In the meantime I would be interested to see if, in the cases where Chinese characters are being sent, both targets get Chinese characters. Will check as I see an update in the occurrence log. Ttenbergen 11:03, 2013 August 29 (CDT)
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 column 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