Solution : https://service.sap.com/sap/support/notes/1010854 (SAP Service marketplace login required)
Summary :
SAP Note addresses SQL error 7719 when maximum partition limit on SQL Server is reached during table operation. Common scenarios include during migration with SMIGR_CREATE_DDL report, which fails due to unknown partition limits in the target SQL Server, and when loading data to BW system's F fact table, where error manifests despite possible successful data load. Solution involves compressing data in source system's F fact table to reduce partition count, re-executing migration and import tasks, or decommissioning partitioning entirely for E fact tables. Enhanced SQL Server versions support more partitions, reducing occurrence likelihood.
Key words :
create/alter partition function failed, recent sql server releases, symptom sql error 7719 occurs, migration report smigr_create_ddl, compress loaded requests, sap system log, sql error 7719 occurs, error occurs, solution symptom 1, sql server
Related Notes :
| 1637822 | SAP Solution Manager 7.* Administration on MS SQL Server |
| 1178655 | E2E Diagnostics - BI InfoCube compression - information |
| 1080120 | SQL-ERROR when deleting requests or during compression |
| 888210 | NW 7.**: System copy (supplementary note) |
| 771209 | NetWeaver 04: System copy (supplementary note) |