I am using python to make changes to a workbook , with following step
- Download workbook
- Unzip twbx file
- Make changes ß using element tree package
- write change back
- Zip twbx file ß
- Publish ß
When I am publishing I am getting this error *** Unexpected response from the server: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><created_job xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <job_id>22393</job_id> <polling_interval_in_millis>10000</polling_interval_in_millis></created_job> Visual things that I can think changed in XML are –
- python converting ‘’ to “” that is original xml has ‘ ‘ single quotes , changed workbook had “ “
- removal of comment (<!-- build 10300.17.0915.2101 -->)
- automatic &apos to ‘ (for element such as don’t , won’t)
Running out of options , any help appreciated.
Hi Saket. Most likely there's something going wrong inside the XML. Is using bash / sed sed - Wikipedia an option for you? I am updating an occurrence of a parameter inside of a tdsx using the attached. Other than this, all I can advise is to figure out what's being updated in error and fix it. Since it's a custom solution, it's not going to be debugged by Tableau Support.
1. Copy the file to a temp location
2. Use the unzip that is supplied with Tableau Server
3. Update any instance of the parm "ZQJ1" to "ZQJ2". I know it's funky naming, but this ensured that it was unique and I wasn't inadvertently updating other values
4. Remove the original tdsx
5. Zip the updated folder / file to a new tdsx
update_parm.txt.zip 346 bytes
for me the whole xml changes from "" to '' , i dont think that should be an issue however , i am not able to find out what is the error in the xml as i am able to manually publish the file using tableau desktop. Error comes only when using tabcmd
i am getting this error for all tabcmd publish this is the command i am using do you see any errors
tabcmd publish "report.twbx" --project "Demand Planning" --tabbed --db-username "DB" --db-password "pwd" --save-db-password --no-certcheck --site "''"
Try getting rid of the --site tag. If it's the default site, then this tag isn't needed and in fact will error out if you have it.
just tried that aswell , doesnt work , same error as above .. now tried with three different workbooks. surprisingly i can refresh their extracts easily.
tabcmd publish "report.twbx" --project "Demand Planning" --tabbed --db-username "DB" --db-password "pwd" --save-db-password --no-certcheck
What error do you get? And is this the twbx that you are manipulating the XML via Python? What happens if you use a non-manipulated twbx?
so I couldn't get the changed xml to publish, so i tried publishing an unchanged workbook and got the same error as below , making me thing i am not using tabcmd publish command properly.
*** Unexpected response from the server: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><created_job xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <job_id>22494</job_id> <polling_interval_in_millis>10000</polling_interval_in_millis></created_job>
Is the version of tabcmd and Tableau Server in sync? This could be the cause. They need to be on the same release.
The server is 10.3 , since i have a mac i downloaded tabcmd for 10.5 linux. However apart from publishing , i can do the refresh extract easily.
The versions need to match. can you try deploying 10.3 tabcmd onto a windows box and see if this helps?
Here's a link for the latest maintenance release of 10.3 where you can get tabcmd Tableau Server 10.3.16 | Tableau Software
yes , i am gona do that now .. will update, thanks for suggestions.