Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Database Query fails with incorrect parameters

I Have a Database Query component which takes in a number of parameters.

Every now and then, the component fails and returns the error "Parameters contain errors". Upon inspection however, it looks like the component received the same parameters as always.

Looking at the server log, I don't see an error but there is a warning: "WARNING [task-thread-29] com.matillion.bi.emerald.shared.model.component.impl.BaseCompWrapper.getParameter Component my_component parameter 3 requested hint SINGLE_VALUE_FREEFORM but received SINGLE_VALUE_FROM_OPTIONS"

Could these be related? Also, what can I do to get rid of this warning?

1 Community Answers

Matillion Agent  

Kalyan Arangam —

Hi Alastair,

Its possible they are related. Unfortunately, its very vague. It would be useful to identify which parameter threw this error.
Please share the logs with us for review.

I’ve found in the past that such errors were thrown when S3 API took longer to respond. Does your S3 bucket used in S3-Staging-Area have many files in it? If so, try using a bucket with fewer files and see if it helps.

Please share a screenshot of a failed task execution from Project→Task History.

Best
Kalyan

Post Your Community Answer

To add an answer please login