Teradata connector error: offset 0 parsing parameter 0

bgs_vb · Post by **bgs_vb** » Thu Mar 13, 2014 8:44 am

Hello All,

I am trying to load data from dataset to teradata using teradata connector. I get the below error. Can someone help please.

Teradata_Connector_test: Unexpected character found at offset 0 parsing parameter 0 (CC_DBStmtParamParser::getNextToken, file CC_DBStmtParamParser.cpp, line 246)

Thanks in advance.

bgs_vb

chulett · Post by **chulett** » Thu Mar 13, 2014 9:48 am

Are you supplying any values to the stage that contain "special characters"? If not, please provide details as to how you have it configured in the job.

I'd also be curious if this is the first attempt at using that stage in your environment or other jobs have used it successfully and just this one doesn't work?

bgs_vb · Post by **bgs_vb** » Thu Mar 13, 2014 10:27 am

I am using sql server as source and yes I see few data's containing spl character like !,$ etc

I wonder whether this is issue for loading to Teradata?

This is my first attempt at using Td connector stage.

bgs_vb · Post by **bgs_vb** » Thu Mar 13, 2014 10:56 am

I filtered records with spl. character and tried to load. I get a different error as below:

TERT_test_insert,0: Fatal Error: Fatal: Unable to start MultiLoad process : MultiLoad failed: Check MultiLoad report STG_473_1_ins.rpt for details

chulett · Post by **chulett** » Thu Mar 13, 2014 11:18 am

bgs_vb wrote:This is my first attempt at using Td connector stage.

That's an important piece of information to pass along.

It would seem you've missed the 'Configure DataStage for Teradata' steps that you need to do before it knows how to run on your system. Should be documented in the Connector's manual from what I recall. It will also be online, here as one example. Also note that 'configure' includes ensuring that the TD client is installed on the DS server.