Jun Suzuki · 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.

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

Hi Jun,

A <PROTECT> error indicates you don't have permission on something, in this case per the error it looks like you don't have permission on the HSCUSTOM database. I'd recommend checking this error with your admin to get that access, if appropriate.