Bug #107628 Cannot convert value 'AC-SINV-2022-Bukhari-08888' from column 5 to TIMESTAMP.
Submitted: 22 Jun 2022 5:11 Modified: 27 Jul 2022 18:18
Reporter: Muhammad Umer Lari Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:5.0 OS:Any
Assigned to: MySQL Verification Team CPU Architecture:Any

[22 Jun 2022 5:11] Muhammad Umer Lari 
Description:
Exception in component tDBInput_1 (POS_C_INVOICE_DETAILS)
java.sql.SQLException: Cannot convert value 'AC-SINV-2022-Bukhari-08888' from column 5 to TIMESTAMP.
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1084)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:973)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1404)
	at com.mysql.jdbc.ByteArrayRow.getTimestampFast(ByteArrayRow.java:127)
	at com.mysql.jdbc.ResultSetImpl.getTimestampInternal(ResultSetImpl.java:6587)
	at com.mysql.jdbc.ResultSetImpl.getTimestamp(ResultSetImpl.java:6187)
	at srb_95.pos_c_invoice_details_0_1.POS_C_INVOICE_DETAILS.tDBInput_1Process(POS_C_INVOICE_DETAILS.java:1364)
	at srb_95.pos_c_invoice_details_0_1.POS_C_INVOICE_DETAILS.runJobInTOS(POS_C_INVOICE_DETAILS.java:2457)
	at srb_95.pos_c_invoice_details_0_1.POS_C_INVOICE_DETAILS.main(POS_C_INVOICE_DETAILS.java:2306)
Caused by: java.lang.NumberFormatException: AC-SINV-2022-Bukhari-08888
	at com.mysql.jdbc.StringUtils.getInt(StringUtils.java:789)
	at com.mysql.jdbc.ResultSetRow.getTimestampFast(ResultSetRow.java:1156)
	... 6 more
[statistics] disconnected

How to repeat:
as i pass convert null in parameter but can't work
please help me out 

Suggested fix:
See note in description.
[27 Jun 2022 18:18] MySQL Verification Team 
Hi,

We need more data in order to reproduce this
[28 Jul 2022 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".