Skip to content

SQLCODE -99 on document open as %Developer #465

Open
@isc-tleavitt

Description

@isc-tleavitt
Collaborator

In the log:
Executing Studio Action "Opened Document" on *****************:443[TLEAVITT] failed with the following error:
ERROR #5540: SQLCODE: -99 Message: User tleavitt is not privileged for the operation

Activity

added
upstreamFull/ideal correction requires changes to upstream dependencies (e.g., IRIS)
and removed
bugSomething isn't working
on Aug 28, 2024
isc-tleavitt

isc-tleavitt commented on Aug 28, 2024

@isc-tleavitt
CollaboratorAuthor

Also seeing:

Executing Studio Action "Closed Document" on *************:443[TLEAVITT] failed with the following error:

ERROR #5540: SQLCODE: -99 Message: User tleavitt is not privileged for the operation [e^%Next+7^%sqlcq.TLEAVITT.cls3.1^6 e^AppendResultSet+35^%Api.Atelier.v6.1^1 e^Query+46^%Api.Atelier.v6.1^1 e^DispatchRequest+23^%CSP.REST.1^1 e^Page+26^%CSP.REST.1^1 e^zPage+2^%Atelier.REST.1^1 e^CSPDispatch+503^%SYS.cspServer^2 d^CSPDispatch+280^%SYS.cspServer^1 d^ProcessRequest+1^%CSP.Session.1^1 d^Request+683^%SYS.cspServer2^1 d^Request+25^%SYS.cspServer2^1 d^ProcessRequest+1^%CSP.Request.1^1 d^css+21^%SYS.cspServer2^1 d^Server+64^%SYS.SERVER^2 d^^^0:TLEAVITT]

isc-tleavitt

isc-tleavitt commented on Aug 28, 2024

@isc-tleavitt
CollaboratorAuthor

This is ultimately upstream in vscode-objectscript. Closing the issue here.

isc-tleavitt

isc-tleavitt commented on Aug 28, 2024

@isc-tleavitt
CollaboratorAuthor

Actually, keeping this here as a record that the root cause needs to be found. (I haven't yet and the diff on https://github.com/intersystems-community/vscode-objectscript/pull/1414/files seems totally innocuous.)

self-assigned this
on Sep 6, 2024
removed their assignment
on Oct 22, 2024
isc-tleavitt

isc-tleavitt commented on Dec 13, 2024

@isc-tleavitt
CollaboratorAuthor

This also happens periodically with menus on Health Connect Cloud when operating over isfs.

added
bugSomething isn't working
questionFurther information is requested
on Dec 13, 2024
added this to the H1 2025 Targets milestone on Dec 13, 2024
isc-pbarton

isc-pbarton commented on Mar 5, 2025

@isc-pbarton
Collaborator

Still occurring sometimes with source control menus on HealthConnect Cloud. Audit log shows a SQL statement like this:

SELECT * FROM %Atelier_v1_Utils . Extension_UserAction ( ? , ? , ? , ? )
/*#OPTIONS { "IsolationLevel":0 } */
Parameter values:
%CallArgs(1)=0
%CallArgs(2)="%SourceMenu,GitWebUI"
%CallArgs(3)="test.testclass.cls"
%CallArgs(4)=

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requestedupstreamFull/ideal correction requires changes to upstream dependencies (e.g., IRIS)

    Type

    Projects

    No projects

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @isc-pbarton@isc-tleavitt

        Issue actions

          SQLCODE -99 on document open as %Developer · Issue #465 · intersystems/git-source-control