[U2] INDEX taking forever to rebuild after server upgrade.
Hello, We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. The basic syntax we're using is EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX ':FILENAME:' ':FIELDNAME The output looks like Clearing Index File INDEX.007 Starting DATA processing for index 'OTHER_REF'! 2251000 processed. *** However, this used to finish in a couple minutes and now runs for HOURS without finishing. Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INDEX taking forever to rebuild after server upgrade.
Chris, Does your index return a bunch of empty string values? If so, your CREATE.INDEX command might have needed a NO.NULLS keyword to prevent index records from being created. Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Monday, April 21, 2014 11:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] INDEX taking forever to rebuild after server upgrade. Hello, We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. The basic syntax we're using is EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX ':FILENAME:' ':FIELDNAME The output looks like Clearing Index File INDEX.007 Starting DATA processing for index 'OTHER_REF'! 2251000 processed. *** However, this used to finish in a couple minutes and now runs for HOURS without finishing. Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INDEX taking forever to rebuild after server upgrade.
Chris, did you open a support case with Rocket on this? On Apr 21, 2014, at 9:39 AM, Chris Austin cjausti...@hotmail.com wrote: Hello, We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. The basic syntax we're using is EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX ':FILENAME:' ':FIELDNAME The output looks like Clearing Index File INDEX.007 Starting DATA processing for index 'OTHER_REF'! 2251000 processed. *** However, this used to finish in a couple minutes and now runs for HOURS without finishing. Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INDEX taking forever to rebuild after server upgrade.
Possibly you're indexing nulls, which will give you a very large branch of the tree. EXECUTE DELETE.INDEX : FILENAME: : FIELD.NAME EXECUTE CREATE.INDEX : FILENAME: NO.NULLS EXECUTE BUILD.INDEX : FILENAME: : FIELDNAME -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Monday, April 21, 2014 12:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] INDEX taking forever to rebuild after server upgrade. Hello, We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. The basic syntax we're using is EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX ':FILENAME:' ':FIELDNAME The output looks like Clearing Index File INDEX.007 Starting DATA processing for index 'OTHER_REF'! 2251000 processed. *** However, this used to finish in a couple minutes and now runs for HOURS without finishing. Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INDEX taking forever to rebuild after server upgrade.
Ryan, That's a good point, we do have a lot of strings with NULL so maybe setting NULLS to NO would help. Chris From: ryan.l...@meritain.com To: u2-users@listserver.u2ug.org Date: Mon, 21 Apr 2014 12:47:38 -0400 Subject: Re: [U2] INDEX taking forever to rebuild after server upgrade. Chris, Does your index return a bunch of empty string values? If so, your CREATE.INDEX command might have needed a NO.NULLS keyword to prevent index records from being created. Ryan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Monday, April 21, 2014 11:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] INDEX taking forever to rebuild after server upgrade. Hello, We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. The basic syntax we're using is EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX ':FILENAME:' ':FIELDNAME The output looks like Clearing Index File INDEX.007 Starting DATA processing for index 'OTHER_REF'! 2251000 processed. *** However, this used to finish in a couple minutes and now runs for HOURS without finishing. Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INDEX taking forever to rebuild after server upgrade.
No, we have not since I wasn't sure if it was something on our end or with the new version of UniVerse. Has this come up with anyone else by chance that you know of? Chris From: neilri...@gmail.com Date: Mon, 21 Apr 2014 09:48:07 -0700 To: u2-users@listserver.u2ug.org Subject: Re: [U2] INDEX taking forever to rebuild after server upgrade. Chris, did you open a support case with Rocket on this? On Apr 21, 2014, at 9:39 AM, Chris Austin cjausti...@hotmail.com wrote: Hello, We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. The basic syntax we're using is EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX ':FILENAME:' ':FIELDNAME The output looks like Clearing Index File INDEX.007 Starting DATA processing for index 'OTHER_REF'! 2251000 processed. *** However, this used to finish in a couple minutes and now runs for HOURS without finishing. Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] INDEX taking forever to rebuild after server upgrade.
I checked the Rocket support system and did not see anything related to poor index build performance lately. Allen’s prognosis would be a good one to follow as indexing NULLS is not good (unless thats what you really need) Neil Richards Sales Engineer Rocket Software On Apr 21, 2014, at 9:48 AM, Allen Egerton aeger...@pobox.com wrote: Possibly you're indexing nulls, which will give you a very large branch of the tree. EXECUTE DELETE.INDEX : FILENAME: : FIELD.NAME EXECUTE CREATE.INDEX : FILENAME: NO.NULLS EXECUTE BUILD.INDEX : FILENAME: : FIELDNAME -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Monday, April 21, 2014 12:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] INDEX taking forever to rebuild after server upgrade. Hello, We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. The basic syntax we're using is EXECUTE 'CREATE.INDEX ':FILENAME:' ':FIELDNAME EXECUTE 'BUILD.INDEX ':FILENAME:' ':FIELDNAME The output looks like Clearing Index File INDEX.007 Starting DATA processing for index 'OTHER_REF'! 2251000 processed. *** However, this used to finish in a couple minutes and now runs for HOURS without finishing. Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
