· Aug 8, 2022

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.

Discussion (1)1
Log in or sign up to continue