Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    MS: Day View gives "Database Media Error!" if no 245 in bib

    • Article Type: General
    • Product: Voyager
    • Product Version: 9

    Problem Symptoms:
    * Click Day View in Media Scheduling results in "Database Media Error!"
    * Bookings for day includes an item with no 245 field in its bib record

    Cause:
    This behavior is the result of Issue VYG-6250.

    Resolution:
    VYG-6250 is resolved for Voyager 9.1.1 and higher

    Additional Information

    Replication steps:
    1. Find or create a bib where the title information is in the 246 field and no 245 tag exists.
    1.a. 245 is used to populate BIB_TEXT.TITLE_BRIEF
    1.b. Media Scheduling Day View uses BIB_TEXT.TITLE_BRIEF in display
    2. Create a booking for the item from step 1 in Media Scheduling.
    3. When saving booking, receive error message:
    Database Media Error!
    Details>>
    Return Code: 1
    Module: BOOKDAY
    Form: frmMain
    Missing Tags:
    4. Click Media Scheduling > Schedule > Day View and will not display.
    4.a. If in same session as booking, whatever was on previous screen shows in box
    4.b. If new session receive:
    Database Media Error!
    Details>>
    Return Code: 1
    Module: BOOKDAY
    Form: frmMain
    Missing Tags:
    5. In log.voyager, error logged similar to:
    mediasvr[22938] - THEWORKS - Fri Oct 10 10:31:28 2014
    - SQLError - search_sql__ppc.cxx[157]
    Function code: 4 query="select b.title_brief into :b0 from media_schedule_item m ,bib_text b where ((m.bib_id=b.bib_id and m.media_schedule_id=:b1) and m.media_schedule_trans_type_id=1)"

    Workaround:
    Option 1: Search in Media Scheduling:
    1. From a Schedule view, click Search
    2. Date > Booking date > Find Now
    3. Booking will display (Title field will be empty)

    Option 2: Populate BIB_TEXT for bib:
    1. Open record in Cataloging
    2. Add 245 tag with title to bib record.
    3. Click Save to DB

    Category: Media Scheduling - Voyager

    Subject: Voyager


    • Article last edited: 10/10/2014
    //doorbell.io feedback widged