[SYNCOPE-1175] Password Reset Token Generation Not Working After Upgrading to 2.0.4

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.0.4
• Fix Version/s: 2.0.5, 2.1.0
• Component/s: core, enduser
• Assignee: Francesco Chicchiriccò
• Reporter: Justin Isenhour
• Created: 27/Jul/17 15:54
• Updated: 04/Sep/17 09:11
• Resolved: 28/Jul/17 11:23

Description

When I make a REST call to the User Self confirmPasswordReset API for a users I am getting a JPA persistence error. It seems that it is not able to save the User object because of the token value, see value below. I just recently upgrade to 2.0.4, prior to the upgrade this was working. Because of this all password reset functionality is impacted.

JPA Exception:
Caused by: org.apache.openjpa.persistence.PersistenceException: Incorrect string value: '\xF0\xA2\xA8\xAC\xEA\x92...' for column 'token' at row 1

{prepstmnt 1197754412 UPDATE SyncopeUser SET lastChangeDate = ?, lastModifier = ?, token = ?, tokenExpireTime = ? WHERE id = ?}

[code=1366, state=HY000]

Generate Token Value:
ખ—३¹ֽ·੕·੏߀½낵◭羐쒵࢙ꤿ쇟ॷ¬Ꮈ䥡ࡱŽ梭縶＝夾࡮¥࢏¼㷓ߎ¡ॎ¯ં«ｲ॓ᵲ㏉ચ¶੺‡认짃ㄘੰ˜ܪ㠄Œ멼饖뵣ࢪ§डµ櫆ꄳ㋏ࢡ ਡ‡⋨޸¯搘級籰녣헶੶·䬇࠼¸҉Ÿ뫫Ӈ“ॠ‡ࡁŸ씜҅‡몋뚧ц’ࣈš㧤㈰ং¸﮷ࣅ”ឹ櫚઻ƒࠟ¢ঘŠૈŸꇽঀ©⤠ਪ¸顉宏ৈŸ䚻兮蠥胳鏏યŽਤ¦਎¼ੂšऌŽથ°䰱ज±ओ¥뱐ਸº剾Є¿ટ ֦ºਚŸ੥¼ࡦ㦘৚¤ૉŒ㌳ꋂ㴹걲জ¿쨐व´ਭ§੾«࡞¢ࡵ‘⥮ਜ¯晶৫ू¬ッ࣓ƒम¶݌‹ࡉˆ긱ঈ¼ú뵳Ｎ쩸L鎹ࣺŸএŒ丠䆵ɥ檵ইº੏³䌻峨躾च²뱛ਚš륋斴݌¶꼲݉ݍ«䅯媍੊¼║ࡥ½쐬ࡤŸણ·鸼ࡡ°݆¬ॾž曻狤鹳५¯ਨ‰Ꮕਾº࣒³伡༽♦쪕㙳韍ऑ´さબ—릊띸뚒Ҍ¤㗆ੴ—㯙৓Œৈ“♥뛂赗놚੫¥屑઒‡퓐䂍簇踬濡਀¹૟£稹ृ±沽쪿࣢´㞿忟뾑甝ꈰࡻ¡➢ࡨª媉֨—ঃ˜৴Œⱚࢪ࢏®ࡰਉ–燈ෝ∯ঘ¦邈৚¾ࣕӏ•䐯埨넰৞˜ࡋŠਫ਼‹ࣈªࡺ—龚婁錄