Is anyone having issue with roadtest submissions? Having some SQL error message.

Question

This is error message I get when I try to submit:

PreparedStatementCallback; SQL [ INSERT INTO e14RoadTestApp ( roadTestAppID, containerID, containerType, userID, status, creationDate, modificationDate, title, description, roadTestID, fullName, email, address1, address2, language_code, city, province, postal, phone, fax, country, internalStatus, eeExperience, jobRole, comparableProducts, applicationUsage, projectTitle ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ); ]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation

jdlui · Answer

HI Dudley, I'm applying for the tinyTILE roadtest. My submission is viewable here: element14 tinyTILE Intel Curie Based Board Please see my comment at Apr 12, 2017 7:51 AM for some more detail on the issue. How I caused the error: I allow Google Chrome fill fields and it inserted an 11 char string into the postal code field. Example 00146 ITALY. If I click submit now, it will crash and give SQL error. However if I delete a single char so that it's length 10, it will submit happily. Note I cannot physically enter the characters again. I guess Chrome's autofill inserts text a bit differently and this bypassed the webpage form coding on Element14 site. Here is a screen shot where I replicate issue on a different roadtest.

jdlui · Answer

Thank you for the suggestions Andy and Frederick.

I played with it a bit further and managed to find the problem. I have now managed to submit my application. The issue was not in the word limit of the main submission, but the character limit of postal code field.

Problem was that I was allowing Chrome to autofill my address details. This shouldn't cause an issue in theory but I noticed that Chrome seems to be overfilling the postal code field (I cram my postal code and country here since there is no country field in the application).

Chrome autofilled 11 characters into this field, but I can see when I erase the postal code field and manually type it, the browser truncates my text at 10 characters. So this is where the truncation error was in that SQL error.

Thanks folks!

Robert Peter Oakes · Answer

rscasny Aside from the fact there appears to be a problem with submission, it may be a one off, it may be ongoing but worse than that, the error handler is giving away internal infrastructure and details that could be used to compromise the system You may want to get your support guys on this ASAP (Fix the error handling and the submission problem) Jordan, im sure well get this fixed asap, your issue is bad but the implications of error handler is worse... I am sure E14 will get both fixed asap. Peter

rscasny · Answer

Peter, I'll ask the support. But first I updated your RoadTest application. Try it again. Randall

Robert Peter Oakes · Answer

It was Jordan's Road test, not mine but i'm sure he will realise that.

Workshopshed · Answer

Data truncation, Is it a really long submission?

fvan · Answer

Could try to isolate truncation issue by submitting review with single word in body, see if that works?

jdlui · Answer

Hi Randall, I tried again to submit, looks like identical SQL error message. Any suggestion you have would be much appreciated PreparedStatementCallback; SQL [ INSERT INTO e14RoadTestApp ( roadTestAppID, containerID, containerType, userID, status, creationDate, modificationDate, title, description, roadTestID, fullName, email, address1, address2, language_code, city, province, postal, phone, fax, country, internalStatus, eeExperience, jobRole, comparableProducts, applicationUsage, projectTitle ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ); ]; Data truncation; nested exception is java.sql.DataTruncation: Data truncation