Unable to perform basic SQL Queries : [SQLCODE: <-400>:<Fatal error occurred>]

Hello, new user here ! My admin granted me all access to the domain I'm working on. Nonetheless, I'm unable to perform simple SQL queries such as creating a table or an index.

What I have tried :

• Creating a table : within the namespace I've been granted access to, I'm trying to create a table with 2 methods :

  • Basic query : CREATE TABLE test.hello_world (col1 INTEGER, col2 VARCHAR)
    This raises the error :

  [SQLCODE: <-400>:<Fatal error occurred>] [%msg: <Exception caught during dSQL statement %Execute: <PROTECT> ^rINDEXCLASS("HS.JSON.WRITER"),/iris/irishealth/mgr/HSCUSTOM/>]

  • Creating a table from an already existing view : CREATE TABLE test.hello_world AS SELECT test.v_tableA
    This raises a pop up window saying : User <user> is not privileged for the operation

• Creating an index from an existing table : for a given table tableB : CREATE INDEX index_name ON tableB (col1, col2). This raises the error :

  [SQLCODE: <-400>:<Fatal error occurred>] [%msg: <ERROR #5002: ObjectScript error: <PROTECT>GetAllDerivedClasses+57^%occLibrary ^rINDEXCLASS("HS.JSON.WRITER"),/iris/irishealth/mgr/HSCUSTOM/>]

Constraints :

I currently don't have access to Object Script classes or VSC.

What am I missing ? Would be grateful for any help.