Oracle Upsert Error

keshav0307 · Post by **keshav0307** » Thu Apr 05, 2007 7:54 am

when I am loading a oracle table, Oracle Enterprise stage, upsert methode. I am getting this following error

ORA_TRAcct: APT_OraUpsertOperator: connect failed. Environment: user: csa_user; password: *****; server: PLRS; ORACLE_SID: PLRP; ORACLE_HOME: /u01/app/oracle/product/9.2.0.

but Using using the same user name and password i can connect to the same data base using sqlplus.

i am also able to extract data from this database using Oracle Enterprise stage.

DSguru2B · Post by **DSguru2B** » Thu Apr 05, 2007 8:26 am

Does your id have load permissions to the table? Extracting data just means you have select permissioins, not necessarily insert/update permissions. Verify it from your dba.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 05, 2007 1:14 pm

What properties have you used in the stage? For example, do you have the Remote Server property set?

keshav0307 · Post by **keshav0307** » Thu Apr 05, 2007 5:33 pm

Yes, I have insert,update permission too.
I have set Remote Server =<database Name>.

it may be some environment parameter setting problem, because this job was earlier runningperfactly in other project, fpr the same table load

ray.wurlod · Post by **ray.wurlod** » Thu Apr 05, 2007 7:44 pm

Look at the "job starting" event in the log - the first event in the log, to verify the job parameter settings that were used, and in the "environment variables" event in the log (usually about the fourth event) to verify what environment variable settings were actually used.

ivannavi · Post by **ivannavi** » Mon Apr 09, 2007 3:58 am

Try to connect with sqlplus, but not from your PC. Instead use the unix sqlplus from your ETL machine where your DataStage is installed. You may want to examine the tnsnames.ora on the machine to see how the database name is stored there.