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 MessageDB_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" />
Log InLog in to view more of this document
Historical Number
NFX7861
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21555357