Skip to main content
O
oscarsantiagoh0001
August 19, 2021
Solved

Trying use dunction a!query for query an external database

  • August 19, 2021
  • 6 replies
  • 0 views

Hi,

I'm trying to query an external data base using a!query function, like the next image.

The Data Store have all cdt created from the third party credentials.

I need know if i can use all appian objects normally with an external database.

    Best answer by oscarsantiagoh0001

    The problem was resolved, thanks a lot to the people who answered. The problem reviewing the logs, was that the user used in the third party credentials had access permissions to the database, but not to the database tables, so the problem was permissions. It has already been resolved in case someone else has the same problem :D.

    6 replies

    selvakumark
    selvakumark
    Participating Frequently
    August 19, 2021

    Hi, 

    How many rows of data does your table have? Can you try querying with a batch size of 10 first? Sometimes, if the table has huge data, then querying the entire data will not work.

    O
    oscarsantiagoh0001Author
    August 19, 2021

    Yes and didn't work, this have 31 rows in the table.

    selvakumark
    selvakumark
    Participating Frequently
    August 19, 2021

    If your database connection has no issues, then my next recommendation is to validate the data present in the table.

    For example, if a date column has values like "0000-00-00" which is unsupported by Appian, then we will get this error. Please validate your data set once.

    O
    oscarsantiagoh0001AuthorAnswer
    August 19, 2021

    The problem was resolved, thanks a lot to the people who answered. The problem reviewing the logs, was that the user used in the third party credentials had access permissions to the database, but not to the database tables, so the problem was permissions. It has already been resolved in case someone else has the same problem :D.

      Terms & ConditionsAccessibility statement