Support #4950

[SCP ID :##2484##] : Cash Management Solutions Problem : Services is currently unavailable.

Added by Zahir Abd Latif almost 10 years ago. Updated over 9 years ago.

Status:Closed - End of life cycleStart date:November 25, 2014
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY RIBSpent time:-
Target version:-

Description

Hi,
Kindly attend below request:

There is an error when user try to perform fund transfer saying "Services is currently unavailable". Kindly investigate.

bib_schema_missing_constraints_in_dr.sql (55.7 KB) Yap Kah Yan, January 12, 2015 09:17

bvprod_schema_missing_constraints_in_dr.sql (329 KB) Yap Kah Yan, January 12, 2015 09:17

ibg_schema_missing_constraints_in_dr.sql (15.2 KB) Yap Kah Yan, January 12, 2015 09:17

DR_bib_schema.sql (13.1 KB) Yap Kah Yan, January 12, 2015 09:17

DR_bvuserprod_schema.sql (44.1 KB) Yap Kah Yan, January 12, 2015 09:17

DR_ibg_schema.sql (2.7 KB) Yap Kah Yan, January 12, 2015 09:17

PROD_bib_schema.sql (67.8 KB) Yap Kah Yan, January 12, 2015 09:17

PROD_bvuserprd_schema.sql (368 KB) Yap Kah Yan, January 12, 2015 09:17

PROD_ibg_schema.sql (17.7 KB) Yap Kah Yan, January 12, 2015 09:17

History

#1 Updated by Zahir Abd Latif almost 10 years ago

  • Assignee changed from Nor Shuhaida Subri to Hafizudin MD

#2 Updated by Yap Kah Yan almost 10 years ago

Root Cause:
Trigger for auto generate OID is missing from DB for BIB related tables.

List of tables containing the trigger:
BIB_BILL_PAYMENT
BIB_INTER_TRANSFER
BIB_INTRA_TRANSFER
BIB_MOBILE_RELOAD
BIB_RECEIPT_DETAILS
BIB_SI
BIB_SI_HISTORY
BIB_USER_ACTIVITY

#3 Updated by Tan Lee Yong almost 10 years ago

  • Assignee changed from Hafizudin MD to Yap Kah Yan

Hi Kah Yan, we need to know why the sequence number script was removed. Even if the sequence id is disabled, but OID is the primary or unique key, how could the record being inserted?

#4 Updated by Tan Lee Yong almost 10 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

#5 Updated by Yap Kah Yan almost 10 years ago

Hi Mr Tan,

This issue happened when swing from DR env to PROD env. I am not sure how the IT team back up and restore the database.
From what we know,
1. they back up PROD DB
2. bring the data from PROD DB to DR DB
3. swing to DR
4. do trnx in DR
5. after DR - backup whatever in DR DB
6. restore the data into PROD DB
7. This issue happened (null value in OID column)

I tried to replicate the insert using SQL statement. Was not able to insert a null value for oid

#6 Updated by Tan Lee Yong almost 10 years ago

May be need to check their DR DB on the table and sequence number setting

#7 Updated by Zahir Abd Latif almost 10 years ago

Hi Kah Yan,
Please update this status by tomorrow morning. If not, I assumed this case is closed and will close this case by tomorrow afternoon.

#8 Updated by Yap Kah Yan almost 10 years ago

Hi Zahir,

We are still pending for the schema of DR database for verification.
Currently there is no report of this issue occurring again.

Thank you.

#9 Updated by Yap Kah Yan over 9 years ago

Compare both schema for prod and DR.
Found missing constraints and sequence in DR schema.
Attached is prod schema, DR schema, and the difference when comparing both schema

#10 Updated by Ngoh Chee Ping over 9 years ago

  • Status changed from Development / Work In Progress to Pending Customer Feedback

Last udated by Shikin - Jan 12 (4 days ago)

Dear Kah Yan;
We spoke. The constraints are exist in DR schema but when exported, its doesn't write to the sql. Will check and revert.

#11 Updated by Zahir Abd Latif over 9 years ago

Dear Kah Yan/ Chee Ping,

Any update on this case?

Thanks.

#12 Updated by Norhaidah Md Dasuki over 9 years ago

  • Assignee changed from Yap Kah Yan to Zahir Abd Latif
  • % Done changed from 0 to 90

Zahir,
Kindly forward email to IT based on the last email send by Tengku Norashikin on 12/1/2015 where they need to confirm on the constraints which exist in DR schema but when exported, its doesn't write to the sql.

We have make comparison on both schema for prod and DR and found missing constraints and sequence in DR schema.
We also has provided the the result on the prod schema, DR schema, and the difference when comparing both schema.

If no feedback within the resolution day, we shall close the case.

#13 Updated by Zahir Abd Latif over 9 years ago

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

Refer email (Jan 19, 2015 02:56 PM): Re: [Request ID :##2484##] : Cash Management Solutions Problem : Services is currently unavailable.

Case closed.

Also available in: Atom PDF