OBIEE 10 web services issues

1064912

Hi,

I want to use webservices to download the data from Answers. In case of small reports all is working correctly, but if I want to download complex report I received an error: 'Error occured while processing the query' (sometimes it passed, but I need to have a sure that if I will schedule this SSIS package I will received data). Please see below my code in VB.NET

Sub Main()

        Try

            sessionid = sawservice.logon(Dts.Variables("login").Value.ToString(), Dts.Variables("password").Value.ToString())

            repPath = Dts.Variables("*").Value.ToString

            repref.reportPath = repPath

            xmlQueryExecutionOption.async = True

            xmlQueryExecutionOption.maxRowsPerPage = 500

            xmlQueryExecutionOption.refresh = True

            xmlQueryExecutionOption.presentationInfo = False

            xmlviewservice.Timeout = 90000

            QueryResult = xmlviewservice.executeXMLQuery(repref, saw.XMLQueryOutputFormat.SAWRowsetData, xmlQueryExecutionOption, reportparams, sessionid)

            xmlviewservice.executeXMLQueryAsync(repref, saw.XMLQueryOutputFormat.SAWRowsetData, xmlQueryExecutionOption, reportparams, sessionid)

        Catch e As Exception

            MsgBox(e.Message & Chr(10) & "ExecuteQuery")

        End Try

        Try

            Using writer As New StreamWriter("*")

                Do While Not QueryResult.finished

                    QueryResult = xmlviewservice.fetchNext(QueryResult.queryID, sessionid)

                    writer.WriteLine(QueryResult.rowset.ToString())

                Loop

            End Using

        Catch ex As Exception

            MsgBox(ex.Message & Chr(10) & "Module Extracting")

          

        End Try

        sawservice.logoff(sessionid)

    End Sub

The same situation is if I run 'executeSQLQuery' - my IT departament is not cooperating with me, I don't know configuration of OBIEE, I cannot change anything in configuration.

Kind regards,

Piotr