Page 1 of 1

Dictionary data is broken out into relational data

Posted: April 2nd, 2022, 2:57 am
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.

Re: Dictionary data is broken out into relational data

Posted: April 4th, 2022, 1:08 pm
by khurshid.arshad
Dear CSPro Team.

Any update on this issue.

Thanks.
a.

Re: Dictionary data is broken out into relational data

Posted: April 4th, 2022, 3:43 pm
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?"

Re: Dictionary data is broken out into relational data

Posted: April 5th, 2022, 3:21 am
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

Re: Dictionary data is broken out into relational data

Posted: April 5th, 2022, 6:50 pm
by aaronw
Are you noticing an issue besides the job ids resetting?

Re: Dictionary data is broken out into relational data

Posted: April 5th, 2022, 7:36 pm
by khurshid.arshad
Dear Arronw
Try to find out the error but did not get any result.
thanks.
a.

Re: Dictionary data is broken out into relational data

Posted: April 6th, 2022, 1:50 pm
by khurshid.arshad
Any update?
a.

Re: Dictionary data is broken out into relational data

Posted: April 7th, 2022, 2:08 pm
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.

Re: Dictionary data is broken out into relational data

Posted: May 2nd, 2022, 2:38 pm
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.