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     [FIXED IN 8200] Troubles trying to index hold tables within InfoAssist:

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[FIXED IN 8200] Troubles trying to index hold tables within InfoAssist:
 Login/Join
 
CoolGuy
Virtuoso
posted
Hey all,

So, we have a scenario where we are trying to start having some "advanced" users that have access to build reports, etc. within the InfoAssist product. The first report I've assigned our first IA user is a multi-step request that contains multiple hold file requests joined together to prepare for the final report request at the end. Within the first 3 hold file requests, we are needing to index on a certain explicitly declared column/field. For some reason or rhyme, InfoAssist is not letting us do that. The procedure's request structure is as follows within the Query Panel within InfoAssist:


focusFile1 (mssql description file) still need index on column, option not visible in query pane
focusFile2 (mssql description file 2) still need index on column, option not visible in query pane

join focusFile1 to focusFile2 (should be on indexed columns)

focusFile3 (focusFile2) still need index on column 
**Note: The Index option appears for the above focusFile3 hold request (not for the above 2 requests), but doesn't allow us to use the fields we select for the index. I get an "invalid dao-object" message pop-up.**

join focusFile2 to focusFile3 (should be on indexed columns)

focusFile4 (focusFile2)

finalReport (focusFile4)


Anyone here know how to index columns for a hold request within InfoAssist? Also, anyone else run into the "invalid dao-object" error message before, and know what it means?

Any and all help is much appreciated!

Thanks in advance!

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


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
CoolGuy
Virtuoso
posted Hide Post
UPDATE:

My case worker from IBI notified me that this was already an ongoing project within the product division and will be fixed as of 8.2.xx (scheduled to release on September 30th, 2016).


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report 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     [FIXED IN 8200] Troubles trying to index hold tables within InfoAssist:

Copyright © 1996-2020 Information Builders