2025-03-14T16:02:22.036064+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142035,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/service/gus/gus.connection.ts:22:16","msg":"GUS login succeeded. GUS User Id: 0059A000004SbztQAC"}
2025-03-14T16:02:22.036357+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142036,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.getDataFromSalesforce (src/scheduler/gus/gusTablesSyncAndLoad.ts:86:12)","msg":"Getting data from GUS for table goc__configuration_item__c"}
2025-03-14T16:02:22.041844+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142040,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/service/gus/gus.connection.ts:22:16","msg":"GUS login succeeded. GUS User Id: 0059A000004SbztQAC"}
2025-03-14T16:02:22.041846+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142041,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.getDataFromSalesforce (src/scheduler/gus/gusTablesSyncAndLoad.ts:86:12)","msg":"Getting data from GUS for table adm_scrum_team_member__c"}
2025-03-14T16:02:22.043120+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142042,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/service/gus/gus.connection.ts:22:16","msg":"GUS login succeeded. GUS User Id: 0059A000004SbztQAC"}
2025-03-14T16:02:22.043402+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142043,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.getDataFromSalesforce (src/scheduler/gus/gusTablesSyncAndLoad.ts:86:12)","msg":"Getting data from GUS for table user"}
2025-03-14T16:02:22.044753+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142044,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/service/gus/gus.connection.ts:22:16","msg":"GUS login succeeded. GUS User Id: 0059A000004SbztQAC"}
2025-03-14T16:02:22.045222+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142044,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.getDataFromSalesforce (src/scheduler/gus/gusTablesSyncAndLoad.ts:86:12)","msg":"Getting data from GUS for table goc__configuration_item_type__c"}
2025-03-14T16:02:22.047221+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142046,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/service/gus/gus.connection.ts:22:16","msg":"GUS login succeeded. GUS User Id: 0059A000004SbztQAC"}
2025-03-14T16:02:22.047412+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142047,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.getDataFromSalesforce (src/scheduler/gus/gusTablesSyncAndLoad.ts:86:12)","msg":"Getting data from GUS for table adm_scrum_team__c"}
2025-03-14T16:02:22.048638+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142048,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/service/gus/gus.connection.ts:22:16","msg":"GUS login succeeded. GUS User Id: 0059A000004SbztQAC"}
2025-03-14T16:02:22.048928+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142048,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.getDataFromSalesforce (src/scheduler/gus/gusTablesSyncAndLoad.ts:86:12)","msg":"Getting data from GUS for table feature__c"}
2025-03-14T16:02:22.136523+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142135,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/scheduler/gus/gusTablesSyncAndLoad.ts:111:18","msg":"Query completed"}
2025-03-14T16:02:22.138346+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142137,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"module.exports.<anonymous> (src/scheduler/gus/gusTablesSyncAndLoad.ts:103:18)","msg":"Fetched 20 records from GUS for table goc__configuration_item_type__c"}
2025-03-14T16:02:22.140901+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142140,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.writeJsonToCsv (src/scheduler/gus/gusTablesSyncAndLoad.ts:215:12)","msg":"File updated"}
2025-03-14T16:02:22.141291+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142140,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:128:14)","msg":"File /app/goc__configuration_item_type__c.csv exists and is readable"}
2025-03-14T16:02:22.141711+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142141,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeDuplicateHeaders (src/scheduler/gus/gusTablesSyncAndLoad.ts:248:12)","msg":"Removing duplicate headers from CSV file: /app/goc__configuration_item_type__c.csv"}
2025-03-14T16:02:22.146557+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142145,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeDuplicateHeaders (src/scheduler/gus/gusTablesSyncAndLoad.ts:281:12)","msg":"Duplicate headers removed for file: /app/goc__configuration_item_type__c.csv"}
2025-03-14T16:02:22.152347+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142151,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:145:12)","msg":"updateSet: name = excluded.name"}
2025-03-14T16:02:22.160337+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":50,"time":1741968142155,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"CopyStreamQuery.<anonymous> (src/scheduler/gus/gusTablesSyncAndLoad.ts:158:18)","msg":"File stream error for temp_goc__configuration_item_type__c: error: invalid input syntax for type timestamp: \"a7I9A0000004ELMUA2\""}
2025-03-14T16:02:22.160789+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":50,"time":1741968142160,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:177:14)","msg":"Error loading data to database: false"}
2025-03-14T16:02:22.161069+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142160,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:178:14)","msg":"Attempting to delete file and table"}
2025-03-14T16:02:22.161536+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142161,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeCsvAndDropTable (src/scheduler/gus/gusTablesSyncAndLoad.ts:188:12)","msg":"Dropping table temp_goc__configuration_item_type__c"}
2025-03-14T16:02:22.165076+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142164,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeCsvAndDropTable (src/scheduler/gus/gusTablesSyncAndLoad.ts:194:14)","msg":"Table temp_goc__configuration_item_type__c dropped"}
2025-03-14T16:02:22.181402+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142180,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/scheduler/gus/gusTablesSyncAndLoad.ts:111:18","msg":"Query completed"}
2025-03-14T16:02:22.186840+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142186,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"module.exports.<anonymous> (src/scheduler/gus/gusTablesSyncAndLoad.ts:103:18)","msg":"Fetched 836 records from GUS for table feature__c"}
2025-03-14T16:02:22.200876+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142200,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.writeJsonToCsv (src/scheduler/gus/gusTablesSyncAndLoad.ts:215:12)","msg":"File updated"}
2025-03-14T16:02:22.201438+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142201,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:128:14)","msg":"File /app/feature__c.csv exists and is readable"}
2025-03-14T16:02:22.201766+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142201,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeDuplicateHeaders (src/scheduler/gus/gusTablesSyncAndLoad.ts:248:12)","msg":"Removing duplicate headers from CSV file: /app/feature__c.csv"}
2025-03-14T16:02:22.205802+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142205,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeDuplicateHeaders (src/scheduler/gus/gusTablesSyncAndLoad.ts:281:12)","msg":"Duplicate headers removed for file: /app/feature__c.csv"}
2025-03-14T16:02:22.210026+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142209,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:145:12)","msg":"updateSet: name = excluded.name, team__c = excluded.team__c, service__c = excluded.service__c, product_tag__c = excluded.product_tag__c"}
2025-03-14T16:02:22.246667+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142246,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"CopyStreamQuery.<anonymous> (src/scheduler/gus/gusTablesSyncAndLoad.ts:166:20)","msg":"Table feature__c upserted"}
2025-03-14T16:02:22.246972+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142246,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeCsvAndDropTable (src/scheduler/gus/gusTablesSyncAndLoad.ts:188:12)","msg":"Dropping table temp_feature__c"}
2025-03-14T16:02:22.252701+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968142251,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeCsvAndDropTable (src/scheduler/gus/gusTablesSyncAndLoad.ts:194:14)","msg":"Table temp_feature__c dropped"}
2025-03-14T16:02:26.464833+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968146460,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"module.exports.<anonymous> (src/scheduler/gus/gusTablesSyncAndLoad.ts:103:18)","msg":"Fetched 41199 records from GUS for table adm_product_tag__c"}
2025-03-14T16:02:29.000291+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968148999,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"module.exports.<anonymous> (src/scheduler/gus/gusTablesSyncAndLoad.ts:103:18)","msg":"Fetched 45137 records from GUS for table goc__configuration_item__c"}
2025-03-14T16:02:30.159481+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150158,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.writeJsonToCsv (src/scheduler/gus/gusTablesSyncAndLoad.ts:215:12)","msg":"File updated"}
2025-03-14T16:02:30.160240+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150159,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:128:14)","msg":"File /app/user.csv exists and is readable"}
2025-03-14T16:02:30.160789+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150160,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeDuplicateHeaders (src/scheduler/gus/gusTablesSyncAndLoad.ts:248:12)","msg":"Removing duplicate headers from CSV file: /app/user.csv"}
2025-03-14T16:02:30.278412+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150277,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeDuplicateHeaders (src/scheduler/gus/gusTablesSyncAndLoad.ts:281:12)","msg":"Duplicate headers removed for file: /app/user.csv"}
2025-03-14T16:02:30.283089+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150282,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:145:12)","msg":"updateSet: username = excluded.username, name = excluded.name, managerid = excluded.managerid, isactive = excluded.isactive, slack_id__c = excluded.slack_id__c, email = excluded.email"}
2025-03-14T16:02:30.293700+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":50,"time":1741968150293,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"CopyStreamQuery.<anonymous> (src/scheduler/gus/gusTablesSyncAndLoad.ts:158:18)","msg":"File stream error for temp_user: error: invalid input syntax for type boolean: \"Craig Poynton\""}
2025-03-14T16:02:30.294027+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":50,"time":1741968150293,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:177:14)","msg":"Error loading data to database: false"}
2025-03-14T16:02:30.294269+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150293,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.loadToDatabase (src/scheduler/gus/gusTablesSyncAndLoad.ts:178:14)","msg":"Attempting to delete file and table"}
2025-03-14T16:02:30.294522+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150294,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeCsvAndDropTable (src/scheduler/gus/gusTablesSyncAndLoad.ts:188:12)","msg":"Dropping table temp_user"}
2025-03-14T16:02:30.305705+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150305,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"GusTablesSyncAndLoad.removeCsvAndDropTable (src/scheduler/gus/gusTablesSyncAndLoad.ts:194:14)","msg":"Table temp_user dropped"}
2025-03-14T16:02:30.305833+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150305,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"Function.gusTablesSyncAsync (src/scheduler/gus/gusTablesSyncAndLoad.ts:335:18)","msg":"Data import completed"}
2025-03-14T16:02:30.312534+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150311,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/scheduler/gus/gusTablesSyncAndLoadJob.ts:11:14","msg":"GUS Table Sync and Load job finished successfully"}
2025-03-14T16:02:30.312858+00:00 f25d4032-0498-4446-b7d8-6952ea770fb8 app[scheduler.4095] {"level":30,"time":1741968150312,"pid":29,"hostname":"dyno-3fbc0cd8-0e55-462d-a8d0-4193aa40608a","name":"icc-rest","caller":"src/scheduler/gus/gusTablesSyncAndLoadJob.ts:15:12","msg":"Process finished..."}