error # 1056 - Refreshing BW queries in query browser

[former_member213493]

Hi All,

PFA, I am getting #1056 error while Refreshing BW queries in query browser. Please let me know your thoughts.

Thanks,

winod

[former_member213493 · Accepted solution]

Hi All,

SAP ask us to do the below steps and we done those steps and it is working fine. in below, 3 rd point is the root cause of this issue.

steps :

1/Disable  the antivirus test the behavior after that

2/Disable  the firewall and test the behavior after that

3/Add the @ip and the hostname of the BO server to the hosts  file of the client machine

4/Restart the tomcat and test the behavior after that

5/Generate fiddler traces and attach them to the incident :

Download : https://www.telerik.com/download/fiddler

Use fiddler : https://www.youtube.com/watch?feature=player_embedded&v=gujBKFGwjd4

Thanks,

Vinodh

[former_member182541]

Does it happens only to this query or for all connections?

Check the Connection ? Did you tried executing this query in analyzer or in RSRT, does the query runs fine ?

Do you have any input parameter enabled in the query is it a variable ? If its so please remove the prompts and try to run the query ?

[former_member213493]

Hi Suman,

it happens all the queries and also I executed the queryin RSRT and BEx analyzer too and all queries are working fine. there is no prompts too and we opened the ticket with SAP and waiting for their response too.

Regards,

Vinodh

[former_member182541]

Good please let us know, what is the exact resolution so that it can be helpful for others.

Cheers!!!