Skip to main content

PG&E PSPS Event: File Import and Reporting - Services & Configurations Overview

Srikanth Chinnammagari
Organization
Convey Logo

PG&E PSPS Event: File Import and Reporting - Services & Configurations Overview

This document outlines the PM2 service details, server locations, and corresponding environment (.env) variables required for managing the PGE PSPS manual file imports, completion files, and inflight files.

1. Manual Files Import

Service Details

  • Server: 10.10.6.23
  • Service Name: prod_pge3_node_cf_api_3020_1
  • Version: 1.0.0
  • Interpreter: node (Node.js version 10.24.1)
  • Execution Mode: fork_mode
  • Script Path: /opt/pge3/pge_node/services/api/api.js
  • Execution CWD: /opt/pge3/pge_node/services/api
  • Error Log Path: /home/appuser/.pm2/logs/prod-pge3-node-cf-api-3020-1-error.log
  • Out Log Path: /home/appuser/.pm2/logs/prod-pge3-node-cf-api-3020-1-out.log

Environment Variables

.env File Path: /opt/pge3/pge_node/.env 

#FTP MB INTERNAL -- MANUAL IMPORT
SFTP_HOST=transfer.mbdt01.com
SFTP_USER=testuser
SFTP PASS ENTER CORRECT PASSWORD
SFTP_FROM_DIR=./sftpData/pge3prod/

#FTP PGE LIVE PROD
MANUAL IMPORT
SFTP_HOST=sftext.cloud.pge.com
SFTP_USER=ahasan_messagebroadcast
SFTP_PASS ENTER CORRECT PASSWORD
SFTP_FROM_DIR=./MessageBroadcast/

# MB settings AUTO
#SFTP_POSTAUTO_HOST=10.10.3.81
#SFTP_POSTAUTO_USER=testuser
#SFTP_POSTAUTO_PASS ENTER CORRECT PASSWORD
#SFTP_POSTAUTO_FROM_DIR_24x7=./sftpData/pge3Import/PGE_24Hours
#SFTP_POSTAUTO_FROM_DIR_8x9=./sftpData/pge3Import/PGE_Daytime
#SFTP_POSTAUTO_FROM_DIR_24x7=./sftpData/pge3prod/PostAuto/PGE_24Hours
#SFTP_POSTAUTO_FROM_DIR_8x9=./sftpData/pge3prod/PostAuto/PGE_Daytime

# PROD settings AUTO
SFTP_POSTAUTO_HOST=transfer.mbdt01.com
SFTP_POSTAUTO_USER=10615_61401
SFTP_POSTAUTO_PASS ENTER CORRECT PASSWORD
SFTP_POSTAUTO_FROM_DIR_24x7=./sftpData/toMB/PGE_24Hours
SFTP_POSTAUTO_FROM_DIR_8x9=./sftpData/toMB/PGE_Daytime

2. Completion Reporting

Service Details

  • Server: 10.10.6.24
  • Service Name: prod_pge3_sftp_loop
  • Version: 1.0.0
  • Interpreter: bash
  • Execution Mode: fork_mode
  • Script Path: /opt/pge3/pge_node/services/prod_pge3_sftp_loop.sh
  • Execution CWD: /opt/pge3/pge_node/services
  • Error Log Path: /home/appuser/.pm2/logs/prod-pge3-sftp-loop-error.log
  • Out Log Path: /home/appuser/.pm2/logs/prod-pge3-sftp-loop-out.log

Environment Variables

.env File Path: /opt/pge3/pge_node/services/completion/.env 

DB_USER=91pgappsvc
DB_PASSWORD="ENTER CORRECT PASSWORD"
DB_PREFIX=pge3
DB_HOST=10.10.4.18
DB_HOST_READONLY $=10.10.4.18$
FTP_USE_SSH=TRUE
FTP_LOCAL_FOLDER=/tmp/

# FTP PGE PROD LIVE
FTP_HOST=transfer.mbdt01.com
FTP_USER=10615_61401
FTP_PASSWORD ENTER CORRECT PASSWORD
FTP_REMOTE_FOLDER=./sftpData/fromMB/completion/
FTP_REMOTE_FOLDER_PLA=./sftpData/fromMB/inflight/

# FTP MB INTERNAL
#FTP_HOST=transfer.mbdt01.com
#FTP_USER=testuser
#FTP_PASSWORD ENTER CORRECT PASSWORD
#FTP_REMOTE_FOLDER=./sftpData/pge3prod/MB_Files/Completion-Parked-Temporary-2025MAR05/
#FTP_REMOTE_FOLDER_PLA=./sftpData/pge3prod/MB_Files/Inflight

3. Inflight Reporting

Service Details

  • Server: 10.10.6.24
  • Service Name: prod_pge3_go_inflight_transfer
  • Version: 1.0.0
  • Interpreter: bash
  • Execution Mode: fork_mode
  • Script Path: /opt/pge3/pge_node/services/inflight/go_pge3_inflight_transfer.sh
  • Execution CWD: /opt/pge3/pge_node/services/inflight
  • Error Log Path: /home/appuser/.pm2/logs/prod-pge3-go-inflight-transfer-error.log
  • Out Log Path: /home/appuser/.pm2/logs/prod-pge3-go-inflight-transfer-out.log

Environment Variables

.env File Path: /opt/pge3/pge_node/services/inflight/.env 

DB_USER=91pgappsvc
DB_PASSWORD ENTER CORRECT PASSWORD
DB_PREFIX=pge3
DB_HOST=10.10.4.18
DB_HOST_READONLY 10.10.4.19
FTP_USE_SSH=TRUE
FTP_LOCAL_FOLDER=/tmp/

# FTP PGE LIVE PROD
FTP_HOST=transfer.mbdt01.com
FTP_USER=10615_61401
FTP_PASSWORD ENTER CORRECT PASSWORD
FTP_REMOTE_FOLDER=./sftpData/fromMB/inflight/

# FTP INTERNAL
#FTP_HOST=transfer.mbdt01.com
#FTP USER=testuser
#FTP PASSWORD ENTER CORRECT PASSWORD
#FTP_REMOTE_FOLDER=./sftpData/pge3prod/MB_Files/Inflight-Parked-Temporary-2025MAR05/Inflight-Parked-Temporary-PSPS_01202025/Inflight-Parked-Temporary-PSPS_01132025/

4. PM2 PGE3 Service Inventory

Below is the complete list of all prod_pge3_* related PM2 services currently running on the server 10.10.6.23/24:

  • prod_pge3_archive-waterfall
  • prod_pge3_dialResultsExtractor_194439
  • prod_pge3_dialResultsExtractor_195905
  • prod_pge3_dialResultsExtractor_196200
  • prod_pge3_dialResultsExtractor_197479
  • prod_pge3_dialResults Extractor_consumer_1
  • prod_pge3_emailConsumer_1
  • prod_pge3_emailConsumer_2
  • prod_pge3_emailEventConsumer_1
  • prod_pge3_emailPublisher__1
  • prod_pge3_errorConsumer_1
  • prod_pge3_go_inflight_blank15min
  • prod_pge3_go_inflight_transfer
  • prod_pge3_go_loop.sh
  • prod_pge3_go_smsSinchDrConsumer_2
  • prod_pge3_go_smsSinchMoConsumer_2
  • prod_pge3_node_cf_api_3020_1
  • prod_pge3_premise_portal_api_3021
  • prod_pge3_premisesOptout_consumer
  • prod_pge3_premisesUnenroll_consumer
  • prod_pge3_premises_go_24_even
  • prod_pge3_server_public_email_templates_3016
  • prod_pge3_sftp_loop
  • prod_pge3_smsConsumer_1
  • prod_pge3_smsConsumer_2
  • prod_pge3_smsConsumer_3
  • prod_pge3_smsConsumer_4
  • prod_pge3_smsPublisher_1
  • prod_pge3_successConsumer_1
  • prod_pge3_voiceConsumer_1
  • prod_pge3_voiceConsumer_2
  • prod_pge3_voiceConsumer_PLA_1
  • prod_pge3_voicePublisher_1

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk