IBM Support

Patch Installation Failed Db_Verify Reports Missing Indexes and Tables

Troubleshooting


Problem

Patch Installation Failed Db_Verify Reports Missing Indexes and Tables

Symptom

Attempting to patch GIS 4.3 system, the patch installation is failing.

db_verify.sh the output shows the indexes and tables do not exist.

GIS Oracle database server.

GIS runs fine.

Error Message

DB_Verify Output

 ...Reading entity repository into memory from 
/gis/43/base/repository/entity ... ...Done... ...Verifying db connection... 
JdbcUrl: jdbc:oracle:thin:@server:1521:genericserver JdbcUser: generic 
JdbcDriver: oracle.jdbc.OracleDriver JdbcSchema: gis ...DbConnection OK... 
...Getting metadata from database. This is time consuming. Please wait... 
WARNING: The system catalog CTX_USER_INDEXES was not found...assuming text 
search is not enabled. ...Database Metadata obtained... ...Generating alter 
script now... [Table YFS_BASE_CONFIG_TASK_STATUS is missing see 
EFrame_TableChanges.sql to correct.] [Table YFS_BASE_CONFIG_TASK_STATUS is 
missing Primary Key YFS_BASE_CONFIG_TASK_STATUS_PK on 
BASE_CONFIG_TASK_STATUS_KEY ] [Table YFS_BASE_CONFIG_TASK_STATUS is missing 
index TASK_STAT_I1 see EFrame_IndexAdds.sql to correct. ] [Table 
RPT_CONFIG_SCHEDUL is missing see EFrame_TableChanges.sql to correct.] [Table 
RPT_CONFIG_SCHEDUL is missing Primary Key SCI_PK_209 on CONFIG_NAME ] [Table 
RPT_CONFIG_SCHEDUL is missing Primary Key SCI_PK_209 on SCHEDUL_ID ] [Table 
SWNET_SVC_PROFILE is missing see EFrame_TableChanges.sql to correct.] [Table 
SWNET_SVC_PROFILE is missing Primary Key SWIFT_SVC_PROF_PK on REQUEST_TYPE ] 
[Table AS2_TRADEPART_INFO is missing see EFrame_TableChanges.sql to correct.] 
[Table AS2_TRADEPART_INFO is missing Primary Key AS2TP_PRIM_KEY on 
PARTNER_PROFILE_ID ] [Table NDC_PACKAGES is missing see EFrame_TableChanges.sql 
to correct.] [Table YFS_NONLOCALIZED_STRINGS is missing see 
EFrame_TableChanges.sql to correct.] [Table YFS_NONLOCALIZED_STRINGS is missing 
Primary Key YFS_NONLOCALIZED_STRINGS_PK on NONLOCALIZED_STRINGS_KEY ] [Table 
FG_P_FLR_PRM is missing see EFrame_TableChanges.sql to correct.] [Table 
FG_P_FLR_PRM is missing Primary Key FG_PFLRPRM_PK on P_FLR_PRM_KEY ] [Table 
MODELER_PALETTES is missing see EFrame_TableChanges.sql to correct.] [Table 
MODELER_PALETTES is missing Primary Key SCI_PK_136 on PALETTE_NAME ] [Table 
SI_VERSION is missing see EFrame_TableChanges.sql to correct.] [Table 
SI_VERSION is missing Primary Key SCI_PK_64 on PRODUCT_LABEL ] [Table 
YFS_ZIP_CODE_LOCATION is missing see EFrame_TableChanges.sql to correct.] 
[Table YFS_ZIP_CODE_LOCATION is missing Primary Key YFS_ZIP_CODE_LOCATION_PK on 
ZIP_CODE_LOCATION_KEY ] [Table YFS_ZIP_CODE_LOCATION is missing index 
YFS_ZIP_CODE_LOCATION_I1 see EFrame_IndexAdds.sql to correct. ] [Table 
YFS_ZIP_CODE_LOCATION is missing index YFS_ZIP_CODE_LOCATION_I2 see 
EFrame_IndexAdds.sql to correct. ] [Table DATA_FLOW is missing see 
EFrame_TableChanges.sql to correct.] [Table DATA_FLOW is missing Primary Key 
DATA_FLOW_PK on DATA_FLOW_ID ] [Table DATA_FLOW is missing index SCI_IDX_DMI1 
see EFrame_IndexAdds.sql to correct. ] 

....

<img id="myFxSearchImg" style="border-right: medium none; border-top: medium none; display: none; z-index: 2147483647; border-left: medium none; border-bottom: medium none; position: absolute; opacity: 0.6" height="24" alt="" width="24" hidden="true" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAADsElEQ VR4nK2VTW9VVRSGn33OPgWpYLARbKWhQlCHTogoSkjEkQwclEQcNJEwlfgD/AM6NBo1xjhx5LyJ0cYED HGkJqhtBGKUpm3SFii3vb2956wPB/t+9raEgSs52fuus89613rftdcNH8/c9q9++oe/Vzb5P+3McyNcf m2CcPj9af9w6gwjTwzvethx3Bx3x8xwd1wNM8dMcTNUHTfFLPnX6nVmZpeIYwf3cWD/PhbrvlPkblAzV FurKS6GmmGqqComaS+qmBoTI0Ncu3mXuGvWnrJ+ZSxweDgnkHf8ndVTdbiT3M7cQp2Z31dRTecHAfqyd p4ejhwazh6Zezfnu98E1WIQwB3crEuJ2Y45PBTAQUVR9X4At66AppoEVO1Q8sgAOKJJjw6Am6OquDmvH skZ3R87gW+vlHz98zpmiqphkkRVbQtsfPTOC30lJKFbFTgp83bWh7Zx/uX1B6w3hI3NkkZTqEpBRDBRz G2AQHcwcYwEkOGkTERREbLQ/8HxJwuW7zdYrzfZ2iopy4qqEspKaDYravVm33k1R91Q69FA1VBRzFIVv Xbx5AgXT44A8MWP81yfu0utIR2aVK3vfCnGrcUNxp8a7gKYKiLCvY2SUvo/aNtnM3e49ucK9S3p0aDda T0UAVsKi2tVi6IWwNL9JvdqTdihaz79/l+u/rHMxmaJVMLkS2OoKKLWacdeE3IsSxctc2D5Qcl6vUlVV gNt+fkPPcFFmTw1xruvT7SCd7nuVhDQvECzJH90h0azRKoKFRkAmP5lKTWAGRdefoZL554FQNUxB92Wv YeA5UN4PtSqwB2phKqsqMpBgAunRhFR3j49zuU3jnX8k6fHEQKXzh1jbmGDuYU6s4t1rt6socUeLLZHh YO2AHSHmzt19ihTZ48O8Hzl/AmunD/BjTvrvPfNX3hWsNpwJCvwYm+ngug4UilSCSq6k8YPtxDwfA+WR awIWFbgscDiULcCEaWqBFOlrLazurupOSHLqGnEKJAY8TwBEHumqUirAjNm52vEPPRV4p01XXMPAQhUB jcWm9QZwijwokgAeYHlHYA06KR1cT6ZvoV56pDUJQEjw0KeaMgj1hPEY4vz2A4eW0/e1qA7KtQdsxTYA G0H3iG4xyK1Y+xm7XmEPOJZDiENzLi2WZHngeOjj2Pe+sMg4GRYyLAsx7ME4FnsyTD9pr0PEc8zPGRAw KXBkYOPEd96cZRvf11g9MDe7e3R4Z4Q+vyEnn3P4t0XzK/W+ODN5/kPfRLewAJVEQ0AAAAASUVORK5CY II%3D" />

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

NFX7861

Document Information

Modified date:
16 June 2018

UID

swg21555357