Das XING-Abonnement funktioniert seit einiger Zeit nicht mehr. Nach Klick auf "Aktualisieren" ist nur ein Teil der Kontakte angekommen. Eine Analyse der Logfiles hat folgendes ergeben:
Schmutzige Lösung: Ich habe das Datenbankfeld einfach erweitert über:
Jetzt geht es erstmal wieder, sollte aber bei einem zukünftigen Release evtl. gefixt werden, da das Feature sonst de fakto unbrauchbar ist.
SEVERE: CON-0154 Category=12 Message=Import failed. Some data entered exceed the database field limit. Please shorten following entries: field21 Character Limit: 64 Sent 74 exceptionID=-651764010-109131
CON-0154 Category=12 Message=Import failed. Some data entered exceed the database field limit. Please shorten following entries: field21 Character Limit: 64 Sent 74 exceptionID=-651764010-109131
at com.openexchange.groupware.contact.ContactExceptio nFactory.buildException(ContactExceptionFactory.ja va:77)
at com.openexchange.groupware.contact.ContactExceptio nFactory.buildException(ContactExceptionFactory.ja va:62)
at com.openexchange.groupware.AbstractOXExceptionFact ory.createException(AbstractOXExceptionFactory.jav a:173)
at com.openexchange.groupware.contact.ContactExceptio nFactory.create(ContactExceptionFactory.java:89)
at com.openexchange.groupware.contact.Contacts.getTru ncation(Contacts.java:3027)
at com.openexchange.groupware.contact.Contacts.perfor mContactStorageInsert(Contacts.java:614)
at com.openexchange.api2.RdbContactSQLImpl.insertCont actObject(RdbContactSQLImpl.java:157)
at com.openexchange.subscribe.internal.ContactFolderU pdaterStrategy.save(ContactFolderUpdaterStrategy.j ava:159)
at com.openexchange.subscribe.internal.ContactFolderU pdaterStrategy.save(ContactFolderUpdaterStrategy.j ava:70)
at com.openexchange.subscribe.internal.StrategyFolder UpdaterService.save(StrategyFolderUpdaterService.j ava:90)
at com.openexchange.subscribe.internal.SubscriptionEx ecutionServiceImpl.storeData(SubscriptionExecution ServiceImpl.java:102)
at com.openexchange.subscribe.internal.SubscriptionEx ecutionServiceImpl.executeSubscriptions(Subscripti onExecutionServiceImpl.java:143)
at com.openexchange.subscribe.json.SubscriptionMultip leHandler.refreshSubscriptions(SubscriptionMultipl eHandler.java:160)
at com.openexchange.subscribe.json.SubscriptionMultip leHandler.performRequest(SubscriptionMultipleHandl er.java:133)
at com.openexchange.ajax.MultipleAdapterServlet.handl e(MultipleAdapterServlet.java:113)
at com.openexchange.ajax.MultipleAdapterServlet.doGet (MultipleAdapterServlet.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:596)
at com.openexchange.ajax.AJAXServlet.service(AJAXServ let.java:386)
at com.openexchange.ajax.SessionServlet.service(Sessi onServlet.java:165)
at com.openexchange.ajax.PermissionServlet.service(Pe rmissionServlet.java:66)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.doServletService(AJPv13RequestHandlerImpl.java: 504)
at com.openexchange.ajp13.AJPv13Request.response(AJPv 13Request.java:129)
at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.createResponse(AJPv13RequestHandlerImpl.java:31 6)
at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.c reateResponse(AJPv13ConnectionImpl.java:207)
at com.openexchange.ajp13.najp.AJPv13Task.call(AJPv13 Task.java:346)
at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.jav a:138)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:737)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:763)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'field21' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3489)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 36)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:995)
at com.openexchange.database.internal.wrapping.Prepar edStatementWrapper.execute(PreparedStatementWrappe r.java:99)
at com.openexchange.groupware.contact.Contacts.perfor mContactStorageInsert(Contacts.java:563)
... 25 more
CON-0154 Category=12 Message=Import failed. Some data entered exceed the database field limit. Please shorten following entries: field21 Character Limit: 64 Sent 74 exceptionID=-651764010-109131
at com.openexchange.groupware.contact.ContactExceptio nFactory.buildException(ContactExceptionFactory.ja va:77)
at com.openexchange.groupware.contact.ContactExceptio nFactory.buildException(ContactExceptionFactory.ja va:62)
at com.openexchange.groupware.AbstractOXExceptionFact ory.createException(AbstractOXExceptionFactory.jav a:173)
at com.openexchange.groupware.contact.ContactExceptio nFactory.create(ContactExceptionFactory.java:89)
at com.openexchange.groupware.contact.Contacts.getTru ncation(Contacts.java:3027)
at com.openexchange.groupware.contact.Contacts.perfor mContactStorageInsert(Contacts.java:614)
at com.openexchange.api2.RdbContactSQLImpl.insertCont actObject(RdbContactSQLImpl.java:157)
at com.openexchange.subscribe.internal.ContactFolderU pdaterStrategy.save(ContactFolderUpdaterStrategy.j ava:159)
at com.openexchange.subscribe.internal.ContactFolderU pdaterStrategy.save(ContactFolderUpdaterStrategy.j ava:70)
at com.openexchange.subscribe.internal.StrategyFolder UpdaterService.save(StrategyFolderUpdaterService.j ava:90)
at com.openexchange.subscribe.internal.SubscriptionEx ecutionServiceImpl.storeData(SubscriptionExecution ServiceImpl.java:102)
at com.openexchange.subscribe.internal.SubscriptionEx ecutionServiceImpl.executeSubscriptions(Subscripti onExecutionServiceImpl.java:143)
at com.openexchange.subscribe.json.SubscriptionMultip leHandler.refreshSubscriptions(SubscriptionMultipl eHandler.java:160)
at com.openexchange.subscribe.json.SubscriptionMultip leHandler.performRequest(SubscriptionMultipleHandl er.java:133)
at com.openexchange.ajax.MultipleAdapterServlet.handl e(MultipleAdapterServlet.java:113)
at com.openexchange.ajax.MultipleAdapterServlet.doGet (MultipleAdapterServlet.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:596)
at com.openexchange.ajax.AJAXServlet.service(AJAXServ let.java:386)
at com.openexchange.ajax.SessionServlet.service(Sessi onServlet.java:165)
at com.openexchange.ajax.PermissionServlet.service(Pe rmissionServlet.java:66)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:689)
at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.doServletService(AJPv13RequestHandlerImpl.java: 504)
at com.openexchange.ajp13.AJPv13Request.response(AJPv 13Request.java:129)
at com.openexchange.ajp13.najp.AJPv13RequestHandlerIm pl.createResponse(AJPv13RequestHandlerImpl.java:31 6)
at com.openexchange.ajp13.najp.AJPv13ConnectionImpl.c reateResponse(AJPv13ConnectionImpl.java:207)
at com.openexchange.ajp13.najp.AJPv13Task.call(AJPv13 Task.java:346)
at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.jav a:138)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.runTask(CustomThreadPoolExecuto r.java:737)
at com.openexchange.threadpool.internal.CustomThreadP oolExecutor$Worker.run(CustomThreadPoolExecutor.ja va:763)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'field21' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3489)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 36)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2542)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1734)
at com.mysql.jdbc.PreparedStatement.execute(PreparedS tatement.java:995)
at com.openexchange.database.internal.wrapping.Prepar edStatementWrapper.execute(PreparedStatementWrappe r.java:99)
at com.openexchange.groupware.contact.Contacts.perfor mContactStorageInsert(Contacts.java:563)
... 25 more
Code:
alter table prg_contacts change COLUMN field21 field21 varchar(128);
Comment