Got an error while trying run a job in Data Manager

Thanin S

Hi there,

I am exploring the Data manager. I have Asset schema ready so I have tried to create a job to import Raw Data by using Adapter "Schema". After creating the job, I go to Recent Jobs and click on "Transformation Request", choose the job and after submitting I got below error message.

"An error occurred while the backend was trying to get access to the destination database. 42P01: relation "ready.76697167-a280-45db-b7ae-74d44523bd9f" does not exist POSITION: 182"

Am I missing some step or config import job wrongly? Or do I need to run this job on the local Adapters client first?

 

Peter_DevSamurai

The error message you’re encountering, 42P01: relation "ready.76697167-a280-45db-b7ae-74d44523bd9f" does not exist, indicates that the system is attempting to access a database table or relation that doesn’t exist. You should check if that table exists or could have been deleted or not in your ready schema:

SELECT table_name

FROM information_schema.tables

WHERE table_schema = 'ready';

Or just import again should do the trick