Wrong Results in Pipeline iScript Date Functions

(Doc ID 880106.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 28-March-2016***

Symptoms

Problem Statement

Pipeline iScript Date functions computes wrong results.

Steps To Reproduce

1) Added below entries in opt/ifw/iScriptLib/AAA/ISC_PopulateOpcodeAndUtilBlock_Diameter.isc , after line number 590 i.e. in Authorize request.

Date date0 = strToDate("1970-01-01 01:00:01", "%Y-%m-%d %H:%M:%S");
Date date1 = strToDate("2009-07-22 10:00:01", "%Y-%m-%d %H:%M:%S");
Long diff01 = dateDiff(date1, date0);
logPipeline("date0 = "+dateToStr(date0, "%Y-%m-%d %H:%M:%S"), 0);
logPipeline("date1 = "+dateToStr(date1, "%Y-%m-%d %H:%M:%S"), 0);
logPipeline("diff01 = "+longToStr(diff01), 0);
edrDate(DETAIL.ASS_GSM_AAA_DETAIL.PCM_OP_GSM_AUTHORIZE.INPUT.PIN_FLD_START_T,
0,0,0) = date0;
edrDate DETAIL.ASS_GSM_AAA_DETAIL.PCM_OP_GSM_AUTHORIZE.INPUT.PIN_FLD_END_T ,
0,0,0) = date1;

 

 

2) Send Auth request through Diameter, using ccr_initial_cctime.xml.

Snippet from ccr_initial_cctime.xml:

<?xml version="1.0" encoding="ISO-8859-1" ?>
<scenario>
.
<!-- Traffic -->
<traffic>
<send channel="trans-ip-v5">
<command name="AAAR">
<avp name="Session-Id" value="DTFD1.002.16"> </avp>
<avp name="CC-Request-Type" value="1"> </avp>
<avp name="CC-Request-Number" value="4"> </avp>
<avp name="User-Name"
value="792-20090824-043935-0-7975-1-bangor"> </avp>
<avp name="Called-Station-Id" value="111111111"> </avp>
<avp name="Calling-Station-Id" value="22222222222"> </avp>
<avp name="Auth-Application-Id" value="0"> </avp>
<avp name="Origin-Host" value="seagull.ims.hpintelco.org">
</avp>
<avp name="Origin-Realm" value="ims.hpintelco.org"> </avp>
<avp name="Destination-Realm" value="ims.hpintelco.org">
</avp>
<avp name="Requested-Service-Unit">
<avp name="CC-Time" value="120"> </avp>
</avp>
</command>
</send>
<receive channel="trans-ip-v5">
<command name="AAAA">
</command>
</receive>
</traffic>
</scenario>


Snippet from testProcessPipe.log:

24.08.2009 04:12:34 bangor ifw IFW NORMAL [T:21] 00387
- (ifw.Pipelines.ProcessPipeline.Functions.Stan
dard.FunctionPool.PopulateOpcodeAndUtilBlock.Module.Scripts.PreOpcode) date0
= 1970-01-01 01:00:01
24.08.2009 04:12:34 bangor ifw IFW NORMAL [T:21] 00387
- (ifw.Pipelines.ProcessPipeline.Functions.Stan
dard.FunctionPool.PopulateOpcodeAndUtilBlock.Module.Scripts.PreOpcode) date1
= 2009-07-22 10:00:01
24.08.2009 04:12:34 bangor ifw IFW NORMAL [T:21] 00387
- (ifw.Pipelines.ProcessPipeline.Functions.Stan
dard.FunctionPool.PopulateOpcodeAndUtilBlock.Module.Scripts.PreOpcode) diff01
= 1248253200


Snippet from cm.pinlog :

W Mon Jan 2 12:34:01 2012 bangor cm:24963 cm_child.c(106):4472
1:bangor:cm:3732:1:9:1251112354:2
CM input flist: opcode PCM_OP_GSM_AUTHORIZE, opflags=0x0
# number of field entries allocated 20, used 14
0 PIN_FLD_POID POID [0] 0.0.0.1 /service/telco/gsm/telephony -1 0
0 PIN_FLD_PROGRAM_NAME STR [0] "AAA-GW"
0 PIN_FLD_MSID STR [0] "287-20090824-041212-0-25737-1-bangor"
0 PIN_FLD_AUTHORIZATION_ID STR [0] "DTFD1.002.15"
0 PIN_FLD_QUANTITY DECIMAL [0] 120
0 PIN_FLD_ORIGIN_NETWORK STR [0] "ims.hpintelco.org"
0 PIN_FLD_DESTINATION_NETWORK STR [0] "ims.hpintelco.org"
0 PIN_FLD_IMSI STR [0] ""
0 PIN_FLD_CALLED_NUMBER STR [0] "111111111"
0 PIN_FLD_CALLING_NUMBER STR [0] "22222222222"
0 PIN_FLD_START_T TSTAMP [0] (32401) Thu Jan 1 01:00:01 1970
0 PIN_FLD_END_T TSTAMP [0] (1248282001) Wed Jul 22 10:00:01 2009
0 PIN_FLD_AGGREGATE_MODE ENUM [0] 8
0 PIN_FLD_DIRECTION ENUM [0] 0



Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms