Database Error while refreshing webi report

[Former Member]

Hi,

I am getting following error while refreshing webi report. And also all my scheduled webi reports are getting failed because of same issue. What would be the reason for this error.

Regards,

PRK

[Former Member · Accepted solution]

Hi All,

I am getting below error when i click on "Test Connection". And no password has changed for this user since from long time.

[Former Member · Accepted solution]

Hi Praveen,

Check if user got locked in BW (Backend).If yes unlock.

[Former Member · Accepted solution]

Hi Sathish,

Same has been verified, there is no locks found on that user. And it's a background user. No one login with this userid.

Regards,

PRK.

[Former Member · Accepted solution]

Did you checked you can able to open and refresh the BEx query in RSRT/Analyzer  with the user.

Do this user have reporting role assigned in BW?

[Former Member · Accepted solution]

HI Sathish,

We are facing this issue only for Relational connection. And same user and password is used in OLAP connection and they are working fine.

Regards,

PRK.

[Former Member · Accepted solution]

Hi Praveen,

We should go with the OLAP connection only when connecting to BEx query.

Relational connections are to connect DSO.

[Former Member · Accepted solution]

HI Sathish,

Sorry for my earlier post. Source of my relational connection is BW Infocube not bex query. My sincere apologies for wrong information.

As i told you earlier there is no issue upto last Saturday. Issue started form sunday onwards.

Regards,

PRK.

[Former Member · Accepted solution]

Hi Praveen ,

Hope you did JCo configuration in BW/BO .

below threads may be helpful

SAP BW With RFC JCO Connections In Information Design Tool - Business Intelligence (BusinessObjects)...

[Former Member · Accepted solution]

HI All,

Thanks for your support and valuable feed back.

Issue resolved. IN CMC Adaptive processing server is not active. We have restarted the server, now it's working fine.

Regards,

PRK.