Errors while replaying Oracle-2tier Vuser script

[Jagadeesh]

I am working on VB6 client/server application with oracle 10g back
end.
It is getting recorded with Oracle 2-tier protocol. But when i am
replaying the script, i am getting errors like the following. When i
tried to auto corrlate, it is showing irrelevant parameters for
correlation. Even when I manually correlated some of the values, the
same errors are being generated.

All login credentials are correct but showing insufficient privileges.
-----------------------------------------------------------------------------------------------------------------------------
vuser_init.c(103): Error: lrdo.c/fjExec: "oexec" LDA/CDA return-
code=01937:
vuser_init.c(103): Error: ORA-01937: missing or invalid role name


user_init.c(210): Error: lrdo.c/fjParse: "oparse" LDA/CDA return-
code=01031:
vuser_init.c(210): Error: ORA-01031: insufficient privileges
vuser_init.c(210): lrd_stmt: ERROR, return-code=LRDE2009. DELETE FROM
launch_pad_log

-----------------------------------------------------------------------------------------------------------------------------

Anybody worked on client/server OR Oracle-2 tier OR database
protocols? Please help.

Jagadeesh.

[Vamsi]

refer this link

http://performancetestinginfo.blogspot.com/2009/10/working-with-loadrunner-sybase-ctlib.html

Thanks
Vamsi

[James Pulley]

"ORA-01031: insufficient privileges "

Oracle error based upon the credentials used to connect. You would
experience this same issue with any vendors tool that integrates at the
ORACLE level. Your application may be masking these errors but you are
able to see them with any tool that interacts with the ORACLE interface.

As a check against this, hook up a "sniffer" with an ORACLE decode and watch
the ORACLE messages going back and forth between client and server for the
same business process and credentials that you used to record your business
process. Odds would suggest that you will see the identical errors without
LoadRunner in the loop when looking at the protocol level.

This may be a wider indication that your test environment is not set up
properly with the proper credentials for your test users.

[Roland Jefferson JR]

Also your front end gui may be using a system login that you are
capturing when recording. Check with the dev team and see if there is
a way around it, or if they can give you a direct login.

Hope this helps,

Roland

[Jagadeesh]

Vamsi,
Thanks for the info.
I have gone through the link. There is document to be downloaded to
view the content. When i tried to donwload, it says no permission.
Please share the document if you have.

Thnaks
Jagadeesh.

On Oct 12, 9:31 pm, Vamsi <vamsi...@gmail.com> wrote:
> refer this link
>
> http://performancetestinginfo.blogspot.com/2009/10/working-with-loadr...

> > Jagadeesh.- Hide quoted text -
>
> - Show quoted text -

[Jagadeesh]

Roland,
Application is not using the windows authentication. It will prompt
for login details when i open the application.
Login is being recorded properly.

Any further suggestions?

Thanks,
Jagadeesh.

On Oct 12, 10:00 pm, Roland Jefferson JR

<rolandjefferson...@gmail.com> wrote:
> Also your front end gui may be using a system login that you are
> capturing when recording. Check with the dev team and see if there is
> a way around it, or if they can give you a direct login.
>
> Hope this helps,
>
> Roland
>

> > ---------------------------------------------------------------------------­-

> > -------------------------------------------------
> > vuser_init.c(103): Error: lrdo.c/fjExec: "oexec" LDA/CDA return-
> > code=01937:
> > vuser_init.c(103): Error:     ORA-01937: missing or invalid role name
>
> > user_init.c(210): Error: lrdo.c/fjParse: "oparse" LDA/CDA return-
> > code=01031:
> > vuser_init.c(210): Error:     ORA-01031: insufficient privileges
> > vuser_init.c(210): lrd_stmt: ERROR, return-code=LRDE2009.  DELETE FROM
> > launch_pad_log
>

> > ---------------------------------------------------------------------------­-

> > -------------------------------------------------
>
> > Anybody worked on client/server OR Oracle-2 tier OR database protocols?
> > Please help.
>

[Roland Jefferson JR]

Can you see any password encryption being recorded in your script?
Roland