I am having an issue importing a newer version of my application. It gives me an error:
Failed to add application from the uploaded file. Please increase the log level for transfers to 'Everything' and try again - details will then be visible in the system logs.
In the logs, I find many INFO messages regarding the transfer followed by the error message
could not finish module import, ERROR: insert or update on table "query_join" violates foreign key constraint "query_join_query_id_fkey" (SQLSTATE 23503)
I haven't experienced such a problem updating this application in the past, though I follow the same steps. The platform version is 3.7.6.5159.
How shall I complete the update process? How can I identify the row in the query_join
table causing the error? Is there any manual step on the database (e.g. query_join
table) which would let me fix the problem?