Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I keep having this error when I try loading my script;
The following error occurred:
Field names must be unique within table
The error occurred here:
SQL SELECT GSK_TEF_MODULE_VIEW.REQUEST_ID
,ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_START_TIME) AS INCIDENT_START_TIME
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_START_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'YYYY') AS INCIDENT_START_YEAR
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_START_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MON') AS INCIDENT_START_MONTH_
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_START_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MONTH') AS INCIDENT_START_MONTH
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_START_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'Mon-YY') AS INCIDENT_Beginning_Time
,ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_END_TIME) AS INCIDENT_END_TIME
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_END_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'YYYY') AS INCIDENT_END_YEAR
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_END_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MON') AS INCIDENT_END_MONTH_
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_END_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'MONTH') AS INCIDENT_END_MONTH
,TO_CHAR(TO_DATE(ARADMIN.GET_REM_DATE(gsk_incident.INCIDENT_END_TIME), 'MONTH DD, YYYY HH12:MI:SSAM'), 'Mon-YY') AS INCIDENT_ENDED_Time
,GSK_TEF_MODULE_VIEW.TEF_CREATE_DATE
,GSK_TEF_MODULE_VIEW.TEF_LAST_MODIFIED_DATE
,GSK_TEF_MODULE_VIEW.LOCATIONS_AFFECTED
,GSK_TEF_MODULE_VIEW.BUSINESS_GROUP_AFFECTED
,GSK_TEF_MODULE_VIEW.SERVICE_IMPACT
,GSK_TEF_MODULE_VIEW.BUSINESS_IMPACT
,GSK_TEF_MODULE_VIEW.IMPACT
,GSK_TEF_MODULE_VIEW.SEVERITY
,GSK_TEF_MODULE_VIEW.SITE
,GSK_TEF_MODULE_VIEW.LOCATIONS_AFFECTED
,GSK_TEF_MODULE_VIEW.SEVERITY
,GSK_TEF_MODULE_VIEW.COUNTRY
,GSK_TEF_MODULE_VIEW.EST__SERVICE_RESTORED
,GSK_TEF_MODULE_VIEW.INCIDENT_CAUSED_BY
,GSK_TEF_MODULE_VIEW.ASSIGNED_TO_INDIVIDUAL_
,GSK_TEF_MODULE_VIEW.TEF_STATUS
,GSK_TEF_MODULE_VIEW.BUSINESS_GROUP_AFFECTED
,TO_CHAR(GSK_TEF_MODULE_VIEW.TEF_DURATION_MINS/24,'99,999.99') as Outage_duration
,gsk_incident.ticket_id_
,gsk_incident.category
FROM aradmin.GSK_TEF_MODULE_VIEW,aradmin.gsk_incident
where to_date(ARADMIN.get_rem_date(TEF_CREATE_DATE), 'Month DD, YYYY HH:MI:SSAM') > to_date('01/01/2016', 'MM/DD/YYYY')
and to_date(ARADMIN.get_rem_date(TEF_CREATE_DATE), 'Month DD, YYYY HH:MI:SSAM') < to_date('01/01/2018', 'MM/DD/YYYY')
AND GSK_TEF_MODULE_VIEW.ASSIGNED_TO_GROUP_ = 'IT-RDIT-SUPPORT'
and GSK_TEF_MODULE_VIEW.ticket_id_ = gsk_incident.ticket_id_
and gsk_incident.Category in ('ARCHIVE QUICK CHECK',
'CLINICAL DATA VISIBILITY TOOL',
'CLIN PHARM MODELING SIMULATION ANALYSIS WORKFLOW',
'CPMS AW',
'DATASET MANAGER',
'EDX - ELECTRONIC DOC EXCHANGE',
'ENAVIGATOR',
'GSP - GSK STUDY PORTAL',
'HARP',
'HARP SUITE',
'HIF - HEALTHCARE INFO FACTORY',
'HEALTHCARE INFO FACTORY VISUALISATION',
'INET CATALIST',
'INSIGHT (STUDY MANAGER)',
'PREDICTIVE MODELLING',
'PREDICTIVE MODELLING ENVIRONMENT (PME)',
'RBM - RISK BASED MONITORING',
'SITE OPTIMIZER',
'SPECTRE',
'STUDY ALLOCATION AND RESOURCING SYSTEM (STARS)',
'STUDY OPTIMIZER',
'SUPPLIER CONTRACTS',
'TSCG - TIBCO SPOTFIRE CLINICAL GRAPHICS')
what could be the cause???
The cause is stated in the log :
Field names must be unique within table
The cause is stated in the log :
Field names must be unique within table
Well, I have gone through my field names and cant find any named twice.
I would steadily comment out the lines until it works, thus finding out the line that is the problem.
Seen the duplicated fields, for some reasons when I pasted the code on my editor, it duplicated some fields.