MapInfo Pro

 View Only
Expand all | Collapse all

Problem saving edits to table

  • 1.  Problem saving edits to table

    Posted 10-04-2019 04:24

    Hello all,

     I have a problem when trying to edit a table in Mapinfo Pro 17.0.3 called TPO zones – Individual type.

     

    Here's the flow…

     

    • Open table from UNC path
    • Make editable
    • Make an edit (e.g.: add new polygon feature and attribute)
    • Table> Save> Save Table
    • Choose the table to save 

    I then get a message saying 'cannot access file TPO zones – Individual type.DAT for writing.Please be sure thatv this file is not open in another application'. I can also get a message saying get a message saying 'cannot access file TPO zones – Individual type.MAP for writing. Please be sure that this file is not open in another application'.

    If I select Cancel on that message I get another one saying'cannot access TPO zones – Individual type.DAT. Cannot save edits now.  Someone else is using this table, or table is read only'.
     
    I've found that if I log off my network session, log back in again and go through the same process I can then edit and save. However after a while I find that it stops being able to save changes and the original error re-occurs.


    I've found that I can take a copy of the original (saved to a different directory), edit the copy and successfully save the changes. But if I then if I open that copy in MI Pro and try to do a Save As (overwriting the original) I get the same 'cannot access file' errors. But I've found that if I rename the copy (to the name of the original) and then manual copy/paste the files using Windows Explorer, then that works.

    It's all a bit of a mess.

     

    Also note that…

    - This only happens with this table
    - The table is linked to SSA
    - I do have edit rights to the storage location
    - No one else is using the table. If they are they are doing so on a read-only basis through another installation of Mapinfo.

     

    Why is this table giving me such problems. Is it a Windows or a Mapinfo thing?

     

    Thanks,

    Stuart



    ------------------------------
    Stuart Carter
    Corporate GIS Manager
    Southwark Council
    London
    ------------------------------


  • 2.  RE: Problem saving edits to table

    Moderator
    Posted 10-07-2019 04:28
    Hello Stuart,

    From your description it looks like we might need to delve a bit deeper into this case to check what is happening. Please open a case for Technical Support and someone from the team will look into this.

    Thank you
    Susan

    ------------------------------
    Susan Bardet
    Software Support Engineer (EMEA)
    susan.bardet@pb.com

    Pitney Bowes
    Henley-on-Thames
    RG9 6AB Oxfordshire
    pitneybowes.com
    ------------------------------



  • 3.  RE: Problem saving edits to table

    Posted 10-07-2019 05:22
    ​Hi Stuart
    Have you deployed a new anti-virus program lately?
    I have seen this issue with other users on a network drive.
    John

    ------------------------------
    John Ievers
    CDR Group
    Hope Valley, United Kingdom
    ------------------------------



  • 4.  RE: Problem saving edits to table

    Posted 10-07-2019 05:27

    Hi John,

     

    I suppose it's possible that our IT service providers have done so, but I wouldn't know. To be honest it going to be near impossible to find out.

     

    But why does this happen on this one table? Why not on everything else on that directory?

     

    Thanks,

    Stuart

     






  • 5.  RE: Problem saving edits to table

    Posted 10-07-2019 06:47
    Hi Stuart
    And are the other tables being edited over the network to that server?
    (as opposed to edited locally and copied over to it).
    You can invoke exceptions with the anti-virus app to ignore changes to the dat, map, tab, id and ind files.
    Otherwise - mystery time and check with the PB support team...
    John​

    ------------------------------
    John Ievers
    CDR Group
    Hope Valley, United Kingdom
    ------------------------------



  • 6.  RE: Problem saving edits to table

    Posted 10-07-2019 06:54

    Thanks for that, John.

     

    Other tables are being edited over the network to the server.

     

    Unfortunately I have no control over anti-virus software settings.

     

    I took the matter through PB Support before raising it here, but I didn't get anywhere with that.

     

    Thanks anyway.

    Stuart

     






  • 7.  RE: Problem saving edits to table

    Posted 10-07-2019 07:06
    Hi Stuart I think that the problem is
    - The table is linked to SSA (Spectrum LIM)


    ------------------------------
    Boris Rubtsov
    Knowledge Community Shared Account
    Shelton CT
    ------------------------------



  • 8.  RE: Problem saving edits to table

    Posted 10-07-2019 08:40

    Thanks for that, Boris.

     

    We have around 1000 tables linked to SSA. This appears to be the only one to experience these problems.

     

    Thanks,

    Stuart

     






  • 9.  RE: Problem saving edits to table

    Posted 10-07-2019 11:09
    Hi Stuart. If the table got into the Spectrum cache, then in this case there may be problems

    ------------------------------
    Boris Rubtsov
    Knowledge Community Shared Account
    Shelton CT
    ------------------------------



  • 10.  RE: Problem saving edits to table

    Posted 10-13-2019 19:05
    Edited by Duri Bradshaw 10-13-2019 19:05
    Hi Stuart,

    I agree with Boris, I think by default Spectrum Spatial opens files in Read+Write mode which can lock the files.

    Two things I would try in Spatial Manager:
    1. Set the table Read-Only=True (unless you need to edit it in SSA).
    2. Set the table as Volatile=True.


    ------------------------------
    Duri Bradshaw
    Spatial IT Consultant
    Insight GIS
    ------------------------------



  • 11.  RE: Problem saving edits to table

    Posted 10-14-2019 04:59

    Hi Duri,

     

    Potentially, I have good news.

     

    I've set that table in Spatial Manager to read only=true and volatile=true.

     

    I then carried out a few tests on editing in MIPro. On all occasions it did not generate the same locked file error as before.

     

    I'm giving this a cautious thumbs up for now. There was always a slightly intermittent nature to the issue anyway, so let's see how it goes. But it's certainly looking good so far.

     

    Thank you,

    Stuart

     

     






  • 12.  RE: Problem saving edits to table

    Moderator
    Posted 10-14-2019 05:22
    Hi Stuart,

    Glad that the 'volatile = True' works for you. For any table that you intend to change the structure volatile needs to be set to 'True' else it would throw up an error. I did not suggest this earlier because from your description I thought that you were editing the data in the table but not changing the table structure, by table structure I mean for example adding new columns, etc. Glad to hear that it is finally working for you.

    Best regards​

    ------------------------------
    Susan Bardet
    Software & Data support EMEA
    susan.bardet@pb.com

    Pitney Bowes
    Henley-on-Thames
    RG9 6AB Oxfordshire
    United Kingdom
    pitneybowes.com
    ------------------------------



  • 13.  RE: Problem saving edits to table

    Posted 10-14-2019 09:33

    Thanks for that, Susan.

     

    "For any table that you intend to change the structure volatile needs to be set to 'True' else it would throw up an error": Yes, but I wasn't changing the structure. Just adding/deleting objects and editing existing attributes/objects.

     

    But, yes, it's looking better with volatile set to true.

     

    Many thanks,

    Stuart

     

     

     

     

     

     

     






  • 14.  RE: Problem saving edits to table

    Moderator
    Posted 10-07-2019 07:27
    Hi Stuart,

    In Windows check the properties of the tab file to see if it has not been accidently changed to 'Read only'. Also check in Spatial Manager if the table is not 'Read only'.
    If the table is being used by other Spectrum processes then this could also be the reason why you cannot edit.
    Also try this: Copy the dataset to another location, create a new connection in Spatial Manager pointing to this new location, now try editing, what happens?
    I shall check who has this case, and give a heads up.

    ------------------------------
    Susan Bardet
    Software Support Engineer (EMEA)
    susan.bardet@pb.com

    Pitney Bowes
    Henley-on-Thames
    RG9 6AB Oxfordshire
    pitneybowes.com
    ------------------------------



  • 15.  RE: Problem saving edits to table

    Posted 10-08-2019 12:05

    Thanks for that, Susan.

     

    In Windows Explorer the .tab file is not set to Read Only.

     

    In Spatial Manager the Read-Only setting is set to False...

     

    Also, I done the following:

     

    1, Via MI Pro I saved table to a different location

    2, Saved with a different name "TestTPOIndyEditable"

    3, Uploaded to Spectrum

    4, Added to SSA map config

    5, Opened map config in SSA to see the layer showing – all good

    6, Opened table in MI Pro and made some edits (add polygon, edit attributes on existing object)

    7, Saved. It saved OK.

    8, Check SSA, changes came through to SSA – all good

    9, Repeated step 6, but this time I experienced the same as the original problem ('cannot access file TestTPOIndyEditable.DAT for writing. Please be sure that this file is not open in another application').

     

     

    Thanks,

    Stuart

     

     

     

     






  • 16.  RE: Problem saving edits to table

    Moderator
    Posted 10-09-2019 04:35
    Hi Stuart, This would need further investigation, it looks like you are doing the right thing. I am aware that my colleague is investigating this, please update him with your tests and results.

    Good luck​

    ------------------------------
    Susan Bardet
    Software & Data support EMEA
    susan.bardet@pb.com

    Pitney Bowes
    Henley-on-Thames
    RG9 6AB Oxfordshire
    United Kingdom
    pitneybowes.com
    ------------------------------