Dictionary data is broken out into relational data

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

Dictionary data is broken out into relational data

Post by khurshid.arshad »

Dear CSPro Team;

I am using two dictionaries in my application. One is for Listing and the other for Household Interview.

Dictionary data is broken out into relational data by running the command line CSWeb process.

Currently I am facing problem in my Household data.

Whenever I update my application, and run this command to convert in rational data, the only Household data starts from 0. And the listing data starts from the last position to convert in rational data.

Please guide.

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

Re: Dictionary data is broken out into relational data

Post by khurshid.arshad »

Dear CSPro Team.

Any update on this issue.

Thanks.
a.
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Dictionary data is broken out into relational data

Post by aaronw »

Can you clarify the following "the only Household data starts from 0. And the listing data starts from the last position to convert in rational data?"
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Dictionary data is broken out into relational data

Post by khurshid.arshad »

Dear Aaronw,

Before updated the application through deployment the “Creating process for dictionary HH1_NSER_Dict jobID is 781. For reference see picture “1 – Beforeupdate”.

After update the application the “Creating process for dictionary HH1_NSER_Dict jobID is 1. For reference see picture “3 – Afterupdate app”

Thank you.
Arshad
Attachments
1 - Beforeupdate app.png
1 - Beforeupdate app.png (28.76 KiB) Viewed 2420 times
3 - Afterupdate app.png
3 - Afterupdate app.png (31.7 KiB) Viewed 2420 times
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Dictionary data is broken out into relational data

Post by aaronw »

Are you noticing an issue besides the job ids resetting?
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Dictionary data is broken out into relational data

Post by khurshid.arshad »

Dear Arronw
Try to find out the error but did not get any result.
thanks.
a.
khurshid.arshad
Posts: 571
Joined: July 9th, 2012, 11:32 am
Location: Islamabad, Pakistan

Re: Dictionary data is broken out into relational data

Post by khurshid.arshad »

Any update?
a.
aaronw
Posts: 561
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: Dictionary data is broken out into relational data

Post by aaronw »

When I uploaded a dataset it increments the job ids. If I modify the dataset and upload it continues to increment the job id. However, if I upload a dataset with no modifications the job id resets. This is just an observation that always incrementing job ids isn't necessarily correct.

I don't think this output is particularly helpful to the user and I wouldn't pay much attention to what the job ids are doing.
savy
Posts: 159
Joined: December 27th, 2012, 1:36 pm

Re: Dictionary data is broken out into relational data

Post by savy »

There is nothing wrong in what you are seeing. The jobIds are unique to each dictionary and are created in cspro_jobs table in the target schema. If the dictionary is modified in the source schema, the blob break out process cleans up the target schema (drops all tables and recreates the target tables) and thus resets the jobIds renumbering.
Post Reply