Index: grails-app/services/com/lemans/ds/qualitycontrol/QcChangeLogService.groovy
===================================================================
diff -u -rb4ee89a5294ff0aa256b3c50a187c511c550c0c5 -rd62387f918194bc923545698f275fd0c49a98e01
--- grails-app/services/com/lemans/ds/qualitycontrol/QcChangeLogService.groovy	(.../QcChangeLogService.groovy)	(revision b4ee89a5294ff0aa256b3c50a187c511c550c0c5)
+++ grails-app/services/com/lemans/ds/qualitycontrol/QcChangeLogService.groovy	(.../QcChangeLogService.groovy)	(revision d62387f918194bc923545698f275fd0c49a98e01)
@@ -344,7 +344,6 @@
 
             int[] batch = sql().withBatch(50, CHANGE_LOG_INSERT_SQL) { stmt ->
                 changes.each {
-                    log.debug("it: ${it}")
                     boolean saveChange = true
 
                     List entitiesByConfig = existingChangesForEntity?.getAt(it.entityId)?.getAt(it.configId)
@@ -362,7 +361,6 @@
                         List existingEntitiesForEntityId = existingChangesForEntity[it.entityId.toString()]?.values()?.flatten()
 
                         if (createdEntity) {
-                            log.debug("createdEntity: ${createdEntity}")
                             changeLogsIdsToBeDeleted << createdEntity.changeLogId //Same entity is created and deleted before approve
                             saveChange = false
                         }
@@ -383,25 +381,12 @@
                         changeLogsToBeDeleted << [configId: it.configId, entityId: it.entityId, userName: it.username] //ChangedValue is Same as the LastApprovedValue
                         saveChange = false
                     }
-                    log.debug("changeLogsToBeUpdatedToPendingApproval: ${changeLogsToBeUpdatedToPendingApproval}")
-                    log.debug("changeLogsToBeDeleted: ${changeLogsToBeDeleted}")
-                    log.debug("changeLogIdsToBeDeleted: ${changeLogsIdsToBeDeleted}")
-                    log.debug("saveChange: ${saveChange}")
                     if (saveChange) {
-                        log.debug("Executing..")
                         stmt.addBatch([configId: it.configId, parentEntityId: it.parentEntityId, entityId: it.entityId, approvalStatusId: approvalStatusId,
                                        changedValue: changedValue, lastApprovedValue: lastApprovedValue, changedDate: now, changedBy: it.username])
                     }
                 }
             }
-            log.debug("batch: ${batch}")
-            log.debug("entityIds: ${changes*.entityId}")
-            String query = "SELECT * FROM qc.changeLog WITH(NOLOCK) WHERE parentEntityId = '${changes[0].parentEntityId}' AND entityId IN (${changes*.entityId.join(',')})"
-            List results = sql().rows(query)
-            log.debug("results: ${results}")
-            log.debug("results.size(): ${results.size()}")
-            log.debug("changeLogIds: ${results*.changeLogId}")
-            println("sql lookup ${sql().rows(query)}")
             updateChangeLogsToPendingApproval(changeLogsToBeUpdatedToPendingApproval)
             deleteChangeLogsByConfigAndEntity(changeLogsToBeDeleted)
             deleteChangeLogsById(changeLogsIdsToBeDeleted, loggedUserName)
@@ -667,8 +652,6 @@
                 cleanedChangeLogs.addAll(cleanLogValues(partFitmentsByYear)*.changeLogId)
             }
         }
-        log.debug("cleanedChangeLogs: $cleanedChangeLogs")
-        log.debug("keywordChanges: ${partFitmentChanges*.changeLogId}")
         List changeLogsThatCanBeDeleted = partFitmentChanges*.changeLogId - cleanedChangeLogs
         changeLogsThatCanBeDeleted
     }