Skip to main content
Contact a Moderator

Question

6
Replies
292
Views
 Saikrishna Chitimalli (saikrishnaCSK) Central Provident Fund Board
Central Provident Fund Board
IN
saikrishnaCSK Member since 2015 16 posts
Central Provident Fund Board
Posted: March 21, 2017
Last activity: June 1, 2017
Posted: 21 Mar 2017 3:48 EDT
Last activity: 1 Jun 2017 0:36 EDT
Closed
Solved

batch set up for bix extraction in Pega5

Extract rule was ran for the execution of batch( consists of one record ) using command line parameter -b.

But execution was not happening like record by record in pega5( We passed the command line parameter like -b 01 in shellscript)

Could anyone help me.

***Moderator Edit: Vidyaranjan | Updated Categories***

Low-Code App Development Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 5 years ago
Posted: 24 Mar 2017 0:13 EDT
Pawan Singh (pa1singh) PEGA Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hello Saikrishna,

 

Please note that this option is not available when running an Extract rule on the cloud.

If you aren't on cloud then you could share the BIX extract log file and extract script for us to review, else you could wait for other community members to review your query.

 

Sincerely,

Pawan
Posted: 5 years ago
Posted: 11 Apr 2017 7:37 EDT
Saikrishna Chitimalli (saikrishnaCSK) Central Provident Fund Board
Central Provident Fund Board
IN

Thanks Pawan,

I had tried with command line parameter like "-b 01". But this didn't impact on batch execution(100 records executed at atime instead of one record).

Please find the log file below.

 

Regards

Saikrishna
Posted: 5 years ago
Posted: 11 Apr 2017 7:26 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US

Try with -b 1

If you are still seeing an issue please post the complete Java command that you are issuing and the PegaBIX log file.

Why is it that you want to issue a commit after every insert instead of doing them in batches?
Posted: 5 years ago
Posted: 11 Apr 2017 7:40 EDT
Saikrishna Chitimalli (saikrishnaCSK) Central Provident Fund Board
Central Provident Fund Board
IN

Hi Celeste,

I have tried with below java code

java -Djava.ext.dirs=lib -Xms128m -Xmx256m -Dpegarules.config=./config/prconfig.xml -Dpegarules.logging.configuration=./config/prlogging.xml com.pega.pegarules.engine.database.ExtractImpl -I SPL_RULES/Claim_report_rule.xml -b 01
Posted: 5 years ago
Posted: 11 Apr 2017 8:01 EDT
Celeste Dufresne (CelesteDufresne_GCS) PEGA Senior Principal Engineer, Technical Support, Cloud Service
Pegasystems Inc.
US

Try without the leading 0.  ie, -b 1 instead of -b 01

Also please try with -i instead of -I to see if the issue is when trying to use -b option with -I.

The default batch size is 30 not 100 so it may be useful to see the actual PegaBIX log file to see where it is getting a batch size of 100 from.  What version of Pega/BIX are you running?

 

Accepted Solution

Posted: 5 years ago
Posted: 17 May 2017 13:10 EDT
Shivarama Shetty (SHIVARAMAS) Accenture Services
Accenture Services
US

Hi Sai,

Its -s .

java -Djava.ext.dirs=lib -Xms128m -Xmx256m -Dpegarules.config=./config/prconfig.xml -Dpegarules.logging.configuration=./config/prlogging.xml com.pega.pegarules.engine.database.ExtractImpl -I SPL_RULES/Claim_report_rule.xml -s 1

Thanks,

Shivarama Shetty

 

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice