Processing Cases - Command line shell

Discussions about CSEntry
Forum rules
New release: CSPro 8.0
Post Reply
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Processing Cases - Command line shell

Post by khurshid.arshad »

Dear Team;
I have two dictionaries, one for Listing and one for Household interviews. Total cases are 697,518 in listing and 87,218 are in household interviews. When i run the php bin/console csweb:process-cases, it shows process cases 87,218 out of 87,218 cases with the current process date and time for Household Interviews. In the listing situation is different. It shows process cases 690,247 out of 697,518 cases . In it the last process time is 4 days back for listing.

Every time When i run the command it shows

Running blob breakout process.
Processing dictionary: HH1_NSER_DICT- Running threads 0
creating a new blob breakout thread
Creating process for dictionary HH1_NSER_DICT jobID: 0
No jobs available to run for dictionary: HH1_NSER_DICT
Processing dictionary: LISTING_DICT_NSER- Running threads 0
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1471
Processing for dictionary LISTING_DICT_NSER jobID: 1471
Processing dictionary: LISTING_DICT_NSER- Running threads 1
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1472
Processing for dictionary LISTING_DICT_NSER jobID: 1472
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1473
Processing for dictionary LISTING_DICT_NSER jobID: 1473
Processing dictionary: LISTING_DICT_NSER- Running threads 0
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1474
Processing for dictionary LISTING_DICT_NSER jobID: 1474
Processing dictionary: LISTING_DICT_NSER- Running threads 1
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1475
Processing for dictionary LISTING_DICT_NSER jobID: 1475
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1476
Processing for dictionary LISTING_DICT_NSER jobID: 1476
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1477
Processing for dictionary LISTING_DICT_NSER jobID: 1477
Processing dictionary: LISTING_DICT_NSER- Running threads 1
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1478
Processing for dictionary LISTING_DICT_NSER jobID: 1478
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1479
Processing for dictionary LISTING_DICT_NSER jobID: 1479
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1480
Processing for dictionary LISTING_DICT_NSER jobID: 1480
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1481
Processing for dictionary LISTING_DICT_NSER jobID: 1481
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1482
Processing for dictionary LISTING_DICT_NSER jobID: 1482
Processing dictionary: LISTING_DICT_NSER- Running threads 1
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1483
Processing for dictionary LISTING_DICT_NSER jobID: 1483
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1484
Processing for dictionary LISTING_DICT_NSER jobID: 1484
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1485
Processing for dictionary LISTING_DICT_NSER jobID: 1485
Processing dictionary: LISTING_DICT_NSER- Running threads 1
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 1486
Processing for dictionary LISTING_DICT_NSER jobID: 1486
Processing dictionary: LISTING_DICT_NSER- Running threads 2
creating a new blob breakout thread
Creating process for dictionary LISTING_DICT_NSER jobID: 0
No jobs available to run for dictionary: LISTING_DICT_NSER


thanks.
a.
savy
Posts: 159
Joined: December 27th, 2012, 1:36 pm

Re: Processing Cases - Command line shell

Post by savy »

Can you send us the cases_process*.log files? The log files are in var/logs folder
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Processing Cases - Command line shell

Post by khurshid.arshad »

Dear Savy;

log files are attached.
thanks.
a.
Attachments
Desktop.rar
(1.03 MiB) Downloaded 164 times
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Processing Cases - Command line shell

Post by khurshid.arshad »

Dear Savy;

Any update in this regards.

Thanks.
a.
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Processing Cases - Command line shell

Post by khurshid.arshad »

Dear CSPro Team;

Any update on my query??

thanks.
a.
savy
Posts: 159
Joined: December 27th, 2012, 1:36 pm

Re: Processing Cases - Command line shell

Post by savy »

Arshad, the logs show error related to a field 'cnicempty' in the dictionary LISTING_DICT_NSER. The field is not set in the cases that are failing. Did the dictionary change after at some point after collecting the data? Can you send me the LISTING_DICT_NSER dictionary?
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Processing Cases - Command line shell

Post by khurshid.arshad »

Dear Savy

Yes, i made some changes, but in rational table for my Dashboard and not in LISTING_DICT_NSER.

I have shared my dictionary on your mail.

Thanks.
a.
savy
Posts: 159
Joined: December 27th, 2012, 1:36 pm

Re: Processing Cases - Command line shell

Post by savy »

The item 'cnicempty' is not in your dictionary. Is this a column that you added to your relational table in the blob-breakout schema?
If so, you should allow default value to be null or an empty string.
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Processing Cases - Command line shell

Post by khurshid.arshad »

Dear Savy;
Thank you so much. I will fix it and let you know.

thanks.
a.
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Processing Cases - Command line shell

Post by khurshid.arshad »

Dear Savy;

It is working now.
Thank you.
a.
Post Reply