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]Generic Master file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]Generic Master file
 Login/Join
 
PrakashDT
Member
posted
Hi,

We have generic master file on iSeries box. When I execute the report it goes and reads the data from default schema on DB2. Now we have created LINUX box for the purpose of scalability and this connects to the same DB2 DB on iSeries. But now the same synonym is not working in the same way. It is throwing below error. IADMIN is the admin user but I logged in using different dev user. Looks like some parameter or setting is not done properly. Could some one through some light on this issue ?

SET GRAPHSERVURL=http://172.31.8.34:8080/ibi_apps/IBIGraphServlet
SET GRAPHENGINE=GRAPH53
SET EXCELSERVURL=http://172.31.8.34:8080/ibi_apps
TABLE FILE pymast_sec_test
PRINT *
WHERE RECORDLIMIT EQ 500
WHERE READLIMIT EQ 500
END
(FOC1400) SQLCODE IS -204 (HEX: FFFFFF34) XOPEN: 42S02
: [S0002] [IBM][CLI Driver][AS] SQL0204N "IADMIN.PYMAST" is an undefined
: name. SQLSTATE=42704
L (FOC1406) SQL OPEN CURSOR ERROR. : PYMAST_SEC_TEST

Best Regards,
Prakash

This message has been edited. Last edited by: <Emily McAllister>,


WebFocus 8, OS: iSeries
 
Posts: 22 | Registered: September 23, 2015Report This Post
Waz
Expert
posted Hide Post
Sounds like your old server was not Linux, and the adapter needs to communicate a different way.

You may have to recreate your adapter config.

Just a guess though.


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
BabakNYC
Virtuoso
posted Hide Post
Compare paymast_sec_test.acx on your Linux to the one on the iSeries. Did you create synonym for the paymast_sec_test or did you copy the one you had on iSeries?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 2015Report This Post
PrakashDT
Member
posted Hide Post
Master file is a generic one. But I have created the test master file on the same table both on iSeries and LINUX.

I feel like, it has to do with settings.


WebFocus 8, OS: iSeries
 
Posts: 22 | Registered: September 23, 2015Report This Post
BabakNYC
Virtuoso
posted Hide Post
I'm not sure what a generic master file is but if you create a new master file on Linux for this table and open this master file can you get sample data? I suspect you'll get an error there as well.

What happens when you open the Adapter Connection and Test it? Do you get any errors or do you get a sampling of system tables?


WebFOCUS 8206, Unix, Windows
 
Posts: 1853 | Location: New York City | Registered: December 30, 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     [CLOSED]Generic Master file

Copyright © 1996-2020 Information Builders