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.
Message was edited by: Sree Damodararaj