Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
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

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