OpenCue Incorrect result size: expected 1, actual 0

Attempting to submit first test job with cuesubmit but getting this error:

2022-05-12 10:07:21,945 ERROR grpc-default-executor-0 com.imageworks.spcue.servant.ManageJob - Failed to launch and add job. org.springframework.dao.EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0

Can anyone help me determine where the problem is?

May 12 '22 14:05 nburdan

Looks like an issue with database configuration but from this it's hard to say where.

Do you have access to your Cuebot logs? That should include more detailed information on the error.

May 12 '22 16:05 bcipriano

Here is spcue.log. Thanks for your help. spcue.log

May 12 '22 18:05 nburdan

If I follow the "Quick Start for Linux" and create postgres/cuebot/rqd in docker I can make a successfull test submission with cuesubmit. But following https://www.opencue.io/docs/getting-started/setting-up-the-database/ seems to not create the same db. Is the db setup in https://www.opencue.io/docs/getting-started/setting-up-the-database/ up to date?

May 12 '22 19:05 nburdan

I upgraded the local postgres from 9.2 to 14 and it has resolved the issue. Perhaps there is a requirement for using postgres >9.2?

May 13 '22 16:05 nburdan