Old publications cannot be found/viewed after an upgrade from v5 to v6
When upgrading BI Office from v5 to v6, a new publication shared folder is created
However, the application does not update the publishing folder.
As a result the following error will appear while running a publication:
Below are the steps to update the new publication folder:
- Open the admin console and navigate to the Settings Tab --> Publishing settings
- Browse the Directory
- Configure the new Publishing6 folder as in the screenshot below:
In addition, the old publications will stay in the old folder.
They can be moved to the new folder to allow users to view them.
The old folder usually located under:
C:\Program Files\Pyramid Analytics\BI Office 5\publishing
We followed this step after upgrading from v5 to v6, and we are able to publish under the new Publishing6 directory, but publications from v5 aren't accessible from "C:\Program Files\Pyramid Analytics\BI Office 5\publishing" or after copying to the new publishing folder in "C:\Program Files\Pyramid Analytics\BI Office 6\publishing"
It looks like the publish_tbl.Output table contains a path value that still references "Publishing5" on the server.
If it's changed to "Publishing6" AND the files are copied to the new folder, then the files are retrievable once again.