Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

Open Operation on Table

Posted on by 2

Cost_5F00_Variance.PNG

Good day,

This message came up whilst posting SOP documents, the batch posted through, but I'm just trying to understand what it means, as well as how concerned I should be.

Thanks

Regards

Rosemary

Categories:
  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Open Operation on Table

    Thanks very much for the responses, I read your previous input regarding the CTree temp tables. I will monitor what is happening on the local machine, I do nor post much batches, but it is good to know relative to other users who post.

    Regards

    Rosemary

  • Verified answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,928 Most Valuable Professional on at
    RE: Open Operation on Table

    Hi all

    The IV_Cost_Variance_TEMP table is a ctree Temp table which will be created in the %TEMP% folder on the local workstation.

    The error you are getting is usually caused by your anti-virus software.

    When GP creates temp tables it created the data, index and semaphore files TNT*.dat, TNT*.idx and TNT*.tmp.

    When the table is no longer needed, Dexterity requests for the tables to be removed, but does not confirm that the delete was succesful.

    So what happens is that the Anti-Virus is messing around with the dat and idx files but allows the tmp file to be removed.

    Eventually, Dexterity will try to use the same TNT* file name again and there is no tmp file to say that the file name is used. So it will use it and try to open the existing dat and idx files, which were created for a different temp table with different columns.... and so the error shows up.

    More info

    winthropdc.wordpress.com/.../

    winthropdc.wordpress.com/.../

  • Suggested answer
    RE: Open Operation on Table

    I couldn't find anything on this message either, but as it mentions being a TEMP table, I think Richard is on the right path.

    Let us know if this doesn't resolve it for you or you have any further questions.

    Thanks

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Open Operation on Table

    Most likely not much of a concern. Go out  to %temp% folder and delete everything you find in there.

    You can type %temp% in your search box.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans