Unable to invoke a procedure with no input and output arguments using Teradata Adapter' RPC service.
book
Article ID: KB0087032
calendar_today
Updated On:
Products
Versions
TIBCO Adapter for Teradata
-
Not Applicable
-
Description
Description: Symptoms ======== The adapter throws the following error when a RPC invocation of this type is attempted.
TeradataAdapterConfiguration.TeradataAdapterConfiguration Error [Database] AETD- 000005 SQL Error - Syntax error: expected something between the word 'AddToTable' and ';'.
Impact ======
Loss of Functionality
The Stored Procedure invocation fails.
Workaround ==========
The procedure name needs to be edited in the dat file.
Suppose Test is the database and AddToTable is the procedure with no input arguments, then there is an entry in the dat file say 'call Test.AddToTable' . This needs to be changed to 'call Test.AddToTable;' [semicolon to be added at the end of proc name].
Cause ===== This is a defect with the Teradata Adapter 5.1.0. A semi-colon is missing from the procedure name in the dat file.
Resolution ======== This issue will be addressed in a future release\hotfix . Symptoms:
Cause:
Issue/Introduction
Unable to invoke a procedure with no input and output arguments using Teradata Adapter' RPC service.