Unable to access stored procedures via Teradata Connector.
Article ID: KB0082058
Updated On:
| Products | Versions |
|---|---|
| Spotfire Connector for Teradata | All Supported Versions |
Description
When you try to access and run a stored procedure via the Spotfire Data Connector for Teradata, it may fail with the following error message:
External error:
[Teradata Database] [5510] Invalid session mode for procedure execution.
The attached "error.JPG" file illustrates this, in an image that shows a 'Data Connection" pop-up error dialog, along with the dialogs that are opened by a "Views in Connection > Stored Procedures > Run" selection sequence.
External error:
[Teradata Database] [5510] Invalid session mode for procedure execution.
The attached "error.JPG" file illustrates this, in an image that shows a 'Data Connection" pop-up error dialog, along with the dialogs that are opened by a "Views in Connection > Stored Procedures > Run" selection sequence.
Issue/Introduction
Unable to access stored procedures via Teradata Connector.
Environment
All Supported Environments
Resolution
Try changing the Teradata connection's Session mode to "ANSI".
Detailed steps:
(1) Select "File > Add Data Tables > Teradata Connection" from the main menu, then select the Teradata Connection dialog's Advanced tab.
(2) On the Advanced tab, select "ANSI" from the "Session mode" drop-down list, then press the Teradata Connection dialog's OK button to close the dialog.
(3) Press the OK button in the Add Data Tables dialog.
This is illustrated in the image of a Teradata Connection dialog in the attached "ANSI.PNG" file.
Detailed steps:
(1) Select "File > Add Data Tables > Teradata Connection" from the main menu, then select the Teradata Connection dialog's Advanced tab.
(2) On the Advanced tab, select "ANSI" from the "Session mode" drop-down list, then press the Teradata Connection dialog's OK button to close the dialog.
(3) Press the OK button in the Add Data Tables dialog.
This is illustrated in the image of a Teradata Connection dialog in the attached "ANSI.PNG" file.
Additional Information
https://community.teradata.com/t5/Database/Invalid-session-mode-for-procedure-execution/td-p/57172
Attachments
Feedback
Yes
No
Powered by
