Cannot load script in Data load Editor

[#1]

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???

[Anonymous · Accepted solution]

The cause is stated in the log :

     Field names must be unique within table

[#3]

Well, I have gone through my field names and cant find any named twice.

[Anonymous]

I would steadily comment out the lines until it works, thus finding out the line that is the problem.

[#5]

Seen the duplicated fields, for some reasons when I pasted the code on my editor, it duplicated some fields.