SAP Knowledge Base Article - Preview

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

Symptom

  •  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


Read more...

Environment

  • 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 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Business Warehouse all versions

Keywords

extraction, SQL12841, partition, name, unique, alter table, RSAR_PSA_CLEANUP_DIRECTORY , KBA , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.