RE: [U2] UD spooler entry explosion
Bill; I've seen this happen a couple of times. We thought it was a problem with SB+ compiled reports. I don't think I've seen it prior to UD 6 (but it's hard to tell). I've only looked at one (it's tough when they're that big and have the server on it's knees) but it seemed to be the report followed by pages of the header and footer with no detail lines. As far as I know it seems to just keep going until the drive fills up. Sorry, not much help other than to tell you that you're not alone Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I've been having very unusual UD spooler problems. A spooler entry, for a two page report, seems to keep loading over, and over, and over, and over into the spooler job; thus creating a spooler entry of, perhaps, 15Gb. In the past, this has shutdown our UD server. I created an environment variable for DTA_SPOOL to point to a file on another Windows drive. Now, if the spooler fills up it fills up another drive then UD doesn't crash, just spooled jobs abort. I've noticed this problem about six or seven times in the past 18 months. We run the exact same report, that created the most recent large hold file, hundreds of times over the past 30 days, using the exact same software, without incidence. I've saved the most recent 17Gb spooler file of a simple two page report, in case IBM is interested, and wonder has anyone experienced such unusual behavior on UD. Thanks, Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UD spooler entry explosion
not a problem that I recognize (having been reported and escalated to me, etc) SETPTR options specified? OS version? UniData version? Collision with backup software or AV software checking directories? no clue, really... :-( Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] "Bill Haskett" <[EMAIL PROTECTED] os.net>To Sent by: [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] UD spooler entry explosion 01/03/2008 10:11 PM Please respond to [EMAIL PROTECTED] er.u2ug.org I've been having very unusual UD spooler problems. A spooler entry, for a two page report, seems to keep loading over, and over, and over, and over into the spooler job; thus creating a spooler entry of, perhaps, 15Gb. In the past, this has shutdown our UD server. I created an environment variable for DTA_SPOOL to point to a file on another Windows drive. Now, if the spooler fills up it fills up another drive then UD doesn't crash, just spooled jobs abort. I've noticed this problem about six or seven times in the past 18 months. We run the exact same report, that created the most recent large hold file, hundreds of times over the past 30 days, using the exact same software, without incidence. I've saved the most recent 17Gb spooler file of a simple two page report, in case IBM is interested, and wonder has anyone experienced such unusual behavior on UD. Thanks, Bill Haskett Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 24881828.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic16530.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD spooler entry explosion
Wally: UD v7.1.9 Windows 2K3 Server Standard w/SP2 SETPTR 0,,,1,0,3,BRIEF,NOMESSAGE,NOEJECT,NOHEAD,BANNER UNIQUE LWMI_BILLIEB_39_1460744348 No AV software Backups done w/NTBackup and compressed with WinRAR (6 hours before report run) I reran this particular report, just now, five times with no problem. So it doesn't seem to be associated with the software. The subroutine that runs the SETPTR command is used throughout the entire application and there must be over 1,000 reports run every day, with no issues. The person who ran this particular report connects over the internet to the UD server. Yesterday, there were two 15Gb files, created by two different users over the internet. This is a pretty heavily used system and these two particular reports have been run, maybe, 250 times since the U2 Conference in SF in Nov 2007 (the last time this problem occurred) as they are two of the most popular reports on the enterprise system. I'm wondering if IBM support is interested in this, as it seems to be an intermittent problem where reproduction would be difficult. I did keep a copy of the 17Gb file from yesterday though. Thanks, Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune >Sent: Friday, January 04, 2008 7:28 AM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] UD spooler entry explosion > >not a problem that I recognize (having been reported and escalated to me, etc) > >SETPTR options specified? >OS version? >UniData version? >Collision with backup software or AV software checking directories? >no clue, really... :-( > > > Wally Terhune > SWG Client Support - Information > Management Software > U2 Support Architect b IBM U2 > Client Support Team > 4700 S. Syracuse St., Denver, CO > 80237 > Tel: (303) 773-7969 T/L > 656-7969 > Mobile: (303) 807-6222 > [EMAIL PROTECTED] > "Bill Haskett" <[EMAIL PROTECTED] os.net>To Sent by: [EMAIL PROTECTED] cc stserver.u2ug.org Subject: [U2] UD spooler entry explosion 01/03/2008 10:11 PM Please respond to u2-users@listserver.u2ug.org I've been having very unusual UD spooler problems. A spooler entry, for a two page report, seems to keep loading over, and over, and over, and over into the spooler job; thus creating a spooler entry of, perhaps, 15Gb. In the past, this has shutdown our UD server. I created an environment variable for DTA_SPOOL to point to a file on another Windows drive. Now, if the spooler fills up it fills up another drive then UD doesn't crash, just spooled jobs abort. I've noticed this problem about six or seven times in the past 18 months. We run the exact same report, that created the most recent large hold file, hundreds of times over the past 30 days, using the exact same software, without incidence. I've saved the most recent 17Gb spooler file of a simple two page report, in case IBM is interested, and wonder has anyone experienced such unusual behavior on UD. Thanks, Bill Haskett Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD spooler entry explosion
Bill wrote: UD v7.1.9 Windows 2K3 Server Standard w/SP2 SETPTR 0,,,1,0,3,BRIEF,NOMESSAGE,NOEJECT,NOHEAD,BANNER UNIQUE LWMI_BILLIEB_39_1460744348 No AV software Backups done w/NTBackup and compressed with WinRAR (6 hours before report run) I reran this particular report, just now, five times with no problem. So it doesn't seem to be associated with the software. The subroutine that runs the SETPTR command is used throughout the entire application and there must be over 1,000 reports run every day, with no issues. The person who ran this particular report connects over the internet to the UD server. Yesterday, there were two 15Gb files, created by two different users over the internet. This is a pretty heavily used system and these two particular reports have been run, maybe, 250 times since the U2 Conference in SF in Nov 2007 (the last time this problem occurred) as they are two of the most popular reports on the enterprise system. I'm wondering if IBM support is interested in this, as it seems to be an intermittent problem where reproduction would be difficult. I did keep a copy of the 17Gb file from yesterday though. We are happy to work on this problem with you, if you wish. I doubt there is anything of interest in the particular print file. I presume you have examined it for unprintable characters or such. I suspect they are mostly empty? and will likely zip down pretty small? Sounds like 'connects over the internet' may be the difference in behavior? Not sure exactly what that means in your environment. Please open a case if you want to pursue this. We can always post the eventual discovery to this list - rather than the continued dialog. Regards, Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] [demime 1.01d removed an attachment of type image/gif which had a name of 1D852900.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD spooler entry explosion
Wally: Thanks. I've submitted a case to IBM. One point to note is I couldn't find any bogus characters in the file; but I could only view the file via a DOS "more LWMI_BILLIEB_39_1460744348" command because it was too large to edit. Bill >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune >Sent: Friday, January 04, 2008 3:06 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] UD spooler entry explosion > >Bill wrote: >UD v7.1.9 >Windows 2K3 Server Standard w/SP2 >SETPTR 0,,,1,0,3,BRIEF,NOMESSAGE,NOEJECT,NOHEAD,BANNER UNIQUE LWMI_BILLIEB_39_1460744348 >No AV software >Backups done w/NTBackup and compressed with WinRAR (6 hours before report >run) > >I reran this particular report, just now, five times with no problem. So it >doesn't >seem to be associated with the software. The subroutine that runs the SETPTR command >is used throughout the entire application and there must be over 1,000 reports >run >every day, with no issues. > >The person who ran this particular report connects over the internet to the UD >server. Yesterday, there were two 15Gb files, created by two different users >over >the internet. This is a pretty heavily used system and these two particular >reports >have been run, maybe, 250 times since the U2 Conference in SF in Nov 2007 (the >last >time this problem occurred) as they are two of the most popular reports on the >enterprise system. > >I'm wondering if IBM support is interested in this, as it seems to be an intermittent >problem where reproduction would be difficult. I did keep a copy of the 17Gb >file >from yesterday though. > We are happy to work on this problem with you, if you wish. I doubt there is anything of interest in the particular print file. I presume you have examined it for unprintable characters or such. I suspect they are mostly empty? and will likely zip down pretty small? Sounds like 'connects over the internet' may be the difference in behavior? Not sure exactly what that means in your environment. Please open a case if you want to pursue this. We can always post the eventual discovery to this list - rather than the continued dialog. Regards, Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/