Index: grails-app/services/com/lemans/ds/fitment/PartFitmentService.groovy =================================================================== diff -u -r5c4def71f2b02472ca27deaa986ea680154bade9 -re19bce49dd0cef10f35b7cb54d6e0f1b645ca11e --- grails-app/services/com/lemans/ds/fitment/PartFitmentService.groovy (.../PartFitmentService.groovy) (revision 5c4def71f2b02472ca27deaa986ea680154bade9) +++ grails-app/services/com/lemans/ds/fitment/PartFitmentService.groovy (.../PartFitmentService.groovy) (revision e19bce49dd0cef10f35b7cb54d6e0f1b645ca11e) @@ -24,7 +24,12 @@ List results = sql().callWithAllRows(FIND_MODEL_SQL, [criteria.partNumber, criteria.offset, criteria.pageSize, criteria.sorting]) {} Clob clob = (Clob) results[0][0][0] - String clobData = clob.getSubString(1, (int) clob.length()) + String clobData + if (clob == null){ + clobData = ""; + } else { + clobData = clob.getSubString(1, (int) clob.length()) + } [results: clobData, totalRecords: results[1][0]?.totalRecords ?: 0] }