BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Oct 19.

Report Conversion Tool, BI 4.2 and Free-Hand SQL


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
darren1090
Forum Member
Forum Member



Joined: 16 Feb 2007

Posts: 20


flag
PostPosted: Tue Mar 13, 2018 5:08 pm 
Post subject: Report Conversion Tool, BI 4.2 and Free-Hand SQL

Hi there

Please can anyone confirm if they can successfully convert a Desktop Intelligence Report with a Free-hand SQL data source, to Web Intelligence, using the Report Conversion Tool on BI 4.2?

I am specifically using BI 4.2 SP5 as source and target, having used the UMT to copy DeskI reports to the platform. I have tried this with several single DeskI reports with a very simple query, and every time I try it fails with "Failed: Free-hand SQL Connection". It never creates the connections required.

Looking in the .GLF files in the logging directory on the server, I see in a log file starting "javaw_" the following text:

"Cannot start Designer Application!"

I tried starting the BI 4.2 Universe Design Tool (FKA Designer) before using the RCT, and noted that it closed whilst trying to run the conversion. I assume the UDT is supposed to open when the RCT is creating the secured connections needed. However, this doesn't seem to happen.

I can't find anyone else reporting the same issues I am experiencing - but maybe everyone else apart from my current customer has already converted all their Freehand SQL DeskI reports!

If anyone can prove this functionality still works, at least I can work backwards from there....
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0308 seconds using 17 queries. (SQL 0.0024 Parse 0.0009 Other 0.0275)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo