Performance Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Oracle 2-Tier error after login

Frequent Advisor

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
6 REPLIES
Honored Contributor Honored Contributor

Re: Oracle 2-Tier error after login

The command tried to update or insert a duplicate value. Google ORA-00001 for reference.
Frequent Advisor

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 Honored Contributor

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

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

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
Highlighted
Occasional Contributor

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