B - Production Support » Maybank Support » Maybank BII M2U-RIB Support

Dear all,

Below is the email trace:

12 January 2017 17:52 UTC+7

Dear Pak Wahyu,

Here is some suggested steps:

1. Make sure the said approval list is not listed in checker maker table (make sure there is anomaly caused by system).
select * from MK_TRNX_MASTER;

2. I need to understand, which module throwing ‘Pending Approval’ error. Please inform.

3. Perform update query to reset pending indicator. However, this is just a sample. It depends on the nature of the problem, since you did not mention it clearly.

Example, if the error is service info related area, E.g.: cannot edit service info display name (EN) and (IN) because of Pending for Approval, then perform:
update MK_PENDING = 0, where service_code = ‘<service code value>';

Thank you.

16 January 2017 15:32 UTC+7

Dear Gabby,

Below is the list that user want to delete :

cid:image001.png@01D267FF.454F6C00

16 January 2017 16:13 UTC+7

Dear Pak Wahyu,

1. If there is an error when approving or rejecting, please find the error containing keyword: IBSSAuthorizationResultEditUserServices inside SystemErr.log,

2. Workaround solution that we can suggest is by deleting those pending tasks that can be done as follows. Kindly run it in SIT first and test.

- delete from dbo.mk_trnx_master where mk_id in ('78661', '85346', '89411', '89656', '99067','100915');
- update dbo.ib_cust_profile where set mk_pending = '0' where user_id in (select user_id from dbo.ib_user where user_alias in ('steven0107', 'ReniHY19', 'ucialfnt', 'andrewad3012', 'yessika83', 'rezaballistics'));

Thank you.

16 January 2017 16:54 UTC+7

Dear Gabby,

Currently all the field mk_pending is allready 0

bash-3.2$ db2 "select mk_pending from dbo.ib_cust_profile where user_id in (select user_id from dbo.ib_user where user_alias in ('steven0107', 'ReniHY19', 'ucialfnt', 'andrewad3012', 'yessika83', 'rezaballistics'))" 

MK_PENDING
----------
        0.
        0.
        0.
        0.
        0.
        0.

  6 record(s) selected.

17 January 2017 09:35 UTC+7

Dear Pak Wahyu,

As spoken, we need to know the details what is this "edit user" about. I assumed, edit user profile activity that back office performed related to IB_CUST_PROFILE (such as changing financial status)?

Please:
1. Ask back office to provide screen capture for each activity that is having problem. The reason why I asking this, is so that we could more precisely check:
a. the table affecting it and provide quick solution,
b. check the service for any issue for long term fix (need to provide the log as well).

Example:
Screen Shot 2017-01-17 at 09.28.38.pngScreen Shot 2017-01-17 at 09.30.12.pngScreen Shot 2017-01-17 at 09.31.04.pngScreen Shot 2017-01-17 at 09.31.26.png

Thank you.