Report throwing error while running from schedule or in interactive mode.RQP-DEF

[mohitgupta06]

Guys..!!..below error is coming while running active report in scheduling or interactive mode..!!..

RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'. UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".

Please help me out..Thanks in advance..!!

[MFGF]

Guys..!!..below error is coming while running active report in scheduling or interactive mode..!!..

RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'. UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen".

Please help me out..Thanks in advance..!!

Hi,

Looks like you have something invalid in your report:

http://www-01.ibm.com/support/docview.wss?uid=swg21391649

It seems to be a generic error that is saying "I'm not happy with something" - but we can't say any more than that from the scarce details you have posted.

Cheers!

MF.

[mohitgupta06]

Hi ,

This is active report..!!..using transformer package

When I am scheduling this its getting failed, though its validating successfully at report studio since there is no error in that..!!

I hope I have clarified the problem..kindly help..!!

below is the error which I am getting while scheduling this ,


RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'. UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen

[MFGF]

Hi ,

This is active report..!!..using transformer package

When I am scheduling this its getting failed, though its validating successfully at report studio since there is no error in that..!!

I hope I have clarified the problem..kindly help..!!

below is the error which I am getting while scheduling this ,


RQP-DEF-0177 An error occurred while performing operation 'sqlAOpen' status='-9'. UDA-SQL-0107 A general exception has occurred during the operation "sqlAOpen

Hi,

Ok - it's an Active Report, built over a package from a Transformer cube. That doesn't really clarify much, though. We don't know how you have built the report. We don't know what objects and controls you included and how they link. All we know so far is that it's an Active Report...

As I indicated earlier, the error message is generic and doesn't give us any clues. It's just saying that something in the report is making it unhappy.

You're going to have to do some work to debug this. You could start by providing details on how the report is built. You could also try removing objects one at a time to see if it makes a difference. Although it would be nice if someone could say "Oh, the error tells me the problem is xyz", it isn't possible in this case, so you're going to have to roll your sleeves up and get busy trying to find the cause.

Cheers!

MF.