Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!
SOLVED

Batch size parameter for NmsBroadLogRcp

Avatar

Level 2

Hi,

 

I have found that table NmsBroadLogRcp is updated in batches 

For ex. like

UPDATE NmsBroadLogRcp SET iStatus=:1, iMsgId=:2, tsEvent=:3, tsLastModified=cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE) WHERE iDeliveryId=:4 AND iStatus=:5 AND ROWNUM<=5000

 

I'm looking for solution how to manage batch size to avoid too many loops.

Those value is any defined parameter ?

 

Thanks in advance

1 Accepted Solution

Avatar

Correct answer by
Employee

Hi Klaster,

 

Are you using mid-sourcing to send deliveries. If yes , there should be an option called NmsMidSourcing_LogsBatchSize

which can be changed to manage size of batch per SOAP call.

 

Regards,
Adhiyan

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

Hi Klaster,

 

Are you using mid-sourcing to send deliveries. If yes , there should be an option called NmsMidSourcing_LogsBatchSize

which can be changed to manage size of batch per SOAP call.

 

Regards,
Adhiyan