IBM E027SLL-H Troubleshooting Guide - Page 267
Documentation for the base agents, The report fails to generate because the SQL query was not valid
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 267 highlights
To address this problem for a DB2 database, you would need to copy the following files: v db2jcc.jar v db2jcc_license_cu.jar Typically found in this default DB2 installation path or in the java directory of whatever alternate path you specified for DB2 installation, into this directory. Make these corrections and then try running the report again. Documentation for the base agents If you purchased as a product, you received a set of base monitoring agents as part of the product. If you purchased a monitoring agent product (for example, an OMEGAMON XE product) that includes the commonly shared components of , you did not receive the base agents. The following publications provide information about using the base agents. v Operating system agents: - Windows OS Agent User's Guide, SC32-9445 - UNIX OS Agent User's Guide, SC32-9446 - Linux OS Agent User's Guide, SC32-9447 - i5/OS Agent User's Guide, SC32-9448 - UNIX Log Agent User's Guide, SC32-9471 v Agentless operating system monitors: - Agentless Monitoring for Windows Operating Systems User's Guide, SC23-9765 - Agentless Monitoring for AIX Operating Systems User's Guide, SC23-9761 - Agentless Monitoring for HP-UX Operating Systems User's Guide, SC23-9763 - Agentless Monitoring for Solaris Operating Systems User's Guide, SC23-9764 - Agentless Monitoring for Linux Operating Systems User's Guide, SC23-9762 v Warehouse agents: - Warehouse Summarization and Pruning Agent User's Guide, SC23-9767 - Warehouse Proxy Agent User's Guide, SC23-9766 v System P agents: - AIX Premium Agent User's Guide, SA23-2237 - CEC Base Agent User's Guide, SC23-5239 - HMC Base Agent User's Guide, SA23-2239 - VIOS Premium Agent User's Guide, SA23-2238 v Other base agents: - Monitoring Agent for IBM Tivoli Monitoring 5.x Endpoint User's Guide, SC32-9490 The report fails to generate because the SQL query was not valid If you have made changes to the reports or to the workspace against which the query is being run, you could see SQL query errors. Typically this error looks similar to this: The following items have errors: ReportDesign (id = 1): Chapter 15. Tivoli Common Reporting troubleshooting 249
-
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