TAE Password Migration 1905 Issue

[x1111111111]

SAP COMMERCE v1905

SQL search error wile running TAE Password Migration from HAC.

PROBLEM METHOD: de.hybris.platform.util.encryption.EncryptionUtil.getAllInstances(String, String)

ERROR : SQL search error - Column Index out of range, 2 > 1. CAUSE : You select one column in your statement and then access more than one column in your ResultSet.
OLD JAR [1808]

FlexibleSearch.getInstance().search("SELECT {PK}, {" + attribute + "} FROM {" + type + "}", Collections.EMPTY_MAP, Arrays.asList(new Class[] { Long.class, String.class }), true, true, 0, -1).getResult();

NEW JAR [1905]

FlexibleSearch.getInstance().search("GET {" + type + "}", Collections.EMPTY_MAP, Arrays.asList(Long.class, String.class), true, true, 0, -1).getResult(); 

Looks like GET only returns PK wheres result class expects LONG and String

SEVERE: Servlet.service() for servlet [springmvc] in context with path [/rexelatlantic/hac] threw exception [Request processing failed; nested exception is de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: SQL search error - Column Index out of range, 2 > 1.  query = 'SELECT  item_t0.PK  FROM users item_t0 WHERE (item_t0.TypePkString=? )', values = [8796097445970][HY-0]] with root cause
java.sql.SQLException: Column Index out of range, 2 > 1.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861)
        at com.mysql.jdbc.ResultSetImpl.checkColumnBounds(ResultSetImpl.java:767)
        at com.mysql.jdbc.ResultSetImpl.getStringInternal(ResultSetImpl.java:5214)
        at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5136)
        at de.hybris.platform.jdbcwrapper.interceptor.ResultSetWithJDBCInterceptor.lambda$5(ResultSetWithJDBCInterceptor.java:85)
        at de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.passThrough(SQLRecoverableExceptionHandler.java:101)
        at de.hybris.platform.jdbcwrapper.interceptor.recover.SQLRecoverableExceptionHandler.get(SQLRecoverableExceptionHandler.java:59)
        at de.hybris.platform.jdbcwrapper.interceptor.JDBCInterceptor.get(JDBCInterceptor.java:69)
        at de.hybris.platform.jdbcwrapper.interceptor.ResultSetWithJDBCInterceptor.getString(ResultSetWithJDBCInterceptor.java:85)
        at de.hybris.platform.jdbcwrapper.ResultSetImpl.getString(ResultSetImpl.java:156)
        at de.hybris.platform.persistence.property.JDBCValueMappings$DefaultStringValueReaderWriter.readValue(JDBCValueMappings.java:875)
        at de.hybris.platform.persistence.property.JDBCValueMappings$DefaultStringValueReaderWriter.readValue(JDBCValueMappings.java:1)
        at de.hybris.platform.persistence.property.JDBCValueMappings$AbstractValueReaderWriter.getValue(JDBCValueMappings.java:550)
        at de.hybris.platform.persistence.property.JDBCValueMappings.readValue(JDBCValueMappings.java:517)
        at de.hybris.platform.persistence.property.JDBCValueMappings.readColumns(JDBCValueMappings.java:507)
        at de.hybris.platform.persistence.property.JDBCValueMappings.processRows(JDBCValueMappings.java:481)
        at de.hybris.platform.persistence.property.JDBCValueMappings.getRows(JDBCValueMappings.java:455)
        at de.hybris.platform.persistence.property.JDBCValueMappings.getQueryResults(JDBCValueMappings.java:319)
        at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:208)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearch(FlexibleSearch.java:1928)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.compute(FlexibleSearchCacheUnit.java:51)
        at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:304)
        at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:277)
        at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:179)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.myGet(FlexibleSearchCacheUnit.java:92)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearchUsingFlexibleSearchDialect(FlexibleSearch.java:1607)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearchUsingPolyglotDialect(FlexibleSearch.java:1435)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1366)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1354)
        at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1791)
        at de.hybris.platform.util.encryption.EncryptionUtil.getAllInstances(EncryptionUtil.java:389)
        at de.hybris.platform.util.encryption.EncryptionUtil.migrate(EncryptionUtil.java:287)

Anyone has any idea about this ? Is it OOTB BUG ? Is there any Patch Jars released for this ?

[anuraghosh]

Hi, could you find a solution to your problem? I am getting similar issues when trying to click Migrate from HAC in 1905