Home : Products : Hach WIMS : Server Setup : Hach WIMS Server Setup for ORACLE : Documentation : 1.3.6 Database upgrade fails on OPSWWTUTOR in Oracle Server Setup
Q13607 - KNOWNISSUE: 1.3.6 Database upgrade fails on OPSWWTUTOR in Oracle Server Setup

When using the OPSWWTUTOR.DMP file from the OracleServerSetup (OPSORAsvrSetup.exe) install (version 2.2.0).  Import the DMP file and use Server Setup to upgrade database get error:

Database Upgrade Failed:

The Log file shows in fails on the following line trying to alter the BODRECS table. 

alter table BODRECS modify("AUDITUSER" varchar2(50) default NULL, "SAMPLENAME" nvarchar2(50), "BOTTLENUM" nvarchar2(50), "PREDIL" nvarchar2(50), "INITTEMP" float, "INITPH" float, "FINALTEMP" float)


09:49:50 AM : Script execution failed  :
09:49:50 AM : 1440  -  -2147217900  -  ORA-01440: column to be modified must be empty to decrease precision or scale
09:49:50 AM : Upgrade136Facility() return value = False

The INITTEMP field had data in it (there are 13 records).  We set the INITTEMP data to null before starting the database upgrade and successfully upgraded!!

To set INITTEMP to Null, use SQL_CONSOLE and execute the following command against the OPSWWTUTOR database: 

update bodrecs set INITTEMP=null

WARNING - DO NOT USE THE ABOVE STATEMENT AGAINST A USER DATABASE AS IT WILL CLEAR THE DATA.  YOU NEED TO CHECK THE BODRECS TABLE BEFORE PROCEEDING.   

 

 

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 11/15/2011 11:25 AM.
Last Modified on 11/15/2011 11:25 AM.
Last Modified by Scott Dorner.
Article has been viewed 2404 times.
Rated 4 out of 10 based on 2 votes.
Print Article
Email Article