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     [Case-Opened] Error: Accesing teradata DB thru WebFocus

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Case-Opened] Error: Accesing teradata DB thru WebFocus
 Login/Join
 
Vinay Kumar
Platinum Member
posted
Hi,

I am trying to fetch the data from teradata, i could able to run the query succesfully but when i am running the procedure it is throwing the following error.

(FOC1400) SQLCODE IS -3706 (HEX: FFFFF186) XOPEN: 42000
: [37000] [NCR][ODBC Teradata Driver][Teradata Database] Syntax error: exp
: ected something between the word 'EDWTEST' and ';'.
(FOC1414) EXECUTE IMMEDIATE ERROR.

EDWTEST is the data source name.

Could any one help me on how to solve this error.

This message has been edited. Last edited by: Vinay Kumar,


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
It's kind a high important task. I couldn't able to run the procedure. Could any one help me!


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Hi Vinay,

Have you tested the DATA Adapter that have been created in webfocus to access Teradata Database ?

Is that working fine ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Ya Ram! I have tested the adapter, its working fine.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Doug
Expert
posted Hide Post
What syntax are you using? SQL passthru? TABLE FILE?
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Hi Doug, i am using SQL passthru not TABLE FILE.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
I have tried the below code also, return codes are ZERO, but i couldn't able to find where the error is.

ENGINE SQLDBC SET EDWTEST
-RUN
-TYPE &FOCERRNUM
-TYPE &RETCODE
SQL STATEMENT


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Try to debug using ECHO as ALL, and find out what error it throws.

Also could you please share the bit of code here ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Hi Ram,

Below is my piece of code.

-SET ECHO=ON
ENGINE SQLDBC SET DEFAULT_CONNECTION EDWTEST
SQL SQLDBC PREPARE SQLOUT FOR
select * from TABLE;
END
-TYPE &FOCERRNUM
-TYPE &RETCODE
-RUN

I couldn't able to find the error using ECHO=ALL.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Have a look at the configuration with EDW, i have selected "no connection" and SET the datasource EDWTEST in the textbox as in the below pic.



let me know what i have done is correct.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
-SET &ECHO='ALL';
SQL SQLDBC PREPARE SQLOUT FOR
SELECT * FROM TABLE
;
END


If you dont have more than one Teradata Adapter configured, can you try this piece of code.

Else, try to go thro the Dev Studios SQL Report wizard and generate the Report. Please check Whether your connection gets Listed out there.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
When i try thru SQL Wizard m getting the below error.



WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
quote:
Originally posted by Ramkumar - Webfous:
-SET &ECHO='ALL';
SQL SQLDBC PREPARE SQLOUT FOR
SELECT * FROM TABLE
;
END



I tried the above code, in the browser it is not fetching the records from DB. The output in browser is the same query which is written in the procedure.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Ram, any other solution?


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
From your error code FOC1671...

http://solution.ibi.com:8080/51962012.html

quote:

The above error happened because there were errors in the global profile.

The error messages were found by reviewing the EDAPRINT.
Because of the errors, the global profile was not processed and therefore
the Connections for the Data Adapters were not set.

Correcting the errors in the Global Profile solved the problem connecting to the Data Adapters.


This is the solution given in IB solutions... May be you also can check your EDAPRINT Log for more info regarding this.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Whatz the Status of the CASE that you have raised with IBI ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
I shall try the IBI solution and let you know the status! Thanks for the reply!


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
quote:
EDAPRINT Log


Ram, where can i find "EDAPRINT Log" file?


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
I found it but couldn't able to find the errors Sweating.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Senthilvasan S
Member
posted Hide Post
Vinay,

Try to check with DB Admin for the USER configured in the Adapter for Teradata has SELECT access to allow the Adapter to communicate to the DB.

And also check by creating a sample MFDs through Teradata Adapter to validate the connection.

Roll Eyes


WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL
 
Posts: 24 | Registered: April 24, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Senthilvasan,

I have tested creating MFD's, its working fine!
But i couldn't able to Query the tables!


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Senthilvasan S
Member
posted Hide Post
Try executing query in Teradata client with the user configured in the WF TD Adapter,

let me know...


WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL
 
Posts: 24 | Registered: April 24, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Senthilvasan,
I ran the query in SQL Teradata Analyser, it was succesful.


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Hi All,

Does any one have precise solution for this?


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
IB has to give you one... Should be something environemental...

Adapter - Fine
Query - Fine
Connection - Fine

Still...


Whatz your CASE's status ? Are you following up on that? Had any calls or Mail chains with them?

If this is quite urgent, Increase the severity of CASE...


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Senthilvasan S
Member
posted Hide Post
Try sample data in the MFDs created for the teradata tables, is this working...!!!


WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL
 
Posts: 24 | Registered: April 24, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Ram,

Its not urgent, but want to know the solution!


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Ramkumar - Webfous
Guru
posted Hide Post
Thatz fine Vinay...

Did you try Senthil's Idea ?

Were you able to create master files for the Tables in the Same Teradata DB and access Data through the MFDs?

Does that work for you ?


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
 
Posts: 394 | Location: Chennai | Registered: December 02, 2009Report This Post
Vinay Kumar
Platinum Member
posted Hide Post
Yes Ram! I tried its working fine!


WebFOCUS 7.6.4, Mainframe Focus
Windows XP, All Output Formats
 
Posts: 135 | Registered: November 30, 2010Report This Post
Senthilvasan S
Member
posted Hide Post
Could you post the FOCUS code and the Error message after trying again.

Also use TRACE in the code, to get the log.

Are you executing the procedure in MR or Data Server?


WebFOCUS 7 6 9
Windows XP
HTML, AHTML, PDF, EXCEL
 
Posts: 24 | Registered: April 24, 2009Report 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     [Case-Opened] Error: Accesing teradata DB thru WebFocus

Copyright © 1996-2020 Information Builders