search

compomics / meta-proteome-analyzer

MetaProteomeAnalyzer (MPA) software for analyzing and visualizing MS-based metaproteomics data.
27 stars 10 forks source link

error while running #34

Open AndreaQ7 opened 3 years ago

AndreaQ7 commented 3 years ago

Hello everyone, I am running MPA on my mgf data but I get an error message and Im not sure about what it is telling me , does anyone may help? At the end of the run no protein is recognized at all

INFO 2021-05-20 11:36:20,433 [pool-1-thread-1] ServerImpl:52 SEARCH 1/1 BATCH 1/14 FINISHED
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'mzarray' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4094)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2444)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2347)
        at de.mpa.db.mysql.accessor.SpectrumTableAccessor.persist(SpectrumTableAccessor.java:706)
        at de.mpa.db.mysql.storager.SpectrumStorager.store(SpectrumStorager.java:164)
        at de.mpa.db.mysql.storager.SpectrumStorager.run(SpectrumStorager.java:228)
        at java.lang.Thread.run(Thread.java:745)

ERROR 2021-05-20 11:39:48,412 [Thread-10] SpectrumStorager:236 Spectrum storing error message: null
java.lang.NullPointerException
        at de.mpa.db.mysql.accessor.SearchspectrumTableAccessor.<init>(SearchspectrumTableAccessor.java:123)
        at de.mpa.db.mysql.accessor.Searchspectrum.<init>(Searchspectrum.java:24)
        at de.mpa.db.mysql.storager.SpectrumStorager.store(SpectrumStorager.java:176)
        at de.mpa.db.mysql.storager.SpectrumStorager.run(SpectrumStorager.java:228)
        at java.lang.Thread.run(Thread.java:745)

 INFO 2021-05-20 11:39:48,416 [Thread-10] SpectrumStorager:239 Spectra stored to the DB.