MobileSheets Forums

Full Version: database problem
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have created a backup file using the companion from my WIN10 surface pro.
This file is called xxx.msb.

After that, I copied this msb-file using an usb stick to my colleagues android tablets.
Restoring this file on android tablets does work. All songs are listed correct in the library.

But if we open one of the songs we get:
"Die Datei c:\users\xxx\mobilesheets\files\..Name existiert nicht"

It seems as if restoring from an WIN-10 msb-file to android (using the delet existing files option) does not modify the path.
I did test this recently, and didn't encounter any problems. If you would like me to test with the backup file you've generated, I'd be happy to do that. It's possible the file is missing from the backup entirely - that would explain why the path wasn't updated. 

Mike
Are you including settings with the backup, or not?

Thanks,
Mike
I just tested this multiple times and encountered no problems. If you want to share the backup file with me, I'll be happy to test it, otherwise I'm not sure how to reproduce it.

Thanks,
Mike
I guess this is similiar to the problems I have occasionally. Check the misbehaving song on the surface pro. Is there an explicit path associated with the missing file - full path displayed  in edit -> files tab? Maybe this is fixed now, but in some situations MS did not import the file but rather reference it in the original import location. Those files were not included in the backup
Hello Mike,
the msb-File is 3,3 GB. This is too much for mailing.

I just tried again:
  • Sync SurfacePro to PC (via Companian)
  • Backup Library (#no backup audio files, #no backup settings)
  • copy msb-file to android tablet (SD-card)

  • Start Mobilesheets on Android tablet
  • #Settings #Other Settings #Clear Library #Delete All Songs Files...
  • #Settings #Backup and Restore 'Restore Library from Backup
       # check: Delete all existig
       # uncheck: restore Settings,
       # MobileSheets Storage Location
       # Select msb-file

Result:
  • all files listed
  • no access to any file
    "File c:\users.... does not sxist."
Any chance you can upload the file to Dropbox or Google Drive to share with me? I wasn't testing using the companion app before, so I can certainly give that a shot. You could also try not using the companion app and see if you encounter the same problem.

Thanks,
Mike
Hi Mike,

did you find anything in my file?
I meanwhile found out, that restoring stops at about 90% of the files (I currently don't know why).
But after that, none of the songs can be opened in mobilesheets, but they are at the correct location (explorer).

It seems to me, as if all file paths are changed after successfull restoring of all files. So if there is one error during restoring, no path ist changed to the current location.

Is this possible?
I successfully restored your backup file with no problems using the companion application. I then verified I could load songs without encountering errors. I went to Find Missing Files, and there are 150 missing files reported. They all appear to be mp3 files. Would you expect to see those missing?

If your restore fails to complete, then the database will not be updated and the file paths will be wrong. So you definitely need to finish the restore without it failing. 

Mike
Thank you for testing!
The mp3-files are missing because I stored the backup without audio to reduce the file size.
I thought, the database would know if the backup-option "no audio" is used.

But the real reason of the problems seem to be that something stops the restore process just before finish.
Maybe there is not enough memory. I don't know.
This only happens on two tablets using Android 5.1.1.

Is there a possibility to force an database update, even if there is an error?
Currently nearly all songs are on the tablet, but we can't open any of them!
Turns out I spoke incorrectly. Even if the restore doesn't finish, it should be updating the paths for every song it was able to process. If that's not occuring for you, I will have to look into why that is.

Mike
I just verified that the database update does occur by letting the companion app restore to 90% and then I killed it (to simulate a connection being broken). The tablet updated what it could, and all the songs from around "U" onward were missing files. The others loaded fine.

Mike
(11-19-2017, 05:39 AM)Zuberman Wrote: [ -> ]I just verified that the database update does occur by letting the companion app restore to 90% and then I killed it (to simulate a connection being broken). The tablet updated what it could, and all the songs from around "U" onward were missing files. The others loaded fine.

Mike

Sorry for my bad english knowledge, but it seems as if I am not able to explain the problem.
I do not restore using the companion app!
The companion app is only used to create an msb-backup file to be stored the Desktop-PC, using the main tablet (Surface Pro). Later this msb-file is copied to the SD-card of the tablets from my musician colleagues (because we have no WLAN-access where ever we are playing).

The problem occurs during restoring the msb-file from the local SD card to mobilesheets without using the compainion, only using the mobilesheets app (android 5.1.1).
I just tried that on my Samsung Galaxy Note Pro 12.2" running 5.0.2, and it restored without a problem. What kind of tablet is this not working on?

Thanks,
Mike
The problems occur on both Point of View POV_TAB-I1345.
It seems to be a memory problem that causes the error during restoring.
Restoring stops at about 90% without any information.
But the mobilesheets-app doe not close.

On both tablets moving the sheets to SD card does still not work.
It seems to be a special problem of this tablet type.

I fear, we will have to replace those tablets.