Error while upgrading to SP-06

[Former Member]

Dear All,

We have GRC AC 5.3 with SP-03, while upgrading to SP-06 i'm getting below error,

r 11, 2009 6:16:16 PM Info: E R R O R ******* (DbMssColumn)

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 mss-Error: compareTo (GENOBJID): conversion necessary: original length 300 greater than target length 50

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: VIRSA_CC_MTGENOBJ modify column GENOBJID from type : VARCHAR,len : 300,dec : 0,not null : true,default : | |

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: VIRSA_CC_MTGENOBJ modify column GENOBJID from type : VARCHAR,len : 300,dec : 0,not null : true,default : | |

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: VIRSA_CC_MTGENOBJ modify column GENOBJID to type : VARCHAR,len : 50,dec : 0,not null : true,default : |<null>|

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: VIRSA_CC_MTGENOBJ modify column GENOBJID to type : VARCHAR,len : 50,dec : 0,not null : true,default : |<null>|

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 mss-Info: table VIRSA_CC_MTGENOBJ contains data

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: Action: CONVERT

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: Action: CONVERT

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: Table has to be converted

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: Table has to be converted

Mar 11, 2009 6:16:16 PM Info:

Mar 11, 2009 6:16:16 PM Info: E R R O R ******* (DbModificationManager)

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Error: Table VIRSA_CC_MTGENOBJ: Conversion currently not possible

Mar 11, 2009 6:16:16 PM Info:

Mar 11, 2009 6:16:16 PM Info: E R R O R ******* (DbModificationManager)

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Error: Table VIRSA_CC_MTGENOBJ: Conversion currently not possible

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: Next archive object : dbtables/VIRSA_CC_MTGENOBJH.gdbtable

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: Next archive object : dbtables/VIRSA_CC_MTGENOBJH.gdbtable

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: <<< Analyze table VIRSA_CC_MTGENOBJH >>>

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: <<< Analyze table VIRSA_CC_MTGENOBJH >>>

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: predefined action is: >>>null<<<

Mar 11, 2009 6:16:16 PM Info: 18:16:11 2009-03-11 dbs-Info: predefined action is: >>>null<<<

Mar 11, 2009 6:16:16 PM Info:

Any idea?

[frank_bannert]

Hi Yash,

check in your DB if this table is locked or in change mode.

Regards,

Frank

[Former Member]

There are no open transaction in DB going on..neither table is in locked mode

Thanks,

Yash

[Former Member]

Issue Resolved after changing column ACTDATE in table VIRSA_CC_ACTUSAGE to NOT NULL

Thanks