Error occurred while importing the assay library

support
Error occurred while importing the assay library caixue  2023-12-11 04:35
 
When I tried to import the assay library in TSV format, I encountered the following error message:

---------------------------
Skyline
---------------------------
Failed reading the file D:\lab\project\DIA_PRM\TPDlibV2_FAIMS_FP_iRT_nonIsoform20422Fasta_20230621.tsv. Unexpected SQLite failure reading D:\lab\project\MFT\FAIMS_TPD_lib-assay.blib.
---------------------------
OK More Info
---------------------------
System.IO.IOException: Unexpected SQLite failure reading D:\lab\project\MFT\FAIMS_TPD_lib-assay.blib. ---> System.Data.SQLite.SQLiteException: SQL logic error or missing database
no such table: RefSpectraPeaks
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at pwiz.Skyline.Model.Lib.BiblioSpecLiteLibrary.<>c__DisplayClass72_0.<ReadSpectrum>b__0(SQLiteConnection connection) in C:\proj\skyline_23_1\pwiz_tools\Skyline\Model\Lib\BiblioSpecLite.cs:line 1319
   at pwiz.Skyline.Util.PooledSqliteConnection.ExecuteWithConnection[T](Func`2 function) in C:\proj\skyline_23_1\pwiz_tools\Skyline\Util\PooledSqliteConnection.cs:line 95
   --- End of inner exception stack trace ---
   at pwiz.Skyline.Util.PooledSqliteConnection.ExecuteWithConnection[T](Func`2 function) in C:\proj\skyline_23_1\pwiz_tools\Skyline\Util\PooledSqliteConnection.cs:line 106
   at pwiz.Skyline.Model.Lib.CachedLibrary`1.LoadSpectrum(Object spectrumKey) in C:\proj\skyline_23_1\pwiz_tools\Skyline\Model\Lib\Library.cs:line 1118
   at pwiz.Skyline.Model.Lib.SpectrumInfoLibrary.get_SpectrumPeaksInfo() in C:\proj\skyline_23_1\pwiz_tools\Skyline\Model\Lib\Library.cs:line 2526
   at pwiz.Skyline.Model.Lib.SpectrumMzInfo.GetInfoFromLibrary(Library library) in C:\proj\skyline_23_1\pwiz_tools\Skyline\Model\Lib\Library.cs:line 2425
   at pwiz.Skyline.SkylineWindow.ImportMassListIntensities(SrmDocument& doc, List`1 librarySpectra, Boolean assayLibrary, BiblioSpecLiteSpec& docLibrarySpec, BiblioSpecLiteLibrary& docLibrary, Int32& indexOldLibrary) in C:\proj\skyline_23_1\pwiz_tools\Skyline\SkylineFiles.cs:line 2400
   at pwiz.Skyline.SkylineWindow.ImportMassList(MassListInputs inputs, String description, Boolean assayLibrary, DOCUMENT_TYPE inputType, Boolean forceDlg) in C:\proj\skyline_23_1\pwiz_tools\Skyline\SkylineFiles.cs:line 2106
   at pwiz.Skyline.SkylineWindow.ImportAssayLibrary(MassListInputs inputs, String description) in C:\proj\skyline_23_1\pwiz_tools\Skyline\SkylineFiles.cs:line 1874
   at pwiz.Skyline.SkylineWindow.ImportAssayLibrary(String fileName) in C:\proj\skyline_23_1\pwiz_tools\Skyline\SkylineFiles.cs:line 1864
---------------------------
May I ask how to solve this?
 
 
Nick Shulman responded:  2023-12-11 06:57
The error is saying that the database file "D:\lab\project\MFT\FAIMS_TPD_lib-assay.blib" is missing a table which is expected to be present.

The usual reason that such an error would happen would be if the file was a completely different type of file, and was not a BiblioSpec spectral library.

If you send us that file we might be able to figure out what has gone wrong. It might also be helpful if you send us "D:\lab\project\DIA_PRM\TPDlibV2_FAIMS_FP_iRT_nonIsoform20422Fasta_20230621.tsv" as well.

If those files are less than 50MB you can attach them to this support request. You can upload larger files here:
https://skyline.ms/files.url
--Nick