Symptom
- While trying to migrate BI content from 3.1 system to a 4.x system, UMT fails with the following error:
null Statement too complex. Try rewriting the query to remove complexity. Eliminating many duplicate expressions or breaking up the query
and storing interim results in a temporary table can often help resolve this error - The issue occurs when trying to move either complete content or when doing incremental migration when the content involves moving 3rd Party usergroups such as Active Directory ( AD ) or LDAP authentication.
- You have already followed the UMT best practices kbase 1904814
Read more...
Environment
SAP BI Platform 4.x (4.0 , 4.1 and above)
Upgrade Management Tool
Any supported operating platform
Product
SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1
Keywords
SAP BI platform migration upgrade UMT 3.1 4.0 4.1 4.x fail error null complex statement , KBA , csg_q , BI-BIP-UMT , Upgrade management tool , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.