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] Issue with Query generation from Masterfile.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Issue with Query generation from Masterfile.
 Login/Join
 
Member
posted
Hi,
I have noticed an issue with the SQL that is being generated from a Master file.
Info: We have a Masterfile which will use few tables to fetch some data from DB. This is working as expected in Dev and stage environments with Oracle as the DB.
Of late we had a new data source (Exadata) and when we run the same report/master file it is getting broken with an SQL error. We noticed that all the table names are same in both the DB's and there is a missing parenthesis.
Need your assistance here in understanding what would be the problem. Thanks.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report This Post
Expert
posted Hide Post
What are the ORA messages ?

And can you post the Pre and Post generated SQL ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Member
posted Hide Post
Below is the error message i am getting from the caster log.
Task error: SQLCODE IS 942 (HEX: 000003AE)
No report to distribute.

When I take the query and run in from TOAD it is missing a parenthesis. When I manually keep it, query is getting executed in TOAD.
My undertanding is that the SQL will be created from Masterfile when the report is executed. If so, why is that missing parenthesis.
But in other dev environments it is preparing the right query with our any issues.


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report This Post
Master
posted Hide Post
Did you try creating master file using Synonym editor by directing fetching it from Exadata instead of reusing master files created from Oracle.

Thanks,
Ram
 
Posts: 542 | Location: Dearborn, MI | Registered: June 03, 2009Report This Post
Master
posted Hide Post
Technically Prabhakar, the SQL is generated by the adapter.

Can you provide a copy of your FEX and run a SQL trace and provide that as well. This will help us point you in the correct direction as your message is pretty vague. There are usually ways to tweak your FOCUS code so that SQL can be generated more efficiently as not everything translates properly into Oracle. This might be in your procedure or ultimately this could be in your metadata, depending how much you tweak your metadata and whether you include any define fields or not. But the best way for us to be able to move forward though is to get the ORA message, the procedure, and the SQL output.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Member
posted Hide Post
Here is the masterfile.

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


WebFOCUS 7.7.05 and 8.x
Windows, All Outputs
 
Posts: 27 | Registered: December 13, 2012Report 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] Issue with Query generation from Masterfile.

Copyright © 1996-2020 Information Builders