Error: The database schema does not match the job schema. Please choose the Delete Previous Table option to recreate the table.
The database schema does not match the job schema. Please
choose the Delete Previous Table option to recreate the table.
There are several options to resolve the problem:
- Delete the existing table: On the Advanced tab of the job, check the Delete Previous Table option. This will delete the existing table and create it to match the data structure Sync & Save has. Only do this if you want to delete the existing table data. Once the job has run once, un-check the option so that the table does not get deleted every time the job runs.
- Export to a new table: Change the name of the table in Sync & Save to a table that does not exist in the database and then run the job. The new table will be created to match the data structure Sync & Save has.
- Change the structure of the table in the database: One way to accomplish this is by exporting a single submission to a new temporary table: Temporarily change the name of the table in Sync & Save and then select one submission from the Submissions tab and select Export. This will create a valid table structure that you can compare with the existing table structure. Change the existing table structure in the database to match the temporary table that Sync & Save generated. Be sure to change the temporary name back before running the job again.
- Change the Sync & Save format to match the existing table: Check the list of columns on the Format tab of the job and ensure that they match the columns in the database. Remove any column in Sync & Save that does not exist in the table.
- Change the SQL executed by Sync & Save: On the main tab of the job check the "Edit" checkbox and alter the SQL statements to match the existing database table.