PI Upgrade: Update of table XI_AF_ADM_ERRORS fails

July 12, 2009 at 2:21 am

[] [] [] [] [] [] [] [] [] []

Related:

  1. PI CTC: Additional ccBPM cleanup required after system copySymptom After a SAP NetWeaver PI System Copy some ccBPM...
  2. PI CTC: New Java RFC destination for ccBPM monitorSymptom For ccBPM Monitoring a new Java RFC destination “BusinessProcessEngine_RFC”...
  3. Configuration Wizard: PI-AE initial setupSymptom You are working with SAP NetWeaver PI Adapter Engine...
  4. Configuration Wizard: PI-AE initial setupSymptom You are working with SAP NetWeaver PI Adapter Engine...
  5. Patch Process for SAPXIGUISymptom After deployment of new patch of only SAPXIGUI archive,...
  6. Configuration Wizard: PI Full Qualified Host NameSymptom You are working with SAP NetWeaver for PI 7.1...
  7. ‘Unknown Host’ while communcation over http(s) within serverSymptom During the web based cross communication across web applications...
  8. PI CTC: Downport PI Upgrade CTC TemplateSymptom The “PI System Upgrade” CTC Wizard Template is not...

Symptom

During an upgrade from XI 3.0 SP15 to a higher release you receive the following error during deployment of Development Component (DC) “com.sap.aii.af.service.util.tables”:
dbs-Info: <<< Analyze table XI_AF_ADM_ERRORS >>>
ora-Info: compareTo: Java SQL type INTEGER of column NODE_ID not equivalent to target type VARCHAR
dbs-Info: XI_AF_ADM_ERRORS modify column NODE_ID from type : INTEGER,len : 0,dec : 0,not null : true,default : 0
dbs-Info: XI_AF_ADM_ERRORS modify column NODE_ID to type : VARCHAR,len : 32,dec : 0,not null : true,default :
dbs-Info: ColumnsAction = REFUSE, IndexesAction = null, PrimaryKeyAction = null
Info: E R R O R ******* (DbTableModificationAnalyser)
dbs-Error: Modification not possible for XI_AF_ADM_ERRORS
Stack trace:
com.sap.dictionary.database.dbs.JddRuntimeException:
Modification not possible for XI_AF_ADM_ERRORS at com.sap.dictionary.database.dbs.DbTableModificationAnalyser.
defineAction(DbTableModificationAnalyser.java:249) [...]

Other terms

PI, Process Integration, AII, Exchange Infrastructure

Reason and Prerequisites

The error above occurs only for source release XI 3.0 SP15 and not for other Support Packages.

Solution

Delete table XI_AF_ADM_ERRORS from the database manually. There is no risk since this table contains no important data. Retry the upgrade deployment after that.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

Leave a Comment