How to re-rate existing CDRs

[Jacek Konieczny]

Hi,

This seems like quite a normal use case, but I cannot find any info how to actually do that.

I am using CGRateS for real-time rating, for cost monitoring and abuse prevention. But at the end of the billing period I'll take all the CDRs to make the invoices. Congressionally I may need to correct the tariff for the final billing. How can I process the CDRs already in the StroDB and re-rate them with current/chosen tariff? Preferably in the same CGRateS instance, which is still doing real-time rating for new calls.

Greets,

Jacek

[Alexandru Tripon]

Hi Jacek,

In order to re-rate existing CDRs you need to specify the `*rerate` flag(https://cgrates.readthedocs.io/en/latest/cdrs.html#processevent) when you call the CDRsV1.ProcessCDR(https://pkg.go.dev/github.com/cgrates/cgr...@v0.9.1-rc3.0.20210527081800-3d423bc5b802/apier/v1#CDRsV1.ProcessCDR), CDRsV1.ProcessEvent (https://pkg.go.dev/github.com/cgrates/cgr...@v0.9.1-rc3.0.20210527081800-3d423bc5b802/apier/v1#CDRsV1.ProcessEvent) or CDRsV1.RateCDRs(https://pkg.go.dev/github.com/cgrates/cgr...@v0.9.1-rc3.0.20210527081800-3d423bc5b802/apier/v1#CDRsV1.RateCDRs) APIs.

Thanks,

Trial97

--
You received this message because you are subscribed to the Google Groups "CGRateS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cgrates+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/cgrates/8606b9a8-cdc9-4b89-8f7d-94c8ffe12db3n%40googlegroups.com.

[Jacek Konieczny]

CDRsV1.RateCDRs() seems to be what I was looking for. However it fails for me, as it tries to re-insert the CDRs into the database instead of updating existing entries which causes database errors:

[30-1] 2021-06-11 09:42:01.717 CEST [12664] cgrates@cgrates ERROR:  duplicate key value violates unique constraint "cdrs_cgrid_run_id_key"

Is anything I can do except some database hacking (triggers to replace those inserts with update, or something)?

[Jacek Konieczny]

False alarm. CGRateS does UPDATE when the insert fails. It just updates the record with the very same date that was there before, even though my rating profiles are completely different that they were when the original CDR was generated.

I have set 'Flags' to: ["*rerate", "*chargers:false"], how to disable a flag there was not obvious at all.