Support #10975

[SCP ID :##5405##] : M2U UIUX - BILL PAYMENT -

Added by Zahir Abd Latif about 4 years ago. Updated about 4 years ago.

Status:Closed - End of life cycleStart date:June 30, 2020
Priority:NormalDue date:July 01, 2020
Assignee:Zahir Abd Latif% Done:

100%

Category:-Spent time:2.00 hours
Target version:-

Description

Hi,
Kindly attend below request:

M2U UIUX : Bill Payment Offline with MSS-Payee-Bill Account Number Required set to no, fail to insert to table ib_bill_payment

to simulate :
http://10.247.12.51:9080/bii-rib-ticket/common/Login.do
Bill Payment > Other Bill Payment > Zakat > Baznas infaq

[7/1/20 12:12:40:871 WIB] 00000172 SystemOut O ############## Calling Database URL ################# jdbc:db2://10.247.12.52:50000/BIIDEV
[7/1/20 12:12:40:880 WIB] 00000172 SystemOut O [01/07/2020] [12:12:40:880] [ERROR] [JDBCExceptionReporter]:101 - DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=7, TABLEID=296, COLNO=5, DRIVER=3.62.56
[7/1/20 12:12:40:881 WIB] 00000172 SystemOut O [01/07/2020] [12:12:40:880] [ERROR] [JDBCExceptionReporter]:101 - DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=7, TABLEID=296, COLNO=5, DRIVER=3.62.56
[7/1/20 12:12:40:883 WIB] 00000172 SystemOut O [01/07/2020] [12:12:40:881] [ERROR] [AbstractFlushingEventListener]:324 - Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not insert: [net.penril.ibss.core.hibernate.IbBillPayment

History

#1 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 4 years ago

  • Due date set to July 01, 2020
  • Status changed from New - Begin Life Cycle to Development / Work In Progress
  • % Done changed from 0 to 100

Hazirah's reply to Bella

Hi Bella,

Sorry for the late reply. Earlier I thought about changing the column to nullable but i try to avoid making changes to the db. 
In this case, please refer to attached query to execute to change column to nullable.

#2 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian about 4 years ago

  • Status changed from Development / Work In Progress to Pending Customer Feedback
  • Assignee changed from Rayvandy Gabbytian to Zahir Abd Latif
  • % Done changed from 100 to 0

#3 Updated by Zahir Abd Latif about 4 years ago

  • Status changed from Pending Customer Feedback to Closed - End of life cycle
  • % Done changed from 0 to 100

Issue closed in SCP.

Also available in: Atom PDF