Error message when syncing

Support related problems and questions

Moderators: TerryRogers, Max

Post Reply
kdgdr
Guru
Posts: 308
Joined: Mon Jan 12, 2009 5:03 pm
Has thanked: 9 times
Been thanked: 18 times

Error message when syncing

Post by kdgdr »

Hi,

I get this error message when I sync over Wifi:
validation error for column "HISTNOTETABS"."IDNOTEHISTORY", value "*** null ***"
At trigger 'NOTETABS_BU1' line: 21, col: 1
Any idea:
- what is the cause
- how it can be fixed?

Thanks in advance!
admin
Site Admin
Posts: 15574
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1407 times
Been thanked: 977 times

Re: Error message when syncing

Post by admin »

1. Please mention the app version numbers.
2. Forward us the sync log file. It can be found here: Tools->Options->Synchronization, Browse...
Android version of EssentialPIM. Keep all your data in sync!
kdgdr
Guru
Posts: 308
Joined: Mon Jan 12, 2009 5:03 pm
Has thanked: 9 times
Been thanked: 18 times

Re: Error message when syncing

Post by kdgdr »

Hi,
  1. That's AEPIM 6.0.2 and WEPIM 10.2.1
  2. I will forward it to admin in a PM
admin
Site Admin
Posts: 15574
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1407 times
Been thanked: 977 times

Re: Error message when syncing

Post by admin »

Please update to WinEPIM 11.0.4 and try again.
Android version of EssentialPIM. Keep all your data in sync!
kdgdr
Guru
Posts: 308
Joined: Mon Jan 12, 2009 5:03 pm
Has thanked: 9 times
Been thanked: 18 times

Re: Error message when syncing

Post by kdgdr »

Hi,

Updated to 11.0.4 and got these errors on first sync (1) and second sync (2), so update to 11.0.4 is not a solution.
2022-08-16_114335.png
Cannot send you sync log files because of security issue I just posted here: https://www.essentialpim.com/forum/view ... hp?t=37220

FYI,
Issue only arises with my professional database, for which I have WEPIM Pro Portable 10.2.1 (or 11.0.4 for this test) on Win 10 Pro x64 syncing over Wifi with AEPIM 6.0.2 on Android 12 - One UI 4.1 (Samsung Galaxy A52s 5G).
Issue does not arise with my personal database, for which I have WEPIM Pro Portable 10.2.1 (or 11.0.4 for this test) on Win 10 Pro x64 syncing over Wifi with AEPIM 6.0.2 on Android 8.1.0 (Motorola Moto G5 Plus)
admin
Site Admin
Posts: 15574
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1407 times
Been thanked: 977 times

Re: Error message when syncing

Post by admin »

Create a new database in EPIM 11.0.4 and try to perform synchronization then. Will there be the error?
Android version of EssentialPIM. Keep all your data in sync!
kdgdr
Guru
Posts: 308
Joined: Mon Jan 12, 2009 5:03 pm
Has thanked: 9 times
Been thanked: 18 times

Re: Error message when syncing

Post by kdgdr »

Hi,
  1. Some information that might help: sync issue is definitely Notes-related because when I uncheck Notes from the WEPIM sync profile in my current database, the sync issue does not arise. Of course I need to be able to sync Notes, so unchecking them in the sync proifle is not a usable solution.
  2. Knowing this, is it still useful to create a new database in 11.0.4 and try to perform synchronization? If so, please let me know exactly which steps to perform in WEPIM and AEPIM, because I have to be absolutely sure that after testing this, I will get all my real data back in both WEPIM and AEPIM.
admin
Site Admin
Posts: 15574
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1407 times
Been thanked: 977 times

Re: Error message when syncing

Post by admin »

1. Click on File->New->EPIM Data File
2. Add direct synchronization with AEPIM (you can leave only the Notes module checked for sync as the problem is with it)
3. Start synchronization
4. If there's going to be the same error, forward us the newly created log file, please.
Android version of EssentialPIM. Keep all your data in sync!
kdgdr
Guru
Posts: 308
Joined: Mon Jan 12, 2009 5:03 pm
Has thanked: 9 times
Been thanked: 18 times

Re: Error message when syncing

Post by kdgdr »

Hi,

Thanks for the step-by-step procedure to test with a new database.
But I am especially interested in a step-by-step procedure to get my real data back on the android side, after I have performed the test. Can you provide these steps, please?
admin
Site Admin
Posts: 15574
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1407 times
Been thanked: 977 times

Re: Error message when syncing

Post by admin »

No additional steps will be required. You can, however, make a backup in AEPIM just in case.
Android version of EssentialPIM. Keep all your data in sync!
kdgdr
Guru
Posts: 308
Joined: Mon Jan 12, 2009 5:03 pm
Has thanked: 9 times
Been thanked: 18 times

Re: Error message when syncing

Post by kdgdr »

So the step-by-step procedure you listed earlier ...
1. Click on File->New->EPIM Data File
2. Add direct synchronization with AEPIM (you can leave only the Notes module checked for sync as the problem is with it)
3. Start synchronization
4. If there's going to be the same error, forward us the newly created log file, please.
... will not delete my real data on AEPIM side?
... will not make the notes (created while testing) sync back to my real database afterwards?
I guess I will have to set "Synchronize deletions" inactive in the new testing sync profile? Otherwise my real data will be deleted on AEPIM side, no?

In general: Does this mean you can actually sync 2 different WEPIM databases to the same AEPIM instead of just 1 WEPIM database?
admin
Site Admin
Posts: 15574
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1407 times
Been thanked: 977 times

Re: Error message when syncing

Post by admin »

Note, I didn't ask you to create any notes during test. Your data will not be deleted, you can leave the default sync settings intact.
You can synchronize with as many WinEPIM databases as needed.
Android version of EssentialPIM. Keep all your data in sync!
kdgdr
Guru
Posts: 308
Joined: Mon Jan 12, 2009 5:03 pm
Has thanked: 9 times
Been thanked: 18 times

Re: Error message when syncing

Post by kdgdr »

Hi,

Sorry for the delay. Error did not arise after performing these steps in a new empty database (v R11.0.4) and syncing
1. Click on File->New->EPIM Data File
2. Add direct synchronization with AEPIM (you can leave only the Notes module checked for sync as the problem is with it)
3. Start synchronization
4. If there's going to be the same error, forward us the newly created log file, please.
admin
Site Admin
Posts: 15574
Joined: Thu Nov 25, 2004 3:12 am
Has thanked: 1407 times
Been thanked: 977 times

Re: Error message when syncing

Post by admin »

Ok, in this case please transfer all your data into the new DB using EPIM Synchronizer and then use the following EPIM build:
https://www.essentialpim.com/download/t ... Pro110.exe
The issue should be solved then.
Android version of EssentialPIM. Keep all your data in sync!
Post Reply