Skip to Content
0
Former Member
Jun 05, 2018 at 04:50 PM

LDAP import fails on Oracle with ORA-00932

158 Views

Our LDAP import work locally(default DB) but fails on the customer server(Oracle DB) with ORA-00932.

I have traced with problem to https://stackoverflow.com/questions/12980038/ora-00932-inconsistent-datatypes-expected-got-clob - basicaly the dn is a CLOB and hybris uses it in a SQL query WHERE clause where it is not allowed.

Hybris 6.7 DB Oracle

Looks like a Hybris bug to me(?)

This does NOT work

 SELECT  item_t0.PK  FROM users item_t0 WHERE ( item_t0.p_dn  = '12345678_1234')

This works

 SELECT  item_t0.PK  FROM users item_t0 WHERE ( item_t0.p_dn  LIKE '12345678_1234')

This confirms the problem a CLOB can't be compared with "=" only with "LIKE"

Full stacktrace

 INFO   | jvm 1    | main    | 2018/06/05 10:40:26.883 | [32mINFO  [hybrisHTTP14] [172.19.215.31] [DefaultImportService] Starting import synchronous using cronjob with code=0000007W
 INFO   | jvm 1    | main    | 2018/06/05 10:40:26.983 | [m[32mINFO  [hybrisHTTP14] [172.19.215.31] (0000007W) [ImpExImportJob] Starting multi-threaded ImpEx cronjob "ImpEx-Import" (4 threads)
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.083 | [m[32mINFO  [ImpExWorker<2/4>] [ImpExWorker] Returning worker impex worker 2/4 [cj:0000007W] to the pool
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.084 | [m[32mINFO  [ImpExWorker<3/4>] [ImpExWorker] Returning worker impex worker 3/4 [cj:0000007W] to the pool
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.084 | [m[32mINFO  [ImpExWorker<0/4>] [ImpExWorker] Returning worker impex worker 0/4 [cj:0000007W] to the pool
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.084 | [m[32mINFO  [ImpExWorker<1/4>] [ImpExWorker] Returning worker impex worker 1/4 [cj:0000007W] to the pool
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.084 | [m[32mINFO  [impex result worker [cj:0000007W]] [ImpExWorker] Returning worker impex result worker [cj:0000007W] to the pool
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.084 | [m[32mINFO  [impex reader worker [cj:0000007W]] [ImpExWorker] Returning worker impex reader worker [cj:0000007W] to the pool
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.084 | [m[32mINFO  [hybrisHTTP14] [172.19.215.31] (0000007W) [Importer] Finished 1 pass in 0d 00h:00m:00s:130ms - processed: 64, no lines dumped (last pass 0)
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.184 | [m[32mINFO  [hybrisHTTP14] [172.19.215.31] [DefaultImportService] Import was successful (using cronjob with code=0000007W)
 INFO   | jvm 1    | main    | 2018/06/05 10:40:27.685 | [m
 INFO   | jvm 1    | main    | 2018/06/05 10:42:17.446 | [33mWARN  [hybrisHTTP37] [172.19.215.31] [DefaultAbstractCollectorChartHandler] Could not find series values
 INFO   | jvm 1    | main    | 2018/06/05 10:42:17.947 | [m
 INFO   | jvm 1    | main    | 2018/06/05 10:55:41.231 | [33mWARN  [hybrisHTTP11] [172.19.38.126] [DefaultAbstractCollectorChartHandler] Could not find series values
 INFO   | jvm 1    | main    | 2018/06/05 10:55:41.732 | [m
 INFO   | jvm 1    | main    | 2018/06/05 10:58:05.148 | [32mINFO  [hybrisHTTP19] [172.19.38.126] [PerformCronJobAction] Performing CronJob LDIFImportCronJobModel (8796098167285@1871) from Backoffice!
 INFO   | jvm 1    | main    | 2018/06/05 10:58:05.649 | [m
 STATUS | wrapper  | main    | 2018/06/05 10:58:52.209 | Pinging the JVM took 1 seconds to respond.
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.011 | [32mINFO  [LdifImportCronJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (LdifImportCronJob) [LDIF2ImpExConverter] Read 19548 total entries.  -- All successfully imported.
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.411 | [m[1;31mERROR [LdifImportCronJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (LdifImportCronJob) [FlexibleSearch] line 5 at main script: Flexible search error occured...
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.411 | [m[1;31mERROR [LdifImportCronJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (LdifImportCronJob) [Importer] line 5 at main script: Exception 'SQL search error - ORA-00932: inconsistent datatypes: expected - got CLOB
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.411 |  query = 'SELECT  item_t0.PK  FROM users item_t0 WHERE ( item_t0.p_dn  =  ?) AND (item_t0.TypePkString IN  (?,?) )', values = [00032377_19901101, 8796096823378, 8796095610962]' in handling exception: SQL search error - ORA-00932: inconsistent datatypes: expected - got CLOB
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |  query = 'SELECT  item_t0.PK  FROM users item_t0 WHERE ( item_t0.p_dn  =  ?) AND (item_t0.TypePkString IN  (?,?) )', values = [00032377_19901101, 8796096823378, 8796095610962]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 | [m[32mINFO  [LdifImportCronJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (LdifImportCronJob) [DefaultDumpHandler] Dump file is located at /usr/sap/WEHY/hybris/temp/hybris/dumpfile8477307896514098219.tmp
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 | [m[33mWARN  [LdifImportCronJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (LdifImportCronJob) [Importer] Import aborted after 0d 00h:00m:00s:032ms
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 | [m[1;31mERROR [LdifImportCronJob::de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob] (LdifImportCronJob) [LDIFImportJobPerformable] Exception at LDIFImportJobPerformable
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 | [m de.hybris.platform.servicelayer.exceptions.SystemException: Cannot generate ImpExScript.
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.ldap.jobs.impl.DefaultLDIFImportStrategy.executeFileBasedImport(DefaultLDIFImportStrategy.java:115) ~[ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.c2p..services.strategy.impl.LDIFImportStrategy.executeFileSearchBasedImport(LDIFImportStrategy.java:92) ~[servicesserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.ldap.jobs.LDIFImportJobPerformable.executeSearchBasedImport(LDIFImportJobPerformable.java:93) ~[ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.ldap.jobs.LDIFImportJobPerformable.performJob(LDIFImportJobPerformable.java:71) ~[ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.ldap.jobs.LDIFImportJobPerformable.perform(LDIFImportJobPerformable.java:44) [ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.ldap.jobs.LDIFImportJobPerformable.perform(LDIFImportJobPerformable.java:1) [ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.ldap.jobs.LDIFImportJobPerformable$$EnhancerBySpringCGLIB$$c37d414a.perform(<generated>) [ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.servicelayer.internal.jalo.ServicelayerJob.performCronJob(ServicelayerJob.java:38) [processingserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.cronjob.jalo.Job.execute(Job.java:1390) [processingserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.cronjob.jalo.Job.performImpl(Job.java:814) [processingserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.cronjob.jalo.Job.access$1(Job.java:767) [processingserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.cronjob.jalo.Job$JobRunable.run(Job.java:686) [processingserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.util.threadpool.PoolableThread.internalRun(PoolableThread.java:208) [coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 |     at de.hybris.platform.core.threadregistry.RegistrableThread.run(RegistrableThread.java:134) [coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.412 | Caused by: de.hybris.platform.impex.jalo.ImpExException: line 5 at main script: SQL search error - ORA-00932: inconsistent datatypes: expected - got CLOB
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |  query = 'SELECT  item_t0.PK  FROM users item_t0 WHERE ( item_t0.p_dn  =  ?) AND (item_t0.TypePkString IN  (?,?) )', values = [00032377_19901101, 8796096823378, 8796095610962]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.Importer.importNextInternal(Importer.java:764) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.Importer.importAll(Importer.java:709) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.ImpExManager.importDataLight(ImpExManager.java:966) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.ldap.jobs.impl.DefaultLDIFImportStrategy.executeFileBasedImport(DefaultLDIFImportStrategy.java:106) ~[ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     ... 13 more
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 | Caused by: de.hybris.platform.impex.jalo.ImpExException: SQL search error - ORA-00932: inconsistent datatypes: expected - got CLOB
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |  query = 'SELECT  item_t0.PK  FROM users item_t0 WHERE ( item_t0.p_dn  =  ?) AND (item_t0.TypePkString IN  (?,?) )', values = [00032377_19901101, 8796096823378, 8796095610962]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.imp.ImpExImportReader.processLine(ImpExImportReader.java:756) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.imp.ImpExImportReader.readLine(ImpExImportReader.java:518) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.Importer.doImport(Importer.java:251) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.Importer.importNextInternal(Importer.java:758) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.Importer.importAll(Importer.java:709) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.impex.jalo.ImpExManager.importDataLight(ImpExManager.java:966) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.ldap.jobs.impl.DefaultLDIFImportStrategy.executeFileBasedImport(DefaultLDIFImportStrategy.java:106) ~[ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     ... 13 more
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 | Caused by: de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: SQL search error - ORA-00932: inconsistent datatypes: expected - got CLOB
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |  query = 'SELECT  item_t0.PK  FROM users item_t0 WHERE ( item_t0.p_dn  =  ?) AND (item_t0.TypePkString IN  (?,?) )', values = [00032377_19901101, 8796096823378, 8796095610962]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:183) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.413 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearch(FlexibleSearch.java:1810) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.compute(FlexibleSearchCacheUnit.java:51) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:305) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:278) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:180) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.myGet(FlexibleSearchCacheUnit.java:90) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1453) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1380) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1343) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1640) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.imp.DefaultExistingItemResolver.searchItems(DefaultExistingItemResolver.java:345) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.imp.DefaultExistingItemResolver.resolveByQuery(DefaultExistingItemResolver.java:192) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.imp.DefaultExistingItemResolver.findExisting(DefaultExistingItemResolver.java:133) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.imp.DefaultImportProcessor.processItemData_Impl(DefaultImportProcessor.java:213) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.imp.DefaultImportProcessor.processItemData(DefaultImportProcessor.java:158) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.imp.ImpExImportReader.processLine(ImpExImportReader.java:718) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.imp.ImpExImportReader.readLine(ImpExImportReader.java:518) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.Importer.doImport(Importer.java:251) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.Importer.importNextInternal(Importer.java:758) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.Importer.importAll(Importer.java:709) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.impex.jalo.ImpExManager.importDataLight(ImpExManager.java:966) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at de.hybris.platform.ldap.jobs.impl.DefaultLDIFImportStrategy.executeFileBasedImport(DefaultLDIFImportStrategy.java:106) ~[ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     ... 13 more
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 | Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 | 
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.414 |     at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) ~[ojdbc7.jar:12.1.0.2.0]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jdbcwrapper.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:196) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:124) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearch(FlexibleSearch.java:1810) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.compute(FlexibleSearchCacheUnit.java:51) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.cache.AbstractCacheUnit.privateGetNoLock(AbstractCacheUnit.java:305) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.cache.AbstractCacheUnit.privateGet(AbstractCacheUnit.java:278) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.cache.AbstractCacheUnit.get(AbstractCacheUnit.java:180) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearchCacheUnit.myGet(FlexibleSearchCacheUnit.java:90) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1453) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1380) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1343) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.search(FlexibleSearch.java:1640) ~[coreserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.imp.DefaultExistingItemResolver.searchItems(DefaultExistingItemResolver.java:345) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.imp.DefaultExistingItemResolver.resolveByQuery(DefaultExistingItemResolver.java:192) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.imp.DefaultExistingItemResolver.findExisting(DefaultExistingItemResolver.java:133) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.imp.DefaultImportProcessor.processItemData_Impl(DefaultImportProcessor.java:213) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.imp.DefaultImportProcessor.processItemData(DefaultImportProcessor.java:158) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.imp.ImpExImportReader.processLine(ImpExImportReader.java:718) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.imp.ImpExImportReader.readLine(ImpExImportReader.java:518) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.Importer.doImport(Importer.java:251) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.Importer.importNextInternal(Importer.java:758) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.Importer.importAll(Importer.java:709) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.impex.jalo.ImpExManager.importDataLight(ImpExManager.java:966) ~[impexserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     at de.hybris.platform.ldap.jobs.impl.DefaultLDIFImportStrategy.executeFileBasedImport(DefaultLDIFImportStrategy.java:106) ~[ldapserver.jar:?]
 INFO   | jvm 1    | main    | 2018/06/05 10:58:54.415 |     ... 13 more