Skip to Content

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

Mar 09 at 05:54 PM


avatar image


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?


10 |10000 characters needed characters left characters exceeded

I fixed your tags, please select more careful next time.

Are you able to create universes on this new server?
Both in IDT and UDT ?
How about connection creation ?
Are you able to refresh any webi reports in BILP or WRC ?

* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jawahar Konduru Mar 09 at 06:24 PM

You can try couple of options

1. Try to run RCT on Windows 7 machines rather on Server

2. FHSQL report connection - Create a secured connection in UDT exactly same name as Deski connection and try to run RCT.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for your assistance.

Unfortunately I am working remotely so don't have access to any Windows 7 Machines at the moment, so I can't try your first suggestion. I have tried the second suggestion of creating a secured connection with the same name, but it didn't make any difference, unfortunately.

Darren Smith Mar 12 at 11:33 AM

Hi, I have since tried to convert a Desktop Intelligence Document with a Freehand SQL query against a Microsoft Access Database from XI 3.1 to three different servers - BI 4.2 SP5 Patch 1, BI 4.2 SP5 RTM and BI 4.2 SP2 RTM. This failed in all three cases.

Please can anyone come up with a workflow where FHSQL DeskI reports successfully convert? Does it require the ODBC connection to be in place? Does it require the ODBC connection to have exactly the same properties including the path of the database?


10 |10000 characters needed characters left characters exceeded
Stephen Davies yesterday

Hi Darren.

I am facing exactly the same errors as you.

Our scenario is that we currently have a 4.2 SP3 environment. The old Deski XI 3 environment is still running in parallel, however, as for whatever historical reason, those reports were not migrated. But now there is a push to get off the XI 3 system and I'm finding that the Report Conversion Tool is just not working. Even if I create a brand new simple free-hand SQL report, it fails with these errors. I am uploading from Deski into the XI 3 repository and trying to use the RCT to go from XI 3 to one of our BI 4 servers.

I will let you know if I discover anything but if you do get a solution then please post it here. Many thanks.

EDIT: SAP - I would really like a solution to this...

10 |10000 characters needed characters left characters exceeded