Skip to main content

Search

Welcome to Tibero GTS!

Error (-17004) occurs in slog when performing SQLTrace function without permission in Tiberostudio

Document Type | Troubleshooting

Category | Utility

Applicable Product Versions | 6FS06, 6FS07

Document Number | TUTTS010

 

Issue

When performing the SQLTrace function in Tibero Studio (client), users without permission receive error 17004.
 
This error does not directly affect the database, but it is repeatedly recorded in the SLOG, causing unnecessary log accumulation.
# slog
THROW. ec=ERROR_SECU_INSUFFICIENT_PRIVILEGE(-17004) [ Permission denied. ] (csr_id:4294967295) [ddl_check_common.c:125:ddl_check_create_obj_internal]
1-15T09:47:34.549042] [DDL-110] [I] DDL execution failed (ec = -17004): CREATE OR REPLACE LIBRARY EXTPROC IS 'null'

 

Cause

This error occurs when the user lacks the necessary DIRECTORY and LIBRARY privileges.
 
 

Solutions

You can temporarily work around this by granting the user (DIRECTORY, LIBRARY) privileges.
  • grant create any directory to username;
  • grant create any library to username;
 
slog after granting privileges
[01-15T10:09:09.782173] [DDL-110] [I] Executing DDL: CREATE OR REPLACE DIRECTORY USER_PATH AS '/tibero_engine/tibero6/client/lib/'
[01-15T10:09:09.783012] [DDL-110] [I] DDL execution succeeded
[01-15T10:09:09.790488] [DDL-110] [I] Executing DDL: CREATE OR REPLACE LIBRARY EXTPROC IS '/tibero_engine/tibero6/client/lib/libtbprof.so'
[01-15T10:09:09.790990] [DDL-110] [I] DDL execution succeeded
..
[01-15T10:09:09.899826] [RCF-39] [I] REDO THREAD #0 CKPT updated to 2.58539/0000.0000f126 (prev 2.58474/0000.0000f10f)
[01-15T10:09:09.899869] [RCF-39] [I] DB CKPT updated: 0000.0000f10f => 0000.0000f126 (open count=1)
[01-15T10:09:09.906280] [DDL-110] [I] DDL execution succeeded
[01-15T10:09:09.917379] [DDL-110] [I] Executing DDL: DROP LIBRARY EXTPROC
[01-15T10:09:09.918410] [DDL-110] [I] DDL execution succeeded
 
 
 

Related to