O7 native data file on Windows 2012 Server

Tue May 14 12:47:16 EDT 2013

Yes that's what these are too !! I only say 5 years as that's how long my Studio version has been properly going :) (I think)

On May 14, 2013, at 12:33 PM, Keith Bartlett <keith at adnetltd.co.uk> wrote:

> 5 years!!!  They work fast compared with some of our clients....  We still have some running the 7 version
> 
> 
> Cheers
> Keith
> 
> On 14 May 2013, at 17:03, Andy Hilton wrote:
> 
>> Sadly - as with most of my installations - I am not (and frankly don't want to be) in control of the users choice of servers !
>> 
>> They tell me what they are using and I either go with it or not......in this case I was able to persuade the clients that this proposed combination would be a really bad idea, and it is hopefully lighting a fire under them to proceed to upgrade - it has only taken 5 years to get them to this point !!
>> 
>> Andy
>> 
>> On May 14, 2013, at 11:47 AM, Lou Picciano <loupicciano at comcast.net> wrote:
>> 
>>> Though not directly on point re Windows servers (Don't use Windows Servers, so claim no expertise there. Hopefully some of this will 'translate'):
>>> 
>>> One way we approached this in the past was to isolate the Omnis Data File into its own, discrete share, with its own set of locking rules. Don't remember offhand; we most probably would have been using Samba...  Yes, it's probably unwise to serve ODFs and _other_ files from the same share, given the potentially varying lock expectations of those files - and their clients.
>>> 
>>> As I recall, we made the share an automated process - making use of Windows mount switches to keep it completely invisible. I think we also made the ODF itself invisible on the share, in case anyone managed to mount it ad hoc.
>>> 
>>> This works really well on even an inexpensive *nix server, as long as it has kernel support for the Windows oplocks.
>>> 
>>> The traffic jams, and non-release of these byte range oplocks is where many of the Omnis 'Lock of Death' errors come from.
>>> 
>>> So, with proper locking options, and being sure that no non-Windows (non-Omnis, perhaps) processes ever have access to the ODF, you may find yourself in Omnis HappySpace.
>>> 
>>> (Any thought to nixing use of the Win server in this case, and serve the ODF over a Samba server, which offers lots of granularity over locking (caching) control?)
>>> 
>>> Lou Picciano
>>> 
>>> 
>>> ----- Original Message -----
>>> From: Alain Stouder OmnisNews <omnis at smartway.ch>
>>> To: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
>>> Sent: Tue, 14 May 2013 14:46:29 -0000 (UTC)
>>> Subject: Re: O7 native data file on Windows 2012 Server
>>> 
>>> Only SMB (1) was open to disabling Opportunistic Locking. Its built-in with SMB2.
>>> 
>>> You can turn off SMB2 but a lot of IT people will complain because some MS apps might need it.
>>> 
>>> On 12 mai 2013, at 02:58, Andy Hilton wrote:
>>> 
>>>> Perfect - so really I should encourage their move to 2012 then so it leads to a swift upgrade !!!!
>>>> 
>>>> On May 11, 2013, at 5:48 PM, Jock Philip  wrote:
>>>> 
>>>>> Of course. ;-)
>>>>> 
>>>>> Just wanted to wait until I was on my pc to respond instead of doing it on
>>>>> the iphone.
>>>>> 
>>>>> Two issues, write behind caching (WBC) and opportunistic locking (OL).  I
>>>>> believe the WBC can be turned off but not the OL.  Had an experience with a
>>>>> customer recently.  Been rock solid for years and suddenly they started
>>>>> having corruption.  I did a complete rebuild of their data files and it
>>>>> happened again a day later.  Did the rebuild followed by renewed corruption
>>>>> a few times before we found out that the IT folks had moved the data files
>>>>> from a 2003 server to a 2008 server without notifying anybody.  They moved
>>>>> it back and the problem disappeared.  This caused their conversion to our
>>>>> Studio version to be brought forward very quickly.  I'm assuming 2012 would
>>>>> have similar issues.
>>>>> 
>>>>> Jock
>>>>> 
>>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>>>> ~
>>>>> Jock Philip       [jock at visionchips.com] Vision Chips, Inc.
>>>>> 888.517.7779 x 3563
>>>>> http://www.visionchips.com/
>>>>> 
>>>>> Developers of OBserver OB/GYN Ultrasound Reporting and Image Archiving
>>>>> System
>>>>> 
>>>>> 
>>>>> -----Original Message-----
>>>>> From: omnisdev-en-bounces at lists.omnis-dev.com
>>>>> [mailto:omnisdev-en-bounces at lists.omnis-dev.com] On Behalf Of Andy Hilton
>>>>> Sent: Saturday, May 11, 2013 2:38 PM
>>>>> To: OmnisDev List - English
>>>>> Subject: Re: O7 native data file on Windows 2012 Server
>>>>> 
>>>>> Any technical reason for that ? Not sure putting it quite like that will
>>>>> enhance my technical reputation :)
>>>>> 
>>>>> On May 11, 2013, at 5:30 PM, Jock Philip  wrote:
>>>>> 
>>>>>> Give them about three minutes before corruption starts showing up
>>>>>> 
>>>>>> Jock Philip
>>>>>> From my iPhone (we don't always agree on what I meant to type)
>>>>>> 
>>>>>> On May 11, 2013, at 2:28 PM, Andy Hilton 
>>>>> wrote:
>>>>>> 
>>>>>>> Folks
>>>>>>> 
>>>>>>> One of my last remaining O7 clients is planning on converting their
>>>>> servers from Windows 2003 to Windows 2012......I don;t know but I am
>>>>> assuming they would be running 64 bit.....not sure what their plan is for
>>>>> clients but let's assume mix of older and newer Windows based machines
>>>>>>> 
>>>>>>> They currently use a set of three native datafiles each with multiple
>>>>> segments in my app (running O7.3.8 non-ODB)......changing to ODB is not an
>>>>> option as I am not making any changes to the application at all any more as
>>>>> I have a perfectly valid Studio option !
>>>>>>> 
>>>>>>> Does anyone know if this combination is likely to give them any grief ?
>>>>>>> 
>>>>>>> Obviously I want them to upgrade to my postgresql / Studio version but
>>>>> the client is resistant to change - so I have been looking for the right
>>>>> reason to give them to force the situation through - but I have no
>>>>> experience of using O7 with native data files on the latest Windows servers
>>>>> (and not honestly sure I want to either !)
>>>>>>> 
>>>>>>> If anyone has any comments, please feel free to air them !!
>>>>>>> 
>>>>>>> Andy_____________________________________________________________
>>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>>> _____________________________________________________________
>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>> 
>>>>> _____________________________________________________________
>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>> 
>>>>> _____________________________________________________________
>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>> 
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> Keith Bartlett
> Adnet Ltd - (0)1491 642133
> www.adnetltd.co.uk
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com