IBM Support

SCHAPI Error -272 No SELECT permission for syssqltrace

Troubleshooting


Problem

SCHAPI Error -272 No SELECT permission for syssqltrace

Symptom

Errors similar to the following will be contained in the Online.log file:

14:53:17 On-Line Mode

14:53:19 SCHAPI: Started dbScheduler thread.

14:53:20 Booting Language <spl> from module <>

14:53:20 Loading Module <SPLNULL>

14:53:20 SCHAPI: Started 2 dbWorker threads.

14:53:20 SCHAPI: Error -272 No SELECT permission for syssqltrace_info.

14:53:20 SCHAPI: Type: SENSOR, Name: Save SQL Trace, Location: NULL.

14:53:20 SCHAPI: Type: SENSOR, Name: Save SQL Trace, Error Message:

Unable to execute function [ sql_showsnap(integer,integer) ] .

14:53:53 Assert Failed: Unhandled NT Exception!

14:53:53 See Also: E:\PROGRA~1\INFORM~1\tmp\af.3f6b2f0

14:53:53 Assert Failed: Unhandled NT Exception!

14:53:53 See Also: E:\PROGRA~1\INFORM~1\tmp\af.3f6b2f0

14:53:53 Assert Failed: Unhandled NT Exception!

14:53:53 See Also: E:\PROGRA~1\INFORM~1\tmp\af.3f6b2f0

14:53:53 Assert Failed: Unhandled NT Exception!

14:53:53 See Also: E:\PROGRA~1\INFORM~1\tmp\af.3f6b2f0

[{"Product":{"code":"SSGU8G","label":"Informix Servers"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.1;11.5;11.70","Edition":"Developer;Workgroup;Ultimate;Growth;Innovator","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
03 June 2021

UID

swg21499445

Page Feedback