Spectrum Spatial (SSA/LIM)

Expand all | Collapse all

Click "See on map" error - Created table view (Solved)

  • 1.  Click "See on map" error - Created table view (Solved)

    Posted 06-30-2019 21:21

    Hi All, though I would share my recent experience.

    I've created a Custom Table view, Layer and Map and have come across a slight issue.

    This map has been added to a project and the info panel works as it should for the map project.


    ====================
    Problem:-

    When I click either "Show on Map" or "Add as annotation" the screen comes up with an error and I can't click on objects without a browser refresh.

    ========================
    Solution:-
    I found an error message using the Developer window in Chrome (F12):-

     

    {type: "com.mapinfo.midev.service.feature.ws.v1.ServiceException",…}

    1. message: "Invalid expression. Unable to resolve MI_KEY for table with no primary key for expression MI_key"
    2. type: "mapinfo.midev.service.feature.ws.v1.ServiceException"


    Looks like Primary key for the object is missing when you create a view.

     

    This works (I added "MI_KEY" field to the custom MI SQL query):-

    SELECT
    Obj, MI_Style,

    MI_KEY,

    PROP_PFI as "Prop PFI",

    MOO_PROP_NO as "Prop Number",

    EZI_ADDRESS as "Address",

    Round(MI_AREA(obj, 'sq m', 'Spherical'),4) as "Area SqM" ,

    Round(MI_AREA(obj, 'sq m', 'Spherical'),4)/10000 as "Area Ha",
    etc..... 

    FROM "/Moorabool/Data/INTEGRATION"



    After clicking "See on map" this is the result.



    ------------------------------
    Tim Warfe
    GIS Officer
    MOORABOOL SHIRE COUNCIL
    ------------------------------


  • 2.  RE: Click "See on map" error - Created table view (Solved)

    Posted 06-30-2019 21:43
    Thanks Tim
    This was one I also came across, with the result I have added the MI_KEY column to all my tables and views.

    ------------------------------
    Russell Ferguson
    Ararat Rural City Council
    Ararat
    ------------------------------



  • 3.  RE: Click "See on map" error - Created table view (Solved)

    Pitney Bowes
    Posted 07-08-2019 02:56

    ​Hi Tim,

    Appreciate you sharing your experience and solution in detail. This issue/resolution definitely warrants a knowledge base article, and here it is - link below:

    http://support.pitneybowes.com/SearchArticles/VFP06_KnowledgeWithSidebarTroubleshoot?id=kA21E000000blPgSAI&popup=false&lang=en_US



    ------------------------------
    Dave Kuo
    Pitney Bowes Australia Pty Ltd
    Australia
    ------------------------------



  • 4.  RE: Click "See on map" error - Created table view (Solved)

    Posted 07-08-2019 17:44
    Thank you @Dave Kuo.   :)​

    ------------------------------
    Tim Warfe
    GIS Officer
    MOORABOOL SHIRE COUNCIL
    ------------------------------