Database error 322 at OPC

[Former Member]

Hi experts,

Sorry for asking this silly question.

Today while performing manual monitoring ,i have come across the following error in SM21 transaction.

Database error 322 at OPC

Following is the trace:

C  *** ERROR =>   execute() of C_0745, #rec=0, rc=1, rcSQL=322

[dbsdbsql.cpp 1689]

C  *** ERROR => EXECUTE C_0745 on connection 0, rc=322

[dbslsdb.cpp  9778]

C  SQLCODE    : 322

C  SQLERRTEXT : cannot use duplicate view name:  [322] "SAPABAP1"."/IBP/CL_NETVI_VIEW=>CREATE_PRODRES_SOURCE_VIEW#st\

C               b2#20150506091527": line 9 col 3 (at pos 231): [322] (range 3) cannot use duplicate view name except\

C               ion: cannot use duplicate view name:  [322] "SAPABAP1"."/IBP/CL_NETVI_VIEW=>CREATE_PRODRES_SOURCE_VI\

C               EW": line 221 col 5 (at pos 9058): [322] (range 3) cannot use duplicate view name exception: cannot \

C               use duplicate view name: SOPNZ_S66_PRODRES_SOURCE_VIEW: line 1 col 23 (at pos 22)

C  sc_p=7f7a69c054e8,no=745,idc_p=(nil),con=0,act=1,slen=89,smax=256,#vars=2,stmt=9d27270,table="/IBP/CL_NETVI_VIEW=>CREATE_PR

C  CALL  "/IBP/CL_NETVI_VIEW=>CREATE_PRODRES_SOURCE_VIEW#stb2#20150506091527"  (  ? ,  ?  ) ;

B  ***LOG BY2=> sql error 322 performing OPC [dbds         346]

B  ***LOG BY0=> cannot use duplicate view name:  [322] "SAPABAP1"."/IBP/CL_NETVI_VIEW=>CREATE_PRODRES_SOURCE_VIEW#stb2#2015050609152

I am using HANA DB.

I am aware that the error code 322 means that it cant use the duplicate view name.

Could you please suggest how to avoid this error in future.

Many thanks in advance.

Regards

Arun

[Sriram2009 · Accepted solution]

Hi Arun

Could you check this SAP KBA

1897236 - HANA: Error "insufficient privilege: Not authorized" in SM21

BR

SS

[Former Member · Accepted solution]

Hi sriram,

I have checked the above SAP KBA but i was not able to find anything relevent to the error.

The note explains more of Database error 258 at OPC while in my case it is

Database error 322 at OPC

Regards

Arun

[Sriram2009 · Accepted solution]

Hi Arun

Thanks for your info,

Could you check this SAP Note correction

2049209 - HANA: many error messages for duplicate view name (SQL error code = 322 ) in Syslog

BR

SS

[Former Member · Accepted solution]

Hi sriram,

I have checked the above note,looks more relevant to my case.

However the error is no longer re-occurring in our monitoring.

But Many thanks for your reply.

Regards

Arun