SQL Exception when loading vistor info

Opening pixel log file 09081923-207.txt
2009-08-20 00:11:56.747 (1) [P2T0]: Exception [Error loading
record]:com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION
st-tracker.ARRAY does not exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3170)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3099)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1172)
at com.carldunham.jst.db.Database.executeQuery(Database.java:356)
at com.carldunham.jst.db.Database.executeQuery(Database.java:308)
at com.carldunham.jst.db.BaseDatabaseTable.select(BaseDatabaseTable.java:184)
at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:380)
at com.carldunham.jst.db.BaseDatabaseTableRow.load(BaseDatabaseTableRow.java:341)
at com.thesearchagency.playback.SpikeVisitor.load(SpikeVisitor.java:87)
at
com.thesearchagency.playback.RecordedCGISpikeTracker.updateSession(RecordedCGISpikeTracker.java:465)
at
com.thesearchagency.playback.RecordedCGISpikeTracker.record(RecordedCGISpikeTracker.java:254)
at
com.thesearchagency.playback.SpikePlayer$RecordHitPixel.recordHit(SpikePlayer.java:914)
at
com.thesearchagency.playback.SpikePlayer$SpikePlayerWorker.parseFile(SpikePlayer.java:565)
at
com.thesearchagency.playback.SpikePlayer$SpikePlayerWorker.run(SpikePlayer.java:500)
at com.carldunham.jst.concurrency.ThreadPool$WorkerThread.run(ThreadPool.java:248)

This is happening due to bad data in the input file for visitorid having bad
data as in sample below. It usually starts with prefix uvid but in sample it is
ARRAY%280x87e9928%29.

1250749068
tsas207:usid121a944cbdff3b569afc996a2a73373e73541|tsav207:ARRAY%280x87e9928%29
HTTP_USER_AGENT:Mozilla%2F5.0%20%28Windows%3B%20U%3B%20Windows%20NT%205.1%3B%20en-US%3B%20rv%3A1.9.0.12%29%20Gecko%2F2009070611%20Firefox%2F3.0.12|REMOTE_ADDR:220.225.232.237|HTTP_REFERER:https%3A%2F%2Fssl.safewebshop.mysitebeta.com%2Fcgi-bin%2Fpath%2Fsignup%2Freceipt%3Fxt%3D1250749062
tsatime:1250749068153|uref:https%3A%2F%2Fssl.safewebshop.mysitebeta.com%2Fcgi-bin%2Fpath%2Fsignup%2Fconfirm%3Fxt%3D1250749027%26transfer_domain%3D%26register_extension%3Dcom%26NIGOL%3D886f28fea558739bfeb89b7bb4358e64%2Fsignup.mysitebeta.com%2F1250749022%2F120%2Fsss.2.89275%2F1250748957.20982248%26upsell_was_showed%3D1%26package_id%3D0%26domain_option%3Dsubdomain%26link_id%3D1%26domain%3Djfaux-5.mysitebeta.com%26free_desired_partner_domain%3Dmysitebeta.com%26free_subdomain%3Djfaux-5%26from_host%3Dsignup.mysitebeta.com%26tld_domain%3D|pageQs:xt%3D1250749062|siteid:207|wayid:930|productID:Free|tsa1v207:ARRAY%280x87e9928%29|tsa1s207:usid121a944cbdff3b569afc996a2a73373e73541
10

To fix this the lines in pixel logs is processed only if the visitor id starts
with prefix uvid or tsavid.