Paras Motors Live Cron Logs

Back
Login credentials injected. Engaging Siebel survival loop...
Pop-up cleared.
SUCCESS: Vehicles tab clicked!
Waiting 15 seconds for the Vehicles UI to settle...
Hunting for the top-right 'Saved Queries' dropdown...
Exact match found: '*All Vehicles'. Injecting selection...
SUCCESS: Filter applied! The server is extremely slow.
Waiting 45 FULL SECONDS to guarantee the red Siebel 'Busy' spinner disappears...

Hunting for the correct Gear Menu...
  -> Testing Menu button 1...
     SUCCESS: 'Export' option found! Clicking it...
Confirming Export settings and starting large download...
Safely archived yesterday's file to: Archive/master_20260926_080316.csv
FINAL SUCCESS: New master_11k.csv is saved securely!
Processing Master Database...
Scanning 11,000 rows for customers due on: 29/09/2026
Extraction Complete. Found 7 valid customers to message today.
Proceeding to Broadcast...
[2026-09-26 08:03:30] Starting Meta Broadcast...
Loaded 1 blacklisted numbers.
  [SUCCESS] Sent 'paras_paid_service' to MAHENDRABHAI  MANSINGBHAI (917359904155)
  [SUCCESS] Sent 'paras_paid_service' to LALSINGBHAI VARSINGBHAI (919510761995)
  [SUCCESS] Sent 'paras_free_3' to RAKESHBHAI MANGILAL (919638625142)
  [SUCCESS] Sent 'paras_free_3' to YOGESHBHAI (919512724643)
  [SUCCESS] Sent 'paras_free_2_v1' to ALKESHBHAI BABUBHAI (918849194368)
  [SUCCESS] Sent 'paras_free_2_v1' to RASIKBHAI (918469441757)
  [SUCCESS] Sent 'paras_paid_service' to RAHULKUMAR VIRSINGBHAI (919586758186)
=====================================
Broadcast Complete! Success: 7 | Skipped (Blacklist): 0 | Failed: 0
Checking for pending Joyride data...
Loading Master Database into memory for Joyride deduplication...
Loaded 1 blacklisted numbers.
Running Insurance Broadcast...
Scanning for Insurance expiring between 11/09/2026 and 01/10/2026...
Found 110 customers in the time window. Processing...
Loaded 1 blacklisted numbers.
✅ [AFTER_EXPIRY] Sent Alert to: KADKAKIYABHAI SAMABHAI GARASIYA (917803737680) | Expiry: 22 સપ્ટેમ્બર 2026
✅ [AFTER_EXPIRY] Sent Alert to: BHAVINKUMAR PATEL (919243360010) | Expiry: 25 સપ્ટેમ્બર 2026
✅ [AFTER_EXPIRY] Sent Alert to: PATEL DINESHCHANDR PAROSTAMBHAI (917580698480) | Expiry: 23 સપ્ટેમ્બર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: PARSINGBHAI AMALIYAR (919838283730) | Expiry: 01 ઓક્ટોબર 2026
✅ [AFTER_EXPIRY] Sent Alert to: ANILKUMAR BABUBHAI AGRAVAL (917242222110) | Expiry: 23 સપ્ટેમ્બર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: AMALIYAR HASMUKHBHAI KALJIBHAI (919804692920) | Expiry: 01 ઓક્ટોબર 2026
✅ [AFTER_EXPIRY] Sent Alert to: DINESHBHAI MANSUKHBHAI BHEDI (916380631610) | Expiry: 22 સપ્ટેમ્બર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: KHANT RANCHHODBHAI BHURABHAI (917275440870) | Expiry: 01 ઓક્ટોબર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: PATHAN MEMUDKHAN LATIFKHAN (918244876700) | Expiry: 29 સપ્ટેમ્બર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: MUKESHBHAI BARIA (919788774790) | Expiry: 01 ઓક્ટોબર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: ASHISHBHAI RAYMALBHAI PALAS (919097153000) | Expiry: 28 સપ્ટેમ્બર 2026
✅ [AFTER_EXPIRY] Sent Alert to: RAFIKKHA SIKANDAR BELIM (916682550240) | Expiry: 23 સપ્ટેમ્બર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: VIPULKUMAR AMARSINH RANA (919631912990) | Expiry: 01 ઓક્ટોબર 2026
✅ [AFTER_EXPIRY] Sent Alert to: MAHMAD NUMAN KHEDAPAWALA (916649617020) | Expiry: 22 સપ્ટેમ્બર 2026
=====================================
Insurance Broadcast Complete! Sent: 14 | Skipped (Already Sent): 30 | Skipped (Blacklist): 0 | Failed: 66
Running Lost Customer Broadcast (30 Days)...
Scanning for Lost Customers whose service was due exactly on: 27/08/2026...
Found 13 lost customers. Processing...
Loaded 1 blacklisted numbers.
✅ Sent Lost Customer Alert to: MAHESHBHAI PUNJABHAI DAMOR (919879725055) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: VIRSANG PUNABHAI MAKWANA (919687021435) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: GANPATBHAI KHARADI (916359335497) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: RUPCHANDBHAI PARGI` (916351667710) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: JAYANTIBHAI BHURIYA (918200564272) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: RAJESHBHAI PRATAPBHAI PARGI (919979002825) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: RAJESHBHAI VADI (917984693362) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: RASILABEN CHATURBHAI DINDOR (919512376163) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: SHARMA DIPAKKUMAR LATA (919529380727) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: KANTIBHAI RAVAL (919727439608) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: PANKAJKUMAR RAJAT (919726551503) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: MADARI SUNILNATH JANNATH (916352320373) | Missed Date: 27 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: PRAJAPATI LALCHANDBHAI KADVABHAI (919909872968) | Missed Date: 27 ઓગસ્ટ 2026
=====================================
Lost Customer Broadcast Complete! Sent: 13 | Skipped (Already Sent): 0 | Skipped (Blacklist): 0 | Failed: 0
Running 1st Paid Service Broadcast...
No manual Paid Service files found in pending directory.
Downloading PSF Master File...

Step 1: The PSF Extraction Protocol...
Injecting credentials...
Pop-up cleared.
SUCCESS: JobCard Invoices tab clicked!
Waiting 15 seconds for the Invoice UI to settle...
Rolling 72-Hour Window Target Date: 23/09/2026
Targeting the Siebel Find Bar Inputs directly...
Typing 'Invoice Created Date' into the field selector...
Injecting target date: 23/09/2026 into the value box...
Executing query via spatial mouse strike...
Search executed. Waiting 30 seconds for Siebel to filter the database...

Hunting for the Gear Menu...
     SUCCESS: 'Export' option found! Clicking it...
Confirming Export settings...
FINAL SUCCESS: psf_master.csv saved securely!
Running PSF Broadcast...
Initiating Post-Service Follow-up Broadcast Pipeline...
Transmitting to ASHISHKUMAR (919512263600)... SUCCESS
Transmitting to VIVEKBHAI (918320669978)... SUCCESS
Transmitting to SIDDHRAJ (917567910213)... SUCCESS
Transmitting to GULABBHAI BALVANTBHAI (918238398878)... SUCCESS
Transmitting to PARGI (919313455619)... SUCCESS
Transmitting to RAMSINGBHAI GALABHAI (916355872081)... SUCCESS
Transmitting to PRAKASHBHAI (917435940754)... SUCCESS
Transmitting to ARIFBHAI (919429145166)... SUCCESS
Transmitting to SOMABHAI RANGABHAI (919637532055)... SUCCESS
Transmitting to BHEDI (919016538665)... SUCCESS
Transmitting to VALVAI (919512728209)... SUCCESS
Transmitting to DHARMENDRAKUMAR (919726795921)... SUCCESS
Transmitting to RAJUBHAI (919586104223)... SUCCESS

--- BROADCAST SUMMARY ---
Messages Sent: 13 | Skipped: 3 | Failed: 0
Run completed at: Sat Sep 26 08:06:08 IST 2026
Running Storage Retention Policy (30 Days)...
Scanning chat_history.db for messages older than 60 days...
✅ Successfully deleted 2 stale messages.
✅ Database successfully vacuumed and optimized.
Maintenance Complete.
=====================================
Run started at: Sun Sep 27 08:00:00 IST 2026
Downloading new Master File...

Step 1: The Secure Extraction Protocol...
Detecting login screen architecture...
Login credentials injected. Engaging Siebel survival loop...
Pop-up cleared.
SUCCESS: Vehicles tab clicked!
Waiting 15 seconds for the Vehicles UI to settle...
Hunting for the top-right 'Saved Queries' dropdown...
Exact match found: '*All Vehicles'. Injecting selection...
SUCCESS: Filter applied! The server is extremely slow.
Waiting 45 FULL SECONDS to guarantee the red Siebel 'Busy' spinner disappears...

Hunting for the correct Gear Menu...
  -> Testing Menu button 1...
     SUCCESS: 'Export' option found! Clicking it...
Confirming Export settings and starting large download...
Safely archived yesterday's file to: Archive/master_20260927_080346.csv
FINAL SUCCESS: New master_11k.csv is saved securely!
Processing Master Database...
Scanning 11,000 rows for customers due on: 30/09/2026
Extraction Complete. Found 13 valid customers to message today.
Proceeding to Broadcast...
[2026-09-27 08:08:11] Starting Meta Broadcast...
Loaded 1 blacklisted numbers.
  [SUCCESS] Sent 'paras_paid_service' to RAVINDRABHAI RAMSINGBHAI (917567373053)
  [SUCCESS] Sent 'paras_paid_service' to RAMANBHAI CHHAGANBHAI (918849815192)
  [SUCCESS] Sent 'paras_paid_service' to SATISHBHAI (919537490938)
  [SUCCESS] Sent 'paras_paid_service' to LALSINGBHAI (917567352282)
  [SUCCESS] Sent 'paras_free_4' to MUKESHBHAI (919265164359)
  [SUCCESS] Sent 'paras_free_4' to MUKESHBHAI JOTIBHAI (916353890729)
  [SUCCESS] Sent 'paras_free_3' to VIKRAMBHAI (919726572706)
  [SUCCESS] Sent 'paras_free_3' to ASHISHBHAI RAYMALBHAI (919909715300)
  [SUCCESS] Sent 'paras_free_5' to SANGITABEN (919726154700)
  [SUCCESS] Sent 'paras_free_2_v1' to RAMESHBHAI (916351056392)
  [SUCCESS] Sent 'paras_free_2_v1' to MAHENDRAKUMAR (917434936041)
  [SUCCESS] Sent 'paras_paid_service' to NARSINHBHAI K (919427492053)
  [SUCCESS] Sent 'paras_paid_service' to KHANT (919586097278)
=====================================
Broadcast Complete! Success: 13 | Skipped (Blacklist): 0 | Failed: 0
Checking for pending Joyride data...
Loading Master Database into memory for Joyride deduplication...
Loaded 1 blacklisted numbers.
Running Insurance Broadcast...
Scanning for Insurance expiring between 12/09/2026 and 02/10/2026...
Found 110 customers in the time window. Processing...
Loaded 1 blacklisted numbers.
✅ [AFTER_EXPIRY] Sent Alert to: MAULIKKUMAR JAYANTIBHAI PATEL (919841412560) | Expiry: 26 સપ્ટેમ્બર 2026
✅ [AFTER_EXPIRY] Sent Alert to: PIYUSHKUMAR PARMAR (919248801090) | Expiry: 26 સપ્ટેમ્બર 2026
✅ [BEFORE_EXPIRY] Sent Alert to: MANOJKUMAR PARSHOTAMBHAI PANCHAL (919138626010) | Expiry: 02 ઓક્ટોબર 2026
=====================================
Insurance Broadcast Complete! Sent: 3 | Skipped (Already Sent): 42 | Skipped (Blacklist): 0 | Failed: 65
Running Lost Customer Broadcast (30 Days)...
Scanning for Lost Customers whose service was due exactly on: 28/08/2026...
Found 5 lost customers. Processing...
Loaded 1 blacklisted numbers.
✅ Sent Lost Customer Alert to: AMITKUMAR.R SANGADA (917096061636) | Missed Date: 28 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: VIKRAMBHAI BARIA (919726278734) | Missed Date: 28 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: JITENDRAKUMAR  MAHESHBHAI TAVIYAD (919023969293) | Missed Date: 28 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: NAYNABEN DEVABHAI PATEL (919638279782) | Missed Date: 28 ઓગસ્ટ 2026
✅ Sent Lost Customer Alert to: DINESHBHAI PATE (919737034355) | Missed Date: 28 ઓગસ્ટ 2026
=====================================
Lost Customer Broadcast Complete! Sent: 5 | Skipped (Already Sent): 0 | Skipped (Blacklist): 0 | Failed: 0
Running 1st Paid Service Broadcast...
No manual Paid Service files found in pending directory.
Downloading PSF Master File...

Step 1: The PSF Extraction Protocol...
Injecting credentials...
Pop-up cleared.
    [Warning] Siebel hung on attempt 1. Refreshing...
    [Warning] Siebel hung on attempt 2. Refreshing...
FATAL: JobCard Tab not found or Login Failed. Exiting.
Running PSF Broadcast...
Initiating Post-Service Follow-up Broadcast Pipeline...
Error: psf_master.csv not found. Run 1_download_psf.py first.
Run completed at: Sun Sep 27 08:10:55 IST 2026
Running Storage Retention Policy (30 Days)...
Scanning chat_history.db for messages older than 60 days...
✅ Successfully deleted 2 stale messages.
✅ Database successfully vacuumed and optimized.
Maintenance Complete.