/ FOR MIS USE ONLY
Received Date / 10 September 2009
Received By

CHANGE CONTROL FORM

APPLICATION NAME: APP00001 – Pertamina Retail Portal
Major Version: / Minor Version: 1 / Revision No:
Relating Document (Helpdesk ticket No. / Change Management No.):
Modification Type / Priority / Category
1. New / 1. Urgent / 1. Application
2. Errors / 2. High / 2. Report
3. Modification / 3. Medium / 3. Database
4. Enhancement / 4. Low / 4. Framework
5. Documentation / 5. Server Configuration
Routing / By / Date
Requested / Licu Kustikarini / 10 September 2009
Modified / Sugeng – PPI / 11 September 2009
Tested / Sugeng – PPI, Adhymaya / 11 September 2009
Reviewed / Code Review / Setiadi / 11 September 2009
Testing Review / Adhymaya Kusuma / 12 September 2009
Release Team / MIS - Helpdesk / 13 September 2009
Approved / ______
Setiadi / 14 September 2009
Published / Sys Admin [Name] / 14 September 2009

REASON OF CHANGE:

-  Please help to publish the modification of Employee security on PTPR Portal.
SUMMARY OF CHANGES:
§  Due to data changing in some employees we need to modify the security.

Change Control Form 0 of 4

/ FOR MIS USE ONLY
Received Date / 10 September 2009
Received By

TESTING ENVIRONMENT

BACKUP STEPS

Source: JKTSTARJUNA

Steps:

1.  backup table on middb.dbo.hd_ticket

INSTALLATION DETAILS

Database Object

Source: \\jktfs1.jkta.ptpr.com\buildDrop\APP00001-DeptartmentPortal\ 20090324\Release\_PublishedSqlScripts

Destination: JKTSTARJUNA.DBO.MISDB

Steps:

1.  Copy and paste above script (insert_employee.sql) in sql query analyzer and execute it

Dept Portal Application

Source: \\jktfs1.jkta.ptpr.com\buildDrop\APP00001-DeptartmentPortal\ 20090324\Release\_WebAPP

Destination: JKTSTWEBAPP

Step :

1.  Copy all application from above sources into the destination

2.  Setting the needed component by using the following guide :

Setting COM+ Component

1.  Publish Department Portal component , COM+ : EMPLOYEE_COMPONENT

Source : \\jktfs1.jkta.ptpr.com\buildDrop\APP00001-DeptartmentPortal\ 20090324\Release\_WebAPP

Destination : \\IJTSTWEBAPP\windows\system32\

Steps:

a.  Open Windows Componen Services in The server.

b.  Copy the COM+ Componen in above source into the destination

c.  Right Click and deploy, the component.

Setting Active Directory

1.  Publish modify the setting property for the employee id in the script.

Steps: Please open the account that has stated in above script. And modify

ROLLBACK CRITERIA

-  If there are any error has found in the applications

ROLLBACK STEPS

Database Objects

Destination: JKTSTARJUNA

Steps:

1.  restore table on middb.dbo.hd_ticket from backup

Destination: JKTSTAPP

Steps:

1.  Delete COM+ : EMPLOYEE_COMPONENT

2.  Delete Account in Active Directory

PRODUCTION ENVIRONMENT

BACKUP STEPS

Source: ARJUNA

Steps:

1.  backup table on middb.dbo.hd_ticket

INSTALLATION DETAILS

Database Object

Source: \\jktfs1.jkta.ptpr.com\buildDrop\APP00001-DeptartmentPortal\ 20090324\Release\_PublishedSqlScripts

Destination: ARJUNA.DBO.MISDB

Steps:

1.  Copy and paste above script (insert_employee.sql) in sql query analyzer and execute it

Dept Portal Application

Source: \\jktfs1.jkta.ptpr.com\buildDrop\APP00001-DeptartmentPortal\ 20090324\Release\_WebAPP

Destination: WEBAPP

Step :

1.  Copy all application from above sources into the destination

2.  Setting the needed component by using the following guide :

Setting COM+ Component

1.  Publish Department Portal component , COM+ : EMPLOYEE_COMPONENT

Source : \\jktfs1.jkta.ptpr.com\buildDrop\APP00001-DeptartmentPortal\ 20090324\Release\_WebAPP

Destination : \\IJTSTAPP\windows\system32\

Steps:

  1. Open Windows Componen Services in The server.
  2. Copy the COM+ Componen in above source into the destination
  3. Right Click and deploy, the component.

Setting Active Directory

1.  Publish modify the setting property for the employee id in the script.

Steps: Please open the account that has stated in above script. And modify

ROLLBACK CRITERIA

-  If there are any error has found in the applications

ROLLBACK STEPS

Database Objects

Destination: ARJUNA

Steps:

1.  restore table on middb.dbo.hd_ticket from backup

Destination: WEBAPP

Steps:

2.  Delete COM+ : EMPLOYEE_COMPONENT

3.  Delete Account in Active Directory

REFERENCES

Sharepoint Document

Change Control Form 0 of 4