Hi everyone,
I’m planning to use the SMART Profile plugin to manage human encounter data. I’ve tried to configure it by adding profiles, record sources, and attributes. However, I wasn’t able to proceed because an error appeared with the following message:
“Error saving changes to record sources: org.hibernate.exception.SQLGrammarException: could not prepare statement”
Has anyone experienced this before? What should I do?
Attached error log files and screen capture of the notification.
Thank you.
Here is the error log.
error.log.docx (43.8 KB)
Hi Okta,
This looks like the software believes there is an incorrect syntax (check the data for any incorrect typos) or a mismatch between the data and the database structure which could occur if there is data associated with elements of the data model you are attempting to modify.
From the look of the error log it looks like the SMART software is trying to access a database table called E_ACTION, but that table doesn’t exist in the database file currently being used.
This can happen if the database was migrated / copied incorrectly. We can try the following:
1. Restart SMART Desktop
- Just to rule out a transient problem.
2. Try Opening a Different Project
- If other projects work, then the issue is isolated to one database.
- If no project works, SMART may have a corrupted installation.
3. Create a New Test Project
- Go to File > New Project.
- See if you can open and edit profiles without error.
- If this works, the issue is with the original project database.
4. Repair or Rebuild the Project
If the error only occurs in one project:
- Export data (if possible) using Project > Export.
- Create a new project.
- Import the data into the new one.
Cheers,
Alex
