Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java =================================================================== diff -u -rd6fe4609bafd690e3ee4121da7784812957b1bfe -ra2051fdaa03fc4b1127588774c6aece564c8b7cb --- src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision d6fe4609bafd690e3ee4121da7784812957b1bfe) +++ src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java (.../SessionDAOImpl.java) (revision a2051fdaa03fc4b1127588774c6aece564c8b7cb) @@ -1041,7 +1041,7 @@ return siteProductLines.length; } } ); - String sql1="update MIN_MAX_SITE_PREFERENCES set USER_CREATED_DATE=SYSDATE,USER_CREATED= "+user.getUserId ()+" where site_id in ( "+ siteIds +" ) and USER_CREATED_DATE is null "; + String sql1="update MIN_MAX_SITE_PREFERENCES set USER_CREATED_DATE = SYSDATE where site_id in ( "+ siteIds +" ) and USER_CREATED_DATE is null "; String sql2="update MIN_MAX_SITE_PREFERENCES set USER_CREATED= "+user.getUserId ()+" where site_id in ( "+ siteIds +" ) and USER_CREATED is null "; jdbcTemplate.update(sql1); jdbcTemplate.update(sql2); @@ -1201,18 +1201,18 @@ "includeOverstocks : {}, includeSupersede : {}, includeSoldNotStocked : {}, includeNewNumbers : {}, orderAllSkus : {}, dollarLimit : {}, " + "keyLinesOrders : {}, keyLinesReturns : {}, includeLessThanStdPkg : {}, useInvColls : {}, addDepth : {}, " + "comment : {}, siteGroup : {}, sites : {}, productGroups : {},fleetGroups : {}, " + - "customProductGroup : {}, skus : {}, productLines : {}, includeOrders : {}, includeReturns : {}, " + + "customProductGroup : {}, skus : {}, productLines : {}, siteProductLines : {}, includeOrders : {}, includeReturns : {}, " + "expirationDate : {}, includeHubSpokeOrder : {}, includeHubSpokeReturn : {}, includeHubSpokeOrderOption : {}, includeHubSpokeReturnOption : {}, " + "includeDaysCount : {}, salesHistoryValue : {},displayQty :{} ,sessionType : {}, applicationPartsOnly : {}, " + - "expirationDate : {}, isGroupCode : {},sessionId :{}", + "expirationDate : {}, isGroupCode : {} , leadTimeSiteStatus : {},sessionId :{}", includeFleets, perCarOrder, includeSystems, includeSpecials, includeObsoletes, includeOverstocks, includeSupersede, includeSoldNotStocked, includeNewNumbers, orderAllSkus, dollarLimit, includeKeylinesOrders, includeKeylinesOrders, includeLessThanStdPkg, useInvestmentCollections, provideStoreDepth, comment, siteGroupName, sitesArray, productGroupsArray, fleetGroupsIds, - customProductGroup, skuArray, productLineIdArray, includeOrders, includeReturns, + customProductGroup, skuArray, productLineIdArray,siteProductLines, includeOrders, includeReturns, expirationDate, includeHubSpokeOrderOption, includeHubSpokeReturnOption, includeDaysCount, salesHistoryValue,displayQty, sessionType, applicationPartsOnly, - expirationDate,isGroupCode,(BigDecimal) keyHolder.getKey ( )); + expirationDate,isGroupCode,leadTime,(BigDecimal) keyHolder.getKey ( )); rollbackSession ( (BigDecimal) keyHolder.getKey ( ) ); LOGGER.error ( "rollbackSession() called for sessionId: {}" , (BigDecimal) keyHolder.getKey ( ) );