Thursday, June 14, 2007

Tool - Local Database initialization

When you are running the local database initialization using an upgrade wizard you can stop the local database extract half way through. When you log-on to Siebel tools the next time local database extract starts from nearest point where it had stopped.

Local Database Extract keeps loging the status of local database in state.log under Upgrade folder hierarchey. Local database extract is divided into different item.

Exmple of State.log

[Item 0]Status = Complete$TblOwner2 = SIEBELPause = 0

[Item 1]Status = CompleteItem Name = File Copy Entry 0

[Item 2]Status = CompleteItem Name = Sql File Entry 1SQL Statement Prefix = RUN_SQL_SQL Statement Number = 0SQL Statement Status = Success

[Item 3]Status = CompleteItem Name = Sql File Entry 2SQL Statement Prefix = RUN_SQL_SQL Statement Number = 5SQL Statement Status = Success

[Item 4]Status = CompleteItem Name = Sql File Entry 3

[Item 5]Status = CompleteItem Name = Sql File Entry 4SQL Statement Prefix = RUN_SQL_SQL Statement Number = 1SQL Statement Status = Success

[Item 6]Status = ErrorItem Name = Import DML Entry 5Table Name = S_BUTable Index = 118Row Index = 0Imported Row Index = 763402

[Item 7]Status = InComplete

[Item 8]Status = InComplete

[Item 9]Status = InComplete

[Item 10]Status = InComplete

No comments: