Base Article 2054721

building reports webintelligence
1

Hi
When I run my report I get error message: The following database error occurred:Invalid length parameter passed to the LEFT or substring… SAP knowledge base 2054721 IES 10901 Error INF.

The report works for certain periods but it shows this error when I run it between 2016 and 2017.

The report is based on derived table and the sql query works fine in SQL.
Is there anyway that I can get more details of this error???

Thank you

katis (BOB member since 2018-01-09)

2

Welcome to B:bob:B!

Maybe post a snippet of the SQL. You should also let us know what periods do work…

Nick Daniels :uk: (BOB member since 2002-08-15)