[2022-07-11T16:31:26.713Z] Started by user Aditya.Tangirala [2022-07-11T16:31:28.475Z] /softwares/jenkins/tools/hudson.plugins.sonar.SonarRunnerInstallation/SonarQube_Scanner_4.7.0/bin/sonar-scanner -Dsonar.projectKey=LFS-DATA -Dsonar.sources=. -Dsonar.host.url=http://sonar.myprojects.com:9010 -Dsonar.login=****** -Dsonar.projectName=POC-DATA -Dsonar.tsql.file.suffixes=sql,tsql -Dsonar.plsql.file.suffixes=pks,pkb -Dsonar.branch.name=main -Dsonar.projectVersion=7 [2022-07-11T16:31:28.475Z] INFO: Scanner configuration file: /softwares/jenkins/tools/hudson.plugins.sonar.SonarRunnerInstallation/SonarQube_Scanner_4.7.0/conf/sonar-scanner.properties [2022-07-11T16:31:28.475Z] INFO: Project root configuration file: NONE [2022-07-11T16:31:28.475Z] INFO: SonarScanner 4.7.0.2747 [2022-07-11T16:31:28.476Z] INFO: Java 11.0.11 Red Hat, Inc. (64-bit) [2022-07-11T16:31:28.476Z] INFO: Linux 3.10.0-1160.25.1.el7.x86_64 amd64 [2022-07-11T16:31:29.038Z] INFO: User cache: /home/serviceconn@myprojects.com/.sonar/cache [2022-07-11T16:31:29.038Z] INFO: Scanner configuration file: /softwares/jenkins/tools/hudson.plugins.sonar.SonarRunnerInstallation/SonarQube_Scanner_4.7.0/conf/sonar-scanner.properties [2022-07-11T16:31:29.038Z] INFO: Project root configuration file: NONE [2022-07-11T16:31:29.038Z] INFO: Analyzing on SonarQube server 9.5.0.56709 [2022-07-11T16:31:29.038Z] INFO: Default locale: "en_US", source code encoding: "UTF-8" (analysis is platform dependent) [2022-07-11T16:31:29.597Z] INFO: Load global settings [2022-07-11T16:31:29.847Z] INFO: Load global settings (done) | time=131ms [2022-07-11T16:31:29.847Z] INFO: Server id: 837846AE-AYHTzxy9axmTwKmcgopy [2022-07-11T16:31:29.847Z] INFO: User cache: /home/serviceconn@myprojects.com/.sonar/cache [2022-07-11T16:31:29.847Z] INFO: Load/download plugins [2022-07-11T16:31:29.847Z] INFO: Load plugins index [2022-07-11T16:31:29.847Z] INFO: Load plugins index (done) | time=65ms [2022-07-11T16:31:30.098Z] INFO: Load/download plugins (done) | time=262ms [2022-07-11T16:31:30.348Z] INFO: Loaded core extensions: developer-scanner [2022-07-11T16:31:30.914Z] INFO: Process project properties [2022-07-11T16:31:30.914Z] INFO: Process project properties (done) | time=10ms [2022-07-11T16:31:30.914Z] INFO: Execute project builders [2022-07-11T16:31:30.914Z] INFO: Execute project builders (done) | time=2ms [2022-07-11T16:31:31.172Z] INFO: Project key: POC-DATA [2022-07-11T16:31:31.172Z] INFO: Base dir: /softwares/jenkins/workspace/POC-Data-Sonar [2022-07-11T16:31:31.172Z] INFO: Working dir: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork [2022-07-11T16:31:31.172Z] INFO: Load project settings for component key: 'POC-DATA' [2022-07-11T16:31:31.172Z] INFO: Load project settings for component key: 'POC-DATA' (done) | time=94ms [2022-07-11T16:31:31.422Z] INFO: Load project branches [2022-07-11T16:31:31.422Z] INFO: Load project branches (done) | time=17ms [2022-07-11T16:31:31.422Z] INFO: Load project pull requests [2022-07-11T16:31:31.422Z] INFO: Load project pull requests (done) | time=10ms [2022-07-11T16:31:31.423Z] INFO: Load branch configuration [2022-07-11T16:31:31.423Z] INFO: Found manual configuration of branch/PR analysis. Skipping automatic configuration. [2022-07-11T16:31:31.423Z] INFO: Load branch configuration (done) | time=3ms [2022-07-11T16:31:31.423Z] INFO: Auto-configuring with CI 'Jenkins' [2022-07-11T16:31:31.423Z] INFO: Load quality profiles [2022-07-11T16:31:31.673Z] INFO: Load quality profiles (done) | time=67ms [2022-07-11T16:31:31.673Z] INFO: Load active rules [2022-07-11T16:31:35.795Z] INFO: Load active rules (done) | time=3477ms [2022-07-11T16:31:35.795Z] INFO: Load analysis cache [2022-07-11T16:31:35.795Z] INFO: Load analysis cache (404) | time=7ms [2022-07-11T16:31:35.795Z] INFO: Branch name: main [2022-07-11T16:31:35.795Z] INFO: Load project repositories [2022-07-11T16:31:35.795Z] INFO: Load project repositories (done) | time=16ms [2022-07-11T16:31:35.795Z] INFO: Indexing files... [2022-07-11T16:31:35.795Z] INFO: Project configuration: [2022-07-11T16:31:35.795Z] INFO: 152 files indexed [2022-07-11T16:31:35.795Z] INFO: 0 files ignored because of scm ignore settings [2022-07-11T16:31:35.795Z] INFO: Quality profile for json: Sonar way [2022-07-11T16:31:35.795Z] INFO: Quality profile for py: Sonar way [2022-07-11T16:31:35.795Z] INFO: Quality profile for tsql: Sonar way [2022-07-11T16:31:35.795Z] INFO: ------------- Run sensors on module LFS-DATA [2022-07-11T16:31:35.795Z] INFO: Load metrics repository [2022-07-11T16:31:35.795Z] INFO: Load metrics repository (done) | time=33ms [2022-07-11T16:31:39.041Z] INFO: Sensor IaC CloudFormation Sensor [iac] [2022-07-11T16:31:39.041Z] INFO: 0 source files to be analyzed [2022-07-11T16:31:39.041Z] INFO: 0/0 source files have been analyzed [2022-07-11T16:31:39.041Z] INFO: Sensor IaC CloudFormation Sensor [iac] (done) | time=117ms [2022-07-11T16:31:39.041Z] INFO: Sensor C# Project Type Information [csharp] [2022-07-11T16:31:39.041Z] INFO: Sensor C# Project Type Information [csharp] (done) | time=1ms [2022-07-11T16:31:39.041Z] INFO: Sensor C# Analysis Log [csharp] [2022-07-11T16:31:39.041Z] INFO: Sensor C# Analysis Log [csharp] (done) | time=18ms [2022-07-11T16:31:39.041Z] INFO: Sensor C# Properties [csharp] [2022-07-11T16:31:39.041Z] INFO: Sensor C# Properties [csharp] (done) | time=0ms [2022-07-11T16:31:39.041Z] INFO: Sensor HTML [web] [2022-07-11T16:31:39.041Z] INFO: Sensor HTML [web] (done) | time=4ms [2022-07-11T16:31:39.041Z] INFO: Sensor Text Sensor [text] [2022-07-11T16:31:39.041Z] INFO: 148 source files to be analyzed [2022-07-11T16:31:39.041Z] INFO: 148/148 source files have been analyzed [2022-07-11T16:31:39.041Z] INFO: Sensor Text Sensor [text] (done) | time=249ms [2022-07-11T16:31:39.041Z] INFO: Sensor VB.NET Project Type Information [vbnet] [2022-07-11T16:31:39.041Z] INFO: Sensor VB.NET Project Type Information [vbnet] (done) | time=1ms [2022-07-11T16:31:39.041Z] INFO: Sensor VB.NET Analysis Log [vbnet] [2022-07-11T16:31:39.292Z] INFO: Sensor VB.NET Analysis Log [vbnet] (done) | time=17ms [2022-07-11T16:31:39.292Z] INFO: Sensor VB.NET Properties [vbnet] [2022-07-11T16:31:39.292Z] INFO: Sensor VB.NET Properties [vbnet] (done) | time=0ms [2022-07-11T16:31:39.292Z] INFO: Sensor Python Sensor [python] [2022-07-11T16:31:39.292Z] WARN: Your code is analyzed as compatible with python 2 and 3 by default. This will prevent the detection of issues specific to python 2 or python 3. You can get a more precise analysis by setting a python version in your configuration via the parameter "sonar.python.version" [2022-07-11T16:31:39.293Z] INFO: Starting global symbols computation [2022-07-11T16:31:39.293Z] INFO: 45 source files to be analyzed [2022-07-11T16:31:41.174Z] INFO: 45/45 source files have been analyzed [2022-07-11T16:31:41.174Z] INFO: Starting rules execution [2022-07-11T16:31:41.174Z] INFO: 45 source files to be analyzed [2022-07-11T16:31:46.403Z] INFO: 45/45 source files have been analyzed [2022-07-11T16:31:46.403Z] INFO: Sensor Python Sensor [python] (done) | time=6921ms [2022-07-11T16:31:46.403Z] INFO: Sensor Cobertura Sensor for Python coverage [python] [2022-07-11T16:31:46.403Z] INFO: Sensor Cobertura Sensor for Python coverage [python] (done) | time=29ms [2022-07-11T16:31:46.403Z] INFO: Sensor PythonXUnitSensor [python] [2022-07-11T16:31:46.403Z] INFO: Sensor PythonXUnitSensor [python] (done) | time=15ms [2022-07-11T16:31:46.403Z] INFO: Sensor JaCoCo XML Report Importer [jacoco] [2022-07-11T16:31:46.403Z] INFO: 'sonar.coverage.jacoco.xmlReportPaths' is not defined. Using default locations: target/site/jacoco/jacoco.xml,target/site/jacoco-it/jacoco.xml,build/reports/jacoco/test/jacocoTestReport.xml [2022-07-11T16:31:46.403Z] INFO: No report imported, no coverage information will be imported by JaCoCo XML Report Importer [2022-07-11T16:31:46.403Z] INFO: Sensor JaCoCo XML Report Importer [jacoco] (done) | time=3ms [2022-07-11T16:31:46.403Z] INFO: Sensor T-SQL Sensor [tsql] [2022-07-11T16:31:46.403Z] INFO: 96 source files to be analyzed [2022-07-11T16:31:46.403Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/dt_src_ror/vw_loc_m.sql' : Parse error at line 1 column 54: [2022-07-11T16:31:46.403Z] [2022-07-11T16:31:46.403Z] 1: DROP VIEW IF EXISTS dt_src_ror.vw_loc_m CASCADE; [2022-07-11T16:31:46.403Z] ^ [2022-07-11T16:31:46.403Z] 2: [2022-07-11T16:31:46.403Z] 3: CREATE VIEW dt_src_ror.vw_loc_mt [2022-07-11T16:31:46.403Z] 4: ( [2022-07-11T16:31:46.403Z] 5: key, [2022-07-11T16:31:46.403Z] 6: id, [2022-07-11T16:31:46.403Z] 7: location, [2022-07-11T16:31:46.403Z] 8: fname, [2022-07-11T16:31:46.403Z] 9: fid, [2022-07-11T16:31:46.403Z] 10: obid, [2022-07-11T16:31:46.403Z] 11: suite, [2022-07-11T16:31:46.403Z] [2022-07-11T16:31:46.403Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_m/d_p.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:46.403Z] [2022-07-11T16:31:46.403Z] 1: CREATE TABLE IF NOT EXISTS p_mt.d_p [2022-07-11T16:31:46.403Z] ^ [2022-07-11T16:31:46.403Z] 2: ( [2022-07-11T16:31:46.403Z] 3: p_key BIGINT NOT NULL DEFAULT "identity"(370421, 0, '1,1'::text), [2022-07-11T16:31:46.403Z] 4: key integer NOT NULL, [2022-07-11T16:31:46.403Z] 5: id_dbo integer, [2022-07-11T16:31:46.403Z] 6: p_id_obid integer, [2022-07-11T16:31:46.403Z] 7: obid integer, [2022-07-11T16:31:46.403Z] 8: is_current boolean, [2022-07-11T16:31:46.403Z] 9: st_date timestamp, [2022-07-11T16:31:46.403Z] 10: e_date timestamp, [2022-07-11T16:31:46.403Z] 11: is_active boolean, [2022-07-11T16:31:46.403Z] [2022-07-11T16:31:46.653Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_c_blks.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:46.653Z] [2022-07-11T16:31:46.653Z] 1: CREATE TABLE IF NOT EXISTS c_mt.d_c_blks [2022-07-11T16:31:46.653Z] ^ [2022-07-11T16:31:46.653Z] 2: ( [2022-07-11T16:31:46.653Z] 3: c_blk_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:46.653Z] 4: key integer NOT NULL, [2022-07-11T16:31:46.653Z] 5: r_key integer NOT NULL, [2022-07-11T16:31:46.653Z] 6: c_key integer NOT NULL, [2022-07-11T16:31:46.654Z] 7: f_key integer NOT NULL, [2022-07-11T16:31:46.654Z] 8: ibo integer, [2022-07-11T16:31:46.654Z] 9: is_active boolean, [2022-07-11T16:31:46.654Z] 10: c_timestamp timestamp, [2022-07-11T16:31:46.654Z] 11: ch_timestamp timestamp, [2022-07-11T16:31:46.654Z] [2022-07-11T16:31:46.905Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_src_ror/v_ca.sql' : Parse error at line 1 column 57: [2022-07-11T16:31:46.905Z] [2022-07-11T16:31:46.905Z] 1: DROP VIEW IF EXISTS d_src_ror.v_ca CASCADE; [2022-07-11T16:31:46.905Z] ^ [2022-07-11T16:31:46.905Z] 2: [2022-07-11T16:31:46.905Z] 3: CREATE VIEW d_src_ror.v_ca [2022-07-11T16:31:46.905Z] 4: ( [2022-07-11T16:31:46.905Z] 5: c_m_key, [2022-07-11T16:31:46.905Z] 6: key, [2022-07-11T16:31:46.905Z] 7: c_id, [2022-07-11T16:31:46.905Z] 8: f_id, [2022-07-11T16:31:46.905Z] 9: ipi, [2022-07-11T16:31:46.905Z] 10: obi, [2022-07-11T16:31:46.905Z] 11: m_id, [2022-07-11T16:31:46.905Z] [2022-07-11T16:31:46.905Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/ap_m/f_ap.sql' : Parse error at line 6 column 24: [2022-07-11T16:31:46.905Z] [2022-07-11T16:31:46.905Z] 1: CREATE TABLE appointment_mart.fact_appointment [2022-07-11T16:31:46.905Z] 2: ( [2022-07-11T16:31:46.905Z] 3: a_key BIGINT IDENTITY(1,1) NOT NULL [2022-07-11T16:31:46.905Z] 4: ,obi INTEGER [2022-07-11T16:31:46.905Z] 5: ,is_current BOOLEAN NOT NULL [2022-07-11T16:31:46.905Z] 6: ,start_date TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:46.905Z] ^ [2022-07-11T16:31:46.905Z] 7: ,end_date TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:46.905Z] 8: ,aid_a BIGINT [2022-07-11T16:31:46.905Z] 9: ,a_id_o BIGINT [2022-07-11T16:31:46.905Z] 10: ,c_timestamp TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:46.905Z] 11: ,ch_timestamp TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:46.905Z] 12: ,c_key BIGINT [2022-07-11T16:31:46.905Z] 13: ,f_key BIGINT [2022-07-11T16:31:46.905Z] 14: ,key BIGINT [2022-07-11T16:31:46.905Z] 15: ,p_key BIGINT [2022-07-11T16:31:46.905Z] 16: ,a_date DATE [2022-07-11T16:31:46.905Z] [2022-07-11T16:31:47.155Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/i_a_tbl.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:47.155Z] [2022-07-11T16:31:47.155Z] 1: CREATE TABLE IF NOT EXISTS i_a_tbl( [2022-07-11T16:31:47.155Z] ^ [2022-07-11T16:31:47.155Z] 2: r_date datetime, [2022-07-11T16:31:47.155Z] 3: d_src_name varchar(200), [2022-07-11T16:31:47.155Z] 4: b_l_num varchar(200), [2022-07-11T16:31:47.155Z] 5: tb_name varchar(200), [2022-07-11T16:31:47.155Z] 6: s_time datetime, [2022-07-11T16:31:47.155Z] 7: e_time datetime, [2022-07-11T16:31:47.155Z] 8: t_t_t_in_min integer, [2022-07-11T16:31:47.155Z] 9: rows_ld integer, [2022-07-11T16:31:47.155Z] 10: stat varchar(200), [2022-07-11T16:31:47.155Z] 11: er_msg varchar(500), [2022-07-11T16:31:47.155Z] [2022-07-11T16:31:47.156Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_m/d_ref_src.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:47.156Z] [2022-07-11T16:31:47.156Z] 1: CREATE TABLE IF NOT EXISTS patient_mart.dim_referral_source [2022-07-11T16:31:47.156Z] ^ [2022-07-11T16:31:47.156Z] 2: ( [2022-07-11T16:31:47.156Z] 3: r_s_key INTEGER NOT NULL DEFAULT "identity"(351758, 0, '1,1'::text) [2022-07-11T16:31:47.156Z] 4: ,ref_src VARCHAR(50) [2022-07-11T16:31:47.156Z] 5: ); [2022-07-11T16:31:47.156Z] 6: [2022-07-11T16:31:47.156Z] 7: ALTER TABLE p_m.d_r_s [2022-07-11T16:31:47.156Z] 8: ADD CONSTRAINT pk_d_ref_src [2022-07-11T16:31:47.156Z] 9: PRIMARY KEY (ref_src_key); [2022-07-11T16:31:47.156Z] [2022-07-11T16:31:47.406Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/a_m/f_c_h.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:47.406Z] [2022-07-11T16:31:47.406Z] 1: CREATE TABLE IF NOT EXISTS a_m.f_cl_hlds [2022-07-11T16:31:47.406Z] ^ [2022-07-11T16:31:47.406Z] 2: ( [2022-07-11T16:31:47.406Z] 3: c_h_key BIGINT IDENTITY(1,1) NOT NULL [2022-07-11T16:31:47.406Z] 4: ,brule_id BIGINT [2022-07-11T16:31:47.406Z] 5: ,c_key BIGINT [2022-07-11T16:31:47.406Z] 6: ,f_key BIGINT [2022-07-11T16:31:47.406Z] 7: ,key BIGINT [2022-07-11T16:31:47.406Z] 8: ,r_key BIGINT [2022-07-11T16:31:47.406Z] 9: ,a_date DATE [2022-07-11T16:31:47.406Z] 10: ,h_stime VARCHAR(50) [2022-07-11T16:31:47.406Z] 11: ,h_etime VARCHAR(50) [2022-07-11T16:31:47.406Z] [2022-07-11T16:31:47.657Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/a_mt/f_c_blk.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:47.657Z] [2022-07-11T16:31:47.657Z] 1: CREATE TABLE IF NOT EXISTS a_m.f_c_b [2022-07-11T16:31:47.657Z] ^ [2022-07-11T16:31:47.657Z] 2: ( [2022-07-11T16:31:47.657Z] 3: c_bl_key BIGINT IDENTITY(1,1) NOT NULL [2022-07-11T16:31:47.657Z] 4: ,brule_id BIGINT [2022-07-11T16:31:47.657Z] 5: ,c_key BIGINT [2022-07-11T16:31:47.657Z] 6: ,f_key BIGINT [2022-07-11T16:31:47.657Z] 7: ,l_key BIGINT [2022-07-11T16:31:47.657Z] 8: ,a_date DATE [2022-07-11T16:31:47.657Z] 9: ,b_stime VARCHAR(50) [2022-07-11T16:31:47.657Z] 10: ,b_etime VARCHAR(50) [2022-07-11T16:31:47.657Z] 11: ,c_timestamp TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:47.657Z] [2022-07-11T16:31:47.907Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_src_ror/v_i_co.sql' : Parse error at line 1 column 59: [2022-07-11T16:31:47.907Z] [2022-07-11T16:31:47.907Z] 1: DROP VIEW IF EXISTS d_src_ror.v_i_co CASCADE; [2022-07-11T16:31:47.907Z] ^ [2022-07-11T16:31:47.907Z] 2: [2022-07-11T16:31:47.907Z] 3: CREATE VIEW d_src_ror.vw_i_co [2022-07-11T16:31:47.907Z] 4: ( [2022-07-11T16:31:47.907Z] 5: i_co_key, [2022-07-11T16:31:47.907Z] 6: obi, [2022-07-11T16:31:47.907Z] 7: i_co_id, [2022-07-11T16:31:47.907Z] 8: cmp_name, [2022-07-11T16:31:47.907Z] 9: m_id, [2022-07-11T16:31:47.907Z] 10: grp_id, [2022-07-11T16:31:47.907Z] 11: r_to_po_holder, [2022-07-11T16:31:47.907Z] [2022-07-11T16:31:47.907Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/sg/su_sm_rep.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:47.907Z] [2022-07-11T16:31:47.907Z] 1: CREATE TABLE IF NOT EXISTS sg.sup_sm_rep [2022-07-11T16:31:47.907Z] ^ [2022-07-11T16:31:47.907Z] 2: ( [2022-07-11T16:31:47.907Z] 3: su_sp_rep_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:47.907Z] 4: c_at timestamp NOT NULL, [2022-07-11T16:31:47.907Z] 5: email varchar(150), [2022-07-11T16:31:47.907Z] 6: ip varchar(500) [2022-07-11T16:31:47.907Z] 7: ); [2022-07-11T16:31:47.907Z] 8: [2022-07-11T16:31:47.907Z] 9: ALTER TABLE sg.sup_sp_rep [2022-07-11T16:31:47.907Z] 10: ADD CONSTRAINT pk_sup_sp_rep [2022-07-11T16:31:47.907Z] 11: PRIMARY KEY (sup_sp_rep_key); [2022-07-11T16:31:47.907Z] [2022-07-11T16:31:47.907Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_src_ror/v_c_m.sql' : Parse error at line 1 column 55: [2022-07-11T16:31:47.907Z] [2022-07-11T16:31:47.907Z] 1: DROP VIEW IF EXISTS d_src_ror.v_cl_m CASCADE; [2022-07-11T16:31:47.907Z] ^ [2022-07-11T16:31:47.907Z] 2: [2022-07-11T16:31:47.907Z] 3: CREATE VIEW data_source_ror.vw_clinician_mart [2022-07-11T16:31:47.907Z] 4: ( [2022-07-11T16:31:47.907Z] 5: key, [2022-07-11T16:31:47.907Z] 6: c_id, [2022-07-11T16:31:47.907Z] 7: f_name, [2022-07-11T16:31:47.907Z] 8: m_name, [2022-07-11T16:31:47.907Z] 9: l_name, [2022-07-11T16:31:47.908Z] 10: c_type, [2022-07-11T16:31:47.908Z] 11: l_type, [2022-07-11T16:31:47.908Z] [2022-07-11T16:31:47.908Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/i_sc_ing_ctr_tbl.sql' : Parse error at line 1 column 10: [2022-07-11T16:31:47.908Z] [2022-07-11T16:31:47.908Z] 1: TRUNCATE i_ctr_tbl; [2022-07-11T16:31:47.908Z] ^ [2022-07-11T16:31:47.908Z] 2: [2022-07-11T16:31:47.908Z] 3: Insert INTO i_ctr_tbl(d_sr_name, b_l_number, t_name, d_col_name, d_format, l_d_date, [2022-07-11T16:31:47.908Z] 4: l_d_num, l_d_str, p_col) [2022-07-11T16:31:47.908Z] 5: values [2022-07-11T16:31:47.908Z] 6: ('poc','b1','poc_mf',NULL,NULL,NULL,NULL,NULL,NULL) [2022-07-11T16:31:47.908Z] 7: ,('poc','b1','poc_mf_1',NULL,NULL,NULL,NULL,NULL,NULL) [2022-07-11T16:31:47.908Z] 8: ,('poc','b1','poc_mf_1',NULL,NULL,NULL,NULL,NULL,NULL) [2022-07-11T16:31:47.908Z] 9: ,('poc','b1','poc_mf_2',NULL,NULL,NULL,NULL,NULL,NULL) [2022-07-11T16:31:47.908Z] 10: ,('poc','b1','poc_mf_3',NULL,NULL,NULL,NULL,NULL,NULL) [2022-07-11T16:31:47.908Z] 11: ,('poc','b1','poc_mf_t',NULL,NULL,NULL,NULL,NULL,NULL) [2022-07-11T16:31:47.908Z] [2022-07-11T16:31:47.908Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_c.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:47.908Z] [2022-07-11T16:31:47.908Z] 1: CREATE TABLE IF NOT EXISTS c_mart.d_c [2022-07-11T16:31:47.908Z] ^ [2022-07-11T16:31:47.908Z] 2: ( [2022-07-11T16:31:47.908Z] 3: c_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:47.908Z] 4: is_current boolean NOT NULL, [2022-07-11T16:31:47.908Z] 5: s_date timestamp NOT NULL, [2022-07-11T16:31:47.908Z] 6: e_date timestamp, [2022-07-11T16:31:47.908Z] 7: key integer NOT NULL, [2022-07-11T16:31:47.908Z] 8: c_id integer NOT NULL, [2022-07-11T16:31:47.908Z] 9: f_name varchar(100), [2022-07-11T16:31:47.908Z] 10: m_name varchar(100), [2022-07-11T16:31:47.908Z] 11: l_name varchar(100), [2022-07-11T16:31:47.908Z] [2022-07-11T16:31:47.908Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_ed.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:47.908Z] [2022-07-11T16:31:47.908Z] 1: CREATE TABLE IF NOT EXISTS c_m.d_ed [2022-07-11T16:31:47.908Z] ^ [2022-07-11T16:31:47.908Z] 2: ( [2022-07-11T16:31:47.908Z] 3: ed_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:47.908Z] 4: ni integer, [2022-07-11T16:31:47.908Z] 5: uname varchar(200), [2022-07-11T16:31:47.908Z] 6: ucity varchar(200), [2022-07-11T16:31:47.908Z] 7: ustate varchar(200), [2022-07-11T16:31:47.908Z] 8: uc varchar(200), [2022-07-11T16:31:47.908Z] 9: reftype varchar(200), [2022-07-11T16:31:47.908Z] 10: gyear integer, [2022-07-11T16:31:47.908Z] 11: deg varchar(200) [2022-07-11T16:31:47.908Z] [2022-07-11T16:31:48.458Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_mart/m_poc_car.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:48.459Z] [2022-07-11T16:31:48.459Z] 1: CREATE TABLE IF NOT EXISTS c_m.ma_poc_pocn_c [2022-07-11T16:31:48.459Z] ^ [2022-07-11T16:31:48.459Z] 2: ( [2022-07-11T16:31:48.459Z] 3: m_poc_to_pocs_c_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:48.459Z] 4: is_current boolean NOT NULL, [2022-07-11T16:31:48.459Z] 5: s_date timestamp NOT NULL, [2022-07-11T16:31:48.459Z] 6: e_date timestamp, [2022-07-11T16:31:48.459Z] 7: key integer, [2022-07-11T16:31:48.459Z] 8: poc_carrier_id integer NOT NULL, [2022-07-11T16:31:48.459Z] 9: pocs_c_id integer, [2022-07-11T16:31:48.459Z] 10: poc_c_name varchar(100), [2022-07-11T16:31:48.459Z] 11: poc_c_code varchar(100), [2022-07-11T16:31:48.459Z] [2022-07-11T16:31:48.716Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_m/d_i_stats.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:48.716Z] [2022-07-11T16:31:48.716Z] 1: CREATE TABLE IF NOT EXISTS p_m.d_i_stats [2022-07-11T16:31:48.716Z] ^ [2022-07-11T16:31:48.716Z] 2: ( [2022-07-11T16:31:48.716Z] 3: i_st_k INTEGER NOT NULL DEFAULT "identity"(351758, 0, '1,1'::text) [2022-07-11T16:31:48.716Z] 4: ,i_st_id INTEGER [2022-07-11T16:31:48.716Z] 5: ,i_st VARCHAR(50) [2022-07-11T16:31:48.716Z] 6: ); [2022-07-11T16:31:48.716Z] 7: [2022-07-11T16:31:48.716Z] 8: ALTER TABLE p_m.d_i_stats [2022-07-11T16:31:48.716Z] 9: ADD CONSTRAINT pk_d_i_stats [2022-07-11T16:31:48.716Z] 10: PRIMARY KEY (i_stats_key); [2022-07-11T16:31:48.716Z] [2022-07-11T16:31:48.716Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/i_cl_tbl.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:48.716Z] [2022-07-11T16:31:48.716Z] 1: CREATE TABLE IF NOT EXISTS i_ctrl_tbl( [2022-07-11T16:31:48.716Z] ^ [2022-07-11T16:31:48.716Z] 2: d_s_name varchar(200), [2022-07-11T16:31:48.716Z] 3: b_l_number varchar(200), [2022-07-11T16:31:48.716Z] 4: t_n varchar(200), [2022-07-11T16:31:48.716Z] 5: d_c_name varchar(200), [2022-07-11T16:31:48.716Z] 6: d_fort varchar(200), [2022-07-11T16:31:48.716Z] 7: l_d_date datetime, [2022-07-11T16:31:48.716Z] 8: l_d_number integer, [2022-07-11T16:31:48.716Z] 9: l_d_string varchar(200), [2022-07-11T16:31:48.716Z] 10: p_col varchar(200), [2022-07-11T16:31:48.716Z] 11: obi varchar(200) [2022-07-11T16:31:48.716Z] [2022-07-11T16:31:49.627Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/sg/sup_b.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.627Z] [2022-07-11T16:31:49.627Z] 1: CREATE TABLE IF NOT EXISTS sg.sup_b [2022-07-11T16:31:49.627Z] ^ [2022-07-11T16:31:49.627Z] 2: ( [2022-07-11T16:31:49.627Z] 3: sup_b_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:49.627Z] 4: c_at timestamp NOT NULL, [2022-07-11T16:31:49.627Z] 5: email varchar(150), [2022-07-11T16:31:49.627Z] 6: rs varchar(500), [2022-07-11T16:31:49.627Z] 7: stats varchar(500) [2022-07-11T16:31:49.627Z] 8: ); [2022-07-11T16:31:49.627Z] 9: [2022-07-11T16:31:49.627Z] 10: ALTER TABLE sg.sup_b [2022-07-11T16:31:49.627Z] 11: ADD CONSTRAINT pk_sup_b [2022-07-11T16:31:49.627Z] [2022-07-11T16:31:49.627Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/A_Q/M_c_m_tbl.sql' : Parse error at line 33 column 2: [2022-07-11T16:31:49.627Z] [2022-07-11T16:31:49.627Z] 23: acode char(3), [2022-07-11T16:31:49.627Z] 24: ccode varchar(3), [2022-07-11T16:31:49.627Z] 25: obi int, [2022-07-11T16:31:49.627Z] 26: tH_url nvarchar(2083), [2022-07-11T16:31:49.627Z] 27: sex char(1), [2022-07-11T16:31:49.627Z] 28: l varchar(30), [2022-07-11T16:31:49.627Z] 29: pr varchar(10)) [2022-07-11T16:31:49.627Z] 30: Insert INTO C_m(f_name,l_name,c_type,l_type,sp,a_t_p,a_n_p,in_o,v_v,m_med,ag_acc,ed,p_id,npp,key,p_loc,loc,zc,cy,st,acode,ccode,obi,th_url,ged,lang,pr) [2022-07-11T16:31:49.627Z] 31: values [2022-07-11T16:31:49.627Z] 32: ('Aaa','Gaaa','Cricketer','AX', 'XEED', 'helpful and understanding', 0, 0, 0, 0, '0-60', 'XXXXXXXXX', 0, '1666666666', 0, 0, '0 X XXYX xyz', '0000-1122', 'XXXXXXX', 'XX', 100, 'XX',99999,'https://www.example.com/', 'X', 'XX', 'X') [2022-07-11T16:31:49.627Z] 33: ('Bbb','Baaa','Cricketer','XX', 'DEEX Obe', 'xxxX', 0, 0, 0, 0, '0-20', 'XXXXXXXXXXXXXXXXXX', 0, '166666666', 0, 0, '10006666',0,'100 XX XXX xyz', 'XX', 0, 'XXX', 0, 'https://www.example.com', 'X', 'X', 'X') [2022-07-11T16:31:49.627Z] ^ [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_i_sc_i_con_tbl.sql' : Parse error at line 1 column 10: [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] 1: TRUNCATE i_c_tbl; [2022-07-11T16:31:49.628Z] ^ [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_c_a_hld.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] 1: CREATE TABLE IF NOT EXISTS c_mt.d_c_av_hld [2022-07-11T16:31:49.628Z] ^ [2022-07-11T16:31:49.628Z] 2: ( [2022-07-11T16:31:49.628Z] 3: c_a_hd_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:49.628Z] 4: key integer NOT NULL, [2022-07-11T16:31:49.628Z] 5: r_key integer NOT NULL, [2022-07-11T16:31:49.628Z] 6: c_key integer NOT NULL, [2022-07-11T16:31:49.628Z] 7: f_key integer NOT NULL, [2022-07-11T16:31:49.628Z] 8: obi integer, [2022-07-11T16:31:49.628Z] 9: active boolean, [2022-07-11T16:31:49.628Z] 10: c_timestamp timestamp, [2022-07-11T16:31:49.628Z] 11: ch_timestamp timestamp, [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_p.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] 1: CREATE TABLE IF NOT EXISTS c.m_p [2022-07-11T16:31:49.628Z] ^ [2022-07-11T16:31:49.628Z] 2: ( [2022-07-11T16:31:49.628Z] 3: p_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:49.628Z] 4: key integer NOT NULL, [2022-07-11T16:31:49.628Z] 5: p_id integer NOT NULL, [2022-07-11T16:31:49.628Z] 6: obi integer, [2022-07-11T16:31:49.628Z] 7: i_c integer, [2022-07-11T16:31:49.628Z] 8: is_act boolean, [2022-07-11T16:31:49.628Z] 9: agt integer, [2022-07-11T16:31:49.628Z] 10: gd varchar(20), [2022-07-11T16:31:49.628Z] 11: st_date timestamp, [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/a_c_a_pg.sql' : Parse error at line 2 column 20: [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] 1: /**DROP EXISTING INDEX **/ [2022-07-11T16:31:49.628Z] 2: DROP INDEX IF EXISTS xx_pxxxx_c_caa_av_key; [2022-07-11T16:31:49.628Z] ^ [2022-07-11T16:31:49.628Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_t/d_h_b_r.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] 1: CREATE TABLE IF NOT EXISTS c_m.d_ho_b_r [2022-07-11T16:31:49.628Z] ^ [2022-07-11T16:31:49.628Z] 2: ( [2022-07-11T16:31:49.628Z] 3: h_b_r_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:49.628Z] 4: key integer NOT NULL, [2022-07-11T16:31:49.628Z] 5: r_id integer NOT NULL, [2022-07-11T16:31:49.628Z] 6: obi integer, [2022-07-11T16:31:49.628Z] 7: s_d timestamp, [2022-07-11T16:31:49.628Z] 8: e_date timestamp, [2022-07-11T16:31:49.628Z] 9: i_active boolean, [2022-07-11T16:31:49.628Z] 10: r varchar(200), [2022-07-11T16:31:49.628Z] 11: type varchar(200), [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_mm/d_ref_pr.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.628Z] 1: CREATE TABLE IF NOT EXISTS p_m.d_ref_pr [2022-07-11T16:31:49.628Z] ^ [2022-07-11T16:31:49.628Z] 2: ( [2022-07-11T16:31:49.628Z] 3: ref_pr_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:49.628Z] 4: key integer NOT NULL, [2022-07-11T16:31:49.628Z] 5: ref_prov_id integer, [2022-07-11T16:31:49.628Z] 6: prov_code varchar(50), [2022-07-11T16:31:49.628Z] 7: l_name varchar(50), [2022-07-11T16:31:49.628Z] 8: f_name varchar(50), [2022-07-11T16:31:49.628Z] 9: m_name varchar(50), [2022-07-11T16:31:49.628Z] 10: title varchar(50), [2022-07-11T16:31:49.628Z] 11: c_time timestamp, [2022-07-11T16:31:49.628Z] [2022-07-11T16:31:49.879Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_app.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] 1: CREATE TABLE IF NOT EXISTS c_m.d_app [2022-07-11T16:31:49.879Z] ^ [2022-07-11T16:31:49.879Z] 2: ( [2022-07-11T16:31:49.879Z] 3: app_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:49.879Z] 4: app_id integer NOT NULL, [2022-07-11T16:31:49.879Z] 5: key integer NOT NULL, [2022-07-11T16:31:49.879Z] 6: p_key integer NOT NULL, [2022-07-11T16:31:49.879Z] 7: c_key integer NOT NULL, [2022-07-11T16:31:49.879Z] 8: f_key integer NOT NULL, [2022-07-11T16:31:49.879Z] 9: app_type_key integer NOT NULL, [2022-07-11T16:31:49.879Z] 10: app_stats_key integer NOT NULL, [2022-07-11T16:31:49.879Z] 11: stats_rsn varchar(200), [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_m/d_sp_cs.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] 1: CREATE TABLE IF NOT EXISTS p_m.d_sp_c [2022-07-11T16:31:49.879Z] ^ [2022-07-11T16:31:49.879Z] 2: ( [2022-07-11T16:31:49.879Z] 3: sp_case_key INTEGER NOT NULL DEFAULT "identity"(351758, 0, '1,1'::text) [2022-07-11T16:31:49.879Z] 4: ,sp_case_id_ddb INTEGER [2022-07-11T16:31:49.879Z] 5: ,sp_case VARCHAR(50) [2022-07-11T16:31:49.879Z] 6: ,age_type int [2022-07-11T16:31:49.879Z] 7: ); [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_mart/m_mds_c_ca_npp.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] 1: CREATE TABLE IF NOT EXISTS c_m.ma_ca_cat_npp [2022-07-11T16:31:49.879Z] ^ [2022-07-11T16:31:49.879Z] 2: ( [2022-07-11T16:31:49.879Z] 3: xxx_car_cat_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:49.879Z] 4: xxx_car_id integer NOT NULL, [2022-07-11T16:31:49.879Z] 5: xxx integer, [2022-07-11T16:31:49.879Z] 6: xxx_car_name varchar(100) [2022-07-11T16:31:49.879Z] 7: ); [2022-07-11T16:31:49.879Z] 8: [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/xxx/poc.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] 1: create table if not exists poc.xxy [2022-07-11T16:31:49.879Z] ^ [2022-07-11T16:31:49.879Z] 2: ( [2022-07-11T16:31:49.879Z] 3: licensekey integer NOT NULL, [2022-07-11T16:31:49.879Z] 4: chartnumber varchar(20), [2022-07-11T16:31:49.879Z] 5: visit integer, [2022-07-11T16:31:49.879Z] 6: facilityalias varchar(50), [2022-07-11T16:31:49.879Z] 7: clinician_name varchar(100), [2022-07-11T16:31:49.879Z] 8: npinumber int, [2022-07-11T16:31:49.879Z] 9: primary_carrier_code varchar(15), [2022-07-11T16:31:49.879Z] 10: primary_carrier_name varchar(100), [2022-07-11T16:31:49.879Z] 11: secondary_carrier_code varchar(15), [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/xxy/xxpocxx.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:49.879Z] 1: create table if not exists poc.poc_table [2022-07-11T16:31:49.879Z] ^ [2022-07-11T16:31:49.879Z] 2: ( [2022-07-11T16:31:49.879Z] 3: lkey integer NOT NULL, [2022-07-11T16:31:49.879Z] 4: pdetail_uid integer, [2022-07-11T16:31:49.879Z] 5: cdetail_uid integer, [2022-07-11T16:31:49.879Z] 6: vid integer, [2022-07-11T16:31:49.879Z] 7: pddate timestamp, [2022-07-11T16:31:49.879Z] 8: pamount float, [2022-07-11T16:31:49.879Z] 9: rcode varchar(20), [2022-07-11T16:31:49.879Z] 10: ccode varchar(20), [2022-07-11T16:31:49.879Z] 11: pdcatcode varchar(20), [2022-07-11T16:31:49.879Z] [2022-07-11T16:31:50.431Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_fac.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:50.431Z] [2022-07-11T16:31:50.431Z] 1: CREATE TABLE IF NOT EXISTS c_m.d_fac [2022-07-11T16:31:50.431Z] ^ [2022-07-11T16:31:50.431Z] 2: ( [2022-07-11T16:31:50.431Z] 3: fac_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:50.431Z] 4: is_cur boolean NOT NULL, [2022-07-11T16:31:50.431Z] 5: s_date timestamp NOT NULL, [2022-07-11T16:31:50.431Z] 6: e_date timestamp, [2022-07-11T16:31:50.431Z] 7: l_key integer NOT NULL, [2022-07-11T16:31:50.431Z] 8: f_id integer NOT NULL, [2022-07-11T16:31:50.431Z] 9: f_code varchar(10), [2022-07-11T16:31:50.431Z] 10: f_name varchar(200), [2022-07-11T16:31:50.431Z] 11: f_alias varchar(200), [2022-07-11T16:31:50.431Z] [2022-07-11T16:31:50.431Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_sc_ror/x_res_pt.sql' : Parse error at line 1 column 58: [2022-07-11T16:31:50.431Z] [2022-07-11T16:31:50.431Z] 1: DROP VIEW IF EXISTS d_src_ror.xx_res_pt CASCADE; [2022-07-11T16:31:50.431Z] ^ [2022-07-11T16:31:50.431Z] 2: [2022-07-11T16:31:50.431Z] [2022-07-11T16:31:50.431Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_src_ror/v_pat.sql' : Parse error at line 1 column 48: [2022-07-11T16:31:50.431Z] [2022-07-11T16:31:50.431Z] 1: DROP VIEW IF EXISTS d_src_ror.xx_pat CASCADE; [2022-07-11T16:31:50.431Z] ^ [2022-07-11T16:31:50.431Z] 2: [2022-07-11T16:31:50.431Z] 3: CREATE VIEW d_src_ror.x_patient [2022-07-11T16:31:50.431Z] 4: ( [2022-07-11T16:31:50.431Z] 5: p_key, [2022-07-11T16:31:50.431Z] 6: obi, [2022-07-11T16:31:50.431Z] 7: r_srce_key, [2022-07-11T16:31:50.431Z] 8: a_hld_key, [2022-07-11T16:31:50.431Z] 9: s_c_key, [2022-07-11T16:31:50.431Z] 10: i_st_key, [2022-07-11T16:31:50.431Z] 11: i_act, [2022-07-11T16:31:50.431Z] [2022-07-11T16:31:51.342Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/ref_prov_cb/pg_tbl/ref_pro.sql' : Parse error at line 3 column 14: [2022-07-11T16:31:51.342Z] [2022-07-11T16:31:51.342Z] 1: [2022-07-11T16:31:51.342Z] 2: [2022-07-11T16:31:51.342Z] 3: CREATE TABLE IF NOT EXISTS pub.re_pr [2022-07-11T16:31:51.342Z] ^ [2022-07-11T16:31:51.342Z] 4: ( [2022-07-11T16:31:51.342Z] 5: ref_pro_key bigint, [2022-07-11T16:31:51.342Z] 6: key int , [2022-07-11T16:31:51.342Z] 7: refe_pro_id int , [2022-07-11T16:31:51.342Z] 8: pr_code char(6) , [2022-07-11T16:31:51.342Z] 9: l_name varchar(35), [2022-07-11T16:31:51.342Z] 10: f_name varchar(35) , [2022-07-11T16:31:51.342Z] 11: m_name varchar(35) , [2022-07-11T16:31:51.342Z] 12: fname varchar(107) , [2022-07-11T16:31:51.342Z] 13: title varchar(10) , [2022-07-11T16:31:51.342Z] [2022-07-11T16:31:51.893Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_t_of_c_app_ma.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:51.893Z] 1: CREATE TABLE IF NOT EXISTS c.d_map [2022-07-11T16:31:51.893Z] ^ [2022-07-11T16:31:51.893Z] 2: (l_key INTEGER [2022-07-11T16:31:51.893Z] 3: ,c_id INTEGER [2022-07-11T16:31:51.893Z] 4: ,f_id INTEGER [2022-07-11T16:31:51.893Z] 5: ,app_uid INTEGER [2022-07-11T16:31:51.893Z] 6: ,app_type VARCHAR(300) [2022-07-11T16:31:51.893Z] 7: ,vir_or_v_v BOOLEAN [2022-07-11T16:31:51.893Z] 8: ,in_per_v BOOLEAN [2022-07-11T16:31:51.893Z] 9: ,t_of_c VARCHAR(300) [2022-07-11T16:31:51.893Z] 10: ,age_grp VARCHAR(300) [2022-07-11T16:31:51.893Z] 11: ,obi integer [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:51.893Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_sc_ror/t_of_c_ap_ma.sql' : Parse error at line 1 column 73: [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:51.893Z] 1: DROP VIEW IF EXISTS d_src_ror.v_t_c_ap_map CASCADE; [2022-07-11T16:31:51.893Z] ^ [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:51.893Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/c_a_c/pg_tbl/c_av.sql' : Parse error at line 1 column 22: [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:51.893Z] 1: DROP TABLE IF EXISTS public.c_availability [2022-07-11T16:31:51.893Z] ^ [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:51.893Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/public/p_i_s_i_c_tbl.sql' : Parse error at line 1 column 10: [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:51.893Z] 1: TRUNCATE ixxx_cxxx_tbl; [2022-07-11T16:31:51.893Z] ^ [2022-07-11T16:31:51.893Z] [2022-07-11T16:31:53.236Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/public/u_i_s_i_c_tbl.sql' : Parse error at line 1 column 10: [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] 1: TRUNCATE ixxx_cxxx_tbl; [2022-07-11T16:31:53.237Z] ^ [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_m/d_a_brg.sql' : Parse error at line 7 column 24: [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] 1: CREATE TABLE p_mt.d_ap_ap_brg [2022-07-11T16:31:53.237Z] 2: ( [2022-07-11T16:31:53.237Z] 3: a_type_key BIGINT IDENTITY(1,1) NOT NULL [2022-07-11T16:31:53.237Z] 4: ,a_id_amd BIGINT [2022-07-11T16:31:53.237Z] 5: ,a_type_id_amd BIGINT [2022-07-11T16:31:53.237Z] 6: ,is_current BOOLEAN NOT NULL [2022-07-11T16:31:53.237Z] 7: ,s_date TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:53.237Z] ^ [2022-07-11T16:31:53.237Z] 8: ,e_date TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:53.237Z] 9: ,l_key BIGINT [2022-07-11T16:31:53.237Z] 10: ,c_timestamp TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:53.237Z] 11: ,ch_timestamp TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:53.237Z] 12: ,hkey varchar(256) [2022-07-11T16:31:53.237Z] 13: ,PRIMARY KEY (appointment_type_key) [2022-07-11T16:31:53.237Z] 14: ) [2022-07-11T16:31:53.237Z] 15: [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/sg/sup_id_mails.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] 1: CREATE TABLE IF NOT EXISTS sg.sup_iv_mails [2022-07-11T16:31:53.237Z] ^ [2022-07-11T16:31:53.237Z] 2: ( [2022-07-11T16:31:53.237Z] 3: s_ivld_eml_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:53.237Z] 4: c_at timestamp NOT NULL, [2022-07-11T16:31:53.237Z] 5: mail varchar(150), [2022-07-11T16:31:53.237Z] 6: rsn varchar(500) [2022-07-11T16:31:53.237Z] 7: ); [2022-07-11T16:31:53.237Z] 8: [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/public/q_i_sc_in_ctr_tbl.sql' : Parse error at line 1 column 10: [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] 1: TRUNCATE ixxxx_ctr_tbl; [2022-07-11T16:31:53.237Z] ^ [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_mt/d_ac_hld.sql' : Parse error at line 6 column 25: [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.237Z] 1: create TABLE p_m.d_ac_h [2022-07-11T16:31:53.237Z] 2: ( [2022-07-11T16:31:53.237Z] 3: ac_h_key BIGINT IDENTITY(1,1) NOT NULL [2022-07-11T16:31:53.237Z] 4: ,obi INTEGER [2022-07-11T16:31:53.237Z] 5: ,ac_hol_id_obie BIGINT [2022-07-11T16:31:53.237Z] 6: ,s_date TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:53.237Z] ^ [2022-07-11T16:31:53.237Z] 7: ,e_date TIMESTAMP WITHOUT TIME ZONE [2022-07-11T16:31:53.237Z] 8: ,f_name VARCHAR(300) [2022-07-11T16:31:53.237Z] 9: ,l_name VARCHAR(300) [2022-07-11T16:31:53.237Z] 10: ,email VARCHAR(100) [2022-07-11T16:31:53.237Z] 11: ,dob VARCHAR(100) [2022-07-11T16:31:53.237Z] 12: ,gender VARCHAR(50) [2022-07-11T16:31:53.237Z] 13: ,phone VARCHAR(100) [2022-07-11T16:31:53.237Z] 14: ,r_p_key BIGINT [2022-07-11T16:31:53.237Z] 15: ,ref_src_key INTEGER [2022-07-11T16:31:53.237Z] 16: ,ld_date TIMESTAMP WITHOUT TIME ZONE DEFAULT getdate() [2022-07-11T16:31:53.237Z] [2022-07-11T16:31:53.788Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_c_fac_b.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:53.788Z] [2022-07-11T16:31:53.788Z] 1: CREATE TABLE IF NOT EXISTS c_m.d_c_f_b [2022-07-11T16:31:53.788Z] ^ [2022-07-11T16:31:53.788Z] 2: ( [2022-07-11T16:31:53.788Z] 3: c_f_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:53.788Z] 4: key integer NOT NULL, [2022-07-11T16:31:53.788Z] 5: c_id integer NOT NULL, [2022-07-11T16:31:53.788Z] 6: f_id integer NOT NULL, [2022-07-11T16:31:53.788Z] 7: is_active boolean, [2022-07-11T16:31:53.788Z] 8: p_id INTEGER NOT NULL, [2022-07-11T16:31:53.788Z] 9: is_default boolean, [2022-07-11T16:31:53.788Z] 10: obi integer [2022-07-11T16:31:53.788Z] 11: ); [2022-07-11T16:31:53.788Z] [2022-07-11T16:31:53.788Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/sg/su_b.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:53.788Z] [2022-07-11T16:31:53.788Z] 1: CREATE TABLE IF NOT EXISTS sg.sup_blks [2022-07-11T16:31:53.788Z] ^ [2022-07-11T16:31:53.788Z] 2: ( [2022-07-11T16:31:53.788Z] 3: sup_blk_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:53.788Z] 4: c_at timestamp NOT NULL, [2022-07-11T16:31:53.788Z] 5: email varchar(150), [2022-07-11T16:31:53.788Z] 6: rsn varchar(500), [2022-07-11T16:31:53.788Z] 7: stats varchar(500) [2022-07-11T16:31:53.788Z] 8: ); [2022-07-11T16:31:53.788Z] 9: [2022-07-11T16:31:53.788Z] [2022-07-11T16:31:53.788Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_ap_type.sql' : Parse error at line 1 column 15: [2022-07-11T16:31:53.788Z] [2022-07-11T16:31:53.788Z] 1: CREATE TABLE IF NOT EXISTS c_m.d_ap_type [2022-07-11T16:31:53.788Z] ^ [2022-07-11T16:31:53.788Z] 2: ( [2022-07-11T16:31:53.788Z] 3: ap_type_key BIGINT NOT NULL DEFAULT "identity"(305925, 0, ('1,1'::character varying)::text) [2022-07-11T16:31:53.788Z] 4: ,obi INTEGER [2022-07-11T16:31:53.788Z] 5: ,ap_type_id INTEGER NOT NULL [2022-07-11T16:31:53.788Z] 6: ,key INTEGER NOT NULL [2022-07-11T16:31:53.788Z] 7: ,app_name VARCHAR(100) [2022-07-11T16:31:53.788Z] 8: ,is_active BOOLEAN [2022-07-11T16:31:53.788Z] 9: ,is_bill BOOLEAN [2022-07-11T16:31:53.788Z] 10: ,t_of_care VARCHAR(300) [2022-07-11T16:31:53.788Z] 11: ,l_date TIMESTAMP DEFAULT GETDATE() [2022-07-11T16:31:53.788Z] [2022-07-11T16:31:54.339Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/d_src_ror/v_ed.sql' : Parse error at line 1 column 50: [2022-07-11T16:31:54.339Z] [2022-07-11T16:31:54.339Z] 1: DROP VIEW IF EXISTS d_src_ror.v_edu CASCADE; [2022-07-11T16:31:54.339Z] ^ [2022-07-11T16:31:54.339Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/sg/e_act.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:54.339Z] [2022-07-11T16:31:54.339Z] 1: CREATE TABLE IF NOT EXISTS sg.e_activity [2022-07-11T16:31:54.339Z] ^ [2022-07-11T16:31:54.339Z] 2: ( [2022-07-11T16:31:54.339Z] 3: e_activity_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:54.339Z] 4: f_email varchar(150), [2022-07-11T16:31:54.339Z] 5: msg_id varchar(200), [2022-07-11T16:31:54.339Z] 6: sub varchar(200), [2022-07-11T16:31:54.339Z] 7: to_email varchar(200), [2022-07-11T16:31:54.339Z] 8: stats varchar(200), [2022-07-11T16:31:54.339Z] 9: o_count int, [2022-07-11T16:31:54.339Z] 10: c_count int, [2022-07-11T16:31:54.339Z] 11: l_e_time timestamp NOT NULL [2022-07-11T16:31:54.339Z] [2022-07-11T16:31:56.822Z] INFO: 93/96 files, last analyzed (679 ms): r_queries/s_queries/u_ld_obj_suc_rpt_c.sql [2022-07-11T16:31:56.822Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/p_m/d_res_p.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:56.822Z] [2022-07-11T16:31:56.822Z] 1: CREATE TABLE IF NOT EXISTS p_m.d_res_p [2022-07-11T16:31:56.822Z] ^ [2022-07-11T16:31:56.822Z] 2: ( [2022-07-11T16:31:56.822Z] 3: res_p_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:56.822Z] 4: key integer NOT NULL, [2022-07-11T16:31:56.822Z] 5: res_p_id_obie integer, [2022-07-11T16:31:56.822Z] 6: res_p_id_amd integer, [2022-07-11T16:31:56.822Z] 7: obi integer, [2022-07-11T16:31:56.822Z] 8: is_cur boolean, [2022-07-11T16:31:56.822Z] 9: gender varchar(20), [2022-07-11T16:31:56.822Z] 10: f_name varchar(50), [2022-07-11T16:31:56.822Z] 11: m_name varchar(50), [2022-07-11T16:31:56.822Z] [2022-07-11T16:31:56.822Z] WARN: Unable to parse file '/softwares/jenkins/workspace/POC-Data-Sonar/my_redshift_scripts/c_m/d_c_h.sql' : Parse error at line 1 column 14: [2022-07-11T16:31:56.822Z] [2022-07-11T16:31:56.822Z] 1: CREATE TABLE IF NOT EXISTS c_m.d_c_hld [2022-07-11T16:31:56.822Z] ^ [2022-07-11T16:31:56.822Z] 2: ( [2022-07-11T16:31:56.822Z] 3: c_hold_key bigint DEFAULT "identity"(1259707, 0, ('1,1'::character varying)::text) NOT NULL, [2022-07-11T16:31:56.822Z] 4: key integer NOT NULL, [2022-07-11T16:31:56.822Z] 5: rs_key integer NOT NULL, [2022-07-11T16:31:56.822Z] 6: c_key integer NOT NULL, [2022-07-11T16:31:56.822Z] 7: f_key integer NOT NULL, [2022-07-11T16:31:56.822Z] 8: obi integer, [2022-07-11T16:31:56.822Z] 9: is_act boolean, [2022-07-11T16:31:56.822Z] 10: c_time timestamp, [2022-07-11T16:31:56.822Z] 11: ch_time timestamp, [2022-07-11T16:31:56.822Z] [2022-07-11T16:31:56.822Z] INFO: 96/96 files, last analyzed (1 ms): my_redshift_scripts/c_m/d_c_hld.sql [2022-07-11T16:31:56.822Z] INFO: Sensor T-SQL Sensor [tsql] (done) | time=10604ms [2022-07-11T16:31:56.822Z] INFO: Sensor CSS Rules [javascript] [2022-07-11T16:31:56.822Z] INFO: No CSS, PHP, HTML or VueJS files are found in the project. CSS analysis is skipped. [2022-07-11T16:31:56.822Z] INFO: Sensor CSS Rules [javascript] (done) | time=1ms [2022-07-11T16:31:56.822Z] INFO: Sensor ThymeLeaf template sensor [securityjavafrontend] [2022-07-11T16:31:56.822Z] INFO: Sensor ThymeLeaf template sensor [securityjavafrontend] (done) | time=1ms [2022-07-11T16:31:56.822Z] INFO: Sensor Python HTML templates processing [securitypythonfrontend] [2022-07-11T16:31:56.822Z] INFO: Sensor Python HTML templates processing [securitypythonfrontend] (done) | time=17ms [2022-07-11T16:31:56.822Z] INFO: Sensor Serverless configuration file sensor [security] [2022-07-11T16:31:56.822Z] INFO: 0 Serverless function entries were found in the project [2022-07-11T16:31:56.822Z] INFO: 0 Serverless function handlers were kept as entrypoints [2022-07-11T16:31:56.822Z] INFO: Sensor Serverless configuration file sensor [security] (done) | time=4ms [2022-07-11T16:31:56.822Z] INFO: Sensor AWS SAM template file sensor [security] [2022-07-11T16:31:56.822Z] INFO: Sensor AWS SAM template file sensor [security] (done) | time=1ms [2022-07-11T16:31:56.822Z] INFO: Sensor javabugs [dbd] [2022-07-11T16:31:56.822Z] INFO: Reading IR files from: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork/ir/java [2022-07-11T16:31:56.822Z] INFO: No IR files have been included for analysis. [2022-07-11T16:31:56.822Z] INFO: Sensor javabugs [dbd] (done) | time=0ms [2022-07-11T16:31:56.822Z] INFO: Sensor JavaSecuritySensor [security] [2022-07-11T16:31:56.822Z] INFO: Reading type hierarchy from: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork/ucfg2/java [2022-07-11T16:31:56.822Z] INFO: Read 0 type definitions [2022-07-11T16:31:56.822Z] INFO: Reading UCFGs from: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork/ucfg2/java [2022-07-11T16:31:56.822Z] INFO: No UCFGs have been included for analysis. [2022-07-11T16:31:56.822Z] INFO: Sensor JavaSecuritySensor [security] (done) | time=4ms [2022-07-11T16:31:56.822Z] INFO: Sensor CSharpSecuritySensor [security] [2022-07-11T16:31:56.822Z] INFO: Reading type hierarchy from: /softwares/jenkins/workspace/POC-Data-Sonar/ucfg_cs2 [2022-07-11T16:31:56.822Z] INFO: Read 0 type definitions [2022-07-11T16:31:56.822Z] INFO: Reading UCFGs from: /softwares/jenkins/workspace/POC-Data-Sonar/ucfg_cs2 [2022-07-11T16:31:56.822Z] INFO: No UCFGs have been included for analysis. [2022-07-11T16:31:56.822Z] INFO: Sensor CSharpSecuritySensor [security] (done) | time=0ms [2022-07-11T16:31:56.822Z] INFO: Sensor PhpSecuritySensor [security] [2022-07-11T16:31:56.822Z] INFO: Reading type hierarchy from: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork/ucfg2/php [2022-07-11T16:31:56.823Z] INFO: Read 0 type definitions [2022-07-11T16:31:56.823Z] INFO: Reading UCFGs from: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork/ucfg2/php [2022-07-11T16:31:56.823Z] INFO: No UCFGs have been included for analysis. [2022-07-11T16:31:56.823Z] INFO: Sensor PhpSecuritySensor [security] (done) | time=1ms [2022-07-11T16:31:56.823Z] INFO: Sensor PythonSecuritySensor [security] [2022-07-11T16:31:56.823Z] INFO: Reading type hierarchy from: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork/ucfg2/python [2022-07-11T16:31:56.823Z] INFO: Read 382 type definitions [2022-07-11T16:31:56.823Z] INFO: Reading UCFGs from: /softwares/jenkins/workspace/POC-Data-Sonar/.scannerwork/ucfg2/python [2022-07-11T16:31:57.389Z] INFO: 16:31:57.20153 Building Runtime Type propagation graph [2022-07-11T16:31:57.389Z] INFO: 16:31:57.306543 Running Tarjan on 10392 nodes [2022-07-11T16:31:57.389Z] INFO: 16:31:57.333929 Tarjan found 10298 components [2022-07-11T16:31:57.639Z] INFO: 16:31:57.396987 Variable type analysis: done [2022-07-11T16:31:57.639Z] INFO: 16:31:57.40134 Building Runtime Type propagation graph [2022-07-11T16:31:57.639Z] INFO: 16:31:57.459384 Running Tarjan on 10267 nodes [2022-07-11T16:31:57.639Z] INFO: 16:31:57.474248 Tarjan found 10173 components [2022-07-11T16:31:57.639Z] INFO: 16:31:57.506768 Variable type analysis: done [2022-07-11T16:31:57.639Z] INFO: Analyzing 1994 ucfgs to detect vulnerabilities. [2022-07-11T16:31:58.566Z] INFO: All rules entrypoints : 0 [2022-07-11T16:31:58.566Z] INFO: Retained UCFGs : 0 [2022-07-11T16:31:58.566Z] INFO: Taint analysis starting. Entrypoints: 0 [2022-07-11T16:31:58.566Z] INFO: Taint analysis: done. [2022-07-11T16:31:58.566Z] INFO: Sensor PythonSecuritySensor [security] (done) | time=1622ms [2022-07-11T16:31:58.566Z] INFO: Sensor JsSecuritySensor [security] [2022-07-11T16:31:58.566Z] INFO: No UCFGs have been included for analysis. [2022-07-11T16:31:58.566Z] INFO: Sensor JsSecuritySensor [security] (done) | time=0ms [2022-07-11T16:31:58.566Z] INFO: ------------- Run sensors on project [2022-07-11T16:31:58.566Z] INFO: Sensor Analysis Warnings import [csharp] [2022-07-11T16:31:58.566Z] INFO: Sensor Analysis Warnings import [csharp] (done) | time=1ms [2022-07-11T16:31:58.566Z] INFO: Sensor Zero Coverage Sensor [2022-07-11T16:31:58.566Z] INFO: Sensor Zero Coverage Sensor (done) | time=48ms [2022-07-11T16:31:58.566Z] INFO: SCM Publisher SCM provider for this project is: git [2022-07-11T16:31:58.566Z] INFO: SCM Publisher 71 source files to be analyzed [2022-07-11T16:31:59.497Z] INFO: SCM Publisher 71/71 source files have been analyzed (done) | time=912ms [2022-07-11T16:31:59.497Z] INFO: CPD Executor 6 files had no CPD blocks [2022-07-11T16:31:59.497Z] INFO: CPD Executor Calculating CPD for 84 files [2022-07-11T16:31:59.754Z] INFO: CPD Executor CPD calculation finished (done) | time=206ms [2022-07-11T16:32:00.006Z] INFO: Load New Code definition [2022-07-11T16:32:00.006Z] INFO: Load New Code definition (done) | time=17ms [2022-07-11T16:32:00.006Z] INFO: Analysis report generated in 189ms, dir size=3.2 MB [2022-07-11T16:32:00.256Z] INFO: Analysis report compressed in 364ms, zip size=922.3 kB [2022-07-11T16:32:00.256Z] INFO: Analysis report uploaded in 73ms [2022-07-11T16:32:00.507Z] INFO: ANALYSIS SUCCESSFUL, you can find the results at: http://cross-sonar-1.myprojects.com:9010/dashboard?id=POC-DATA&branch=main [2022-07-11T16:32:00.507Z] INFO: Note that you will be able to access the updated dashboard once the server has processed the submitted analysis report [2022-07-11T16:32:00.507Z] INFO: More about the report processing at http://cross-sonar-1.myprojects.com:9010/api/ce/task?id=AYHuGnTcKUzDLUS_Gfpj [2022-07-11T16:32:00.507Z] INFO: Analysis total time: 30.087 s [2022-07-11T16:32:00.507Z] INFO: ------------------------------------------------------------------------ [2022-07-11T16:32:00.507Z] INFO: EXECUTION SUCCESS [2022-07-11T16:32:00.507Z] INFO: ------------------------------------------------------------------------ [2022-07-11T16:32:00.507Z] INFO: Total time: 31.973s [2022-07-11T16:32:00.507Z] INFO: Final Memory: 45M/157M [2022-07-11T16:32:00.507Z] INFO: ------------------------------------------------------------------------ [2022-07-11T16:32:01.064Z] [Pipeline] } [2022-07-11T16:32:01.083Z] [Pipeline] // withSonarQubeEnv [2022-07-11T16:32:01.089Z] [Pipeline] } [2022-07-11T16:32:01.099Z] [Pipeline] // withEnv [2022-07-11T16:32:01.105Z] [Pipeline] } [2022-07-11T16:32:01.114Z] [Pipeline] // stage [2022-07-11T16:32:01.120Z] [Pipeline] } [2022-07-11T16:32:01.128Z] [Pipeline] // withEnv [2022-07-11T16:32:01.134Z] [Pipeline] } [2022-07-11T16:32:01.142Z] [Pipeline] // node [2022-07-11T16:32:01.147Z] [Pipeline] End of Pipeline [2022-07-11T16:32:01.165Z] Finished: SUCCESS