Database repair Failure

[EvanGaines]

Hey Guys, Evan here.

So, Guys, Trainz went AWOL on me & I've told all of you that all of my content went faulty or had missing dependencies. Well, I tried doing an extended Database repair 3 times, & all 3 failed with many errors & warnings showing up. I'm now on the 4th attempt. I'm on my last legs with this game. Can someone, please repair the game. Idk, what is wrong. You guys said the servers are up, but I'm having doubts on it. If you guys are having the same problems, let me know.

Sincerly,
Evan Gaines

 

[fourteen]

Severs are up

 

[JCitron]

First of all, make sure you are logged into My Trainz, otherwise this will be for naught.

Warnings can be ignored. Errors will be reported, but here are some caveats with errors.

DLC will produce a version-error due to the server's rerported version being older than the one that you have installed. You can ignore these errors.

Many times, content will show errors after a DBR and more so after an EDBR. I've said this before.

View errors and warnings. You can do this one asset at a time, or you can select them all and get the job over with.
Select your content. Right-click on the asset and choose View errors and warnings.

Select one asset then press CTRL and A at the same time (CTLR+A) to select all. With the content still selected, right-click on one asset and choose View errors and warnings.

The the process will run then the status will come back. It should say 0 errors and maybe a buch of warnings.

The content used to disappear from the screen but sometimes it does not any longer.
Chage the view to installed.
Wait a minute.

Change back to Faulty.

The errors should be gone. If you have anything left, then these assets need to be looked into and may need to be downloaded again.

If none of this works, there's a brut force repair process which requires deleting files, but we won't go there for now.

 

[Forester1]

Well, I tried doing an extended Database repair 3 times, & all 3 failed with many errors & warnings showing up

Are you saying the repair process itself failed with errors, or that when it completed you had assets with errors and warnings? A Database Repair won't repair assets, but will often report assets as faulty that aren't. John's process above can help correct these, as can sometimes just double-clicking them. But if the assets truly are faulty then whatever errors are reported by right-clicking and selecting View Errors and warnings have to be addressed.

 

[JCitron]

You have never mentioned if these are missing or truly faulty and to be fair this gets confusing, Content Manager includes missing dependencies as part of the faulty assets. If you are seeing missing dependencies, then the process is yet another simple step.

Right-click on the asset and choose download. This should bring down any missing dependencies from the DLS. If they're not on the DLS and are located on a third-party site, you will need to install those manually. If they are DLC, ensure you have that content installed.

 

[EvanGaines]

Thanks for the info Guys. I think I know why this is the case, my hard drive may be causing it, so, it's undergoing a repair for the time being.

 

[EvanGaines]

Update: So, I tried to repair my drive to see if that was the issue. Long story short. I repair at first wiped all of my content. When I restarted my PC, it was back to where it was. IDK what to do. I just want Trainz to fix this problem, so everything runs well & I have no more problems with the Database. I'm seriously, at my wit's end with Trainz. I can't take it anymore. It seems like whatever I do to fix the problem doesn't work. Please, can someone help fix it.

 

[JCitron]

Update: So, I tried to repair my drive to see if that was the issue. Long story short. I repair at first wiped all of my content. When I restarted my PC, it was back to where it was. IDK what to do. I just want Trainz to fix this problem, so everything runs well & I have no more problems with the Database. I'm seriously, at my wit's end with Trainz. I can't take it anymore. It seems like whatever I do to fix the problem doesn't work. Please, can someone help fix it.

Reinstall Trainz.
Let it create a new data folder.
Download your content.
Exclude the data folders and TRS22.exe from your antivirus real-time scanner - this is very important.

If still have login issues, contact the helpdesk.

 

[orangeengine69]

As a rule: the more content you have installed = the longer the database repair. my last database repair showed that i have just over 700,000 Assets! and the database repair took over 5 Hours! i had to open TADDaemon.exe to view to repair process because it was taking that long.
if you're hard drive can't handle it, say goodbye to your precious files. (i have a single as factory fitted 475GB NVME SDD on my laptop it has never let me down)

 

[JCitron]

As a rule: the more content you have installed = the longer the database repair. my last database repair showed that i have just over 700,000 Assets! and the database repair took over 5 Hours! i had to open TADDaemon.exe to view to repair process because it was taking that long.
if you're hard drive can't handle it, say goodbye to your precious files. (i have a single as factory fitted 475GB NVME SDD on my laptop it has never let me down)

That 700,000 file number is actually the total number of assets, including the DLS that Content Manager references for your particular version. The actual number installed is much smaller. However, you are correct regarding how long it takes for a repair. A large number of assets, like I have because I'm a greedy gut and have to install everything, will cause the DBR, in particular an EDBR, to take forever. With 1.43 TB of content, this can run several hours for an EDBR and I will run the repair overnight and check on it the next day.

 

[OddRails]

How do you repair a hard drive?

You can have the operating system check the HDD for errors and it may try rescue data in bad sectors. But I've rarely succeeded in completely restoring a file that used bad sectors.

If your Hdd is having bad sectors repeatedly, it's time to replace the disk.

Is that what you mean by repairing the hard drive?

On the other hand, this may not be your problem at all, but your comments are so vague I don't really know what your system is doing. Sorry!

 

[orangeengine69]

I tried to repair my drive

I have some questions about this.
When you say "repair my drive" do you mean you.
A. Unscrew and disassemble you physical hard drive?
or
B. Use a software like recuva or disk drill to repair it's reading and firmware?

But honestly. It probably has nothing to do with your hard drive in the first place! From personal experience after a database repair session, some assets will get marked as faulty (assets that link their script class to an outside library like AJS and Lilb's are more likely to get marked) but you can just fix them manually.
Just CTRL+E "Open For Edit" and CTRL+M "Commit/Commit Edit" the asset will return to not faulty. But I recommend you check the "Errors and Warnings" log for each asset some might have other issues like the texture got corrupted, there a not permitted tag in the config. Just be patient and you'll get there

 

[JCitron]

On the other hand, this may not be your problem at all, but your comments are so vague I don't really know what your system is doing. Sorry!

It's broke.

 

[EvanGaines]

Here's the evidence I'm talking about. It's also on the TRS22 Community Page & the Trainz Discord Server.