I am reaching out for a little help with regard to this particular error message. I've tried for a while now to beat it but I'm at a point I'll take some expert advice on it.
Exact error message:
A little context on my application.Entry Message (W 10102)
"Could not open the data source CBHS_MENU_SURVEYKEY_01_DICT: An index could not be created for a data file with duplicate case IDs, including: 'Label=CBHS_Menu_'
I have a 3 applications, 2 of which act as menus, and the third is actual questionnaire.
CBHS_Sandbox_Menu_01 - Main menu program, static PFF
CBHS_Sandbox_Substitution_01 - 2nd menu program, dynamically created PFF (has cases for notes) - acts as a kind of Cover page for survey capturing things such as: Is household available? Is substitution required, trip # and notes for respective # etc. If all is greenlight on beginning survey, it launches the below Questionnaire file.
CBHS_Sandbox_01 - Questionnaire, dynamically created PFF (has cases)
I also have 2 external dictionaries
CBHS_Menu_Surveykey_01.dcf - input is .txt file with list of available households for processing and other status type variables. This file is looped over to create dynamic valueset. It is also read/updated in all three applications. (IE- Completion_Status)
CBHS_Substition_Key_Deck.dcf - similar to above, but holds list of possible substitutions available to be selected. .txt file is read/updated when a substitution is selected from the list (IE- Valid_Status).
I receive the above error when the below process is taken:
Main Menu: Launch Main Menu, select household to interview, select begin. (System creates .pff for next execpff and execs SUBSTITUTION_01)
Substitution: Question is answered that household is available to begin interview. (System creates .pff for next execpff and execs SANDBOX_01)
***Error Message occurs here***
Result of error is that .dcf input file is set to blank because could not open actual data source.
I felt like this was a fault on the way I've coded the programs, and was occurring due to a missed CLOSE() statement on my part, but i've overly coded CLOSE() statements in an attempt to resolve the error and this was unable to resolve the issue.
Are there any insights as to why this is occurring and how I can address this issue?
Is this indeed an issue where the system is attempting to open a file under lock by previous apps(menus)?
I appreciate the guidance as always.
Thank you,
Marc