Hi
has somebody tried to convert XI 3.1 Deski reports based on freehand SQL to Webi reports based on FHSLQ on BOBI 4.1 SP06 ?
Any luck?
thia, Tomas
tom_kar 
(BOB member since 2015-06-30)
same question one year+ after… with BO BI 4.2 SP03
imho it’s not possible - except to manually recreate the report - Am I wrong? 
tom_kar (BOB member since 2015-06-30)
I haven’t done it in BI4.2 but I have in 4.1.
The default behavior changes in SP5, however. Prior to that, a the RCT would create a new universe for each DeskI report with a FHSQL query. With SP5, the RCT would then create a native FHSQL query in the converted WebI report. Either way, you have to check off “Free hand SQL” on the report selection tab in RCT.
joepeters 
(BOB member since 2002-08-29)
thanks joe for confirmation
I have also found a related document.
http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp5_rct_user_en.pdf
RCT 14.2:
source: 3.1.7.3 dest: 4.2.3 - fail
source: 4.2.3 dest: 4.2.3 (fhsql deski report tranfered via UMT or BIAR) - fail
source: file dest: 4.2.3 - fail
by fail I mean - frozen window converting but that could be another issue
anyway Im looking forward…
tom_kar (BOB member since 2015-06-30)
I had an issue with the RCT freezing during conversion. It occurred on several versions, and I was never able to get a resolution from tech support.
The issue only occurred when I ran RCT on a workstation. When I ran it on the BO server, it worked.
joepeters (BOB member since 2002-08-29)
the problem was related to this error message: CE SDK Exception occurred : ‘A problem occurred with a file reader (FWM 02011)’ (FWM 04002)
and the solution is describbed in SAP KB 2203527 (to add param -disableAuth to all FRS)
the next problem is: DBDriver failed to load dbd_oci.dll (not a valid Win32) (WIS 10901)
…investigation in protgress…
tom_kar (BOB member since 2015-06-30)
That second message seems due to there not being an installation of Oracle client on the workstation.
Joe
joepeters (BOB member since 2002-08-29)
yep,
https://bobj-board.org/t/188852
(I had just 64bit) so now it works - I am happy =D
thanks joe
tom_kar (BOB member since 2015-06-30)
Keep in mind, if you are using db links in your FRHANDSQL reports then they wont convert at all. Went through this nightmare when upgraded 300 freehandsql reports to 4.1 webi.
NycPriya (BOB member since 2010-11-04)
That might be version-specific. I was able to convert reports with db links in FHSQL.
joepeters (BOB member since 2002-08-29)