Skip to end of metadata
Go to start of metadata

Problem

After the 6.3 DB update script for "Oracle" or "MS SQL" has been executed, creating "Surveys" is not possible. 

Solution

After the update script for release 6.3 has been executed, you can use the following SQL statements to fix the problem:

MS SQL

alter table SURVEYS drop column CREATION_TIME;
alter table SURVEYS add CREATION_TIME datetime2;

Oracle

alter table SURVEYS drop column CREATION_TIME;
alter table SURVEYS add CREATION_TIME timestamp;

We also updated the DB update script 6.3 for Oracle and MS SQL. This script is attached to this article: Link to the script