Skip to main content
shobhits6437
shobhits6437
November 16, 2023
Solved

Getting error "Preview currently unavailable due to an error on the source" while retrieving the data from DB View with Query Entity as well as Record Type.

  • November 16, 2023
  • 4 replies
  • 0 views

Hi,

Getting error "Preview currently unavailable due to an error on the source" while retrieving the data from DB View with Record Type also Expression Evaluation Error while querying with QE. Verified that view has a column wherein unique values are present and same is used as PK in CDT. Only thing is, this view's load time is approx. 20.17 seconds.  

 Anyone can suggest what would be the solution for this.

    Best answer by stefanhelzle0001

    By default the timeouts for database calls are 10 seconds. I suggest to reach out to Appian and discuss this with one of their client success architects.

    4 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 16, 2023

    Make that view faster.

    shobhits6437
    shobhits6437Author
    November 16, 2023

    Hi Stefan,


    Thanks for your reply. We have a separate Database time. And they say that this cannot be shorten more. Is there a way this can be handled at Appian. Need is that I need to use this view for WebAPI creation.

      stefanhelzle0001
      stefanhelzle0001Answer
      Brainy
      November 16, 2023

      By default the timeouts for database calls are 10 seconds. I suggest to reach out to Appian and discuss this with one of their client success architects.

        karumurua531442
        karumurua531442
        November 16, 2023

        Hi [mention:53e48f16520a4945abafe976e4388337:e9ed411860ed4f2ba0265705b8793d05]  initially analyze your database view using explain statement. Later add the necessary indexes for the columns & also remove un-necessary joins from the view. Then check the query time of the view, If still the error exists then reach out to apian support

          Terms & ConditionsAccessibility statement