Error with $PROJDEF expansion/subsitution

[dancomfort]

The DS jobs run fine in Prod, but when I try to run them in QA they abort.
All runtime params are set to $PROJDEF in both prod and QA.
When I check the params in the run logs, Prod has expanded correctly.

$FSCM_AS = 2000
$FSCM_IPC_BUF_SIZE = 512
$FSCM_IPC_TIMEOUT = 600
....
$FSCM_SRC_DBCONNECTION = FSPRD90

But when I check the QA log, I see this:

$FSCM_AS = 2000 [$PROJDEF]
$FSCM_IPC_BUF_SIZE = 512 [$PROJDEF]
$FSCM_IPC_TIMEOUT = 600 [$PROJDEF]
...
$FSCM_SRC_DBCONNECTION = FSPRD [$PROJDEF]

The job aborts with an oracle error since there is no database named "FSPRD $PROJDEF".

I searched the archives, but didn't find this error. I'm guessing I've missed a project setting somewhere.

I'm running 7.5.1A on Windows, PeopleSoft EPM..

[girija]

Check environment variable in QA. You will see the difference.

[girija]

2. Check this variable in your oracle stage. It is appended the value

[anbu]

Do you have connection to Database FSPRD in QA?

[dancomfort]

girija:
1. I checked the /properties/environment/user defined in administrator for both systems, and they seem to be the same; allowing for prod/QA different names.

2. I'm a relative newbie; where can I check this (append vs. replace)?

anbu:
Yes, FSPRD in the internal name of the FS QA database.

[dancomfort]

The $PROJDEF strings seem to have been a false symptom; it may be a benign results of bundle 11, which we have in QA but not Prod.

The issue turned out to be the database Source DB Connector in DSParams. Prod had FSPRD90, QA has FSPRD, an older version of the Prod DB. When the old db went away, Datastage broke! I changed the Source DB connector to "FSQA" and the job ran.

Both prod and QA databases have the internal name of "FSPRD", which helped add to my confusion.

Thanks to all for their help.