SQL error 3127 while saving message in transaction crm_dno_monitor

[Former Member]

Hi gurus,

I have configured the sap servic desk in solution manager SP13 with oracle database as 10.2.0.2.0.

I am able to post a messahe from help-->create support message and with dno_notif_create.

I am trying to configure automatic e-mail functionality. I have done the required configuration as per sapnote .But when i am changing the message from New-->to In process and trying to save the tranaction...after some time the session terminates stating" Sql error 3125".

I have check the Dump in ST22 "DBIF_REPO_SQL_ERROR it states " no new opration allowed until the current finishes..."

Here are the work process log details -->

C actual OCI-type SQLT_CHR of OUT-variable 0 differs from cached statement (SQLT_AFC) ==> reparsing

C sc_p=0643626C,no=47,idc_p=0644ADFC,con=0,act=1,slen=184,smax=256,#vars=3,stmt=19FF9208,table=REPOLOAD

C prep=1,lit=0,nsql=0,lobret=0,#exec=1,dbcnt=0,upsh_p=00000000,ocistmth_p=05AE0084

C IN : cols=3,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=86,vmax=32,bound=1,iobuf_p=19D42068,vda_p=1E446DC8

C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

C OUT: cols=9,rmax=1,xcnt=0,rpc=0,rowi=0,rtot=0,upto=-1,rsize=0,vmax=32,bound=1,iobuf_p=00000000,vda_p=1E448558

C lobs=0,lmax=0,lpcnt=0,larr=00000000,lcurr_p=00000000,rret=0

C SELECT "UNAM" , "UDAT" , "UTIME" , "L_DATALG" , "Q_DATALG" , "SDAT" , "STIME" , "MINOR_VERS" , "MAJO\

C R_VERS" FROM "REPOLOAD" WHERE "PROGNAME" = :A0 AND "R3STATE" = :A1 AND "MACH" = :A2 ;

-

---

Kindly help to solve this error

Thanks,

Rasesh

[Valdecir]

Hi Rasesh,

This error indicates you have some problem at the oracle level communication. I would suggest you to contact an Oracle DBA who would help you better solving this error.

Regards

val