topic Re: Dump while accessing the View in Application Development and Automation Discussions

Dump while accessing the View

Former Member — Wed, 06 Apr 2011 09:32:41 GMT

Hi Folks,

I'm ending with dump with a simple select query.

SELECT *

FROM zview_gltr_data

INTO

TABLE t_gltr_data.

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', was

neither

caught nor passed along using a RAISING clause, in the procedure

"GET_VIEW_DATA" "(FORM)"

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

How to correct the error

The exception must either be prevented, caught within the procedure

"GET_VIEW_DATA"

"(FORM)", or declared in the procedure's RAISING clause.

To prevent the exception, note the following:

Database error text........: "ORA-28000: the account is locked#ORA-02063:

preceding line from TWVERTRA"

Internal call code.........: "[RSQL/FTCH/ZVIEW_AP_TR_LOAD ]"

Please check the entries in the system log (Transaction SM21).

You may able to find an interim solution to the problem

in the SAP note system. If you have access to the note system yourself,

use the following search criteria:

Can anyone lemme know how to over come from this error.

Thks in advance

VEnK@

Re: Dump while accessing the View

Former Member — Wed, 06 Apr 2011 09:44:24 GMT

if data type or size is different in zview_gltr_data nad in t_gltr_data at that time it happen for example in ztalbe u have one field is matnr tyap is different and in internal table type is different .

Re: Dump while accessing the View

Former Member — Wed, 06 Apr 2011 10:04:19 GMT

Hi Krupa,

I'm directly refereing to table

DATA:t_gltr_data TYPE TABLE OF zview_gltr_data.

So there is no scope of size differences.

Regards

VEnK@

Re: Dump while accessing the View

Sandeep_Panghal — Wed, 06 Apr 2011 10:04:27 GMT

Why don't you try with INTO CORRESPONDING FIELDS OF TABLE .

Re: Dump while accessing the View

Former Member — Wed, 06 Apr 2011 11:16:33 GMT

I'm not allowed to use "CORRESPONDING FIELDS OF TABLE ".

Regards

VEnk@

Re: Dump while accessing the View

SuhaSaha — Wed, 06 Apr 2011 11:31:27 GMT

Hello,

You can select data from database views only! For other views(viz., Maintenance) you can use the FM 'VIEW_GET_DATA'.

BR,

Suhas

Re: Dump while accessing the View

Former Member — Wed, 06 Apr 2011 11:34:39 GMT

If Suhas response doesn't solve your problem, google ORA-28000 and speak to your DBA.

Re: Dump while accessing the View

Former Member — Wed, 06 Apr 2011 11:39:34 GMT

HI Suhas,

In my case it is projection view. So if i use VIEW_GET_DATE FM can i over come from this dump. How can this FM effect in over coming from this dump, just wanna know the technicality in this case.

And also wanna bring to you another point like, at times this select query is going fine and at times getting failed.

Regards

VEnK@

Edited by: Venkat Reddy on Apr 6, 2011 5:10 PM

Re: Dump while accessing the View

Former Member — Wed, 06 Apr 2011 11:39:36 GMT

this error comes from the DB

ORA-28000:

+ the account is locked+

Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account

Action: Wait for PASSWORD_LOCK_TIME or contact DBA

Re: Dump while accessing the View

Former Member — Wed, 06 Apr 2011 11:50:59 GMT

And also wanna bring to you another point like, at times this select query is going fine and at times getting failed.

So nice of you to mention this after all these folks spent time to try to give you an intelligent reply. Why not speak to your DBA or Basis expert about why you're getting these Oracle errors SOME OF THE TIME.