Hello everyone!
Today, I'd like to share a case.
Problem Description
U2000 V100R005C00SPC603 was deployed to manage PTN NEs. the U2000 system was down and failed to be started. After U2000 software was reinstalled and data was recovered with backup databases:
1. The CORBA northbound interface was manuflunctional, and failed communicate with the upper layer NMS.
2. PTN tunnels failed to be filtered out on U2000, and a general database error code 1107329317 was returned.
3. Tunnels failed to be created, and a general database error code 1107329317 was returned.
Problem Analysis
1. Used the WINMD5 software to check whether the software package on the server had the same size as that on the PC, and found that the software package was correct.
2. Learned that the installation process was in strict compliance with installation guidelines. Used the system maintenance tool to check deployment components and found no deployment errors or intact deployments.
3. Reconfigured the CORBA interface and found that the CORBA interface was still abnormal.
4. Collected CORBA logs and returned the data to the R&D sector. Based on the analysis results from the R&D sector, data failed to be obtained from the databases due to inconsistent database sorting rules
Log directory: server\var\logs\nbi\
unbi_debug_YYYYMMDD_HHMMSS_Process ID.*
unbi_corbaoper_YYYYMMDD_HHMMSS_Process ID.*
unbi_corbanotify_YYYYMMDD_HHMMSS_Process ID.*
unbi_corbasys_YYYYMMDD_HHMMSS_Process ID.*
unbi_corbadebug_YYYYMMDD_HHMMSS_Process ID.*
unbi_sys_YYYYMMDD_HHMMSS_Process ID.*
TopThr:12604,If:getAllManagedElements,UserInfo:[corba1][10.218.225.52:50788], Thread: 8732,
Debuglevel: 1, Bundle: ii_domain_bundle, Service: ii_domain_model
Function : NS_DOMAIN::StaticDataMgr::GetNETypeByDB
Line : 4450
Detail : Failed to get ne data from database. Error info: Failed to handle UNION sorting rule inconsistency.
Log directory: C:/HWENGR/engineering/tool/ModifySort
Upon a tunnel query, a database error was returned. Checked the logs and found that the database failed to be connected due to inconsistent database sorting rules.
[10:01:53.703],Info ,[T9048],iMapMsgSetMdpTransFlag return 0
[CAsnHelper::CreateReqMsg|asnhelper.cpp|262]
[10:01:53.781],Debug,[T9048],default sql: TNMDBI: dbName = TNIPDB, dbConnection = 03FCCEB8 !
[10:01:53.781],Debug,[T9048],default DATA: temptable: TNTempTblKeyString Create temp table:
create table temp_keystringNml_ip1 ( cKey int not null, cValue nvarchar (390) not null )
!
[10:01:53.796],Debug,[T9048],default Clear temp table temp_keystringNml_ip1 operation!
[10:01:53.796],Debug,[T9048],default DATA: Actived temp table : sql:temp_keystringNml_ip1!
[10:01:53.796],Fixme,[T9048],ErrorCode: 0x00000000, E2E
-----------------DBTools.h++ error ------------------
status.Message: SQL call failed.
status.errorCode: 5
vendor msg1: 42000
vendor msg2: [Microsoft][ODBC SQL Server Driver][SQL Server] failed to handle the equal to operation sorting rule inconsistency.
5. Checked and learned that the backup MO was backed up after T2000 was upgraded to U2000 V100R005C00SPC603. U2000 V100R005SPC603 MO did not use binary database sorting rules but the newly installed U2000 version used binary database sorting.
6. Ran the following commands to change the sorting rules for U2000 databases and database tables to binary sorting:
C:\> cd /d C:/HWENGR/engineering/tool/ModifySort
C:\HWENGR\engineering\tool\ModifySort> ModifySort.bat DBSVR sa sa user password
After the server restarts, the U2000 functions are normal, tunnels can be created and filtered, and CORBA interface monitoring is normal.
Root Cause
U2000 V100R005SPC603 did not use binary database sorting but the newly installed U2000 used binary database sorting.
Solution Description
Run the following commands to change the sorting rules for U2000 databases and database tables to binary sorting:
C:\> cd /d C:/HWENGR/engineering/tool/ModifySort
C:\HWENGR\engineering\tool\ModifySort> ModifySort.bat DBSVR sa sa user password
After the server restarts, the U2000 functions are normal, tunnels can be created and filtered, and CORBA interface monitoring is normal.
Welcome to leave a message below.
We’ll study together.
Thank you!
