Skip to Content
avatar image
Former Member

Not Converted : Free-hand SQL connection problem

While converting a Free Hand SQL report from Desktop Intelligence to Web Intelligence report in BI XI 3.1, I am faced with the problem

Not Converted : <REPNAME> - Free-hand SQL connection problem

It is be noted that there are some other Free Hand SQL Reports, that go converted and published without any error. The subject report has two Data Providers; one referring to the Universe and other from the Free Hand SQL tagged to a DB Connection

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 29, 2014 at 05:01 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Apr 01, 2014 at 01:38 PM

    Raj,

         Conversion of free-hand SQL is NOT support at this time.  There is NO assurance if free-hand SQL will convert.

    Have at look at article that talks more about what is supported in conversion from DeskI to WebI

    Conversion from Desktop Intelligence to Web Intelligence - Business Intelligence (BusinessObjects) - SCN Wiki

    Regards,

    Ajay

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ajay,

      Some more points that can be of consideration to you to help understand my problems.

      1. The conversion from DeskI to WebI is in the same version BI XI 3.1 and not to BI 4.0 in which Free Hand SQLs is not supported.
      2. I have converted one other Free Hand SQL Report with an error "Partially Converted : <REPNAME2> - Conditional or permanent Hide Header not available in Web Intelligence", for which I had to edit the report in InfoView and un-tick the "Show When Empty" property of the table ( http://www.forumtopics.com/busobj/viewtopic.php?t=197157&view=next&sid=e6840aafa2d1267c66dae164d1dbf9db ). I think the solution mentioned in this link does not meet the purpose as the table is not displayed in the design time after the above untick.

      Coming back to our issue, further probing into this aspect I stumbled upon this link meant for RCT for BI 4.0 version

      https://csdwportal.dhhs.state.nc.us/downloads/Business%20Objects%20XI%20R4.0%20Docs/SAP%20BusinessObjects%20Report%20Con…

      where in Section 3.4.9, there is a mention of the limitation in conversion as under

      • "Conversion of reports with free-hand SQL or stored procedures is only possible in Connected mode, since the Report Conversion Tool needs to use the secured connection to the database that is saved in the CMS."

      I want to how the secured connection to the database in REPNAME2 is different from the subject report REPNAME1 as REPNAME2 got partially converted. The error reported for Subject report is "Free Hand SQL Connection Problem" and not conversion problem which can occur after the connection is established.

      I did check the security properties of various FHSQL connections in the CMC and all of them are identical in nature.

      Please advise

  • avatar image
    Former Member
    Oct 01, 2014 at 08:07 PM

    Hi Rajeswarudu,

    As far as I know when a Deski report with Free hand SQL is converted into Webi, a universe is created with the SQL.

    Which exact BO version are you using?

    Is it happening with Deski reports which only have Free Hand SQL data provider and no universe data providers?

    How many reports are giving this issue?

    If you remove the universe data provider from the report (mentioned in the description) and try to convert it into Webi, does it work?

    Regards,

    Yuvraj

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Yuvraj

      The version we are dealing with is BO XI 3.1 to BI 4.1. The RCT was initially done in 3.1 and we are experiencing problems in this version itself. RCT from BO XI 3.1 to BI 4.1 is a different ball game with it's own set of issues and hit a road block.

      In the 3.1 RCT, we had converted bulk DeskI reports to WebI. We observed that every alternate report failed to convert. There are about 60 of them. The Report canvas, the data providers of standard universe, the FHSQL are almost the same between a pair of converted and non-converted reports. Only difference are Minor changes in the SQL SELECT, WHERE clauses and field selected from standard universe.

      After lot of research and experimentation, I stumbled upon this blog http://scn.sap.com/docs/DOC-46238 and converted 18 reports using this technique.