Bug #5401

[SCP ID :##2740##] : EDW Report : cut length character for IP address field.

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

Status:Closed - End of life cycleStart date:July 22, 2015
Priority:NormalDue date:July 23, 2015
Assignee:Zahir Abd Latif% Done:

100%

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

Description

Hi,
Kindly attend below request:

Need your help to check for ip address Length character already match with the length that set in each report EDW.
because of the IP length in DB is set longer then the report length. do cut length character if needed.

History

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

  • Tracker changed from Support to Task
  • Status changed from New - Begin Life Cycle to Development / Work In Progress
  • % Done changed from 0 to 20

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

  • Due date set to July 23, 2015
  • % Done changed from 20 to 100

Dear all,

Root cause:
The reason why this value is written 3 times is because F5 returns same IP for each transaction three times (E.g.: 192.168.1.1, 192.168.1.1, 192.168.1.1) upon login, session and upon saving to DB.

Last workaround is by put more length in DB. However, it causes the report misaligned.

Solution:
IP Address has been cut to 30 digit as per requested.

Thank you.

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

  • Status changed from Development / Work In Progress to Pending Customer Feedback
  • % Done changed from 100 to 0

Dear all,

Waiting for Pak Wahyu's confirmation whether this is the solution that he's looking for.

Pending for SIT deployment.

Thank you.

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

  • Status changed from Pending Customer Feedback to Internal Testing

Informed Pak Wahyu to perform testing in SIT.

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

  • % Done changed from 0 to 100

24th July 2015 - Wahyu:

Hi Gabby,

Below if my feedback :
1. Why the filename is 2014-09-26 although the created datetime is latest.
2. If we open the file M2UTELEGRAPHIC_2014-09-26_000000.000000.DAT , inside is the trx from 20150710 until 20150713, hope this for testing only, just to remind you that this report is generated everyday, so it should include dailly trx only.
3. The file M2UOWNACCOUNTTRANSFER, M2UMOBILERELOAD, M2UTIMEDEPOSIT, M2UTHIRDPARTYTRANSFER, M2UREMITTANCE is empty although if we check on the db theres alot of trx.
4. The EDWSTATISTIC_2015-07-24_*.DAT is generated every 15 menit with the different filename (there addition hours minutes and second in the filename) should use as the other report filename format (EDWSTATISTIC_2015-07-24_000000.000000.DAT).

1st Aug 2015 - Gabby:

Dear Pak Wahyu,

My feedback from your earlier questions:

1. Why the filename is 2014-09-26 although the created datetime is latest.
Penril: Initial requirement, filename is taken from first record. The range of record of all reports is parameterised at AppConfig.

2. If we open the file M2UTELEGRAPHIC_2014-09-26_000000.000000.DAT , inside is the trx from 20150710 until 20150713, hope this for testing only, just to remind you that this report is generated everyday, so it should include dailly trx only.
Penril: You can change the parameter at AppConfig.

3. The file M2UOWNACCOUNTTRANSFER, M2UMOBILERELOAD, M2UTIMEDEPOSIT, M2UTHIRDPARTYTRANSFER, M2UREMITTANCE is empty although if we check on the db theres alot of trx.
Penril: Fixed.

4. The EDWSTATISTIC_2015-07-24_*.DAT is generated every 15 menit with the different filename (there addition hours minutes and second in the filename) should use as the other report filename format (EDWSTATISTIC_2015-07-24_000000.000000.DAT).
Penril: Fixed to follow item #1.

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

  • Tracker changed from Task to Bug
  • Status changed from Internal Testing to Pending Customer Feedback
  • Assignee changed from Rayvandy Gabbytian to Zahir Abd Latif
  • % Done changed from 100 to 0

Dear Zahir,

You may ask Wahyu whether this item can be closed.

Thank you.

#7 Updated by Zahir Abd Latif about 9 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