Problem with InfoSpoke.

[Former Member]

Hi ,

I have a InfoSpoke which dumps the content of a cube into a DataBase table. I've checked the option to delete table before extraction. The extraction fails with the error 'Unable to delete DataBase table'. Even if, I don't check the 'Delete table before extraction' flag, the extraction dumps while trying to insert data into the table (DBIF_RSQL_TABLE_UNKNOWN) saying that table doesn't exist.

I tried dumping the InfoSpoke and recreating it. It worked! but after changing some selections and activating it again, I get the same error again!

Extraction into a flat file is working perfectly. This leaves me no clue what is goin on... can anyone help me out here?

Forgot to mention that, I get this error with/without BADI transformation.

Thanks!

Regards,

Sree

Message was edited by: Sree Damodararaj

[Former Member · Accepted solution]

Hi Sree,

It looks like a tablespace issue. You can look at the short dump in ST22 for more details. You have 2 options to resolve the issue:

1. Ask your BASIS to extend the tablespace.

2. Try to minimise your data extraction by giving data selection parameters.

Alternatively, if it had worked for the first time for the same data volume then it should work again. In that case just check whether the fields you selected in the Infohub are the same when you created them and also match them with the fields in the database table. I ha this problem during my version upgrade when one of the fields did not appear in the Infohub.(I think it was 0CALYEAR).

Bye

Dinesh

[Former Member · Accepted solution]

Thanks for ur response! But, Govind I'm as I mentioned earlier I don't have problems in Flat file extraction. the problem is with extraction into table.

Dinesh, it is not a tablespace issue. I did all these checks already and having a very simple InfoSpoke and still it wouldn't work!

Regards,

Sree

[Former Member]

Hi Sree,

In that case just check whether the fields you selected in the Infohub are the same when you created them and also match them with the fields in the database table. Sometimes the fields in the database table are less than in the infohub.

Bye

Dinesh

[Former Member]

I solved my problem. It's quite peculiar issue. When the option 'Delete table before extraction' is checked, it <b>drops</b> the table (not just delete contents!) and recreates it.

I had a view which was making using of the output tab;e table from InfoSpoke. So, after creating the view, when I try to extract, it tries to Drop the table and it fails! coz it is used in a view. But, it manages to delete the table at DB level and only SAP definition exists (i.e. u can see it in SE11, but it will give you a warning saying that table doens't exist in DB).

Here is what I did to solve my problem.

1> Delete the table from SE11 manually(deleted the view using it before doing this).

2> Uncheck the 'Delete Table Before extraction'

3> Implement the code for deleting table contents in BADI (I had some other customisations as well)

... and now it works!

Regards,

Sree

[Former Member]

Hi Sree,

I had problems with selections when dumping the data into a flat file. This was due to the volume of data (millions of records) involved.

Try extracting a small amount of data initially (making appropriate selections).

Thanks.