Skywalking OAP Data too long for column & Duplicate entry

[llluckyou]

When I started reporting data to the Skywalking soap server after connecting to the Skywalking agent deployment, there were a large number of errors in the soap server log, as shown below：

#2025-07-01 02:22:01,425 org.apache.skywalking.oap.server.storage.plugin.jdbc.common.dao.JDBCBatchDAO 81 [pool-3-thread-1] ERROR [] - [9.7.0-066457b] Data truncation: Data too long for column 'dest_endpoint' at row 1
and
#2025-07-01 02:23:06,072 org.apache.skywalking.oap.server.storage.plugin.jdbc.common.dao.JDBCBatchDAO 81 [pool-3-thread-1] ERROR [] - [9.7.0-066457b] Duplicate entry '202507010222_VXNlcg==.0-VXNlcg==-b2NwLWNsb3Vk.1-T1BUSU9OUzovYXBpL3YyL2luc3RhbmNlcw==' for key 'PRIMARY'

The version I am using is as follows：
Skywalking OAP：9.7.0
Skywalking Agent：9.4.0

Regarding the issue of excessively long fields, my solution in version 8. x.x was to manually increase the column length. However, I found that the new version would create a new data table based on the date suffix, which is no longer effective

I have not encountered any issues regarding the UK conflict before