ERROR while the Security Module tries to create tables -
Creating sec_settings
ERROR: zero-length delimited identifier at or near “”""
LINE 1: CREATE TABLE “”.sec_settings (
This happens even when using a superuser (e.g. postgres).
Cause
In multi-schema projects, if the Schema field in the Scriptcase database connection is left empty or ambiguously unset, the Security Module generates SQL like:
CREATE TABLE “”.sec_users
Solution
When creating or editing the PostgreSQL connection in Scriptcase:
- Go to
Tools → Database → Connections - Edit the connection used by the Security Module
-
Explicitly set the Schema field (for example:
public) - Save, restart Scriptcase, and recreate the Security Module tables
After explicitly setting the schema, the Security Module creates all sec_* tables successfully.
NOTE:
I am sharing an issue I personally faced and the fix that worked for me.
This issue may not occur in all environments or may present differently.
Sharing it in the hope that it helps others facing a similar problem.