Data not loaded to PSA from SQL

[allen_thomas]

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.

Monitor details

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

[former_member192142 · Accepted solution]

Hi,

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.?

Best regards,

-Jacob