ankit barsainya wrote:It is definitely a Data Issue that you and only you can debug. As you have investigated erroneous data exists between 140 and 150 record (not necessarily, but most certainly). It may have worked till date because the data was correct till date. In case you are trying to convert String to Number, then maybe you have encountered a Character data which resulted in an error.
i'm executing a load test using the below statement:
INSERT INTO BPMBI.PPROCINSTANCE SELECT * FROM BPMBI.PPROCINSTANCE_BKP WHERE ROWNUM < 501;
I've been trying to check what the issue is and when i execute the rownum < 140 works fine while rownum < 150 is showing the same error.
Can you please suggest what might be the issue here?