Hi,
cdrs table is getting 0001-01-01T00:00:00 SetupTime.
How can I set it to proper time?
Thanks,
Mike
filter: (ip or ip6) and ( port 2012 or 8448 )
#
288:{"event":"CGR_AUTH_REQUEST",..."tr_index":"35703",..."tr_label":"283238747",..."cgr_subsystems":"*attributes;*resources;*accounts;*suppliers",..."RequestType":"*prepaid",..."Tenant":"tyeng",..."Category":"call",..."Account":"h
anary",..."Destination":"+820000",..."SetupTime":"1519243342"},
#
{"method":"AttributeSv1.ProcessEvent","params":[{"Tenant":"tyeng","ID":"e6de385","Context":"*sessions","Time":"2018-02-22T05:02:22+09:00","Event":{"Account":"tester","Category":"call","Destination":"+820000","RequestType":"*prepai
d","SetupTime":"1519243342","Tenant":"tyeng"}}],"id":4}.
#
{"id":4,"result":null,"error":"NOT_FOUND"}.
##
{"method":"Responder.GetDerivedMaxSessionTime","params":[{"CGRID":"da39a3ee5e6b4b0d3255bfef95601890afd80709","RunID":"","OrderID":0,"OriginHost":"","Source":"SMG_","OriginID":"","ToR":"*voice","RequestType":"*prepaid","Tenant":"ty
eng","Category":"call","Account":"tester","Subject":"","Destination":"+820000","SetupTime":"2018-02-22T05:02:22+09:00","AnswerTime":"0001-01-01T00:00:00Z","Usage":0,"ExtraFields":{},"ExtraInfo":"","Partial":false,"Rated":false,"Co
stSource":"","Cost":-1,"CostDetails":null}],"id":13}.
#
{"id":13,"result":10800000000000,"error":null}.
##
{"method":"ResourceSv1.AuthorizeResources","params":[{"Tenant":"tyeng","ID":"e6de385","Context":"*sessions","Time":"2018-02-22T05:02:22+09:00","Event":{"Account":"tester","Category":"call","Destination":"+820000","RequestType":"*p
repaid","SetupTime":"1519243342","Tenant":"tyeng"},"UsageID":"b6c3bc0","UsageTTL":null,"Units":1}],"id":10}.
#
{"id":10,"result":"TYEng","error":null}.
##
{"method":"SupplierSv1.GetSuppliers","params":[{"Tenant":"tyeng","ID":"e6de385","Context":"*sessions","Time":"2018-02-22T05:02:22+09:00","Event":{"Account":"tester","Category":"call","Destination":"+820000","RequestType":"*prepaid
","SetupTime":"1519243342","Tenant":"tyeng","Usage":60000000000},"Limit":null,"Offset":null,"SearchTerm":""}],"id":4}.
#
{"id":4,"result":{"ProfileID":"IDTExpress","Sorting":"*weight","SortedSuppliers":[{"SupplierID":"TYFaxPJ","SupplierParameters":"","SortingData":{"Weight":20}}]},"error":null}.
##
179:{"Event":"CGR_AUTH_REPLY","TransactionIndex":"35703","TransactionLabel":"283238747","Attributes":"","ResourceAllocation":"TYEng","MaxUsage":10800,"Suppliers":"TYFaxPJ","Error":""},
##
309:{"event":"CGR_CALL_START",..."h_entry":"3241",..."h_id":"77",..."cgr_subsystems":"*resources;*accounts",..."OriginID":"
0c75dca51bd68008...@tytravel.tyeng.com;as7b9f47e5",..."RequestType":"*prepaid",..."Tenant":"ty
eng",..."Account":"tester",..."Destination":"+820000",..."AnswerTime":"1519243345"},
#
{"method":"ResourceSv1.AllocateResources","params":[{"Tenant":"tyeng","ID":"1e190e8","Context":null,"Time":"2018-02-22T05:02:25+09:00","Event":{"Account":"tester","AnswerTime":"1519243345","Destination":"+820000","EvapiConnID":"18
"UsageTTL":null,"Units":1}],"id":11}.
#
{"id":11,"result":"TYEng","error":null}.
##
{"method":"Responder.GetSessionRuns","params":[{"CGRID":"e04efec38e0cdd93651094dd64e8ed22c1da6629","RunID":"","OrderID":0,"OriginHost":"","Source":"SMG_","OriginID":"
0c75dca51bd68008...@tytravel.tyeng.com;as7b9f47e5",
"ToR":"*voice","RequestType":"*prepaid","Tenant":"tyeng","Category":"call","Account":"tester","Subject":"","Destination":"+820000","SetupTime":"0001-01-01T00:00:00Z","AnswerTime":"2018-02-22T05:02:25+09:00","Usage":0,"ExtraFields"
:{"EvapiConnID":"184f07cd-d47d-4f85-b679-76d9d63baa2c"},"ExtraInfo":"","Partial":false,"Rated":false,"CostSource":"","Cost":-1,"CostDetails":null}],"id":14}.
#
{"id":14,"result":[{"DerivedCharger":{"RunID":"*default","RunFilters":"","RequestTypeField":"*default","DirectionField":"*default","TenantField":"*default","CategoryField":"*default","AccountField":"*default","SubjectField":"*defa
ult","DestinationField":"*default","SetupTimeField":"*default","PDDField":"*default","AnswerTimeField":"*default","UsageField":"*default","SupplierField":"*default","DisconnectCauseField":"*default","CostField":"*default","RatedFi
eld":"*default"},"CallDescriptor":{"Direction":"*out","Category":"call","Tenant":"tyeng","Subject":"tester","Account":"tester","Destination":"+820000","TimeStart":"2018-02-22T05:02:25+09:00","TimeEnd":"2018-02-22T05:02:25+09:00","
LoopIndex":0,"DurationIndex":0,"FallbackSubject":"","RatingInfos":null,"Increments":null,"TOR":"*voice","ExtraFields":{"EvapiConnID":"184f07cd-d47d-4f85-b679-76d9d63baa2c"},"MaxRate":0,"MaxRateUnit":0,"MaxCostSoFar":0,"CgrID":"e04
efec38e0cdd93651094dd64e8ed22c1da6629","RunID":"*default","ForceDuration":false,"PerformRounding":false,"DryRun":false,"DenyNegativeAccount":false},"CallCosts":null}],"error":null}.
##
{"method":"Responder.MaxDebit","params":[{"Direction":"*out","Category":"call","Tenant":"tyeng","Subject":"tester","Account":"tester","Destination":"+820000","TimeStart":"2018-02-22T05:02:25+09:00","TimeEnd":"2018-02-22T05:02:35+0
9:00","LoopIndex":0,"DurationIndex":10000000000,"FallbackSubject":"","RatingInfos":null,"Increments":null,"TOR":"*voice","ExtraFields":{"EvapiConnID":"184f07cd-d47d-4f85-b679-76d9d63baa2c"},"MaxRate":0,"MaxRateUnit":0,"MaxCostSoFa
r":0,"CgrID":"e04efec38e0cdd93651094dd64e8ed22c1da6629","RunID":"*default","ForceDuration":false,"PerformRounding":false,"DryRun":false,"DenyNegativeAccount":false}],"id":15}.
#
{"id":15,"result":{"Direction":"*out","Category":"call","Tenant":"tyeng","Subject":"tester","Account":"tester","Destination":"+820000","TOR":"*voice","Cost":0.03,"Timespans":[{"TimeStart":"2018-02-22T05:02:25+09:00","TimeEnd":"201
8-02-22T05:03:25+09:00","Cost":0.03,"RateInterval":{"Timing":{"Years":[],"Months":[],"MonthDays":[],"WeekDays":[1,2,3,4,5,6,0],"StartTime":"00:00:00","EndTime":""},"Rating":{"ConnectFee":0.02,"RoundingMethod":"*up","RoundingDecima
ls":4,"MaxCost":0,"MaxCostStrategy":"","Rates":[{"GroupIntervalStart":0,"Value":0.01,"RateIncrement":60000000000,"RateUnit":60000000000}]},"Weight":10},"DurationIndex":60000000000,"Increments":[{"Duration":0,"Cost":0.02,"BalanceIn
fo":{"Unit":null,"Monetary":{"UUID":"2d15ad2e-8444-4baa-b951-aa49916b9777","ID":"","Value":9.65,"RateInterval":null},"AccountID":"tyeng:tester"},"CompressFactor":1},{"Duration":60000000000,"Cost":0.01,"BalanceInfo":{"Unit":null,"M
onetary":{"UUID":"2d15ad2e-8444-4baa-b951-aa49916b9777","ID":"","Value":9.64,"RateInterval":null},"AccountID":"tyeng:tester"},"CompressFactor":1}],"RoundIncrement":null,"MatchedSubject":"*out:tyeng:call:*any","MatchedPrefix":"+82"
,"MatchedDestId":"South_Korea","RatingPlanId":"TYGold","CompressFactor":1}],"RatedUsage":60000000000,"AccountSummary":{"Tenant":"tyeng","ID":"tester","BalanceSummaries":[{"UUID":"2d15ad2e-8444-4baa-b951-aa49916b9777","ID":"2d15ad2
e-8444-4baa-b951-aa49916b9777","Type":"*monetary","Value":9.64,"Disabled":false}],"AllowNegative":false,"Disabled":false}},"error":null}.
###
288:{"event":"CGR_CALL_END",..."cgr_subsystems":"*resources;*accounts",..."OriginID":"
0c75dca51bd68008...@tytravel.tyeng.com;as7b9f47e5",..."RequestType":"*prepaid",..."Tenant":"tyeng",..."Account":"tester", ..."Desti
nation":"+820000",..."AnswerTime":"1519243345",..."Usage":"5"},
##
{"method":"Responder.RefundIncrements","params":[{"Direction":"*out","Category":"call","Tenant":"tyeng","Subject":"tester","Account":"tester","Destination":"+820000","TimeStart":"0001-01-01T00:00:00Z","TimeEnd":"0001-01-01T00:00:0
0Z","LoopIndex":0,"DurationIndex":0,"FallbackSubject":"","RatingInfos":null,"Increments":null,"TOR":"*voice","ExtraFields":null,"MaxRate":0,"MaxRateUnit":0,"MaxCostSoFar":0,"CgrID":"e04efec38e0cdd93651094dd64e8ed22c1da6629","RunID
":"*default","ForceDuration":false,"PerformRounding":false,"DryRun":false,"DenyNegativeAccount":false}],"id":16}.
#
{"id":16,"result":0,"error":null}.
##
{"method":"CdrsV2.StoreSMCost","params":[{"Cost":{"CGRID":"e04efec38e0cdd93651094dd64e8ed22c1da6629","RunID":"*default","OriginHost":"","OriginID":"
0c75dca51bd68008...@tytravel.tyeng.com;as7b9f47e5","CostSource":"SMR"
,"Usage":5000000000,"CostDetails":{"CGRID":"e04efec38e0cdd93651094dd64e8ed22c1da6629","RunID":"*default","StartTime":"2018-02-22T05:02:25+09:00","Usage":60000000000,"Cost":null,"Charges":[{"RatingID":"98511f4","Increments":[{"Usag
e":0,"Cost":0.02,"AccountingID":"9e40bba","CompressFactor":1},{"Usage":60000000000,"Cost":0.01,"AccountingID":"d0c7823","CompressFactor":1}],"CompressFactor":1}],"AccountSummary":{"Tenant":"tyeng","ID":"tester","BalanceSummaries":
[{"UUID":"2d15ad2e-8444-4baa-b951-aa49916b9777","ID":"2d15ad2e-8444-4baa-b951-aa49916b9777","Type":"*monetary","Value":9.64,"Disabled":false}],"AllowNegative":false,"Disabled":false},"Rating":{"98511f4":{"ConnectFee":0.02,"Roundin
gMethod":"*up","RoundingDecimals":4,"MaxCost":0,"MaxCostStrategy":"","TimingID":"87e4099","RatesID":"0837e3f","RatingFiltersID":"78f5595"}},"Accounting":{"9e40bba":{"AccountID":"tyeng:tester","BalanceUUID":"2d15ad2e-8444-4baa-b951
-aa49916b9777","RatingID":"","Units":0.02,"ExtraChargeID":""},"d0c7823":{"AccountID":"tyeng:tester","BalanceUUID":"2d15ad2e-8444-4baa-b951-aa49916b9777","RatingID":"","Units":0.01,"ExtraChargeID":""}},"RatingFilters":{"78f5595":{"
DestinationID":"South_Korea","DestinationPrefix":"+82","RatingPlanID":"TYGold","Subject":"*out:tyeng:call:*any"}},"Rates":{"0837e3f":[{"GroupIntervalStart":0,"Value":0.01,"RateIncrement":60000000000,"RateUnit":60000000000}]},"Timi
ngs":{"87e4099":{"Years":[],"Months":[],"MonthDays":[],"WeekDays":[1,2,3,4,5,6,0],"StartTime":"00:00:00"}}}},"CheckDuplicate":true}],"id":6}.
##
{"id":6,"result":"OK","error":null}.
##
{"method":"ResourceSv1.ReleaseResources","params":[{"Tenant":"tyeng","ID":"f466141","Context":null,"Time":"2018-02-22T05:02:25+09:00","Event":{"Account":"tester","AnswerTime":"1519243345","Destination":"+820000","OriginID":"0c75dc
#
{"id":12,"result":"OK","error":null}.
##
{"method":"CdrsV1.ProcessCDR","params":[{"CGRID":"e04efec38e0cdd93651094dd64e8ed22c1da6629","RunID":"","OrderID":0,"OriginHost":"","Source":"SMG_","OriginID":"
0c75dca51bd68008...@tytravel.tyeng.com;as7b9f47e5","ToR":"
*voice","RequestType":"*prepaid","Tenant":"tyeng","Category":"call","Account":"tester","Subject":"","Destination":"+820000","SetupTime":"0001-01-01T00:00:00Z","AnswerTime":"2018-02-22T05:02:25+09:00","Usage":5000000000,"ExtraField
s":{},"ExtraInfo":"","Partial":false,"Rated":false,"CostSource":"","Cost":-1,"CostDetails":null}],"id":7}.
##
{"id":7,"result":"OK","error":null}.
#