Re: Oracle 2-Tier error after login (203 Views)
Reply
Frequent Advisor
sbarber_1
Posts: 57
Registered: ‎07-01-2008
Message 1 of 7 (203 Views)

Oracle 2-Tier error after login

Hi, I am getting the below error message after a VuGen playback.
I'm using the Oracle 2-Tier protocol.
Has anyone come across this before?

Error: lrdo_ora8_exec: "OCIStmtExecute" return-code=OCI_ERROR, error-code=00001:
Error: ORA-00001: unique constraint (FCS.PK_AURA_LOGON) violated
ora8_exec: ERROR, return-code=LRDE2009. 0 row(s) processed.
What doesn't kill you only makes you stronger
Honored Contributor
AlanBooth
Posts: 1,338
Registered: ‎01-30-2008
Message 2 of 7 (203 Views)

Re: Oracle 2-Tier error after login

The command tried to update or insert a duplicate value. Google ORA-00001 for reference.
Frequent Advisor
sbarber_1
Posts: 57
Registered: ‎07-01-2008
Message 3 of 7 (203 Views)

Re: Oracle 2-Tier error after login

Thanks Alan.
Do you know how I can set automatic correlation for Oracle 2-tier script recording?
I presume this would be the correct course of action to resolve an error such as this?
What doesn't kill you only makes you stronger
Honored Contributor
AlanBooth
Posts: 1,338
Registered: ‎01-30-2008
Message 4 of 7 (203 Views)

Re: Oracle 2-Tier error after login

Sorry I do not. With the exception of Siebel I have never used auto-correlation. It did not work well when I started using LoadRunner over 10-years ago and I have never really trusted it since.

Hopefully there is someone else on the forum that can help you out.

Alan
Frequent Advisor
sbarber_1
Posts: 57
Registered: ‎07-01-2008
Message 5 of 7 (203 Views)

Re: Oracle 2-Tier error after login

Thanks Alan, I've also asked HP via a support call but I've not got an answer as yet. I'll add it here when I find out.
What doesn't kill you only makes you stronger
Frequent Advisor
sbarber_1
Posts: 57
Registered: ‎07-01-2008
Message 6 of 7 (203 Views)

Re: Oracle 2-Tier error after login

Just an update for anyone reading this.

There is no automatic correlation for the Oracle 2-Tier protocol.
After the script has been recorded, in the script view, you have to right click in the table on the value you wish to correlate and then select 'Correlate' from the menu.
What doesn't kill you only makes you stronger
Occasional Contributor
aittam
Posts: 3
Registered: ‎09-17-2012
Message 7 of 7 (169 Views)

Re: Oracle 2-Tier error after login

[ Edited ]

Hi everybody.

I got the same error while replaying an Oarcle 2-Tier script recorded on Siebel eEnergy W2k.

Could you please give me a hint on how to select the right value to correlate?

Thanks!

 

The error in VuGen is as follows:

Action.c(1505): Error: lrdo_ora8_exec: "OCIStmtExecute" return-code=OCI_ERROR, error-code=00001:
Action.c(1505): Error: ORA-00001: unique constraint (SIEBEL.S_EMPLOYEE_XM_U1) violated
Action.c(1505): ora8_exec: ERROR, return-code=LRDE2009. 0 row(s) processed

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.