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?

[Rodrigo Angulo]

had this issues as well any luck?

[Thanin S]

Sorry for my late reply. In my case I had installed the Assets Adapters Client on my local machine and everything work!

[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

[Thanin S]

Hi Peter,

Thank you very much for reply and sorry for late response. You are right on spot that the table does not exist. I was trying to import the data from Asset directly to Data manager which is wrong. 

After I install the Assets Adapters Client on my local machine, things work as it should be.

Thanks again!