Following the documentation to insert into tableA from tableB in the SQL query box from the Management Portal :

INSERT INTO tableA (col1, col2)
SELECT col1, col2
FROM tableB

This straightforward query raises the following error :

Error #5475: routine compilation error : %sqlcq.TESTuNAMESPACE.cls305. Errors: %sqlcq.TESTuNAMESPACE.cls305.cls
ERROR: %sqlcq.TESTuNAMESPACE.csl305.1(14) :
<UNDEFINED>parseExtFrom+19^%qaqcmx
*mt("f", "1^TABLEA") :

Could someone help me decipher this error message ? Thanks for your help.

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.