Cisco Cisco Prime Provisioning 6.3 Troubleshooting Guide

Step 1. Connect to a Prime Provisioning server on Secure Socket Cell (SSH) session over
iscadm (Prime Provisioning application user) and navigate to base install directory. 

Step 2. Setup SSH session to be ready to connect to Prime Provisioning sybase database:

1. cd $ISC_HOME

2. ./prime.sh shell

3. cd bin

4. source vpnenv.sh

5. cd $SYBASE_HOME/bin

6. source sa_config.sh

Step 3. Stop Prime Provisioning application completely:

./prime.sh stopall

Step 4. Start and Intialize Prime Provisioning sybase database:

./prime.sh startdb

./prime.sh initdb.sh

Step 5. Connect to Prime Provisioning sybase database:

dbisql -nogui -c "uid=DBA;pwd=sql" -port 2630

Note: Verify these parameters in the output of more runtime.properties command from PP
home directory. Look for db_usr and db_pwd values.

Step 6. Confirm the task id covered in exception thrown by Prime Provisioning:

select * from SHARED_UNI_SYNC_INFO; 

Step 7. Capture the details of other SR's that need to be subsumed by the sync task:

select * from SHARED_UNI_SYNC_TARGET;

 Step 8. Delete the shared UNI task details:

delete SHARED_UNI_SYNC_TARGET where KEY_LINK_INFO_ID = <task_id>

delete SHARED_UNI_SYNC_INFO where id = <task_id>

Note: task_id is a task number that is covered in exception thrown by Prime Provisioning.

 Step 9. Start the Prime Provisioning application:

./prime.sh start

Step 10. Navigate to Prime Provisioning GUI > Operate > Task Manager and filter by
synchronized shared UNI where you can select the task and click on Delete and the task will be
deleted.

Step 11. NavigatetoServices Request Manager and filter by the SR number that originated the
sync task and perform a force purge.  

Note: Before you run a force purge on the SR, take a note about all the SR details like VLAN
ID, PE, Interfaces etc.

After job deletion and sync task, you can now create a new SR with the device and interfaces that
were blocked and now they are released to be used by the operators. You will be able to create