topic Re: Short dump error in program SAPMV50A after modification in Application Development and Automation Discussions

Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 09:16:34 GMT

Dear gurus

i have done some modification in vl02n through Badi and it is working fine in Development server.

when i transport it to quality server and test it

it giving a short dump in vl02n while vl01n is working perfectly fine and showing my modification too..

below is the error mentioned

Database error text........: "Unsupported database type in parameter/column
    (168)."
   Internal call code.........: "[RSQL/READ/LIKP ]"
   Please check the entries in the system log (Transaction SM21).

   If the error occures in a non-modified SAP program, you may be able t
   find an interim solution in an SAP Note.
   If you have access to SAP Notes, carry out a search with the followin
   keywords:

   "DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"
   "SAPMV50A" or "MV50AFDB"
   "LIKP_SELECT"

   If you cannot solve the problem yourself and want to send an error
   notification to SAP, include the following information:

Please help

Regards

Saad Nisar

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 10:25:44 GMT

Please post your code here as well. It would help us find the problem.

Does your code do anything different based on the transaction or the data passed in from the transaction? Did you look to make sure everything is activated after the transport?

Michelle

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 10:32:58 GMT

i have created two append structure in standard tables of LIKP & LIPS which are activated and so as LIKP and LIPS

my Badi is also activated and my customized program is also activated.

While making outbound delivery in Quality server it works fine but when i want to make changes in that created delivery it throws dump error

short text
   SQL error in the database when accessing a table.



issing RAISING Clause in Interface
   Program                                 SAPMV50A
   Include                                 MV50AFDB
   Row                                     14
   Module type                             (FORM)
   Module Name                             LIKP_SELECT



rigger Location of Exception
   Program                                 SAPMV50A
   Include                                 MV50AFDB
   Row                                     20
   Module type                             (FORM)
   Module Name                             LIKP_SELECT

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 10:40:10 GMT

This could take a while.

But have you tried SE14 - activate and adjust table for LIKP?

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 10:46:45 GMT

Hi,

The error is during the extraction of data from LIKP

select single *
         into likp
         from likp
         where vbeln = likp-vbeln.

Can you share the details of columns added in LIKP ? As the error suggests, may be something related to the datatype of columns added.

Regards

Vinod

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 10:59:15 GMT

Following details were added in likp table

.APPEND	ZDELIVERYCREATEDBY	STRU	0	0	Delivery Note Created By.
ZZUSERNAME	ITEXT	CHAR	25	0	Infotype Name

and i have activated LIKP table using se14 too.

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 11:11:54 GMT

During create, this exit shouldn't be entered, should it? Only in Change/Display ?

Better practice:

Select single * from likp into lt_likp "internal table described as type of LIKP
 where vbeln eq likp-vbeln.

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 11:17:54 GMT

I did not understand

during create of what?

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 11:22:38 GMT

Hi,

Is it possible for you to paste the dump details?

Regards,

Ankur Parab

Re: Short dump error in program SAPMV50A after modification

Former Member — Thu, 22 Jul 2010 11:26:36 GMT

it started working properly

after re activating the table from se14.

Thank you all.