IBM E027SLL-H Troubleshooting Guide - Page 91

Upgrade SQL file not found when installing application, support on the standby hub

Page 91 highlights

For example, consider an environment in which the monitoring agent for DB2 and the Linux OS agent V6.2.3 are installed on the same computer. The DB2 agent connects to the RTEMS 1 monitoring server and the OS agent connects to the RTEMS 2 monitoring server. After the upgrade, the DB2 agent connection is to RTEMS 2 rather than RTEMS 1. The same problem occurs when agents at V6.2.3 or earlier are updated using group deploy or single deploy. If you have a Tivoli Monitoring V6.2.3 (or earlier) OS agent installed on the same computer as a product monitoring agent and both agents connect to different monitoring servers, upgrade the OS agent to V6.2.3 Fix Pack 1 or later version before upgrading the other monitoring agent. Otherwise, a remote deployment upgrade of the monitoring agent causes the monitoring server connection to change to the same monitoring server that the OS agent connects to. Receive duplicate insert errors (SQL1 return code 80) after an agent switches away from the remote monitoring server and then switches back When a Global Access List hub monitoring server is installed with a previous version of a remote monitoring server, you will see duplicate insert errors (SQL1 return code 80) after an agent switches away from the remote monitoring server and then switches back. These messages do not indicate an environment execution error. Upgrade SQL file not found when installing application support on the standby hub When adding application support to the hubs in a hot standby setup, after the first hub has been seeded, you might receive an error message similar to the following about the productcode_upg.sql file not being found while seeding the second hub: Seeding support for Monitoring Agent for Microsoft SharePoint Server [8 of 10] KCIIN1602E ERROR - file not found: /boadata/IBM/ITM/tables/cicatrsq/SQLLIB/kqp_upg.sql Option "-f install|upgrade" can be used with the "itmcmd support" command to force using the pristine installation or upgrade support file for the product's application support. Seeding failed. Seeding support for Monitoring Agent for Microsoft Virtual Server [9 of 10] KCIIN1602E ERROR - file not found: /boadata/IBM/ITM/tables/cicatrsq/SQLLIB/kqr_upg.sql Option "-f install|upgrade" can be used with the "itmcmd support" command to force usingthe pristine installation or upgrade support file for the product's application support. Seeding failed. This error is not necessarily a fatal error. It simply means the application did not provide an upgrade seeding file. There are generally two types of seeding files: install and upgrade. The installer determines which one to apply by checking to see if there are already situations belonging to the application on the target hub. If no situation is found, then the installation seeding file is chosen, otherwise the upgrade seeding file is used if provided. In a hot standby setup, as soon as one hub is seeded, the other hub can copy the situations immediately. So when seeding is applied to the second hub, the installer detects existing situations and looks for the upgrade seeding file instead. Even though some applications do not provide upgrade seeding files, because the hubs automatically synchronize seeded data, it is generally not a serious issue. Seeding can still be forced on the second hub by using the -f option. Chapter 5. Installation and configuration troubleshooting 73

  • 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

For example, consider an environment in which the monitoring agent for DB2 and
the Linux OS agent V6.2.3 are installed on the same computer. The DB2 agent
connects to the RTEMS 1 monitoring server and the OS agent connects to the
RTEMS 2 monitoring server. After the upgrade, the DB2 agent connection is to
RTEMS 2 rather than RTEMS 1. The same problem occurs when agents at V6.2.3 or
earlier are updated using group deploy or single deploy.
If you have a Tivoli Monitoring V6.2.3 (or earlier) OS agent installed on the same
computer as a product monitoring agent and both agents connect to different
monitoring servers, upgrade the OS agent to V6.2.3 Fix Pack 1 or later version
before upgrading the other monitoring agent. Otherwise, a remote deployment
upgrade of the monitoring agent causes the monitoring server connection to
change to the same monitoring server that the OS agent connects to.
Receive duplicate insert errors (SQL1 return code 80) after an
agent switches away from the remote monitoring server and then
switches back
When a Global Access List hub monitoring server is installed with a previous
version of a remote monitoring server, you will see duplicate insert errors (SQL1
return code 80) after an agent switches away from the remote monitoring server
and then switches back. These messages do not indicate an environment execution
error.
Upgrade SQL file not found when installing application
support on the standby hub
When adding application support to the hubs in a hot standby setup, after the first
hub has been seeded, you might receive an error message similar to the following
about the
productcode_upg.sql
file not being found while seeding the second hub:
Seeding support for Monitoring Agent for Microsoft SharePoint Server [8 of 10]
KCIIN1602E ERROR - file not found:
/boadata/IBM/ITM/tables/cicatrsq/SQLLIB/kqp_upg.sql
Option "-f install|upgrade" can be used with the "itmcmd support" command to force
using the pristine installation or upgrade support file for the product’s
application support. Seeding failed.
Seeding support for Monitoring Agent for Microsoft Virtual Server [9 of 10]
KCIIN1602E ERROR - file not found:
/boadata/IBM/ITM/tables/cicatrsq/SQLLIB/kqr_upg.sql
Option "-f install|upgrade" can be used with the "itmcmd support" command
to force usingthe pristine installation or upgrade support file for the
product’s application support. Seeding failed.
This error is not necessarily a fatal error. It simply means the application did not
provide an upgrade seeding file. There are generally two types of seeding files:
install and upgrade. The installer determines which one to apply by checking to
see if there are already situations belonging to the application on the target hub. If
no situation is found, then the installation seeding file is chosen, otherwise the
upgrade seeding file is used if provided. In a hot standby setup, as soon as one
hub is seeded, the other hub can copy the situations immediately. So when seeding
is applied to the second hub, the installer detects existing situations and looks for
the upgrade seeding file instead. Even though some applications do not provide
upgrade seeding files, because the hubs automatically synchronize seeded data, it
is generally not a serious issue. Seeding can still be forced on the second hub by
using the -f option.
Chapter 5. Installation and configuration troubleshooting
73