Getting error in campaign- You are not authorised to use SQL Expressions.'IsIMSLoggedIn' cannot be processed | Community
Skip to main content
S
Senthil24
Level 4
January 6, 2017
Solved

Getting error in campaign- You are not authorised to use SQL Expressions.'IsIMSLoggedIn' cannot be processed

  • January 6, 2017
  • 16 replies
  • 7532 views

Hi,

I am learning how to use Adobe Campaign tool and while I was working on that I had a requirement of importing few packages using Adobe Campaign package feature for Creating External Instance.

After the package import I am facing this issue of a particular type of error- You are not authorised to use SQL Expressions.'IsIMSLoggedIn' cannot be processed. (see attachment). I dont know the reason for it but this has cropped up after the package import.

Anyone has any idea why this errror is showing up and how to resolve it. It will be very helpful.

Thanks.smiley

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Adhiyan

    Hi Senthil,

     

    I checked the screenshot , your Console is 8601 and server is 8720. So even if version is same the builds are different.

    Please upgrade your client to 8720 as well and the error will not appear.

    The reason is that some components of the server was upgraded and when you use the old client it's not able to properly view the changed components. 

    16 replies

    florentlb
    florentlb
    Level 10
    January 6, 2017

    Hi,

    Can you make sure your user has the necessary named rights? There should be one dedicated to executing SQL expressions.

    For reference, here is the list of available named rights: https://docs.campaign.adobe.com/doc/AC6.1/en/PTF_Administration_Elements_Access_management.html#Named_rights

     

    Florent.

      Adhiyan
      Adobe Employee
      AdhiyanAdobe Employee
      Adobe Employee
      January 6, 2017

      Hi Senthil,

       

      Can you please check the build of the server and the client from help>about in campaign console

      This usually happens when there is a version mismatch between the version of server and client . Try to use the same version and the error should not appear.

      S
      Senthil24Author
      Level 4
      January 9, 2017

      Adhiyan wrote...

      Hi Senthil,

       

      Can you please check the build of the server and the client from help>about in campaign console

      This usually happens when there is a version mismatch between the version of server and client . Try to use the same version and the error should not appear.

       

      Hi Adhiyan, 

      Thanks for replying . Just checked the build of the server and client. They are of  same verison.

      6.1.1. Attaching the screenshot for reference.

      S
      Senthil24Author
      Level 4
      January 9, 2017

      florentlb wrote...

      Hi,

      Can you make sure your user has the necessary named rights? There should be one dedicated to executing SQL expressions.

      For reference, here is the list of available named rights: https://docs.campaign.adobe.com/doc/AC6.1/en/PTF_Administration_Elements_Access_management.html#Named_rights

       

      Florent.

       

      Hi Florent, thanks for your reply.

      I have checked for the named right that you mentioned via
      Administration->Access Management->Named rights( ss attached ). But I am not quite sure how to check if a particluar operator has these names rights. When I checked under Administration->Access Management->Operators-> clicked on a particular user , I could only find Access rights.(ss attached) 

      Any help on how to verify that a particualr operator has the required named rights.

      Note:- ss here means screenshot.

      Thanks.

      Senthil

      Adhiyan
      Adobe Employee
      AdhiyanAdobe EmployeeAccepted solution
      Adobe Employee
      January 9, 2017

      Hi Senthil,

       

      I checked the screenshot , your Console is 8601 and server is 8720. So even if version is same the builds are different.

      Please upgrade your client to 8720 as well and the error will not appear.

      The reason is that some components of the server was upgraded and when you use the old client it's not able to properly view the changed components. 

        S
        Senthil24Author
        Level 4
        January 9, 2017

        Adhiyan wrote...

        Hi Senthil,

         

        I checked the screenshot , your Console is 8601 and server is 8720. So even if version is same the builds are different.

        Please upgrade your client to 8720 as well and the error will not appear.

        The reason is that some components of the server was upgraded and when you use the old client it's not able to properly view the changed components. 

         

        Thanks adhiyan,

        Any inputs on how to upgrade the build version of the campaign client will be helpful as I have installed it using the training environment provided to me in the format http://<yourAdobeCampaignserver>:<port number>/nl/jsp/logon.jsp

        florentlb
        florentlb
        Level 10
        January 9, 2017

        Hi Senthil,

        The URL you mentioned should offer you the possibility to install the right console. If not, contact the person in charge of upgrading the server to request that the right version of the console is made available, as explained here: https://docs.campaign.adobe.com/doc/AC6.1/en/INS_Installation_for_Windows__Client_console_availability.html

        Hope this helps,

        Florent

        S
        Senthil24Author
        Level 4
        January 10, 2017

        florentlb wrote...

        Hi Senthil,

        The URL you mentioned should offer you the possibility to install the right console. If not, contact the person in charge of upgrading the server to request that the right version of the console is made available, as explained here: https://docs.campaign.adobe.com/doc/AC6.1/en/INS_Installation_for_Windows__Client_console_availability.html

        Hope this helps,

        Florent

         

        Thanks florent,

        I will see about upgrading the client console ,however I wanted to ask you about the named rights issue that you mentioned earlier. Did you check that one? Do you think there might be an issue with that as well?

        Or the problem occurs because of build mismatch?

        florentlb
        florentlb
        Level 10
        January 10, 2017

        I think the issue is indeed happening because of the version mismatch between console and server (8601 vs. 8720 is really big difference - lots of builds in between that have required console update).

        Just in case, you should be able to add named rights to operators from the operator details under Administration > Access management > Operators. Click Edit, then go to the Access rights tab. From there, you should be able to add the named right. See screenshot attached.

         

        Florent

          S
          Senthil24Author
          Level 4
          January 10, 2017

          florentlb wrote...

          I think the issue is indeed happening because of the version mismatch between console and server (8601 vs. 8720 is really big difference - lots of builds in between that have required console update).

          Just in case, you should be able to add named rights to operators from the operator details under Administration > Access management > Operators. Click Edit, then go to the Access rights tab. From there, you should be able to add the named right. See screenshot attached.

           

          Florent

           

          Thank you so much florent.

          Show more replies
          Terms & ConditionsAccessibility statement

          Loading footer...