tableau / TabMigrate

A lightweight tool for moving Tableau content between multiple Tableau Server environments
MIT License
118 stars 59 forks source link

Unexpected error finalizing publish of file workbook #15

Open lanzojl519 opened 7 years ago

lanzojl519 commented 7 years ago

Hello,

I am having issues with some workbooks not publishing. In some cases the workbooks on the sources site are pointed to published datasources, which are oracle data sources with extracts. Another case is an embedded data source with a live connection.

I've selected remap workbook dataserver references. In comparing some workbooks that were loaded with similar connections, the main difference was that the datasource and workbook were in the same project. The one with error the data sources are in a different project than the workbook.

259, 6/2/2017 11:28:03 AM, Error: Unexpected error finalizing publish of file C:\Users\xxxxx\AppData\Roaming\TabMigrate\tableau-dev.medtronic.com\siteExport2017-06-02-1111-55_remapTempspace\Tableau Site Usage Views.twb, The remote server returned an error: (400) Bad Request. 260, 6/2/2017 11:28:03 AM, Error: Error uploading workbook C:\Users\xxxxx\AppData\Roaming\TabMigrate\tableau-dev.medtronic.com\siteExport2017-06-02-1111-55\workbooks\Tableau Site Usage\Tableau Site Usage Views.twb. The remote server returned an error: (400) Bad Request.

However, as mentioned a similar issue occurred with a workbook with an embedded data source with a live connection.

229, 6/2/2017 11:27:54 AM, Error: Unexpected error finalizing publish of file C:\Users\judith.lanzo\AppData\Roaming\TabMigrate\tableau-dev.medtronic.com\siteExport2017-06-02-1111-55_remapTempspace\VizAlertsConfig.twb, The remote server returned an error: (400) Bad Request. 230, 6/2/2017 11:27:54 AM, Error: Error uploading workbook C:\Users\judith.lanzo\AppData\Roaming\TabMigrate\tableau-dev.medtronic.com\siteExport2017-06-02-1111-55\workbooks\Default\VizAlertsConfig.twb. The remote server returned an error: (400) Bad Request. 231, 6/2/2017 11:27:54 AM, Attempt web request: https://tableau-dev.medtronic.com/api/2.3/sites/3225751f-f893-40eb-acf0-df1dd782c39b/projects 232, 6/2/2017 11:27:54 AM, Append header X-Tableau-Auth: z1WTQamMeJmv1eCHh2iUWxcnUJkiReeJ 233, 6/2/2017 11:27:54 AM, Project created. Project: Self Service/8b79ec46-109d-406b-963f-fad4b4f418d7 234, 6/2/2017 11:27:55 AM, Intiating file upload C:\Users\judith.lanzo\AppData\Roaming\TabMigrate\tableau-dev.medtronic.com\siteExport2017-06-02-1111-55_remapTempspace\SS Test.twb 235, 6/2/2017 11:27:55 AM, Attempt web request: https://tableau-dev.medtronic.com/api/2.3/sites/3225751f-f893-40eb-acf0-df1dd782c39b/fileUploads 236, 6/2/2017 11:27:55 AM, Append header X-Tableau-Auth: z1WTQamMeJmv1eCHh2iUWxcnUJkiReeJ 237, 6/2/2017 11:27:55 AM, Attempt web request: https://tableau-dev.medtronic.com/api/2.3/sites/3225751f-f893-40eb-acf0-df1dd782c39b/fileUploads/28416:06489A1BCB504CF2AB884BB0B18DCB19-1:0 238, 6/2/2017 11:27:55 AM, Append header X-Tableau-Auth: z1WTQamMeJmv1eCHh2iUWxcnUJkiReeJ 239, 6/2/2017 11:27:58 AM, Upload chunk status 28416:06489A1BCB504CF2AB884BB0B18DCB19-1:0 / 1 MB 240, 6/2/2017 11:27:58 AM, File chunks upload successful. Next step, make it a published workbook 241, 6/2/2017 11:27:58 AM, Attempt web request: https://tableau-dev.medtronic.com/api/2.3/sites/3225751f-f893-40eb-acf0-df1dd782c39b/workbooks?uploadSessionId=28416:06489A1BCB504CF2AB884BB0B18DCB19-1:0&workbookType=twb&overwrite=true 242, 6/2/2017 11:27:58 AM, Append header X-Tableau-Auth: z1WTQamMeJmv1eCHh2iUWxcnUJkiReeJ 243, 6/2/2017 11:27:58 AM, Error: finalize workbook publish (https://tableau-dev.medtronic.com/api/2.3/sites/3225751f-f893-40eb-acf0-df1dd782c39b/workbooks?uploadSessionId=28416:06489A1BCB504CF2AB884BB0B18DCB19-1:0&workbookType=twb&overwrite=true) : The remote server returned an error: (400) Bad Request. <?xml version='1.0' encoding='UTF-8'?>

Bad RequestThere was a problem publishing the file '28416:06489A1BCB504CF2AB884BB0B18DCB19-1:0'.

i also noticed the embedded usrname and password on the datasources did not carry over. Is there editing required to keep them embedded?