Have you ever spent hours working on a model? Perfecting each join, meticulously defining the cardinality of each individual join, fastidiously testing the queries each step of the way, only to have Framework crash on you?
In this screenshot, I’ve spent entire MINUTES building the joins.
Now, because I’m a hotshot developer I know I can get away with not having Auto Save (Project –> Options –> Auto Save) turned on. I live on the edge, so I also turn off the rows restriction when testing my queries.
Now here I go, testing my joins when suddenly… Disaster!
I’ve killed Framework! (After setting up a Cartesian join between two fact tables, and disabling the rows restriction and randomly clicking until Windows thought the process wasn’t responding.) And now, with dread in my heart, I open the model already knowing what I’ll see.
But there’s some hope! Looking at the folder, there’s an XML file there called “session-log-backup.xml”
Under the projects menu there’s a Run Script option.
Clicking that opens a file browser. Let’s select that session-log-backup…
It recorded every action performed on the model. What happens if we run it?
And clicking on accept…
Almost perfect, it recreated all of the joins (including the crazy Cartesian) and the packages. But it didn’t remember that I like the layout as Star, not as Standard. Now instead of spending hours of my life recreating my work, It’ll take me entire SECONDS to get the diagram back as a star.
I’m still not using Auto Save though.
6 thoughts on “Recovering changes made to Framework after a crash”
Welcome to the our club.This feature help me to manage two parallel models.
A) very Nice Feature, Always had an rhought whats the “run Script” Option for…now i know. Ty
B) very Nice style of writing BTW 🙂
Regards Mike charon
Hmmm How many minutes did you spend on the model actually???
“…spent entire MINUTES building the joins…”
From creating the new project to the first screenshot was probably about four minutes. It took longer trying to get the damned model to crash when I wanted it to.
superb for me i am new bee to fm