IBM E027SLL-H Troubleshooting Guide - Page 34

Resolving database problems - missing table or portal server, database, Resolving database problems

Page 34 highlights

v Yes: See step 4. v No: See "Resolving database problems - instance not started" on page 17. 4. Collect the portal server log or the operations log and look for the following text strings: v KFWDBVER, version not found v TEPS database not found v user ID or password invalid v DB2 instance not started 5. Run the Tivoli Enterprise Portal Server Analysis ITMSUPER tool. What to do next For more information on actions that relate to these diagnostics, see the problem resolution tasks. Resolving database problems - missing table or portal server database Database problems caused by a missing table or Tivoli Enterprise Portal Server database, or by a mismatch between the portal server version and the version record in the database, can be resolved by reconfiguring the portal server. About this task To resolve database problems, you perform diagnostic and corrective actions. These actions include reconfiguring the portal server. Procedure Diagnostic and corrective actions 1. To reconfigure the portal server, open Manage Tivoli Monitoring Services, right-click the portal server, and select Reconfigure. If the problem persists, run one of the following commands and set the correct password in the window that is displayed: v For an SQL database, cnpsdatasource.exe v For a DB2 database, db2datasource.exe 2. To reconfigure the portal server, take one of the following steps: v On the GUI interface, open Manage Tivoli Monitoring Services right-click the portal server, and select Reconfigure. v On the command-line interface, run the ./itmcmd config -A cq command. 3. Run the buildpresentation script. Resolving database problems - user ID and password Database problems caused by a password that does not match the operating system password or an incorrect password in the registry can be resolved by reconfiguring the Tivoli Enterprise Portal Server and verifying the user ID and password. The causes of database problems include: v Portal server database user password is out of sync. v User ID does not match the operating system logon user ID. 16 IBM Tivoli Monitoring: Troubleshooting Guide

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310

v
Yes: See step 4.
v
No: See “Resolving database problems - instance not started” on page 17.
4.
Collect the portal server log or the operations log and look for the following
text strings:
v
KFWDBVER, version not found
v
TEPS database not found
v
user ID or password invalid
v
DB2 instance not started
5.
Run the Tivoli Enterprise Portal Server Analysis ITMSUPER tool.
What to do next
For more information on actions that relate to these diagnostics, see the problem
resolution tasks.
Resolving database problems - missing table or portal server
database
Database problems caused by a missing table or Tivoli Enterprise Portal Server
database, or by a mismatch between the portal server version and the version
record in the database, can be resolved by reconfiguring the portal server.
About this task
To resolve database problems, you perform diagnostic and corrective actions. These
actions include reconfiguring the portal server.
Procedure
Diagnostic and corrective actions
1.
To reconfigure the portal server, open Manage Tivoli Monitoring
Services, right-click the portal server, and select
Reconfigure
. If the problem
persists, run one of the following commands and set the correct password in
the window that is displayed:
v
For an SQL database,
cnpsdatasource.exe
v
For a DB2 database,
db2datasource.exe
2.
To reconfigure the portal server, take one of the following steps:
v
On the GUI interface, open Manage Tivoli Monitoring Services right-click the
portal server, and select
Reconfigure
.
v
On the command-line interface, run the
./itmcmd config -A cq
command.
3.
Run the
buildpresentation
script.
Resolving database problems - user ID and password
Database problems caused by a password that does not match the operating
system password or an incorrect password in the registry can be resolved by
reconfiguring the Tivoli Enterprise Portal Server and verifying the user ID and
password.
The causes of database problems include:
v
Portal server database user password is out of sync.
v
User ID does not match the operating system logon user ID.
16
IBM Tivoli Monitoring: Troubleshooting Guide