SAP Knowledge Base Article - Preview

2146704 - UMT Error "null Statement too complex. Try rewriting the query to remove complexity"

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.