Ericsson Statsfile to Database Parser

 Tool Name : ExpOSS

 Compliance : 3GPP 32.435 V10.0 & 32.401 V6.2

 Application  : RNC, NodeB, EnodeB


Table Of Contents
1. Goals
2. Ericsson 3G & 4G LTE Statsfile
3. Hardware & Operating System Platform
4. Installations, Operations & Maintenance
5. Support


1. Goals
- Build alternative performance data collection system, as we know Ericsson has ENIQ.
- Make everything simple, Build Light System in Inexpensive Hardware.
- Source Codes are open for continuity in order to follow Ericsson system upgraded.
- Target System Owner : Ericsson STS Provider.
2. Ericsson 3G & 4G LTE Statsfile
- RNC : 3GPP 32.401
OSS RC dir : /var/opt/ericsson/nms_umts_wran_pms
OSS ENM dir : /ericsson/pmic1 & /ericsson/pmic2
- RBS : 3GPP 32.435 & 32.401
OSS RC dir : /var/opt/ericsson/nms_umts_wran_pms
OSS ENM dir : /ericsson/pmic1 & /ericsson/pmic2
- ERBS : 3GPP 32.435 & 32.401
OSS RC dir : /var/opt/ericsson/nms_umts_wran_pms
OSS ENM dir : /ericsson/pmic1 & /ericsson/pmic2

3. Hardware & Operating System Platform
XML Collector & Parser Server
HP DL360p Dual Xeon E5-2660, 16 Core 32 Threads, RAM 32GB, RAID0 6x146GB DISK +128GB SSD for OS, Gigabit LAN.
Windows Server 2012 R2, JAVA 1.8, Check Point VPN Client.

Database Server
Dell R710, Single Xeon X5675, 6 Core 12 Threads, RAM 64 GB, RAID0 2x2TB + 2x2TB + 2x128 SSD.
Oracle Linux 7/RHEL 7, MySQL 8.0

Storage Server (Optionally)
Storage 2x2TB RAID1 for post processing files ; xml files and output Parser in tabular format.
Windows Server 2012 R2 / Oracle Linux 7, Filezilla ftp server, web server


System Topology

System Capacity & Dimensioning

- Trial with 40Mbps Internet Connection and 1G LAN Connection.
- Collect xml files 30 RNC serial process per oss (avoid disturbing other process and manage resources loads in oss server). Hourly = 30 RNC * 4 xml files
- Parsing 30 RNC, 32 parallel process as num CPU thread, balanced by i/o capacity of RAID0 Disks/SSDs. - Process completed in 10 minutes including load data in Database.
- Collect RBS and ERBS files parallel 8 threads (small size files). Hourly = 5000 NE * 4 xml files
- Parsing 5000 NE, 32 parallel process as CPU thread, balanced by i/o capacity of RAID0 Disks/SSDs. Process completed in 30 minutes including load data in Database.
- Database Dimensioning ; maximum column 1000, rop data 1 Month, Daily data 1 Year or can be managed by partitioning or clustering. Best practice to sts ericsson, its recommended to store data in KPI value.


Quick Process Explanation 1

- Data Collector Server make vpn connection to internal network ericsson or customer.
- Data Collector Server retrieve xml files.
- Parser Server works and produce tabular files and send to Database Server.
- User get the data by query to SQL database.





4. Installation, Operation & Maintenance

Hardware, Software, Network Installation
OS, MySQL, FTP server and Supported software installation.

Operation & Maintenance ; 
 Script written in JAVA, running with cmd, terminal, batch script and bash script.
Data collection, processing and results controlled by file explorer, sql query, web charts dashboard or application dashboard.
Database Backup is a must, can stored in storage server or additional disk.
Manage space by removing unused raw or moving to additional  storages.

5. Support
We give source codes, owner with JAVA skills can modify it self.
Contact essaalif@gmail.com






Comments

Post a Comment

Popular posts from this blog

Decimal Auto Dash Number To HEX

Image
Decimal Number To Hexadecimal Converter Tools This is the code calculator for the dashboard in Kilometres. The resulting code is one of the 5 codes that appear below. Please discuss in the comments column if there are difficulties. Edit EEPROM at spesific memory address acording to type of device, for example shown in picture below honda with EEPROM 93C76 Disclaimer : The use of this software is intended for repair purposes only or experimental, we are not responsible for the misuse of this software resulting in criminal acts according to applicable state laws. Thank you for reading. This tools maybe save your live, so please donate to support me through my paypal https://www.paypal.me/aesixnet Note Please enter a description USD Please enter a price Please enter an Invoice ID
Read more

Example of Query 3G Cell Propagation Data ENIQ with Vector INDEX

Image
The following is an example of an Ericsson ENIQ SQL Query for finding the range of radio signal propagation in average Kilometres by method of Weighted Average. S ELECT Date_ID,RNC,RBS,Sector,Carrier, cast((SUM(A_1)+SUM(A_2)+SUM(A_3)+SUM(A_4)+SUM(A_5)+SUM(A_6)+SUM(A_7)+SUM(A_8)+SUM(A_9)+SUM(A_10)+SUM(A_11)+SUM(A_12)+SUM(A_13)+SUM(A_14)+SUM(A_15)+SUM(A_16)+SUM(A_17)+SUM(A_18)+SUM(A_19)+SUM(A_20)+SUM(A_21)+SUM(A_22)+SUM(A_23)+SUM(A_24)+SUM(A_25)+SUM(A_26)+SUM(A_27)+SUM(A_28)+SUM(A_29)+SUM(A_30)+SUM(A_31)+SUM(A_32)+SUM(A_33)+SUM(A_34)+SUM(A_35)+SUM(A_36)+SUM(A_37)+SUM(A_38)+SUM(A_39)+SUM(A_40)) as float) as TS, cast (((SUM(A_1) * 0.175) + (SUM(A_2) * 0.525) + (SUM(A_3) * 0.875) + (SUM(A_4) * 1.23) + (SUM(A_5) * 1.585) + (SUM(A_6) * 1.935) + (SUM(A_7) * 2.285) + (SUM(A_8) * 2.635) + (SUM(A_9) * 2.985) + (SUM(A_10) * 3.34) + (SUM(A_11) * 3.87) + (SUM(A_12) * 4.57) + (SUM(A_13) * 5.275) + (SUM(A_14) * 5.98) + (SUM(A_15) * 6.68) + (SUM(A_16) * 7.38) + (SUM(A_17...
Read more

JAVA Script Parser Ericsson CEDH and STRT Log

 /*  * To change this license header, choose License Headers in Project Properties.  * To change this template file, choose Tools | Templates  * and open the template in the editor.  */ package strt; import java.io.BufferedReader; import java.sql.*; import java.io.File; import java.io.FileReader; import java.io.FileWriter; import java.io.IOException; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Scanner; import java.util.logging.Level; import java.util.logging.Logger; /**  *  * @author aessa  */ public class STRT {     String dbnn;     String TT;     String locoutfile;     String usreniq;     String pwdeniq;     String ipeniq;     String porteniq;     String dbeniq;     String stsregion;     String maxrowv;     String dtt = null;     private Connection connx;   ...
Read more