Absent Member.. randull Absent Member..
Absent Member..
52 views

PPM Support Tip: The text-field entry has length greater than that allowed for the database

 

Knowledge base article: KM00932974

 

When user takes action in a PPM request is getting the following error:

 

The text-field entry for {0} of {1} has length greater than that allowed for the database. (KNTA-70014)

 

The error shown in the serverLog.txt is:

 

The text-field entry for {0} of {1} has length greater than that allowed for the database. (KNTA-70014)
        at com.kintana.ex.util.ExpressUtils.checkDataIntegrityJSP(ExpressUtils.java:689)
        at com.kintana.crt.util.CRTXRequestUtils.getParameterCodeString(CRTXRequestUtils.java:1492)
        at com.kintana.crt.web.ctrl.RequestUpdateController.extractFields(RequestUpdateController.java:1409)
        at com.kintana.crt.web.ctrl.RequestUpdateController.update(RequestUpdateController.java:520)
        at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:87)
        at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:97)
        at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:115)
        at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
        at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:178)
        at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:104)
        at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:94)

 

The root cause for this issue is that probably while updating the request some special characters were inserted in the text fields that triggered this issue.
We have seen that while performing a copy paste the "LineFeed+CarriageReturn" is copied and this will create similar issues.

 

The recommendation is to try to avoid copying and pasting text into text fields, since the text could come with special characters that will trigger this issue.

 

Workaround

 

Copy the text from a text-only (Plain text) editor such as Notepad

Best regards,
Randall

-- Remember to give Kudos to answers! (click the KUDOS star)
"If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.