Skip to main content
M
matthiasb6903
October 10, 2022
Question

Cannot edit or view Stored Procedures & Functions on MariaDB

  • October 10, 2022
  • 6 replies
  • 0 views

Hey folks,

Been running into an odd situation. Although I am in the groups Database Administrators and Database Editors, I am unable to view or edit (most) Stored Procedures & Functions on the MariaDB. The Appian version the customer runs is 22.2 and I should have all the necessary privileges, but nope.. tried to search for a fix for this but alas, no answer could be found. Has anyone else have had this issue or know how to fix this?

Thanks in advance,

Matthias 

6 replies

stefanhelzle0001
stefanhelzle0001
Brainy
October 10, 2022

What kind of error do you see?

    M
    matthiasb6903Author
    October 10, 2022

    The "edit" button is greyed out and I also cannot click it. I tried to select it from the list and manually "export" to see if I can somehow view it offline, but it says I lack privileges. Do you know of any other place where this is configured?

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    October 10, 2022

    Do you use a separate schema in the DB?

      mikes0011
      mikes0011
      Brainy
      October 10, 2022

      Open a support case.  Stored procedures established using the legacy "DEFINER=" value will need to be changed over manually in the back-end, and the symptoms you describe are what happens before this update is done.  If you have the original stored procedure definition scripts handy (or you can get to them by some way other than the "edit" button), you can re-run them (i think with the "DEFINER=..." statement removed from the CREATE PROCEDURE statement) and that would correct that particular procedure - but of course this would need to be done manually for all of them, which can be a big pain (if even possible).

      In your support case, mention older support case #557828.

      The Expression Guru
        M
        matthiasb6903Author
        October 11, 2022

        Thank you for your reply and the explanation, Mike. I cannot interact with the SPs in any way (not even export them), so we opened a support case. 

        Terms & ConditionsAccessibility statement