Troubleshooting
Problem
Opening shipment details screen in Store Order Management (SOM) leads to the error 'The data bound to the column is invalid in this context'.
Symptom
Steps to reproduce
- Create a locale code as 'Central Time' and assign it to a store user.
- Create an order in OMS, get it fulfilled from store and take it to shipped status.
- Open the same shipment in SOM. The list of shipment appears. Click on the shipment link for details.
The following error message is returned - “The data bound to the column is invalid in this context”
Cause
The language for this item was en but the language code actually being passed in the WHERE clause was Central Time.
Diagnosing The Problem
Analyzing the logs reveal that while trying to open shipment detail screen, it tries to refer to YFS_ITEM_LOCALE table to fetch locale details for that particular item. The following query was fired in the logs which threw error -
- SELECT YFS_ITEM_LOCALE.* FROM YFS_ITEM_LOCALE YFS_ITEM_LOCALE WHERE LANGUAGE = 'Central Time' AND ITEM_KEY = 'xxxxxxxxxxxxxxxxxxxx' ;
The language for this item was en but the language code actually being passed in the WHERE clause was Central Time which was greater than the max column size (10) defined for LANGUAGE field in the YFS_ITEM_LOCALE table. Hence the error.
Further analysis revealed that the code tries to extract the language information to be passed in the WHERE clause, from the Locale code itself.
For example:
If the Locale Code is en_UST, it performs a string split using “_” as regex and extracts the first part as Language code. So, if the locale code is Central Time, there's no underscore (“_”) within it. As a result, no split occurs and the entire string is set in the WHERE clause with data length exceeding the acceptable column size.
Resolving The Problem
Locale Code must be created as per the international convention which is in <language_COUNTRY> format.
Following this convention eliminates the possibility of the above issue.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21674559