DSXchange

Hi all. I am using an STPPX stage within a shared container and I'm having problems passing parameters to this stage from the properties tab in the shared container. In the STPPX, I've parameterized the db credentials, name and source. When I run my job I get the following warning and fatal error.

StoreKeyingTrendChangeC35.New_Pod_Id,0: Error: ORA-12154: TNS:could not resolve the connect identifier specified
StoreKeyingTrendChangeC35.New_Pod_Id,0: Error occurred in call to ORPHCallActivePluginInitialize().

Interesting, if I hard-code the parameter values into the properties tab in the shared container, the job works fine.

Am I doing something incorrectly?

Thank you. Hans

hkiamzon wrote:Hi all. I am using an STPPX stage within a shared container and I'm having problems passing parameters to this stage from the properties tab in the shared container. In the STPPX, I've parameterized the db credentials, name and source. When I run my job I get the following warning and fatal error.

StoreKeyingTrendChangeC35.New_Pod_Id,0: Error: ORA-12154: TNS:could not resolve the connect identifier specified
StoreKeyingTrendChangeC35.New_Pod_Id,0: Error occurred in call to ORPHCallActivePluginInitialize().

Interesting, if I hard-code the parameter values into the properties tab in the shared container, the job works fine.

Am I doing something incorrectly?

Thank you. Hans

You can define Job Parameters like #DBSYSTEM#; #USERID# and #PASSWORD# for the Database Environment [Prod,Test etc], Userid and Password..in the Administrator and keyin the values there. This way, when you move the job from one environment to another [say test to prod], everything is taken care of, as in the prod environment, administrator would hold values for Production dbsystem,userid,password while in the test environment, adminstrator option would hold values for test dbsystem,userid,password...
hope this helps