Author: "Matthew G. Leis" <matthew.leis AT USBANK DOT COM>
Date: Tue, 5 Oct 2010 08:58:34 -0500
After upgrading to TSM 5.5.5, we are unable to generate reports that rely on complex select queries to the database. This error is generated: ANR2914E SQL IDENTIFIER TOKEN NAME OR COMPONENT EXCEEDS 1
Hi Matt: We are on TSM 5.5.5 and are getting the same error so I'm glad to hear I'm not alone (I was wondering why the reports started erroring out like that). Below is the error I am seeing: Session
Author: "Matthew G. Leis" <matthew.leis AT USBANK DOT COM>
Date: Tue, 5 Oct 2010 10:25:41 -0500
I opened a case with IBM, here are the results: We are encountering the following APAR. IC71586: ANR2914E SQL IDENTIFIER TOKEN EXCEEDS 18 CHARACTERS AFTER UPDATETO TIVOLI STORAGE MANAGER SERVER V5.5.
Greetings Matt et al: I thought I had resolved this 18 character limitation in TSM version 5.5.5 by defining the 'from' clause 'Domains' as D, 'Nodes' as N, and 'Occupancy' as O (see Revised SQL belo
Matt: Thanks. Your suggestion worked. The only difference I can see is using dom instead of D, nod instead of N, and occ instead of O. Brilliant. Must be something about single letters it didn't like
Author: robert_clark <robert_clark AT MAC DOT COM>
Date: Thu, 7 Oct 2010 23:06:40 +0000
If you're going to load the 5.2 IDL (WebGUI), do so before upgrading to 5.5.5. Once you've upgraded to 5.5.5, the 5.2 IDL load fails. [RC] On Oct 05, 2010, at 08:25 AM, "Matthew G. Leis" <matthew.lei