O7: Duplicated Sequence

Wendy wizardcompserv at gmail.com
Wed Apr 11 13:17:10 EDT 2018


I think that would only apply to an SQL database I am assuming you are using a DML as I do not know where on a Windows computer you would turn it off

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 Juan Bofill
Sent: 11 April 2018 16:32
To: OmnisDev List - English
Subject: Re: O7: Duplicated Sequence

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 

_____________________________________________________________
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