Change the default schema used in the database queries

The value of default schema is stored in the table DSGLOBALPROPERTIES. The DSGLOBALPROPERTIES table stores the global settings for Dotsphere Case Manager in a name/value pair format.
Execute the following SQL statement to see the value of the schema

SELECT NAME,VALUE FROM DSGLOBALPROPERTIES WHERE NAME='SCHEMANAME';

If the value is not correct it, update it

UPDATE DSGLOBALPROPERTIES SET VALUE='<YOUR SCHEMA>' WHERE NAME='SCHEMANAME';