Skip to Content
0
Former Member
May 02, 2012 at 11:17 AM

CR with SAP BW related issue

44 Views

Hi,

I have a crystal report that connects to SAP BW. while refreshing the report in the CR designer it is not showing any data. Please let me know your feedback if you have faced similar issues.

Following are the details,

1. SAP integration kit is XI 3.1 SP4 FP4.1

2. CR 2008

3. All the required transport files are available in the SAP BW system.

4. Same query works fine in the SAP BW system.

While going through the trace file, i have noticed an issue


SAP: Unable to create binding handle for field "[0CALDAY]"

Following are the more details from the trace file,


MDX Query string: SELECT {[Measures].[4NCIJEHR1JPL0OZDMRJ89IQNA], [Measures].[4NCIJEPFKIBAJBITSLLKJKPD2], [Measures].[4O60KVHS470K09XUGVI7SCRXI]} ON COLUMNS, NON EMPTY CROSSJOIN([ASCFFITRA].[LEVEL01].MEMBERS, CROSSJOIN([AMCOMPCOD].[LEVEL01].MEMBERS, CROSSJOIN([0CALDAY].[LEVEL01].MEMBERS, CROSSJOIN([0AC_DOC_NO].[LEVEL01].MEMBERS, [ASCFFLOTP].[LEVEL01].MEMBERS)))) DIMENSION PROPERTIES [ASCFFITRA].[4ASCFBPCON], [ASCFFITRA].[5ASCFPDEAL] ON ROWS FROM [ATR_M003/ATR_M003_Q0001] SAP VARIABLES [APTUMM00] INCLUDING [ASPRDTYP].[52A] [APTUMM00] INCLUDING [ASPRDTYP].[53A] [APTUMM00] INCLUDING [ASPRDTYP].[55C] [APTUMM00] INCLUDING [ASPRDTYP].[55D] [APTUMM00] INCLUDING [ASPRDTYP].[55K]
[Thu Apr 26 18:13:34 2012] 2804 6668 DbExecuteQuery, treatSAPNULLAsDatabaseNULL is false.
[Thu Apr 26 18:13:34 2012] 2804 6668 ExecuteQuery, use RSR_MDX_* functions without one million cell limitations
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEHR1JPL0OZDMRJ89IQNA] is
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEHR1JPL0OZDMRJ89IQNA]-Value is
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEHR1JPL0OZDMRJ89IQNA]-Unit is CHAR
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEHR1JPL0OZDMRJ89IQNA]-Formatted Value is CHAR
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEPFKIBAJBITSLLKJKPD2] is
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEPFKIBAJBITSLLKJKPD2]-Value is
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEPFKIBAJBITSLLKJKPD2]-Unit is CHAR
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4NCIJEPFKIBAJBITSLLKJKPD2]-Formatted Value is CHAR
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4O60KVHS470K09XUGVI7SCRXI] is
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4O60KVHS470K09XUGVI7SCRXI]-Value is
[Thu Apr 26 18:14:17 2012] 2804 6668 Runtime datatype for [Measures]-[4O60KVHS470K09XUGVI7SCRXI]-Unit is CHAR
[Thu Apr 26 18:14:18 2012] 2804 6668 Runtime datatype for [Measures]-[4O60KVHS470K09XUGVI7SCRXI]-Formatted Value is CHAR
[Thu Apr 26 18:14:18 2012] 2804 7100 Requesting tuples 0 to 9999 for session 0001.8E99729A21601ED1A3F3C0B91CA08E01
[Thu Apr 26 18:14:18 2012] 2804 7100 Done retrieving. Moving on to clean up session 0001.8E99729A21601ED1A3F3C0B91CA08E01
[Thu Apr 26 18:14:18 2012] 2804 6668 SAP: Unable to create binding handle for field "[0CALDAY]" as the field was not found in the resultset metadata
[Thu Apr 26 18:14:18 2012] 2804 6668 SAP: Unable to create binding handle for field "[AMCOMPCOD]" as the field was not found in the resultset metadata
[Thu Apr 26 18:14:18 2012] 2804 6668 SAP: Unable to create binding handle for field "[ASCFFITRA]" as the field was not found in the resultset metadata
[Thu Apr 26 18:14:18 2012] 2804 6668 SAP: Unable to create binding handle for field "[ASCFFITRA]-[4ASCFBPCON]" as the field was not found in the resultset metadata
[Thu Apr 26 18:14:18 2012] 2804 6668 SAP: Unable to create binding handle for field "[ASCFFITRA]-[5ASCFPDEAL]" as the field was not found in the resultset metadata
[Thu Apr 26 18:14:18 2012] 2804 6668 SAP: Unable to create binding handle for field "[ASCFFLOTP]" as the field was not found in the resultset metadata
[Thu Apr 26 18:14:18 2012] 2804 6668 SAP: Unable to create binding handle for field "[0AC_DOC_NO]" as the field was not found in the resultset metadata