Skip to Content
1
Mar 09, 2018 at 05:54 PM

BI 4.2 SP5 Report Conversion Tool - can't convert FHSQL

1172 Views Last edit Mar 09, 2018 at 06:09 PM 2 rev

Hi,

I am working with a new BI 4.2 SP5 Patch 1 system, installed on Windows Server 2016. It's a self-contained system with no clustering. Client Tools of the same version are also installed.

I'm trying to migrate and convert lots of Desktop Intelligence Reports from a BusinessObjects Enterprise XI R2 system. Some of these reports have Freehand SQL data sources, which use Shared Connections (there is no option to create Secured Connections with DeskI, so these connections don't show up in the Connections in the CMC on the XI R2 system.

I have already migrated these reports to the BI 4.2 system using the Upgrade Management Tool. I then try and use the RCT, with both source and target set at the BI 4.2 system, logged in as Enterprise Administrator.

When I try and convert any of these reports, they don't convert. The error reported is "Failed: Free-hand SQL connection". When I look in the RCT Audit Database, the field G_MIG_C_CAUSE = "Not available in Web Intelligence", and G_MIG_C_RESULT = "The free-hand SQL could not be recreated in the universe".

Looking in the logging folder under <installdir>\SAP BusinessObjects Enterprise XI 4.0, I can see a few .glf files generated at the same time. The javaw_<random numbers>_trace.glf has in it, amongst other things, "Designer application is not valid!". The designer_<random numbers>_trace.glf has assert failures such as "Error: wrong number of parameters in URL" and "false: Couldn't get token").

Everything I've read suggests that since BI 4.1 SP6, DeskI reports with Freehand SQL should convert to WebI reports with Freehand SQL. At the same time, it should create secured connections for each report.

I found SAP Note 2471150, which sounded similar, however that had no effect, and in fact it mentions Windows 7/8 rather than WS 2016.

I wondered if the problem was because I was migrating content from XI R2 (I've already discovered that universes fail to migrate from XI R2 to BI 4.2 SP5, so I'm having to do so via an XI 3.1 system I'm about to install. So I tried creating a Freehand SQL report in DeskI XI 3.1 SP7 FP7.3 using eFashion, saving to the Repository, upgrading to the BI 4.2 system, and converting that on the 4.2 system. This didn't convert either.

What am I missing, or is there a fault with BI 4.2 SP5 on Windows Server 2016 causing this behaviour?

Thanks
Darren