Transcript Slide 1

L1 & L2 Handover to BSNL
January 22, 2010
TCS Public
Pre-requisites
• User Should Know the URL of Clarity -- http://clarity.sdc.bsnl.co.in/
• TNS entry
CLRSPH1=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.196.208.162)(PORT = 1581))
)
(CONNECT_DATA =
(SERVICE_NAME =CLRSPH1)
)
)
• For running Clarity application, JRE is Java 5 Update 11 (In both XP and Vista
environments).
• Database credentials are same as Clarity Login.
• Oracle client version 9i with TOAD or PL/SQL Developer.
• User Must be having execute privilege on the procedures.
January 22, 2010
2
Agenda of Issues
• Number Release
• Number range creation
• Workgroup addition/deletion/rerouting
• New port creation.
• NE updation and cross connecting them with circuits.
• Addition of service types to existing ports.
• Change in network type(ex: P2.2 to P3 and vice versa).
• Task in assigned state from long time.
• Cancellations and Halt reasons
• 691 errors and BB_NIB_DONE is in Inprogress state from long time.
• Task Errors.
January 22, 2010
3
Number Release and Number Range Creation
• For Number Release, Front end screen is present in CRM. Contact CSR for
Number release.
• For Number Range Creation, Please follow the process below :
January 22, 2010
Number Range Creation
January 22, 2010
Number Range Creation
January 22, 2010
Number Range Creation
January 22, 2010
Number Range Creation
January 22, 2010
Number Range Creation
January 22, 2010
New port creation Procedure

Procedure name: MIG_INSERT_PORT

Right click on procedure and select test

A test window will appear

Enter the necessary inputs asked in test window

Click on Start Debugger or press F9

Click on the Run or press Ctrl+R

Input Parameters

i_ticketno:mention the ticket number (ex:SD4555)

i_equp_id:mention the equiptment id(you can get this value from the following query
Select * from equipment where equp_locn_ttname=‘HYDGRTO01’

i_locn_name:HYDGRTO01
January 22, 2010
NE Port Updation and Cross Connections

Procedure name: BSNL.BSNL_INSERT_CIRCUIT_PORT

Right click on procedure and select test

A test window will appear

Enter the necessary inputs asked in test window

Click on Start Debugger or press F9

Click on the Run or press Ctrl+R

Input Parameters

i_ticketno:mention the ticket number(ex:SD4555)

i_equp_id:mention the equiptment id(you can get this value from the following query
Select * from equipment where equp_locn_ttname=‘HYDGRTO01’
January 22, 2010
Addition of service type to existing ports

Procedure name: BSNL.BSNL_ADD_SERV_TYPE

Right click on procedure and select test

A test window will appear

Enter the necessary inputs asked in test window

Click on Start Debugger or press F9

Click on the Run or press Ctrl+R

Input Parameters

service_type:LANDLINE/PCO/ISDN_PRI

i_equp_id:mention the equiptment id(you can get this value from the following query
Select * from equipment where equp_locn_ttname=‘HYDGRTO01’
January 22, 2010
Network change procedure

Procedure name:BSNL.BSNL_P2_P3_LATEST

Right click on procedure and select test

A test window will appear

Enter the necessary inputs asked in test window

Click on Start Debugger or press F9

Click on the Run or press Ctrl+R

Input Parameters

i_sero_id: Service_order_number.

i_network_type : New network type(P3 or P2.2)
January 22, 2010
Task Errors
• All Update tasks & CLOSE_SO might fail with the following error message when CRM
db/Server is down
Failed to set the task status to completed:ORA-20904: Error in calling MilestoneReached
callback API: Fault: -2: MSR: Failure. Exception
String:javax.xml.ws.soap.SOAPFaultException: business exception
ORA-06512: at "CLARITY.SEIT_POST_STATUS_UPDATED", line 196
ORA-04088: error during execution of trigger 'CLARITY.SEIT_POST_STATUS_UPDATED'
Failed to set the task status to completed:ORA-20904: Error in calling
MilestoneReached callback API: Fault: -2: MSR: Failure. Exception
String:javax.xml.ws.WebServiceException: org.jboss.ws.core.WSTimeoutException:
Timeout after: 255000ms
ORA-06512: at ""CLARITY.SEIT_POST_STATUS_UPDATED"", line 196
ORA-04088: error during execution of trigger 'CLARITY.SEIT_POST_STATUS_UPDATED'"
January 22, 2010
Task Errors
•
Resolution :
Run the following script when the CRM database is stabilized.
UPDATE SERVICE_IMPLEMENTATION_TASKS
SET SEIT_STAS_ABBREVIATION = 'ASSIGNED'
WHERE SEIT_STAS_ABBREVIATION = 'ERROR' and
SEIT_ID IN
(SELECT DISTINCT SEIT_ID
FROM SERVICE_TASK_COMMENTS, SERVICE_IMPLEMENTATION_TASKS
WHERE SETC_SEIT_ID = SEIT_ID AND SEIT_STAS_ABBREVIATION = 'ERROR' AND
(SETC_TEXT LIKE '%listener%' OR SETC_TEXT LIKE '%business%' OR
SETC_TEXT LIKE '%Timeout%')) and ROWNUM < 50;
January 22, 2010
Task Errors
• BB_INVOKE_NIB task might fail with the following message:
ServiceUserID does not exists PLEASE CHECK THE ORDER AND RESET THE TASK.
• Resolution
Update the correct user id in BB_USER_ID and then RESET the task.
The correct user id is available with the P2.2 incharge / NIB
January 22, 2010
Questions ?
January 22, 2010
17
Thank You
January 22, 2010
TCS Public