Sand production is a major problem that the oil and gas industry has been facing for years. It can lead to loss of production, equipment damage or complete well abandonment. Prediction of sand has been historically challenging due to the periodic nature of sand production, insufficient laboratory tests and lack of field tests validation. Analyses have been performed to identify weak zones for planned wells, and common technique is the application of shear modulus and mechanical properties log (MPL) criteria developed by Tixier et al. (J Pet Technol 27:283-293, 1975). However, the set criteria have been found to be generally inadequate to detect transition zone or predict weak formation in some fields. In this study, using the knowledge of rock behavior, geomechanical properties and well log data, we have established new simple criteria for identifying fragile sections within a transition zone. In situ logging data from a field X, located in Sabah, Malaysia, and Field Y, located in Shimokita, Japan, were used in this study. Using the threshold for shear modulus and MPL, the criteria for the geomechanical properties are set to differentiate formation strengths at different depths. The threshold for Poisson's ratio is 0.34, Young's modulus at 1.6 × 10 6 psi and the unconfined compressive strength at 2400 psi. The MPL and geomechanical models were generated to predict sanding incident. The results were subsequently validated with artificial neural network using MATLAB. Also, critical wellbore pressure is calculated and acts as a guide to operate outside the sand failure envelope. Thus, the prediction of the weak formation using geomechanical properties has been further established in this study.