Solution : https://service.sap.com/sap/support/notes/514907 (SAP Service marketplace login required)
Key words :
database optimizer terminates whilst preparing complex requests due, 0b import support package 24, 0b import support package 01, 1c import support package 16, 0a import support package 08, complex database requests, complex datamart requests, proper access plan, /bi0/0p reason, object valuesplit_query_tabl_thres <number
Related Notes :
| 1139396 | Temporary database objects in BW 7.X |
| 1103409 | DB2-z/OS:BI: Queries split from query splitter are very slow |
| 1075225 | Performance Improvement during Infocube Extraction in Batch |
| 1013912 | FAQ: Oracle BW performance |
| 903627 | SQL error when you execute queries in parallel |
| 852849 | SAPSQL_INVALID_FIELDNAME DT~TC001 on infocube read |
| 811354 | Use of complex Queries slows down database system |
| 799465 | Datamart on partitioned Infocube returns SQL Syntax Error |
| 567995 | Incorrect time/date in a query or Datamart |
| 567747 | Composite note BW 3.x performance: Extraction & loading |
| 565086 | Composite SAP note: Wrong or no data in DataMart or Query |
| 551464 | Short dump UNCAUGHT EXCEPTION CX_RSR_X_MESSAGE |
| 544006 | SAPSQL_INVALID_FIELDNAME DT~CALMONTH error |
| 536223 | Activating master data with navigation attributes |
| 520821 | WRITE_DDIC_INFO-6-/SAPSQL_INVALID_FIELDNAME error |
| 458722 | SAPBWNews BW 3.0B Support Package 01 |
| 456566 | SAPBWNews BW 2.1C Support Package 16 |
| 456551 | SAPBWNews BW 2.0B Support Package 24 |
| 452632 | SAPBWNews BW 3.0A Support Package 08 |
| 449891 | Temporary database objects in BW 3.x |
| 390016 | DB2/390: BW: Database settings and performance |