O7: Duplicated Sequence

Juan Bofill juanbofillaba at gmail.com
Wed Apr 11 11:31:32 EDT 2018


If on multiple users you may need to disable opportunistic locks. https://support.microsoft.com/en-us/help/296264/configuring-opportunistic-locking-in-windows <https://support.microsoft.com/en-us/help/296264/configuring-opportunistic-locking-in-windows>

Juan 

> On Apr 11, 2018, at 9:28 AM, Daniel Sananes <daniel.s at kopparbergs.se> wrote:
> 
> Thanks again Wendy.
> The IT-people is investigating this.
> We must find a way to do this according to your instructions.
> 
> hälsning 
> Daniel Sananés
> Kopparbergs Bryggeri AB
> Tel:  + 46 (0)736 70 40 70
> 
> -----Ursprungligt meddelande-----
> Från: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> För Wendy
> Skickat: den 11 april 2018 11:35
> Till: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
> Ämne: RE: O7: Duplicated Sequence
> 
> Hi Daniel
> 
> It is a must that this value is unset - what Microsoft does in its wisdom is to hold the information locally until it decides to write it back to the database which is the reason for duplicate records.  The problem gets worse if you have linked records - i.e Customers and Contacts as they could be linked to the wrong record.
> 
> The good news is that I have found recently that it has not been reset with updates on Windows 10. 
> 
> 
> Kind regards
> Wendy Osbaldestin
> Wizard Computer Services
> Tel:  01260271647
> Mobile: 07740541021
> 
> 
> -----Original Message-----
> From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Daniel Sananes
> Sent: 11 April 2018 10:29
> To: OmnisDev List - English
> Subject: SV: O7: Duplicated Sequence
> 
> Thank you Wendy!
> Seems we cannot easily set this value according to your description.
> IT explained to me that we use a virtual harddrive and this value can be seen but not changed.
> They are looking into this issue.
> For now I have deleted the sequencenumbers that are duplicated and the order-department can create orders again.
> I suspect we will have these problems again.
> 
> hälsning
> Daniel Sananés
> Kopparbergs Bryggeri AB
> Tel:  + 46 (0)736 70 40 70
> 
> -----Ursprungligt meddelande-----
> Från: omnisdev-en <omnisdev-en-bounces at lists.omnis-dev.com> För Wendy
> Skickat: den 11 april 2018 10:17
> Till: 'OmnisDev List - English' <omnisdev-en at lists.omnis-dev.com>
> Ämne: RE: O7: Duplicated Sequence
> 
> On windows - all versions from 7 upwards - have you checked for write behind cashing being on?
> 
> The setting can be found as follow:-
> 1) Control Panel -> System -> Hardware-> Devise Manager
> 
> 2) Click on the '+' beside the Disc Drives entry and right click on the entry for the hard drive.
> 
> 3) Select 'Properties'
> 
> 4) On the displayed screen select 'Policies'
> 
> 5) Towards the bottom of the screen there is a check box which reads 'Enable write cashing on the disk'  If there is a tick in the check box click on the box so that it is unchecked.
> 
> 6) Click OK
> 
> This can be reset by doing updates to the computer.
> 
> Kind regards
> Wendy Osbaldestin
> Wizard Computer Services
> Tel:  01260271647
> Mobile: 07740541021
> 
> -----Original Message-----
> From: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Daniel Sananes
> Sent: 11 April 2018 09:02
> To: OmnisDev List - English
> Subject: O7: Duplicated Sequence
> 
> Hi all
> 
> We have problems with Omnis assigning the same sequence-number twice or trice every now and then.
> I export and import with omnis data transfer and then the sequencenumber are correct again.
> 
> But the problems does not go away.
> Is there something else I can do?
> 
> hälsning
> Daniel Sananés
> Kopparbergs Bryggeri AB
> Tel:  + 46 (0)736 70 40 70
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list