Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Map Error IA_190716_121057-1 when editing

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Map Error IA_190716_121057-1 when editing
 Login/Join
 
DWaybright
Platinum Member
posted
I am getting this error message when I try to edit a proportional symbol map I created in InfoAssist:

Code: 1095 Type: xFDMinit
the metadata for ENTERPRISE_ANALYTICS/MST_CRM_ACCOUNT is accessed, but not loaded(IA_190716_121057-1)(IA_190716_121057-1)

The issue seems to be when I use a field that isn't defined as a GEOMETRY_POINT (maybe a STATE or COUNTY or LATITUDE). It runs fine when I first create it, but if I try to go back in to edit the map I get the error. When I use a GEOMETRY_POINT field, I don't get the error. Has anyone else encountered this?

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
BabakNYC
Virtuoso
posted Hide Post
When you create this map do you use the Size bucket or only color? Are there missing values in either size or color?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
DWaybright
Platinum Member
posted Hide Post
Actually tried with size bucket only, color bucket only and neither. Tried excluding MISSING values in both Lat and Long fields. None of that fixed the error.

We found that if we define a geometry point field in the master file (using the lat/long fields and the "WKID" - whatever that is) then use that instead of lat/long in the map, we don't get the error. Seems like there is a bug -- why can't I just use lat/long in the IA map?

Another WF quirk, I guess. Roll Eyes


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
BabakNYC
Virtuoso
posted Hide Post
Given a WKID (Well-Known ID) spatial reference, longitude, and latitude, the GIS_POINT function builds a JSON point defining a Geometry object with the provided WKID, longitude, and latitude. The function is optimized for those SQL engines that can build a JSON geometry object. This is actually an ArcGIS concept described here: https://developers.arcgis.com/.../spatial-references/

Here's the example from the manual. Does this work for you? I don't think it's a quirk. The function creates the geopoint the same way as it does in the master. I think having it in the master makes more sense, since users shouldn't have to figure out how to deal with lat/long in IA. 

  
DEFINE FILE WF_RETAIL_LITE
GPOINT/A200 = GIS_POINT('4326', STATE_PROV_CAPITAL_LONGITUDE, STATE_PROV_CAPITAL_LATITUDE);
END
TABLE FILE WF_RETAIL_LITE
SUM FST.STATE_PROV_CAPITAL_LONGITUDE AS Longitude
FST.STATE_PROV_CAPITAL_LATITUDE AS Latitude 
FST.GPOINT AS Point
BY STATE_PROV_CAPITAL_NAME AS Capital
WHERE COUNTRY_NAME EQ 'United States'
WHERE STATE_PROV_CAPITAL_NAME LT 'C'
ON TABLE SET PAGE NOPAGE
END

This message has been edited. Last edited by: BabakNYC,


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
DWaybright
Platinum Member
posted Hide Post
If I add Latitude or Longitude in the location layer in IA, it pops up a window to set the field's geographic role and the associated coordinate field. When I click okay, it replaces the field I put under Layer with a defined "Lattitude_Longitude_Point" field which is defined using the Geo_point function. I guess I'm seeing it as a quirk because why does that then cause an unrecoverable error after I save the map? I can still run it, I just can edit it.
I think I will create the geo_point in all the applicable master files anyway.

Additional information -- it appears to only be a problem if a JOIN is involved. When only one master file is being used, it doesn't error on edit.

This message has been edited. Last edited by: DWaybright,


WebFOCUS 8.2.03 (production), 8.2.06 (testing)
AppStudio, InfoAssist
Windows, All Outputs
 
Posts: 183 | Location: Indiana | Registered: December 05, 2017Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Map Error IA_190716_121057-1 when editing

Copyright © 1996-2020 Information Builders