Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Short dump while inserting into PA0008

Former Member

‎2007 Sep 27 3:32 PM

0 Likes
924

Hi Gurus,

I am trying to use a transfer tool to import employee details from one system to another.

All infotypes are being imported properly but the table PA0008 is not getting imported and

it gives short dump when the program reaches the statement :

"INSERT (AKT-TABLE) FROM W_PREL."

The dump is shown as "DBIF_RSQL_INVALID_REQUEST".The reason are not clear.

Any hints please ?

Waiting for responses,

Sandip.

Hi Gurus,

I am trying to use a transfer tool to import employee details from one system to another.

All infotypes are being imported properly but the table PA0008 is not getting imported and

it gives short dump when the program reaches the statement :

"INSERT (AKT-TABLE) FROM W_PREL."

The dump is shown as "DBIF_RSQL_INVALID_REQUEST".The reason are not clear.

Any hints please ?

Waiting for responses,

Sandip.

Reply
7 REPLIES 7
Read only

Former Member

‎2007 Sep 27 3:36 PM

0 Likes
883

There should be a further description of the error message in the dump.

Rob

Read only

Former Member
In response to Former Member

‎2007 Sep 27 3:40 PM

0 Likes
883

Yes there is.

It is as follows :

"Invalid database interface call in the statement where table "PA0008 "

The current ABAP/4 program terminated due to

an internal error in the database interface.

"

Read only

Former Member

‎2007 Sep 27 3:39 PM

0 Likes
883

Hello,

Always use MODIFY statement,

<b>MODIFY PA0008 from itab</b>

Vasanth

Read only

Former Member

‎2007 Sep 27 3:42 PM

0 Likes
883

Hi

How you are inserting data into PA0008?

You can use HR_INFOTYPE_CREATION fun module to insert data .

See the dump completely in ST22 tcode and analyse it

always better to use MODIFY statement instead of INSERT statement to insert the data into tables/infotypes.

do like that, and check the Dump.

Regards

Anji

Read only

Former Member
In response to Former Member

‎2007 Sep 27 3:48 PM

0 Likes
883

Thanks for your response.

Actually I am not supposed to change the program.So,I want to know why this is happening when all other tables are going in fine.

Thanks once again,

Sandip.

Read only

Former Member
In response to Former Member

‎2007 Sep 27 3:50 PM

0 Likes
883

Hello Sandip,

This is due to the table is not accepting the Duplicate entries.

Cheers,

Vasanth

Read only

Former Member

‎2007 Sep 27 3:53 PM

0 Likes
883

Make sure that the table referred to by AKT-TABLE and the work area W_PREL have the same structure. I think this may be your problem.

Rob