Skip to main content
varshak0002
New Participant
Nov 29, 2022 4:49 PM UTC
Question

Query fails first time and runs fine afterwards

Hi Guys,

I have a query entity rule which is failing to retrieve data when I run for the first time in a day. If I run again, it's working as expected. This behavior has started happening recently(it was running fine from long).

I looked into the logs and I am not finding the error. 

We use on-prem servers and DB is oracle.

Thanks in advance

    5 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    Nov 29, 2022 5:10 PM UTC

    Do you have any details? Could this be a timing issue? It just works as long as the data is cached in the DB.

    varshak0002Author
    New Participant
    Nov 29, 2022 5:27 PM UTC

    I am thinking it's a timing issue but I don't have any proof of that. Will it cache the entire table data? Because I am querying with different id's and it's all returning data quickly. 
    Also, I am wondering why it's not writing the error in logs. 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    Nov 29, 2022 5:37 PM UTC

    We have two involved parties here. Appian and the connected DB. Appian will write details to the tomcat_stdout log file, in case you want to check this. What the DB is doing, is completely out of control of Appian.

      Terms & ConditionsAccessibility statement