IBM E027SLL-H Troubleshooting Guide - Page 215

The Summarization and Pruning Agent and the Warehouse Proxy

Page 215 highlights

CTIRA_HOSTNAME has no effect on log file names Setting CTIRA_HOSTNAME with the virtual host name shows the agent on the workspace as one entity no matter the node on which it is running. However, the setting has no effect on the log file names. These names still use the local nodename instead of the virtual host name. The Summarization and Pruning Agent and the Warehouse Proxy Agent do not work with DB2 9.1 Fix Pack 2 Do not try to use these agents with this version of DB2. An error of 'can bind a LONG value only for insert' appears The following message appears in the Warehouse Proxy Agent: ORA-01461: can bind a LONG value only for insert into a LONG column Upgrade to Oracle 10.1.0.5 or later. Errors in either the Warehouse Proxy Agent or Summarization and Pruning Agent logs You receive the following error in either the Warehouse Proxy Agent or Summarization and Pruning Agent logs: DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, SQLERRMC: null The solution is to increate the DB2 logging for the warehouse database. See the IBM Tivoli Monitoring for Databases: DB2 Agent User's Guide for more information. Receive a message saying that the statement parameter can only be a single select or a single stored procedure You receive the following message when connecting to a Microsoft SQL Server 2000 database on a Windows 2000 system from a Warehouse Proxy Agent on a Linux system using Microsoft SQL Server 2005 JDBC driver 1.2 April 2007. SSQL error: Exception message: sp_cursoropen/sp_cursorprepare: The statement parameter can only be a single select or a single stored procedure. This was fixed by not adding by default the selectMethod=cursor string in a Microsoft SQL Server URL, but you also must remove the string selectMethod=cursor that comes by default when choosing the Microsoft SQL Server database in the Warehouse Proxy Agent configuration panel on UNIX systems. Custom defined workspace views do not handle symbol substitution as expected v v Symbol references in the header and footer regions of custom defined workspace views do not resolve as expected in the Tivoli Enterprise Portal. Symbol references Chapter 10. Monitoring agent troubleshooting 197

  • 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

CTIRA_HOSTNAME has no effect on log file names
Setting CTIRA_HOSTNAME with the virtual host name shows the agent on the
workspace as one entity no matter the node on which it is running. However, the
setting has no effect on the log file names. These names still use the local
nodename instead of the virtual host name.
The Summarization and Pruning Agent and the Warehouse Proxy
Agent do not work with DB2 9.1 Fix Pack 2
Do not try to use these agents with this version of DB2.
An error of 'can bind a LONG value only for insert' appears
The following message appears in the Warehouse Proxy Agent:
ORA-01461: can bind a LONG value only for insert into a LONG column
Upgrade to Oracle 10.1.0.5 or later.
Errors in either the Warehouse Proxy Agent or Summarization and
Pruning Agent logs
You receive the following error in either the Warehouse ProxyAgent or
Summarization and Pruning Agent logs:
DB2 SQL error: SQLCODE: -964, SQLSTATE: 57011, SQLERRMC: null
The solution is to increate the DB2 logging for the warehouse database. See the
IBM Tivoli Monitoring for Databases: DB2 Agent User's Guide for more
information.
Receive a message saying that the statement parameter can only be a
single select or a single stored procedure
You receive the following message when connecting to a Microsoft SQL Server
2000 database on a Windows 2000 system from a Warehouse Proxy Agent on a
Linux system using Microsoft SQL Server 2005 JDBC driver 1.2 April 2007.
SSQL
error: Exception message: sp_cursoropen/sp_cursorprepare: The statement
parameter can only be a single select or a single stored procedure.
This was fixed by not adding by default the selectMethod=cursor string in a
Microsoft SQL Server URL, but you also must remove the string
selectMethod=cursor that comes by default when choosing the Microsoft SQL
Server database in the Warehouse Proxy Agent configuration panel on UNIX
systems.
Custom defined workspace views do not handle symbol substitution
as expected
v
v
Symbol references in the header and footer regions of custom defined workspace
views do not resolve as expected in the Tivoli Enterprise Portal. Symbol references
Chapter 10. Monitoring agent troubleshooting
197