Next
After setting up a non-IBM® SPSS® Data Collection Interviewer Server project for use in IBM® SPSS® Data Collection Survey Tabulation, you should open the project in Survey Tabulation in order to test that the connection string has been set up correctly and the data is accessible. This step is not generally necessary when you are using an Interviewer Server project in Survey Tabulation, because the connection string is created for you.
To Create and Populate a Test Table in Survey Tabulation:
► Select the new project and click Survey Tabulation.
There will be a short delay while Survey Tabulation initializes.
► If you see the message "Server error: Failed to load data", it indicates that Survey Tabulation was not able to connect to the metadata. You will be returned to IBM® SPSS® Data Collection Interviewer Server Administration, where you should first check that you have checked the project's data files into the shared folder. If the files have been checked in, use the project editor to check and, if necessary, correct the connection properties for the metadata source.
► If you see the main Survey Tabulation screen, including the list of variables, it means that Survey Tabulation is able to connect to the project's metadata correctly. You now need to create and populate a simple table (for example, one that crosstabulates two simple categorical variables) to check that Survey Tabulation is able to connect to the project's case data. For information on creating and populating a table, see the Survey Tabulation documentation.
► If the table populates without a problem, it means that the project is set up correctly.
► If you get an error when you attempt to populate the table, you should make a note of the error message, return to Interviewer Server Administration, and then use the project editor to check and, if necessary, correct the connection properties for the case data source.
Tips:
When there is an error populating a simple table immediately after setting up the project, it generally means that there is a problem connecting to the case data. This may be because there is an error in the connection properties for the case data, a problem with the case data itself, or incorrect access permissions.
Generally the first part of the error message comes from the Table Object Model (TOM) and the related Table Aggregator component. Sometimes there is an additional error message from the CDSC that is used to access the case data, and this can sometimes give a clue to the cause of the specific problem.
Aggregator Error 296: Input data doesn't exist (neither VDATA nor HDATA found). This generally means the case data specified in the connection string cannot be found. If you are using a file-based case data format, check that you specified the correct file and location and that the file is present. Check that you specified the right type of data (that you didn't select SPSS Statistics SAV DSC when you meant IBM® SPSS® Data Collection DRS DSC, etc.) If you are using RDB DSC 2, check the following:
• In the OLE DB connection string specified for the Case Data Location, is the Initial Catalog property set to the name of the database?
• In the OLE DB connection string specified for the Case Data Location, is the Data Source property set to the name of the server on which the SQL Server database is located?
• Is the Case Data Project correct? In a project that originated in Interviewer Server, this is typically the same as the database name.
• Do you have appropriate access permissions for the SQL Server database?
Aggregator Error 239: Failed to initialize CDSC. This message is generally followed by a message from the CDSC that should provide more information about the problem. When attempting to connect to an XML file, this message may indicate that the specified file does not exist. When attempting to connect to an RDB database, this message may indicate that you have specified the Case Data Project incorrectly.
Aggregator Error 278: Data table HDATA requested but not available. If you are attempting to connect to an XML file, this generally means that data is in the flat (VDATA) format. This means you need to change to use the flat view within Survey Tabulation. See the topic Preparing Your Data Files For Uploading for more information. Sometimes this error message also occurs when you have selected the wrong case data type (for example, if you accidentally select RDB DSC 2 instead of SPSS Statistics SAV DSC).
For detailed information about the CDSCs that come with the IBM® SPSS® Data Collection Data Model, their error messages, and known problems, see the IBM® SPSS® Data Collection Developer Library.