Set the initial language preferences value from "English" to "Spanish" for non english end-users' first logins into the service portal.
Update the table "entities_100000002" for set the value "es" into the "schar2" field in "xservices_ems" database.
This update is not complete because all items, categories and km records are still displaying in English, nevertheless the rest of literals are displayed in Spanish. (see attachments).
update entities_100000002 set schar2 = 'es' where entity_type_id = 136 and schar8 = 'ESX0001703'; (Database xservices_ems)
The fist login page into service portal where the user has to modify/upload his picture, give the possibility to set the language preferences for the next login too.
Thanks in advance,