[
https://issues.apache.org/jira/browse/AIRAVATA-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie resolved AIRAVATA-2801.
---------------------------------------
Resolution: Fixed
> Cannot create new projects in group base auth implementation. Throws
> AIravataSystemException.
> ---------------------------------------------------------------------------------------------
>
> Key: AIRAVATA-2801
> URL: https://issues.apache.org/jira/browse/AIRAVATA-2801
> Project: Airavata
> Issue Type: Bug
> Components: PGA PHP Web Gateway
> Affects Versions: 0.18
> Environment: https://pga.group-based-auth.scigap.org/
> Reporter: Eroma
> Assignee: Marcus Christie
> Priority: Major
> Fix For: 0.18
>
> Attachments: Screen Shot 2018-06-04 at 12.16.33 PM.png
>
>
> 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]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
