Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Unknown in xxxr0.stg_dim_bib_info

    Unknown in xxxr0.stg_dim_bib_info

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    2. Resolution
    • Article Type: General
    • Product: Aleph
    • Product Version: 2

    Description

    In Bibliographic information (xxxr0.stg_dim_bib_info) 'unknown' is displayed

    Resolution

    This is causes by special characters in the documents.
     
    This can be caused by importing books catalog from external sources originally from Windows system without proper transfer process.

    Resolution:
    Run the following SQL on xxx01 and manually fix the Z13U or Z13 record of the listed DOCS:

    select z13_rec_key, z13_author, z13_title from z13 inner join z13u on z13u_rec_key=z13_rec_key
    where (Z13U_USER_DEFINED_1 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_2 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_3 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_4 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_5 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_6 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_7 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_8 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_9 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_10 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_11 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_12 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_13 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_14 like '%'||chr(13)||'%' or
    Z13U_USER_DEFINED_15 like '%'||chr(13)||'%' or
    z13_author like '%'||chr(13)||'%' or
    z13_title like '%'||chr(13)||'%' ) ;


    The problem can be in fields such as TITLE or AUTHOR of the Z13 table (original BIB record should be fixed as well) or on Z13U record in any of the Z13U_USER_DEFINED_?? columns.

     

    Category: ETL (ARC)/ARC

    Subject: Transform and Load - ARC


    • Article last edited: 26-July-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Unix file system codes and permissions
      • Unknown Item_Status_Desc Entries in ARC
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 2
      2. contype:kba
      3. ETL (ARC)/ARC
      4. Prod:Aleph
      5. Transform and Load - ARC
      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