PGSQL error while uploading Conservation area to SMART Connect

SMART Community Forum
1

Hi - I’ve SMART Desktop running on 7.5.X and SMART Connect on 7.0.0.
I’ve created a Conservation area on SMART Desktop and now I’m trying to upload it to SMART connect, the upload fails at 81%, when I check the pgsql logs these are the errors which I’m receiving, could you pls guide us on this?

*[root@ip-172-31-11-244 log]# tail -f postgresql-Mon.log *
*2022-12-12 07:15:54.506 UTC [8640] ERROR:  relation "smart.i_patrol_record_motivation" does not exist at character 40*
*2022-12-12 07:15:54.506 UTC [8640] STATEMENT:  SELECT PATROL_UUID,I_RECORD_UUID  FROM SMART.I_PATROL_RECORD_MOTIVATION WHERE false*
*2022-12-12 09:10:15.921 UTC [8640] ERROR:  relation "smart.i_patrol_record_motivation" does not exist at character 40*
*2022-12-12 09:10:15.921 UTC [8640] STATEMENT:  SELECT PATROL_UUID,I_RECORD_UUID  FROM SMART.I_PATROL_RECORD_MOTIVATION WHERE false*
*2022-12-12 09:23:19.627 UTC [8639] ERROR:  relation "smart.i_patrol_record_motivation" does not exist at character 40*
*2022-12-12 09:23:19.627 UTC [8639] STATEMENT:  SELECT PATROL_UUID,I_RECORD_UUID  FROM SMART.I_PATROL_RECORD_MOTIVATION WHERE false*

Regards,
Pavan

2

Thanks for posting, Pavan.

As per our conversation today, the issue here is that you are using a different version of Desktop and Connect, they should be the same version. I hope it will work now that you have the updated script. Thanks

Monica