Problem : ( After applying patch 9.0.4 ) User when creates a new event on connect, experience an error stating “The item is not selected” or “Please select an item”
Check in the debug log on connect server and look for “REMOTE_CQ_TEMPLATE”. You will see this item is either missing or not found in the Database table name “PPS_EVENT_DETAILS”. The debug log would capture an entry and throws an exception stating “REMOTE_CQ_TEMPLATE” is not found or invalid.
Reason why this happens is because when user apply the patch for 9.0.4 they definitely have not executed the SQL queries provided in the patch ( 184.108.40.206 and 220.127.116.11). The “REMOTE_CQ_TEMPLATE” is present in the script 18.104.22.168.
Therefore go to the Database, make sure the current data base is selected and run the two scripts in sequence ( First 22.214.171.124 and then 126.96.36.199 ).
This should resolve your problem. In case the problem still persist please contact support.