Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Update to service pack 20

Highlighted
Allex_1
Occasional Advisor

Update to service pack 20

Good morning...

Our system was updated from service pack 18 to service pack 20.

After service pack was installed by the system was counted one error of installation process. Below you can see information from log file:
----------
??, 22/10/2007 10:18:01 Deleting table:FROM REP_PAGEATTRIBUTES
??, 22/10/2007 10:18:01 Current file:C:\Program Files\Hewlett-Packard\OpenView\service desk 4.5\server\repo\tables\upgrade\4.5.0588sp1601.rsd
??, 22/10/2007 10:18:01 DELETE FROM rep_pageattributes WHERE (paa_pai_oid = '281478983450626')
??, 22/10/2007 10:18:01 Exception returned from the database
??, 22/10/2007 10:18:01 java.sql.SQLException: [DELL750-BD69]DELETE statement conflicted with COLUMN REFERENCE constraint 'PAT_PAA_OID_FK'. The conflict occurred in database 'HP_test', table 'REP_PAGEATTRIBUTES_LOCALE', column 'PAT_PAA_OID'.
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.i.if(Unknown Source)
at com.inet.tds.i.execute(Unknown Source)
at com.inet.pool.e.execute(Unknown Source)
at com.hp.ifc.install.database.AppStatement.statementToDatabase(Unknown Source)
at com.hp.ifc.install.database.AppStatement.saveDatabaseWithoutConstraints(Unknown Source)
at com.hp.ifc.install.database.AppUpgradeDatabase.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
----------

Whether this mistake can influence serviceability of system?
3 REPLIES
Jay Mistry
Frequent Visitor

Re: Update to service pack 20

Hi Allex

what database are you connecting to? SQL server or Oracle?

Did you test the upgrade from SP18 to SP20 in a test lab? did you see the same problem there?
Allex_1
Occasional Advisor

Re: Update to service pack 20

We have SQL server 2000 database.

This problem counted when i testing updating on the test base(image of the our work base).
Allex_1
Occasional Advisor

Re: Update to service pack 20

But when i tried to remove the second language the system shows another error message.
The executed operations before emerging of the message about an error:
System->System panel->Regional settings->
in the language list select the language and press remove button
Then system shows information window:"Delete application text"
A bit later system shows error message:"Can not end a transaction that has not been started".

Whether this mistake can influence serviceability of system?
//Add this to "OnDomLoad" event