Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    SFX

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Knowledge Articles
    4. A-Z eJournal list searches result in Title.pm error message

    A-Z eJournal list searches result in Title.pm error message

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    No headers
    • Article Type: General
    • Product: SFX
    • Product Version: 4

    Problem Symptoms:
    When searching or browsing the SFX A-Z eJournal list, the following error message appears:
    SFX Error
    DBLayer::Base::DBEngine::_execute_single_query: Cannot execute SELECT T.OBJECT_ID FROM <instance>4.AZ_TITLE T, <instance>.AZ_LETTER_GROUP LG WHERE T.AZ_PROFILE = ? AND T.SCRIPT IN (?) AND LG.AZ_TITLE_ID = T.AZ_TITLE_ID AND BINARY( LG.AZ_LETTER_GROUP_NAME) IN ('Q') ORDER BY T.TITLE_SORT Table '<instance>4.AZ_TITLE' doesn't exist Parameters: default Latin at /exlibris/sfx_ver/sfx4_1/<instance>/lib/AZLIST/Title.pm line 60.

    Cause:
    The RSI/A-Z eJournal index has either never been built or needs to be rebuilt due to period of inactivity

    Resolution:
    1) log into the unix environment as the affected instance user
    2) type: da
    3) type: ./server_admin_util
    4) select option 7 (AZ Index)
    5) select option 1 (eJournal A-Z index tools)
    6) select option 2 ((Re)build eJournal RSI and AZ index)
    7) type: y to confirm index build
    After the build is completed, the server_admin_util menu prompt will return

    Category: A-Z List (SFX)

    Subject: SFX


    • Article last edited: 10/17/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • A-Z AutoComplete (AJAX) not working properly for titles with non-filing chars.
      • A-Z eJournal List searches returning blank results
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 4
      2. A-Z List (SFX)
      3. contype:kba
      4. Prod:SFX
      5. sfx
      6. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved