topic Re: Short dump while inserting into PA0008 in Application Development and Automation Discussions

Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:32:41 GMT

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.

Re: Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:36:28 GMT

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

Rob

Re: Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:39:43 GMT

Hello,

Always use MODIFY statement,

<b>MODIFY PA0008 from itab</b>

Vasanth

Re: Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:40:05 GMT

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.

Re: Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:42:24 GMT

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

Re: Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:48:58 GMT

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.

Re: Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:50:21 GMT

Hello Sandip,

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

Cheers,

Vasanth

Re: Short dump while inserting into PA0008

Former Member — Thu, 27 Sep 2007 14:53:10 GMT

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