SV: O7: Duplicated Sequence

Daniel Sananes daniel.s at kopparbergs.se
Wed Apr 11 09:28:18 EDT 2018


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 


More information about the omnisdev-en mailing list