Data not loaded to PSA from SQL
I am able to connect to sql server generate the data source and display table contents. But when I try uploading this data to PSA the monitor shows that the request runs indefinitely and later times out.
Data request sent off ? green
RFC to source system successful ? no colour
Does selectable data exist in the source system?no colour
Data selection successfully started ? red
Data selection successfully finished ? red
Processing error in source system reported? yes
RFC to Warehouse successful ? no colour
Processing error in Warehouse reported ? green
Processing successfully finished? no colour
All reported data packets received? no colour
All data packets complete ? no colour
Have all Processing Steps been Carried out ? green
All Data Packets Updated in all Targets? green
Inadmissable Aggregation? green
I've experienced a similar problem. This was caused by the data types in the source system. In my case a BIT datatype, that BW wasn't able to handle, so we changed the view in the source database and changed the field to INT and it worked.
Have you checked the OSS note for your particular source database and fullfilled all the requirements? Capital letters for fields name etc.?