Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • More
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki Blurry Images in TIG
    • Sign in
    • -Exor - Wiki
      • +ALIM Document Manager
      • +AWLRS
      • Exor Accidents Manager
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • +Exor Network Manager
      • +Exor Oracle
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • +Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • +Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA API and Web Service
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • ORA-20000: HIG-0230: Inconsistency detected error on login
      • -Transportation Intelligence Gateway
        • Blurry Images in TIG
        • Login Error: Authorization Required
        • Login failure in TIG
        • Scrollbar issue in TIG 2.3 fix1
        • TIG How to export an extract to a (not ‘Imported’) catalog
        • TIG: PLS-00566: type name “DATE” cannot be constrained
      • +Video Series for Exor
      • Working From Home with Exor

     
     Questions about this article, topic, or product? Click here. 

    Blurry Images in TIG

      Product(s): Transportation Intelligence Gateway
      Version(s): 1.8d
      Environment: N\A
      Area: TIG
      Subarea: N/A

     

    Problem Description

    Images are appearing blurry while accessing TIG link

    Steps to Resolve

    1. The real longer-term fix is to convert all of the images from jpg’s to bmp’s – then modify the xna_hpms_ui package code to call the bmp's
    2. Workaround is replace procedure get_image with below fix and recompile.

    PROCEDURE get_image (p_name  IN  nm_upload_files.name%TYPE, p_type  IN  VARCHAR2 DEFAULT 'jpeg') IS

     

    t_blob          BLOB;

    t_amt           NUMBER := 30;

    t_off           NUMBER := 1;

    t_raw           RAW(4096);

     

    t_type        VARCHAR2(20);

    t_name        VARCHAR2(30);

     

    CURSOR cur_image(cp_name IN VARCHAR2, cp_type IN VARCHAR2) IS

      SELECT hu_image_contents

      FROM   hpms_ui

      WHERE  hu_file_name = cp_name

        AND hu_type = cp_type;

     

    BEGIN

     

        t_type        := 'image/' || p_type;

        t_name        := p_name;

     

        OPEN cur_image(t_name, t_type);

        FETCH cur_image INTO t_blob;

        CLOSE cur_image;

     

        OWA_UTIL.mime_header(t_type);

           

        HTP.p('Content-Length: ' || DBMS_LOB.getlength(t_blob));

        OWA_UTIL.http_header_close;

        WPG_DOCLOAD.download_file(t_blob);

         

    END;

     

      Original Author: Dinesh Gupta, Bentley Technical Support Group
    • Exor
    • images
    • Transportation Intelligence Gateway
    • Share
    • History
    • More
    • Cancel
    • Dinesh Gupta Created by Bentley Colleague Dinesh Gupta
    • When: Thu, May 14 2015 2:49 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Mon, Apr 18 2016 6:55 AM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies