• Replies 2 replies
  • Subscribers 336 subscribers
  • Views 46 views
  • Users 0 members are here
Related

Full Text Search

Marty Jones
$organization

We are starting to incorporate full text searching into our website but looks like I am having an issues with my full text search. The last time that my fulltext_complete_dt in t_inventory is back in January.

I have date as recent as today in fulltext_request_dt. I have ran the procedure tp_populate_fulltext manually multiple times using full and incremental modes and even supplied an @p_inv_no with a value of one of the productions that had a fulltext_request_dt of today and a fulltext_complete_dt of "null".

I have ran out of ideas to try, know anything else I can try?

Thanks,

Parents
  • $organization

    Hi Marty,

    There is a Global Ticket on TASK (#24440) that talks about a bug causing the fulltext search update on t_inventory to fail with a patch included to fix it.
    Here is the description from the ticket

    When the TP_POPULATE_FULLTEXT procedure was modified for the v8.0.0.2 patch, debugging code was inadvertently left in place that caused the procedure to stop working, causing the fulltext search update on T_INVENTORY to fail.  This problem exists in versions 8.0.0.2 and 8.0.0.3.  While the problem will be corrected for v9.0, attached to this ticket is a corrected version of this procedure for v8.0.  If you are running v8.0.0.2 or v8.0.0.3, please download the attached zip file, unzip it and execute the resulting script in a Management Studio Query window and the procedure will then function properly.  After you execute this script, you should rebuild your fulltext index in full mode by running the following command:  TP_POPULATE_FULLTEXT @mode = ‘F’.



    [edited by: Ryan Rowell at 5:12 PM (GMT -6) on 13 Jul 2009]
  • $organization in reply to Ryan Rowell

    Oh! You mean that little pop up window I get when I log into Task that I keep closing without reading???

    <<Marty sticks his head in the sand>>

     

    Thanks Ryan, it fixed the issue.

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Monday, July 13, 2009 5:16 PM
    To: Martin A. Jones
    Subject: Re: [Tessitura Technical Forum] Full Text Search

     

    Hi Marty,

    There is a Global Ticket on TASK (#24440) that talks about a bug in updating t_inventory with a patch included to fix it.
    Here is the description from the ticket

    When the TP_POPULATE_FULLTEXT procedure was modified for the v8.0.0.2 patch, debugging code was inadvertently left in place that caused the procedure to stop working, causing the fulltext search update on T_INVENTORY to fail.  This problem exists in versions 8.0.0.2 and 8.0.0.3.  While the problem will be corrected for v9.0, attached to this ticket is a corrected version of this procedure for v8.0.  If you are running v8.0.0.2 or v8.0.0.3, please download the attached zip file, unzip it and execute the resulting script in a Management Studio Query window and the procedure will then function properly.  After you execute this script, you should rebuild your fulltext index in full mode by running the following command:  TP_POPULATE_FULLTEXT @mode = ‘F’.

    From: Marty Jones <bounce-martyjones7649@tessituranetwork.com>
    Sent: 7/13/2009 4:54:55 PM

    We are starting to incorporate full text searching into our website but looks like I am having an issues with my full text search. The last time that my fulltext_complete_dt in t_inventory is back in January.

    I have date as recent as today in fulltext_request_dt. I have ran the procedure tp_populate_fulltext manually multiple times using full and incremental modes and even supplied an @p_inv_no with a value of one of the productions that had a fulltext_request_dt of today and a fulltext_complete_dt of "null".

    I have ran out of ideas to try, know anything else I can try?

    Thanks,




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization in reply to Ryan Rowell

    Oh! You mean that little pop up window I get when I log into Task that I keep closing without reading???

    <<Marty sticks his head in the sand>>

     

    Thanks Ryan, it fixed the issue.

     

     

     

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Ryan Rowell
    Sent: Monday, July 13, 2009 5:16 PM
    To: Martin A. Jones
    Subject: Re: [Tessitura Technical Forum] Full Text Search

     

    Hi Marty,

    There is a Global Ticket on TASK (#24440) that talks about a bug in updating t_inventory with a patch included to fix it.
    Here is the description from the ticket

    When the TP_POPULATE_FULLTEXT procedure was modified for the v8.0.0.2 patch, debugging code was inadvertently left in place that caused the procedure to stop working, causing the fulltext search update on T_INVENTORY to fail.  This problem exists in versions 8.0.0.2 and 8.0.0.3.  While the problem will be corrected for v9.0, attached to this ticket is a corrected version of this procedure for v8.0.  If you are running v8.0.0.2 or v8.0.0.3, please download the attached zip file, unzip it and execute the resulting script in a Management Studio Query window and the procedure will then function properly.  After you execute this script, you should rebuild your fulltext index in full mode by running the following command:  TP_POPULATE_FULLTEXT @mode = ‘F’.

    From: Marty Jones <bounce-martyjones7649@tessituranetwork.com>
    Sent: 7/13/2009 4:54:55 PM

    We are starting to incorporate full text searching into our website but looks like I am having an issues with my full text search. The last time that my fulltext_complete_dt in t_inventory is back in January.

    I have date as recent as today in fulltext_request_dt. I have ran the procedure tp_populate_fulltext manually multiple times using full and incremental modes and even supplied an @p_inv_no with a value of one of the productions that had a fulltext_request_dt of today and a fulltext_complete_dt of "null".

    I have ran out of ideas to try, know anything else I can try?

    Thanks,




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data