JFM seems to getting locked mutually exclusive

Deepak Vasudevan 96 Reputation points
2021-04-02T07:48:55.91+00:00

This is the follow-up query on (https://learn.microsoft.com/en-us/answers/questions/341970/what-are-jfm-mdl-files-in-visual-studio-database-p.html?childToView=342039#answer-342039) helped by @Vaibhav Chaudhari

Additionally I also observe that when the database project is open this JFM remains undelete-able. When trying to commit them too it git gives a permission denied error because it seems to get locked exclusively.

Is there a way to change this setting?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viorel 112.1K Reputation points
    2021-04-02T08:34:11.133+00:00

    Maybe you do not have to commit it, since it is ignored according to default .gitignore file, generated by Visual Studio.

    0 comments
  2. Tom Phillips 17,716 Reputation points
    2021-04-02T15:58:01.873+00:00
    0 comments
  3. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2021-04-05T09:54:01.7+00:00

    Hi @Deepak Vasudevan ,

    Please try below steps.

    •Add *.jfm as a line to the local .gitignore
    •Close the solution (but stay connected in Team Explorer)
    •Delete the .jfm file in file explorer
    •Commit the .jfm deletion and the .gitignore edit
    •Reopen the solution and rebuild
    •Should see that there are no .jfm changes

    Quote from this thread Visual Studio ignores *.jfm entry in the gitIgnore file.

    Please also check if this thread Visual Studio 2015 Database Project directory contains a file with extension jfm could help you.

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.