{"type":"doc","content":[{"type":"paragraph","content":[{"text":"This page is a generic place to make a note of sync bugs encountered, and how the bug was cleared. The idea now is just to get to this page started... as it becomes larger, we will have to work on better organization.","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG:","type":"text","marks":[{"type":"strong"}]},{"text":" Sync record fails to import because on a parent server, a record containing an obs is generated before the record for the owning encounter. ","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS","type":"text","marks":[{"type":"strong"}]},{"text":": Error message in logs on child server similar to the following:","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - HibernateSyncDAO.processCollection(1191) |2012-06-20 15:58:59,800| Cannot retrieve the collection's owner object.","type":"text"},{"type":"hardBreak"},{"text":" ERROR - HibernateSyncDAO.processCollection(1192) |2012-06-20 15:58:59,801| Owner info:","type":"text"},{"type":"hardBreak"},{"text":" ownerClassName:org.openmrs.Encounter","type":"text"},{"type":"hardBreak"},{"text":" ownerCollectionPropertyName:obs","type":"text"},{"type":"hardBreak"},{"text":" ownerCollectionAction:update","type":"text"},{"type":"hardBreak"},{"text":" ownerUuid:d29a071d-4839-4cc2-8056-666bf4f8ec0dERROR - HibernateSyncDAO.processCollection(1191) |2012-06-20 15:58:59,800| Cannot retrieve the collection's owner object.","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE:","type":"text","marks":[{"type":"strong"}]},{"text":" Unknown... underlying sync issue still needs to be researched.","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION:","type":"text","marks":[{"type":"strong"}]},{"text":" To clear the error, mark the offending obs record(s) to be ignored against all child servers. Then on the parent server, go to the encounter and edit all the obs. (An easy way to do this is simply to add an edit comment like \"fixing sync issue\" without actually making any changes to obs itself). This will cause a new sync record to be generated with the obs data. Confirm that this record (or records) syncs, and then confirm through the ui that the encounter + obs are identical on both parent and child.","type":"text"}]},{"type":"paragraph","content":[{"text":"—","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG:","type":"text","marks":[{"type":"strong"}]},{"text":" Maximum Retry Count Reached, Will No Longer Retry","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS","type":"text","marks":[{"type":"strong"}]},{"text":": The server has attempted to send the sync record too many times and is giving up.","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE:","type":"text","marks":[{"type":"strong"}]},{"text":" The receiving server is encountering an error when importing that record.","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION:","type":"text","marks":[{"type":"strong"}]}]},{"type":"orderedList","attrs":{"order":1},"content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Check the server logs of the server receiving that record. Try to fix according to error message in server log.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Increase the \"retry limit\" for the first server temporarily so that the records are attempted to send again ","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"___","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG:","type":"text","marks":[{"type":"strong"}]},{"text":" Sync record fails to import because somehow on the server the record was created on, the user (..creator of the record) got replaced after the sync record was created and the UUID for the user in the sync record screen doesn't seem to exist.","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS:","type":"text","marks":[{"type":"strong"}]},{"text":" This example shows an Error message in logs on parent server when a user on the child (..who exists also on the parent) has created a patient, and Sync replaced his uuid when the sync record was created","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncIngestServiceImpl.processOpenmrsObject(562) |2013-02-20 10:18:23,380| Unexpected exception occurred while saving openmrsobject: org.openmrs.Patient, uuid 'c62287c2-f645-44ce-92c2-bcb6d3074d52'","type":"text"},{"type":"hardBreak"},{"text":" ERROR - SyncIngestServiceImpl.processSyncRecord(298) |2013-02-20 10:18:23,382| Unable to ingest a sync request","type":"text"},{"type":"hardBreak"},{"text":" org.openmrs.module.sync.ingest.SyncIngestException: Could not save item for unknown reasons - could not insert: [org.openmrs.Patient]","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processOpenmrsObject(SyncIngestServiceImpl.java:563)","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncItem(SyncIngestServiceImpl.java:423)","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.GeneratedMethodAccessor1145.invoke(Unknown Source)","type":"text"}]},{"type":"paragraph","content":[{"text":"...down the stack trace","type":"text"}]},{"type":"paragraph","content":[{"text":"Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'creator' cannot be null","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.GeneratedConstructorAccessor304.newInstance(Unknown Source)","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE:","type":"text","marks":[{"type":"strong"}]},{"text":" Unknown...","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION:","type":"text","marks":[{"type":"strong"}]},{"text":" For this example, identify the real creator of the record first and then from the sync record screen, replace the UUID for the openmrs user with the correct uuid and try and resend the record.","type":"text"}]},{"type":"paragraph","content":[{"text":"____","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG","type":"text","marks":[{"type":"strong"}]},{"text":": Sync record fails to import on the a server because the record contains a relationship and one person in the relationship is missing in the current sever database.","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS","type":"text","marks":[{"type":"strong"}]},{"text":": Error message in logs on the receiving server similar to the following:","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncIngestServiceImpl.processOpenmrsObject(562) |2013-03-20 10:17:44,756| Unexpected exception occurred while saving openmrsobject: org.openmrs.Relationship, uuid '*","type":"text"},{"text":"*","type":"text","marks":[{"type":"strong"}]},{"text":"*","type":"text"},{"text":"**","type":"text","marks":[{"type":"strong"}]},{"text":"**","type":"text"},{"text":"*","type":"text","marks":[{"type":"strong"}]},{"text":"*","type":"text"},{"text":"-","type":"text","marks":[{"type":"strong"}]},{"text":"*","type":"text"},{"text":"*","type":"text","marks":[{"type":"strong"}]},{"text":"******'","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncIngestServiceImpl.processSyncRecord(298) |2013-03-20 10:17:44,758| Unable to ingest a sync request","type":"text"}]},{"type":"paragraph","content":[{"text":"org.openmrs.module.sync.ingest.SyncIngestException: Could not save item for unknown reasons - not-null property references a null or transient value: org.openmrs.Relationship.personA","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processOpenmrsObject(SyncIngestServiceImpl.java:563)","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncItem(SyncIngestServiceImpl.java:423)","type":"text"}]},{"type":"paragraph","content":[{"text":"at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)","type":"text"}]},{"type":"paragraph","content":[{"text":"......down the stack trace","type":"text"}]},{"type":"paragraph","content":[{"text":"Caused by: org.hibernate.PropertyValueException: not-null property references a null or transient value: org.openmrs.Relationship.personA","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.hibernate.engine.Nullability.checkNullability(Nullability.java:100)","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:312)","type":"text"}]},{"type":"paragraph","content":[{"text":"......down the stack trace","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncUtilTransmission.processSyncTransmission(499) |2013-03-20 10:17:44,795| Sync error while ingesting records for server: [Server Name]","type":"text"}]},{"type":"paragraph","content":[{"text":"org.openmrs.module.sync.ingest.SyncIngestException: Could not save item for unknown reasons - not-null property references a null or transient value: org.openmrs.Relationship.personA","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processOpenmrsObject(SyncIngestServiceImpl.java:563)","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncItem(SyncIngestServiceImpl.java:423)","type":"text"}]},{"type":"paragraph","content":[{"text":"at sun.reflect.GeneratedMethodAccessor510.invoke(Unknown Source)","type":"text"}]},{"type":"paragraph","content":[{"text":"...","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE","type":"text","marks":[{"type":"strong"}]},{"text":": Unknown...","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]}]},{"type":"paragraph","content":[{"text":"-Check to confirm that the person is missing on the receiving server","type":"text"}]},{"type":"paragraph","content":[{"text":"-Go on the server that sent the record and mark the failing record to be ignored ( use the “Remove as NOT SUPPOSED TO SYNC” link)","type":"text"}]},{"type":"paragraph","content":[{"text":"-On that server again , go to Manage Persons, search for the person and try to save the person again. This will cause a new sync record to be generated with the person data","type":"text"}]},{"type":"paragraph","content":[{"text":"-Confirm that this record syncs and go on the receiving server to see if the person has been created","type":"text"}]},{"type":"paragraph","content":[{"text":"-Go back to the sending server and set the failing record as a new sync record (by clicking the “Reset as NEW Sync Record” link)","type":"text"}]},{"type":"paragraph","content":[{"text":"-Confirm that the new record syncs, and Go to the receiving server to see if the record has been created","type":"text"}]},{"type":"paragraph","content":[{"text":"_____","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG","type":"text","marks":[{"type":"strong"}]},{"text":": Sync record fails to import because there is a missing PersonAttribute on a the current server.","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS","type":"text","marks":[{"type":"strong"}]},{"text":": Error message in logs on the server similar to the following:","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - HibernateSyncDAO.processCollection(1273) |2013-03-25 09:27:29,935| Was not able to retrieve reference to the collection entry object by uuid.","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - HibernateSyncDAO.processCollection(1274) |2013-03-25 09:27:29,936| Entry info: ","type":"text"}]},{"type":"paragraph","content":[{"text":"entryClassName: org.openmrs.PersonAttribute","type":"text"}]},{"type":"paragraph","content":[{"text":"entryUuid: 1813db65-a474-4af0-8132-b388ff13a9c0","type":"text"}]},{"type":"paragraph","content":[{"text":"entryAction: update","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - HibernateSyncDAO.processCollection(1276) |2013-03-25 09:27:29,937| Sync record original uuid: 70358145-774b-4b91-b0c0-41615071552e|18792d72-7338-11e0-96bf-001e68a9fdcf","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncIngestServiceImpl.processSyncRecord(298) |2013-03-25 09:27:29,940| Unable to ingest a sync request","type":"text"}]},{"type":"paragraph","content":[{"text":"org.openmrs.module.sync.ingest.SyncIngestException: Could not find an object of type: org.openmrs.Patient missing org.openmrs.PersonAttribute with a uuid 1813db65-a474-4af0-8132-b388ff13a9c0","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.openmrs.module.sync.api.db.hibernate.HibernateSyncDAO.processCollection(HibernateSyncDAO.java:1277)","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncItem(SyncIngestServiceImpl.java:420)","type":"text"}]},{"type":"paragraph","content":[{"text":"....","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE","type":"text","marks":[{"type":"strong"}]},{"text":": The receiving server doesn't have the PersonAttribute specified in the sync record.","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION","type":"text","marks":[{"type":"strong"}]},{"text":": I couldn't find a way to get a sync record with all the elements as the original one created, so I had to use manual sql to get the missing PersonAttribute created.","type":"text"}]},{"type":"paragraph","content":[{"text":"-Go first to the server that sent the record and check column values for the offending PersonAttribute. In my case, on the sending server I ran:","type":"text"}]},{"type":"codeBlock","content":[{"text":" SELECT * FROM person_attribute where uuid=\"1813db65-a474-4af0-8132-b388ff13a9c0\"; ","type":"text"}]},{"type":"paragraph","content":[{"text":"-Then use the values you get to run the insert statement on the server that is missing the record:","type":"text"}]},{"type":"codeBlock","content":[{"text":"INSERT INTO person_attribute (person_id, value, person_attribute_type_id, creator,\ndate_created, changed_by, date_changed, voided, voided_by, date_voided, void_reason, uuid )\nSELECT (select person_id from person where uuid = \"5cd067a6-5845-11df-b810-001e68a9fdcf\"), 67, 7, 9324, '2012-10-15 11:05:46',10647, '2013-03-21 10:33:08',1, 9324,\n'2013-03-21 10:39:58', 'New value: 75', '1813db65-a474-4af0-8132-b388ff13a9c0' FROM person_attribute\nWHERE NOT EXISTS (SELECT * FROM person_attribute where\nuuid = \"1813db65-a474-4af0-8132-b388ff13a9c0\")\nLIMIT 1;\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"---------","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"A sync record fails to import on a child server because when the parent server received the sync record (...from the original server where the record was created), it created the record but gave it a null payload.","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS","type":"text","marks":[{"type":"strong"}]},{"text":": Error message in logs on the server similar to the following:","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncIngestServiceImpl.processSyncRecord(306) |2013-05-16 10:27:18,546| Unexpected exception occurred when processing sync records","type":"text"},{"type":"hardBreak"},{"text":"java.lang.NullPointerException","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncRecord(SyncIngestServiceImpl.","type":"text"},{"text":"java:198","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:198"}}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.GeneratedMethodAccessor530.invoke(Unknown Source)","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)","type":"text"},{"type":"hardBreak"},{"text":" at java.lang.reflect.Method.invoke(Method.","type":"text"},{"text":"java:597","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:597"}}]},{"text":")","type":"text"}]},{"type":"paragraph","content":[{"text":"...","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncUtilTransmission.processSyncTransmission(499) |2013-05-16 10:27:19,929| Sync error while ingesting records for server: Rwinkwavu","type":"text"},{"type":"hardBreak"},{"text":"org.openmrs.module.sync.ingest.SyncIngestException: Unable to process sync record, processing terminated unexpectedly.","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncRecord(SyncIngestServiceImpl.","type":"text"},{"text":"java:310","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:310"}}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.GeneratedMethodAccessor530.invoke(Unknown Source)","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)","type":"text"}]},{"type":"paragraph","content":[{"text":"...","type":"text"}]},{"type":"paragraph","content":[{"text":"Caused by: java.lang.NullPointerException","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncRecord(SyncIngestServiceImpl.","type":"text"},{"text":"java:198","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:198"}}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":" ... 42 more","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE","type":"text","marks":[{"type":"strong"}]},{"text":": Unknown...","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION","type":"text","marks":[{"type":"strong"}]},{"text":": On the parent, identify the id of the failing record and update its payload using its value from the original server.","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"update sync_record set payload ='2008-10-07T00:00:00.000+0200false3cd51772-26fe-102b-80cb-0017a47871b2bcf7fb8e-2700-102b-80cb-0017a47871b23cdd5176-26fe-102b-80cb-0017a47871b21/day x 7 days/weektab(s)1.00d10b690-ce88-404d-9cd4-e82818b7351a53d78221-1fc5-4972-9b3c-7b1e34f50dc5falsefalse2011-07-07T18:34:43.000+020059365770-7a5d-4757-91c7-724f50b87303true0d10b690-ce88-404d-9cd4-e82818b7351a42f04f8c-26fe-102b-80cb-0017a47871b22008-10-07T23:59:00.000+0200]]>' where record_id=\"240689\";","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"---------","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG","type":"text","marks":[{"type":"strong"}]},{"text":": Null pointer exception when importing a record containing an “ExtendedDrugOrder” object. (...from Order Extension Module).","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS","type":"text","marks":[{"type":"strong"}]},{"text":": Error message in logs on the server similar to the following:","type":"text"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncUtilTransmission.processSyncTransmission(499) |2013-10-23 09:35:55,690| Sync error while ingesting records for server: Rwinkwavu","type":"text"},{"type":"hardBreak"},{"text":"org.openmrs.module.sync.ingest.SyncIngestException: Unable to process sync record, processing terminated unexpectedly.","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncRecord(SyncIngestServiceImpl.","type":"text"},{"text":"java:310","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:310"}}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.GeneratedMethodAccessor565.invoke(Unknown Source)","type":"text"},{"type":"hardBreak"},{"text":" at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)","type":"text"},{"type":"hardBreak"},{"text":" at java.lang.reflect.Method.invoke(Method.","type":"text"},{"text":"java:597","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:597"}}]},{"text":")","type":"text"}]},{"type":"paragraph","content":[{"text":"...","type":"text"}]},{"type":"paragraph","content":[{"text":"at org.openmrs.api.context.Daemon$2.run(Daemon.","type":"text"},{"text":"java:116","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:116"}}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":"Caused by: java.lang.NullPointerException","type":"text"},{"type":"hardBreak"},{"text":" at java.lang.Class.isAssignableFrom(Native Method)","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.impl.SyncIngestServiceImpl.processSyncRecord(SyncIngestServiceImpl.","type":"text"},{"text":"java:210","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:210"}}]},{"text":")","type":"text"},{"type":"hardBreak"},{"text":" ... 42 more","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE","type":"text","marks":[{"type":"strong"}]},{"text":": For some reason, when the sync record was created, the \"containedType\" was not indicated in the sync record payload.","type":"text"}]},{"type":"paragraph","content":[{"text":"An example record looks like this:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"html/xml"},"content":[{"text":"2013-09-24T00:00:00.000+02003cd906e8-26fe-102b-80cb-0017a47871b2falsebcf7fb8e-2700-102b-80cb-0017a47871b21/day2.007cc02ad-119d-4f1d-bd4f-6eee80f99eeaeeea8f66-db60-4709-ab64-14c5fc954f01false2013-10-22T10:47:50.593+0200truee171e54d-c5fa-4dba-81c5-8e41bbcf4502false0baed678-15f5-102d-96e4-000c29c2a5d7]]>","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION","type":"text","marks":[{"type":"strong"}]},{"text":": Add the missing \"containedType\" to the sync record payload and the record should now look like this:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"html/xml"},"content":[{"text":"2013-09-24T00:00:00.000+02003cd906e8-26fe-102b-80cb-0017a47871b2falsebcf7fb8e-2700-102b-80cb-0017a47871b21/day2.007cc02ad-119d-4f1d-bd4f-6eee80f99eeaeeea8f66-db60-4709-ab64-14c5fc954f01false2013-10-22T10:47:50.593+0200truee171e54d-c5fa-4dba-81c5-8e41bbcf4502false0baed678-15f5-102d-96e4-000c29c2a5d7]]>","type":"text"}]},{"type":"paragraph","content":[{"text":"Update then the payload of the record with sql command:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"update sync_record set payload ='2013-09-24T00:00:00.000+02003cd906e8-26fe-102b-80cb-0017a47871b2falsebcf7fb8e-2700-102b-80cb-0017a47871b21/day2.007cc02ad-119d-4f1d-bd4f-6eee80f99eeaeeea8f66-db60-4709-ab64-14c5fc954f01false2013-10-22T10:47:50.593+0200truee171e54d-c5fa-4dba-81c5-8e41bbcf4502false0baed678-15f5-102d-96e4-000c29c2a5d7]]>' where record_id=\"333191\";","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"-------","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"BUG","type":"text","marks":[{"type":"strong"}]},{"text":": ","type":"text"},{"text":"A sync record fails to import because the xml of the record got corrupted during the creation of the record","type":"text"}]},{"type":"paragraph","content":[{"text":"DIAGNOSIS","type":"text","marks":[{"type":"strong"}]},{"text":": Error message in logs on the server similar to the following:","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"text":"ERROR - SyncUtilTransmission.processSyncTransmission(499) |2014-05-06 06:41:33,605| Sync error while ingesting records for server: Kirehe","type":"text"},{"type":"hardBreak"},{"text":"org.openmrs.module.sync.ingest.SyncIngestException: Transmission data was corrupted. Unable to process item.","type":"text"},{"type":"hardBreak"},{"text":" at org.openmrs.module.sync.api.db.hibernate.HibernateSyncDAO.processCollection(HibernateSyncDAO.","type":"text"},{"text":"java:1195","type":"text","marks":[{"type":"link","attrs":{"href":"http://java:1195"}}]},{"text":")","type":"text"}]},{"type":"paragraph","content":[{"text":"...","type":"text"}]},{"type":"paragraph","content":[{"text":"CAUSE","type":"text","marks":[{"type":"strong"}]},{"text":": Unknown","type":"text"}]},{"type":"paragraph","content":[{"text":"An example record looks like this: (...check line #29 where the owner tag is '","type":"text"},{"text":"<","type":"text","marks":[{"type":"code"}]},{"text":"owner","type":"text","marks":[{"type":"code"}]},{"text":" ","type":"text"},{"text":"type","type":"text","marks":[{"type":"code"}]},{"text":"=","type":"text","marks":[{"type":"code"}]},{"text":"\"recreate\"","type":"text","marks":[{"type":"code"}]},{"text":">","type":"text","marks":[{"type":"code"}]},{"text":"')","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n\n\ntruefalse1948-01-01T00:00:00.000+02002014-03-26T11:53:50.097+0200Ffalse7192b045-0a47-4fbe-a7dd-2ac23a78df7bfalsef3fd6fab-3f4e-4beb-bb05-d729c05f6bd5]>\n\n\n\n\nEastern/UburasirazubaMpangaRushongaRubayacafda0f4-53ce-4ac6-a9ad-5dc742add329truef3fd6fab-3f4e-4beb-bb05-d729c05f6bd5Rwanda]>\n\n\n\n\nCollette9fd417f1-600f-4472-86f1-d20431ac4988truef3fd6fab-3f4e-4beb-bb05-d729c05f6bd5]>\n\n\n\n\n8d87236c-c2cc-11de-8d13-0010c6dffd0ffd75f4da-2694-4b86-b4a3-643e0be91d16f3fd6fab-3f4e-4beb-bb05-d729c05f6bd5]>\n\n\n\n\nd33e7fc7-3513-44d0-80b6-58ae513c29batrue4e458867-9a68-4e55-9fe0-fb49fac4e6b04230341U-8f3fd6fab-3f4e-4beb-bb05-d729c05f6bd5]>\n\n\n\n\n]>\n\n\n\n\n]>\n\n\n\n\n]>\n\n\n\n\n]>\n\n\n","type":"text"}]},{"type":"paragraph","content":[{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"SOLUTION","type":"text","marks":[{"type":"strong"}]},{"text":": Fix the xml by adding the missing attributes and run an sql update to use this new payload.","type":"text"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"}]},{"type":"paragraph","content":[{"type":"hardBreak"},{"type":"hardBreak"}]}],"version":1}

Browser not supported