topic Re: Data transfer - runtime error in Application Development and Automation Discussions

Data transfer - runtime error

Former Member — Thu, 16 Aug 2007 22:35:56 GMT

I am getting a dump while running my conversion program.

The dump says the following

ABAP runtime errors DBIF_RSQL_SQL_ERROR

SQL error "-310" occurred when accessing table "A627 ".

"DBIF_RSQL_SQL_ERROR"

"RV13A627 " or "RV13A627 "

"DB_UPDATE"

how to solve this....?

Re: Data transfer - runtime error

Former Member — Thu, 16 Aug 2007 22:48:03 GMT

Hi Aru,

Is it a standard program or custom program.

Can you provide more details?

Regards,

Atish

Re: Data transfer - runtime error

Former Member — Fri, 17 Aug 2007 01:06:29 GMT

Yes, it is a standard program.

this particular field is a Quantity field with field length 13 (3) (the highlighted one)

DATA:

BEGIN OF TIME_VAKE_DB OCCURS 10.

INCLUDE STRUCTURE VAKE.

INCLUDE STRUCTURE TITAB.

DATA:

END OF TIME_VAKE_DB.

DATA: BEGIN OF L_VADAT_A627, "CAT SEG FOR GROWTH A & B

KBSTAT TYPE KBSTAT,

ZZATINN TYPE ATINN VALUE '0000000004',

ZZATZHL TYPE ATZHL,

<b>ZZKTMNG TYPE KTMNG,</b>

END OF L_VADAT_A627,

DATA: G_AATZHL TYPE ATZHL. (VALUE 0030)

G_AKTMNG TYPE KTMNG. (VALUE 500.000)

CONCATENATE L_KNUMA '0000000004' G_AATZHL ITAB-KFRST

INTO TIME_VAKE_DB-VAKEY.

L_VADAT_A627-ZZATZHL = G_AATZHL.

L_VADAT_A627-ZZKTMNG = G_AKTMNG.

TIME_VAKE_DB-VADAT = L_VADAT_A627.

while debugging I find the values are getting converted to #######

L_VADAT_A627-ZZKTMNG has value ######

L_VADAT_A627 and TIME_VAKE_DB-VADAT has 00000000400030######

the system log says - "parameter 11 Non decimal value"

the dump says SQLCODE "-310"

Re: Data transfer - runtime error

Former Member — Fri, 17 Aug 2007 01:12:39 GMT

sorry it is a custom program (conversion)

Re: Data transfer - runtime error

Former Member — Fri, 17 Aug 2007 01:25:04 GMT

Hi Aru,

From where these data is coming. is it from a flat file. If yes check the data in file.

Regards,

Atish

Re: Data transfer - runtime error

Former Member — Fri, 17 Aug 2007 09:31:09 GMT

Hi,

Declare the variables in Character(C) only when u r Uploading data from flat files.

Cheers...

Santosh

Re: Data transfer - runtime error

Former Member — Fri, 17 Aug 2007 11:14:34 GMT

Hi,

HI ARU CHECK UR CODE AFTER BOLD WHICH IS NOT ENDED WITH ..

SORRY IF IT IS NOT THE ERROR

Check whether u have taken All fields are Character type or not if not . U should take all Character type and length is not lessthan Data dictionary specified length in (Maintain Source fields).

Reward points if helpful.

Thanks

Naveen khan

Message was edited by:

Pattan Naveen

Message was edited by:

Pattan Naveen

Re: Data transfer - runtime error

Former Member — Fri, 17 Aug 2007 11:21:05 GMT

Hi frend,

This can just be solved by u as u can better read the description for cause of dump and solution is available just in that only just above the code.

Regards,

Ameet

Re: Data transfer - runtime error

Former Member — Fri, 17 Aug 2007 12:58:18 GMT

HI ARU,

CHECK UR CODE AFTER BOLD WHICH IS NOT ENDED WITH ..

if u have paste as it is then go it for once.

SORRY IF IT IS NOT THE ERROR.

Reward points if helpfu.

Thanks

Naveen khan