Dump while accessing the View

[Former Member]

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@

[Former Member]

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 .

[Former Member]

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@

[Sandeep_Panghal]

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

[Former Member]

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

Regards

VEnk@

[SuhaSaha]

Hello,

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

BR,

Suhas

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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