IBM E027SLL-H Troubleshooting Guide - Page 268
Message SQL Statement does not return a ResultSet object, displayed, Your report fails to generate
View all IBM E027SLL-H manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 268 highlights
+ Cannot get the result set metadata. SQL statement does not return a ResultSet object. SQL error #1: DB2 SQL error: SQLCODE: -206 SQLSTATE: 42703, SQLERRMC: ASDF SQL error #2: DB2 SQL error: SQLCODE: -727,SQLSTATE: 54098, SQLERRMC: 2:-200:42703:ASDF SQL error #3: DB2 SQL error: SQLCODE: -727,SQLSTATE: 50098, SQLERRMC: 2:-200:42703:ASDF Additional information about the error might be found in the SQLERRMC file. If you experience SQL errors, try generating the report with a different set of parameters. If all executions of the report generate SQL errors, it is likely that, for some reason, the running report is not compatible with your database. Message "SQL Statement does not return a ResultSet object" displayed In this scenario, the report generation process fails to produce a report and this error message will be displayed: SQL Statement does not return a ResultSet object This message is followed by some SQL codes and the name of the table or view that is absent. This message is displayed when the tables and views from which data is to be extracted do not exist in the database. To view the SQL query that generated this problem and determine what historical data is not being collected, review the log files. See "Locations of log files" on page 245 for the locations of log files. Your report fails to generate with unexpected error messages displayed About this task In this scenario, you have defined report parameters for an OMEGAMON XE or NetView® for z/OS report and clicked Run. After a long wait, these messages are displayed: Processing has ended because of an unexpected error. See the Tivoli Common Reporting log files for more information Procedure These error messages are generated by Tivoli Common Reporting and might indicate that you need to increase the default heap size for the JVM on the java command to start the Tivoli Common Reporting server. To confirm that this is the problem, do the following: 1. Open the SystemOut.log file, found in this location: On Windows Systems: /tcr/eWas61/profiles/tcrProfile/logs/tcrServer/ 2. Confirm that this line can be found: An OutOfMemory error happened while running the report. If you find this line, do the following to correct this problem: 3. Stop Tivoli Common Reporting. 250 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