Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
Database keeps getting corrupt
Author Message
DVD Profiler Desktop and Mobile RegistrantStar Contributorhevanw
Registered: March 18, 2007
Belgium Posts: 426
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
For the last couple of months, my database keeps getting corrupt regularly. This typically happens when I download updated profiles or add new DVDs. I would get an error (which I wished I took a screenshot of). It will say about 2 fields that it has an invalid value "[ ]". Most of the times I can repair the database, although it seems to delete records. Recently it turned into quite a mess where several profiles were gone. I had to go look at my online database to compare one by one which ones were gone .

These issues started a while ago when I would also get a Windows warning stating "Delayed Write Failed". Which brings me to some background info...

I'm not sure if this is causing this, but I have a particular deployment. My entire database is on a file server as a shared directory, such that I can access my database from mulitple clients (desktop, laptop, netbook). This worked great for years though. But the fact that the latest DVDP now also has a sharing feature made me doubt. I don't understand the advantage of that sharing feature though as you can't even update your database from the clients, whereas in my setup any client could do the update. Mind you, I make sure that no 2 clients are accessing the database in parallel, as I realize that that might corrupt the database.

I'm at the point now that I've installed DVDP on my file server (XP Pro) and only do updates of DVDP anymore through Remote Desktop on the file server itself. This of course I would like to get fixed still, because I also use DVDP Mobile which is synced to my desktop so I can't keep using the desktop client in read-only mode.
DVD Profiler Unlimited RegistrantStar Contributorcvermeylen
Registered: March 13, 2007
Reputation: High Rating
Belgium Posts: 1,946
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
I'm not sure if this will fix your problem, but you could try the following steps

Run a full database repair (if you still see errors, try running it until you have no more errors)
Backup your database
Create a new database
Perform a restore, but make sure you deselect "Replace full user database)

It's a long shot, but if you have some structural database error the repair can't fix, this might do the trick.
View my collection at http://www.chriskepolis.be/home/dvd.htm

Chris
 Last edited: by cvermeylen
DVD Profiler Desktop and Mobile RegistrantDr. Killpatient
Here's my card
Registered: May 19, 2007
Reputation: Highest Rating
United States Posts: 5,917
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Here's a link to look into to see if you can find and solve the underlying issue for the network delayed write errors.

http://support.microsoft.com/kb/321733

You can also try some long pings.
From a cmd prompt:

ping -t -n 2000 -l 60000 x.x.x.x

Where x.x.x.x is the other's IP

Do this on both PC's simultaniously towards each other.
Let it run for a minute or so and press Ctrl-C .
Check if there is any loss.
 Last edited: by Dr. Killpatient
DVD Profiler Desktop and Mobile RegistrantDr. Killpatient
Here's my card
Registered: May 19, 2007
Reputation: Highest Rating
United States Posts: 5,917
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Also, how is your network set up in your house between the computers in question?  Wireless/wired/switches/routers/etc
DVD Profiler Desktop and Mobile RegistrantStar Contributorhevanw
Registered: March 18, 2007
Belgium Posts: 426
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thanks for the suggestions.

Well, I recently had to re-install my file server completely and since then haven't seen the 'Delayed Write Failure' thing anymore. Nonetheless, I am still getting the DVDP errors. In fact tonight again a problem. It now tells me that there is an error in my 'With Love From Russia' profile from my 007 box, and asked if I wanted to delete it. I said no, but it still is missing from my database now. No idea why this happened because I have not touched that profile in ages.

So I had to go restore from my file backup. I now have done the suggestion of starting from a completely new database and doing the DVDP Import into that. I hope that finally fixes it, because I'm getting completely clueless why I keep getting errors. Obviously I'll be doing the built-in DVDP backups regularly now (in addition to my standard weekly file server backups).

FWIW, the network setup is pretty standard. Server and Desktop PC connected through LAN on the router. Netbook and laptop connected through Wfi. The error tonight was on my Desktop PC.
DVD Profiler Desktop and Mobile RegistrantDr. Killpatient
Here's my card
Registered: May 19, 2007
Reputation: Highest Rating
United States Posts: 5,917
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
There might be issues hanging around from the Delayed Write Error days.  I'd perform a db repair and re-add the profile that reported the error.
DVD Profiler Desktop and Mobile RegistrantStar Contributormreeder50
I was outta bullets
Registered: March 29, 2007
Reputation: Superior Rating
United States Posts: 2,737
Posted:
PM this userEmail this userView this user's DVD collectionDirect link to this postReply with quote
I agree with the Dr.
Marty - Registered July 10, 2004, User since 2002.
DVD Profiler Desktop and Mobile RegistrantStar Contributorhevanw
Registered: March 18, 2007
Belgium Posts: 426
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Ok, trouble in paradise again.

Just opened DVDP on my desktop computer and did a refresh all profiles. It found about 10, and downloaded them. Then after the download finished, my PC gave the following error:

Windows - Delayed Write Failed
Windows was unable to save all the data for the file \\Server\Shared\DVD Profiler\Databases\Our Collection\DirectProduce.DAT. The data has been lost. This error may be caused by a failure of your computer hardware or network connection. Please try to save.

At the same time, DVDP gave a popup :

Error loading the following Entry. Delete this record?
UPC: []
Title: []
Delete Record ?

After clicking Yes (as I intend to just restore my backup) I get a couple of other errors as well.

As the Delayed Write Failure error is again showing up, even after I recently reinstalled my server, I'll look a bit further down that path, with the link that Dr.Killpatient gave.
DVD Profiler Desktop and Mobile RegistrantStar Contributorhevanw
Registered: March 18, 2007
Belgium Posts: 426
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
The problem I am having is exactly what is described here : http://support.microsoft.com/kb/890352 . However, my server is XP Pro, not 2003, so doubt that the cause is the same.
After googling on that same event detail, I however found several hits of other people who have the same problem, even on XP. There are a few mentions about changing the network card's rate from 'auto' to '100 Full Duplex' so am trying that out now...

Update: no help, same problem during update of profiles .
 Last edited: by hevanw
DVD Profiler Desktop and Mobile RegistrantStar Contributorhevanw
Registered: March 18, 2007
Belgium Posts: 426
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Really clueless now. I did some other tests and nothing is revealing any problems with the communication between PC and server. I've never had problems streaming video or copying large files. Just did a test with a >1G file and it copies in a few minutes without hickups.
In fact, I have other applications where the client runs on my PC or laptop and that use a database (postgres) on the server and I never had any problems there either.

So why is it that only DVDP is triggering this Windows 'Delayed Write Failed' error ???
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next