Errors while viewing data through Teradata Enterprise Stage

gsherry1 · Post by **gsherry1** » Wed Nov 16, 2005 9:03 am

Hello Forum,

I get the following Error messages while attempting to view data from client in the Teradata Enterprise stage:

#E TCOS 000005 09:55:01(004) <main_program> Invalid identifier: $
>##E TCOS 000048 09:55:01(005) <main_program> Parameter not resolvable:
##W TCOS 000049 09:55:01(017) <main_program> Parameter specified but not used in flow: _TDDB1
##W TCOS 000049 09:55:01(018) <main_program> Parameter specified but not used in flow: _TDPwd1
##W TCOS 000049 09:55:01(019) <main_program> Parameter specified but not used in flow: _TDUserId1
##W TCOS 000049 09:55:01(020) <main_program> Parameter specified but not used in flow: _TDPID
>##E TCOS 000020 09:55:01(023) <main_program> Parameterization Error: Parameterization failed.

However, the program runs fine and selects data from these stages with no warnings.

My read method is user defined sql with parameter references and Connection settings is using the DB Options with $ parameter references. The parameters shown in the warnings are the ones specified in the connection settings, but in the warnings it has replaced the $ with an _.

Any suggestions?

Thanks,

Greg

ray.wurlod · Post by **ray.wurlod** » Wed Nov 16, 2005 3:00 pm

Does your stage include a non-well-formed reference to a job parameter (for example not enclosed in "#" characters)?

gsherry1 · Post by **gsherry1** » Wed Nov 16, 2005 4:22 pm

I believe them to be all well formed, and all references have # # around them.

All options where set with 'Insert Job Parameter' option to prevent typos. The only exception was the following setting:

user=#$TDUserId1#,password='#$TDPwd1#',RequestedSessions=4

This one was partially generated by DS and then I appended the RequestedSessions setting.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 16, 2005 7:00 pm

Looks reasonable. At the risk of running in sequential mode, does it generate the warnings if you only use the built parameters? Can you post the message from the job log where the "$" characters have been converted to "_"? I haven't got a chance to investigate this this week but am beginning to suspect a bug in the stage's View Data function.

vinaymanchinila · Post by **vinaymanchinila** » Mon Oct 02, 2006 8:52 am

Hi,
I am getting the same error, even though the parameters are all correct !

Error executing View Data command:

##E TCOS 000005 10:52:03(000) <main_program> Invalid identifier: $

##E TCOS 000005 10:52:03(000) <main_program> Invalid identifier: $
##E TCOS 000048 10:52:03(001) <main_program> Parameter not resolvable:
##E TCOS 000005 10:52:03(025) <main_program> Invalid identifier: $
##E TCOS 000048 10:52:03(026) <main_program> Parameter not resolvable:
##E TCOS 000020 10:52:03(049) <main_program> Parameterization error: Parameterization failed..

Was it a bug? I dont get the issue if I dont use TD Enterprise stage and use a TD API stage.

Thanks,

bobyon · Post by **bobyon** » Thu Oct 22, 2009 7:40 am

Ray,

I too suspect a bug. I just experienced the same behaviour. View data presented almost identical errors, but when actually running the job, it runs fine.