Please let me know if any more information is required to explain the situation.
1. So you're using Tableau Desktop 8.2 to create the workbooks but publishing to Tableau Server 8.1, correct?
- If true then that is a problem. Ideally your Desktop and Server versions should be the same or else Server should be a greater version than Desktop.
2. The error looks like it's coming from the data source - Tableau is not generating it - so you may have too many data connections to the data source. If this is the situation then you should re-think all the queries and try to consolidate some of them if possible. Only pull the fields you need. Stay away from Custom SQL if at all possible.
Yaa. i have too many data connection. I am using Custom SQL to retrive only those data which are relevant.
I am using Tableau Desktop 8.2 to create the workbooks but publishing to Tableau Server 8.1.
converting the workbook in 8.1 and then publishing it into server of 8.1 is fine.
Now publish server has been upgraded to 8.2. and now if I open the workbook in 8.2 then in first attempt it is locked.
as far as Custom SQL is concerned, if I do not use it then the workbook is becoming slow as the data source is big.
since last 2 month, i am using the same workbook again & again and many times i have converted it into 8.1 and 8.2.
It was working fine.
But since last 10 days it is giving the error and no one has any clue about it.
Just because down-converting 8.2 to 8.1 didn't break the report doesn't mean it was working 100% as it should be.
I recommend taking your original 8.2 workbook -- NOT the one on the Server (don't download it), NOT the one that was down-converted to 8.1 -- and publish it to the 8.2 Server.
If you still have issues then contacting Tableau Support is your best bet.
As for this:
saurav dokania wrote:
as far as Custom SQL is concerned, if I do not use it then the workbook is becoming slow as the data source is big...
Data source size doesn't matter. Have you tried using filters against the data source?
There are others who can best speak to data source connections, filtering, and properly using the data within.
Thnx for reply.
right now i m using the 8.2 version of workbook but the issue is after giving the password it is locked in first attempt. so i m not able to open it.
the earlier sheet which was published do not consist of any SQL query. to improve the performance, i have created new dashboard with SQL query in 8.2. When I went for publishing it was locked.
SO right now i cant published it in 8.1