SAP EP – Netweaver Portal

Symptom

You are using UWL and notice the following exception in the traces:
“OpenSQLException: Cannot assign a blank-padded string to host variable…” AND you try to do some custom configuration for displaying custom attributes in UWL and might realize that some attributes are not displayed although it seems that you have configured everything correctly.
Other terms

UWL, custom attributes, OpenSQLException
Reason and Prerequisites

OpenSQL rejects some statements containing insertions with trailing spaces and SAP supports OpenSQL for portability reasons. The most likely cause for the error is that in some of your custom xml file a trailing space is present for a String xml tag like
connector=”WebFlowConnector ” or objectType=”WebflowContainer “(note trailing space). UWL has to insert the data given in the custom xml into the database, but it fails due to the OpenSQL restriction.
Solution

Check your custom xml files for trailing spaces in String tags. If you find one, download the xml under question from the portal, backup it, delete the configuration, remove the trailing spaces, save and re-upload the configuration. Clear the UWL cache and re-register the connector with which you are trying to configure the custom attributes.