CM 3.7 does not show dependencies or dependent assets for any asset

[Approach_Medium]

Hi;
On my 'old' copy of TS12+SP1+hotfixes, both dependencies and dependent assets are grayed out on the context menu for all assets listed. I know that most of them do have either or both.
On my 'new' install of TS12+SP1+hotfixes, I can view dependencies and dependent assets.
Both installs are running on Windows 7 Ultimate X64+SP1 and are on the same machine (dual-boot).
I just re-installed Windows on the 'main' partition, and that is the copy of TS12 that is working properly.
On the old copy, I had copied the entire TS12 folder from the primary install (which I had to re-install a couple of days ago) to the backup install. I don't know whether this problem started when I copied the folders or not.
I have run EDR without any effect, but I am currently running a second EDR.
All of the assets listed in CM are working properly.

This does seem to be database related, so I thought the EDR would fix it. I'll see whether the 2nd EDR does anything, and post back here. In the meantime, does anyone have any idea of why this is happening?

Thanks

CP

Update: Ran 2nd EDR. Still have same problem.

 

[xcrossi]

2 methods 1EZ by me and one more complicated,both work.
http://forums.auran.com/trainz/show...tent-Manager-not-showing-missing-dependancies
xcrossi
Mine:
I moved assets.sql and assets.tdx to desk top. (later deleted)
Ran CMv3.7 and it rebuilt the files...NO change until
I did a full EDR. 3/4s thru and its still running, my
CMv3.7 updated and showed Faulty, Missing and all Views.
It worked for me it will work for you.

Other:
The method I prescribed to you preserved your saved filters, Xcrossi's method does not do this. And it is simpler but not far simpler.

Their you go!
xcrossi

 

[Approach_Medium]

Thanks for the help. CM is updating the database now, and I will run the EDR as soon as it's done.
Interestingly, when I went into the \userdata folder in the affected TS12 install, I found assets.sql, assets.sql-wal, assets.tdx-wal, but no file named assets.tdx.
In the good install, there are files assets.sql and assets.tdx but none with the "-wal" extension.
Any idea of what the -wal add-on to the extension is?

CP

 

[shaneturner12]

It's probably a transaction file or similar for updates that need to be added into the .sql/.tdx file, which TADDaemon normally handles.

Shane

 

[Approach_Medium]

Sounds logical. Thanks

CP

 

[Approach_Medium]

Update: Your method worked. Everyone in Trainzland is happy again!
Thank you.

CP

 

[JCitron]

I'll have to remember this method for future reference.

The .wal files are SQL transaction logs. I'm not sure how much use it is for us, but in bigger databases they function as a fall back should the system crash before the data is committed to the database. When the database system comes back up, or files are restored from backup, the SQL database manager (overhead software) will read the logs and "playback" the transactions. This will populate the database properly except for the very last transactions before the database crashed.

John