SAP Knowledge Base Article - Preview

3593957 - Migrated Freehand SQL reports contains no data in 4.3

Symptom

  • After upgrading from SAP 4.2 to 4.3, reports using FreehandSQL were not populating with data after scheduling.
  • The document contained the column titles, but no data.
  • The issue is with only migrated FreehandSQL reports. Newly created reports in 4.3 works fine.
  • On promoting Documents/upgrading the environment, Date value in Web Intelligence Document prompts displays a random numeric value instead of a date.
    • -> For example: 12-Sep-2023 is seen as #169447680000   
  • Below are entries from CMS logs can be observed
    • [ParserValueType.Formatter::stringToDate] ERROR NumberFormatException caught, representation=#1717200000xxx


Read more...

Environment

  • Issue observed on or before SAP business objects 4.3 SP3 Patch 7.
  • FreeHand SQL
  • Any Supported operating system

Product

SAP BusinessObjects Business Intelligence platform all versions

Keywords

SAP 4.3, Upgrade, FreehandSQL, Reports, Data not populating, Bug, Date prompt, Random number, New report creation,Migrated, , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , 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.