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.