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? |
|||||||||||
| |||||||||||