- 추가 사항
총 결제금액 21,900원
취소 요청 보낼 시 403 , NOT_CANCELABLE_AMOUNT code가 뜰 때도 있고
아래의 에러메세지가 발생할 때도 있습니다.
com.tosspayments.pg.approval.db.legacy.pg.support.Cancel_card_hException: org.springframework.jdbc.BadSqlGrammarException: \n### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: \"LASTPCANCEL\": invalid identifier\n\n### The error may exist in com/tosspayments/pg/approval/db/legacy/pg/mapper/PCancelMapper.xml\n### The error may involve com.tosspayments.pg.approval.db.legacy.pg.mapper.PCancelMapper.insertCancelCardH-Inline\n### The error occurred while setting parameters\n### SQL: INSERT /* TP200509 com.tosspayments.pg.approval.db.legacy.pg.mapper.PCancelMapper_insertCancelCardH by UPG 이선경 2017.07.07*/ INTO CANCEL_CARD_H( TRANSACTIONID , SUBTRANSACTIONID , SEQNO , SEQNO_SUB , MERCHANTID , REVAMOUNT , CAPTUREREVREQDATE , CANCELREASON , REGISTERDT , MODIFIEDDT , SUB_MERCHANTID , DIVIDEYN , CANCELSEQNO , POINTAMOUNT , DC_CAPTURE_REV_AMOUNT , TAXFREEAMOUNT , LASTPCANCEL ) VALUES ( SUBSTRB(?,1,24) , SUBSTRB(?,1,3) , ? , ? , SUBSTRB(?,1,15) , ? , SUBSTRB(?,1,14) , SUBSTRB(?, 1, 150) , SUBSTRB(?,1,14) , SUBSTRB(?,1,14) , SUBSTRB(?,1,15) , SUBSTRB(?,1,1) , SUBSTRB(?,1,3) , ? , ? , ? , ? )\n### Cause: java.sql.SQLSyntaxErrorException: ORA-00904: \"LASTPCANCEL\": invalid identifier\n\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: \"LASTPCANCEL\": invalid identifier\n"
com.tosspayments.pg.approval.db.legacy.pg.support.Cancel_card_hException: org.springframework.jdbc.BadSqlGrammarException: \n### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-00904: \"LASTPCANCEL\": invalid identifier\n\n### The error may exist in com/tosspayments/pg/approval/db/legacy/pg/mapper/PCancelMapper.xml\n### The error may involve com.tosspayments.pg.approval.db.legacy.pg.mapper.PCancelMapper.insertCancelCardH-Inline\n### The error occurred while setting parameters\n### SQL: INSERT /* TP200509 com.tosspayments.pg.approval.db.legacy.pg.mapper.PCancelMapper_insertCancelCardH by UPG 이선경 2017.07.07*/ INTO CANCEL_CARD_H( TRANSACTIONID , SUBTRANSACTIONID , SEQNO , SEQNO_SUB , MERCHANTID , REVAMOUNT , CAPTUREREVREQDATE , CANCELREASON , REGISTERDT , MODIFIEDDT , SUB_MERCHANTID , DIVIDEYN , CANCELSEQNO , POINTAMOUNT , DC_CAPTURE_REV_AMOUNT , TAXFREEAMOUNT , LASTPCANCEL ) VALUES ( SUBSTRB(?,1,24) , SUBSTRB(?,1,3) , ? , ? , SUBSTRB(?,1,15) , ? , SUBSTRB(?,1,14) , SUBSTRB(?, 1, 150) , SUBSTRB(?,1,14) , SUBSTRB(?,1,14) , SUBSTRB(?,1,15) , SUBSTRB(?,1,1) , SUBSTRB(?,1,3) , ? , ? , ? , ? )\n### Cause: java.sql.SQLSyntaxErrorException: ORA-00904: \"LASTPCANCEL\": invalid identifier\n\n; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: \"LASTPCANCEL\": invalid identifier\n"