[AIRAVATA-2801] Cannot create new projects in group base auth implementation. Throws AIravataSystemException.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.18
• Fix Version/s: 0.18
• Component/s: PGA PHP Web Gateway
• Environment: https://pga.group-based-auth.scigap.org/
• Assignee: Marcus Christie
• Reporter: Eroma
• Created: 04/Jun/18 16:58
• Updated: 29/Oct/19 06:16
• Resolved: 06/Jun/18 15:23

Description

When tried to save a new project, getting an Airavata System Exception

AiravataSystemException!

Error while retrieving the experiments. More info : Error while retrieving the experiments. More info : (conn:14649) Unknown column 't1.GATEWAY_INSTANCE_ID' in 'field list' {prepstmnt 2101807834 SELECT t0.EXPERIMENT_ID, t1.PROCESS_ID, t1.APPLICATION_DEPLOYMENT_ID, t1.APPLICATION_INTERFACE_ID, t1.COMPUTE_RESOURCE_ID, t1.CREATION_TIME, t1.ENABLE_EMAIL_NOTIFICATION, t1.EXPERIMENT_ID, t1.EXPERIMENT_DATA_DIR, t1.GATEWAY_EXECUTION_ID, t1.GATEWAY_INSTANCE_ID, t1.GENERATE_CERT, t1.GROUP_RESOURCE_PROFILE_ID, t1.LAST_UPDATE_TIME, t1.PROCESS_DETAIL, t2.PROCESS_ID, t2.NODE_COUNT, t2.NUMBER_OF_THREADS, t2.QUEUE_NAME, t2.RESOURCE_HOST_ID, t2.TOTAL_CPU_COUNT, t2.TOTAL_PHYSICAL_MEMORY, t2.WALL_TIME_LIMIT, t1.STORAGE_RESOURCE_ID, t1.TASK_DAG, t1.IS_USE_USER_CR_PREF, t1.USER_DN, t1.USERNAME FROM EXPERIMENT t0 INNER JOIN PROCESS t1 ON t0.EXPERIMENT_ID = t1.EXPERIMENT_ID LEFT OUTER JOIN PROCESS_RESOURCE_SCHEDULE t2 ON t1.PROCESS_ID = t2.PROCESS_ID WHERE (t0.PROJECT_ID LIKE ? ESCAPE '
') ORDER BY t0.EXPERIMENT_ID ASC [params=(String) Test1_c822fbfb-0300-4187-9773-5875caf79298]} [code=1054, state=42S22]