not able to convert FHSQL Deski to Webi

[Former Member]

Hi Gurus,

We are on SAP BO 4.1 SP6 Patch 1,

When i try to convert Deski reports using Report Conversion Tools,

These are Free Hand SQL Reports.

error message: Failed: Error on Migration Engine

Thanks,

[former_member188911 · Accepted solution]

Hi,

you need to check the following

• Install the same connection driver (middleware) on your 4.1 environment, that you used to create the DeskI report in version 3.1.
• Verify that the client tools are exactly on the same version as your BO server.
• Make sure that 3.1 and 4.1 client tools are NOT installed on the same machine.
• Run Report Conversion Tool as an Administrator.

more details are in KBA 2161690 https://launchpad.support.sap.com/#/notes/2161690

See Also

• FHSQL in BI4.1.5 - Limitations, Gotchas, and Troubleshooting
• Freehand SQL (FHSQL) is coming to Web Intelligence
• Free-Hand SQL Feature now available with Web Intelligence 4.1 SP5
• SAP BusinessObjects Business Intelligence Suite 4.1 SP05 (SP5) Released
• BI 4 How To: Planning the Desktop Intelligence conversion to Web Intelligence
• Report Conversion Tool User Guide

Hope this helps, otherwise you should open an incident with support

Cheers

Simone

[Former Member · Accepted solution]

Hi Simone,

i have followed the below steps to convert the Report

• Install the same connection driver (middleware) on your 4.1 environment, that you used to create the DeskI report in version 3.1. "(The report in 3.1 was having OLEDB driver, so i created the driver OLEDB in 4.1 version)"
• Verify that the client tools are exactly on the same version as your BO server.
• Make sure that 3.1 and 4.1 client tools are NOT installed on the same machine.
• Run Report Conversion Tool as an Administrator.

But still i am getting the error: "Failed: Error on Migration Engine"

Can you please help me to solve this Problem.

Thanks for the Support,,,

[former_member188911 · Accepted solution]

Hi,

unfortunately this needs thorough investigation that we cannot do on a forum.

Have you tried to review the documentation links I gave you earlier, especially the first one

Thanks