4 Replies Latest reply: Feb 15, 2017 5:18 AM by victor onyebuchi RSS

    Cannot load script in Data load  Editor

    victor onyebuchi

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