2708952 - Error SQL12841 returned during data extraction - SAP BW on ASE

•  While performing data extraction, it failed at one of the info package with this error message:

Error message: Error during assignment of Request REQU_xxxxxxxxxxx to Partition

• Additionally, in system log we can see the following errors with the PSA table name: 

Database error 11050 at EXE
> [ASE Error SQL12841][SAP][ASE ODBC Driver][Adaptive Server
> Enterprise]Partition names in each table or index must be
> unique. Partition name '/BIC/Bxxxxxxxxxxx' is
> specified more than once.#[ASE Error SQL11050][SAP][ASE ODBC
> Driver][Adaptive Server Enterprise]Adaptive Server cannot
> process this ALTER TABLE statement due to one or more
> preceding errors. If there are no preceding errors, please
> contact SAP Technical Support.#
Database error 11050
PSA_DECIDE_PARTNO_FAILED TRACE
-> TIME_START =xxxxxxxx
-> REQ =REQU_xxxxxx
-> DP =xxxxxxx
-> PSA TABLE =/BIC/Bxxxxxxxx
-> PARTNO =0000
-> TIME_END =xxxxxxx

• SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
• SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
• SAP Business Warehouse - All versions 

extraction, SQL12841, partition, name, unique, alter table, RSAR_PSA_CLEANUP_DIRECTORY, 11050, SQL11050 , KBA , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem