IBM E027SLL-H Troubleshooting Guide - Page 168

You receive a KFW error when a query is sent to more than 200, managed systems

Page 168 highlights

You receive a KFW error when a query is sent to more than 200 managed systems You receive the following error when a query is sent to more than 200 managed systems: KFWITM217E Request error: Request to xxx nodes exceeds the limit of 200. Please specify a smaller distribution or increase the maximum. There is a default limit of 200 nodes for any single query for a workspace view. If the following conditions exist in the query for a workspace view, you must increase the KFW_REPORT_NODE_LIMIT environment variable for the Tivoli Enterprise Portal server environment variable as described below: v The query is assigned to a managed system list that contains more than 200 managed systems. OR v More than 200 managed systems are explicitly assigned to a query in any workspace view. Under these conditions, you must increase the following Tivoli Enterprise Portal server environment variable. KFW_REPORT_NODE_LIMIT=xxx where xxx is an integer that is equal to or greater than one of the following: v The number of managed systems defined in a managed system list. OR v Explicitly assigned to a query over 200 in a Tivoli Enterprise Portal workspace view. You must add the KFW_REPORT_NODE_LIMIT environment variable or remove the comment marker (#) in the following Tivoli Enterprise Portal Server environment files, and restart the portal server. v Windows systems: \ibm\itm\cnps\kfwenv v Linux or AIX systems: /opt/IBM/config/cq.ini After you change the KFW_REPORT_NODE_LIMIT variable, you might receive the following error: KFWITM217E Request error: SQL1_CreateAccessPlan failed, rc=1. Typically this problem is caused when too many explicitly defined managed systems are assigned to a query for a workspace view. The best practice for resolving this problem is as follows: 1. Create a managed system list that specifies the explicitly defined managed systems. 2. Remove the explicit assignments from the query. 3. Assign the managed system list to the query. Alternatively, you can reduce the number of managed systems that you explicitly define in the query. 150 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

You receive a KFW error when a query is sent to more than 200
managed systems
You receive the following error when a query is sent to more than 200 managed
systems:
KFWITM217E Request error: Request to xxx nodes exceeds the limit of 200.
Please specify a smaller distribution or increase the maximum.
There is a default limit of 200 nodes for any single query for a workspace view. If
the following conditions exist in the query for a workspace view, you must
increase the
KFW_REPORT_NODE_LIMIT
environment variable for the Tivoli Enterprise
Portal server environment variable as described below:
v
The query is assigned to a managed system list that contains more than 200
managed systems.
OR
v
More than 200 managed systems are explicitly assigned to a query in any
workspace view.
Under these conditions, you must increase the following Tivoli Enterprise Portal
server environment variable.
KFW_REPORT_NODE_LIMIT=xxx
where
xxx
is an integer that is equal to or greater than one of the following:
v
The number of managed systems defined in a managed system list.
OR
v
Explicitly assigned to a query over 200 in a Tivoli Enterprise Portal workspace
view.
You must add the
KFW_REPORT_NODE_LIMIT
environment variable or remove the
comment marker (#) in the following Tivoli Enterprise Portal Server environment
files, and restart the portal server.
v
Windows systems:
\ibm\itm\cnps\kfwenv
v
Linux or AIX systems:
/opt/IBM/config/cq.ini
After you change the
KFW_REPORT_NODE_LIMIT
variable, you might receive the
following error:
KFWITM217E Request error: SQL1_CreateAccessPlan failed, rc=1.
Typically this problem is caused when too many explicitly defined managed
systems are assigned to a query for a workspace view. The best practice for
resolving this problem is as follows:
1.
Create a managed system list that specifies the explicitly defined managed
systems.
2.
Remove the explicit assignments from the query.
3.
Assign the managed system list to the query.
Alternatively, you can reduce the number of managed systems that you explicitly
define in the query.
150
IBM Tivoli Monitoring: Troubleshooting Guide