Data no getting updated through DTP from DSO to Cube

Hi Gurus,

I am facing this problem since last week. in existing scenario i have made some development in transformation between DSO and cube. Changes wich i have made are perfectly updated in my production. Due to changes i have deleted all the data from cube , now when i am loading data from DSO to cube first of all its take all request's data in one request ( as i selected in DTP--> GET ALL DATA REQUEST BY REQUEST) .. after loading some data its throw an error " DBIF_RSQL_SQL_ERROR". i gonna refer many forums.. i have tried some of them like changing package size, increasing resources.

i have created new DTP but no use its taking all request data in one..

Please immediate response needed...

Regards,

Kavita