Problem Note 68928: The viya-plan-backup.yml playbook fails with the message "…The request could not be understood by the server due to malformed syntax"
 |  |  |  |
The viya-plan-backup.yml playbook that is used during a full-system migration process from SAS® Viya® 3.x to SAS® Viya® 2020 or a later release fails when it uses a SAS® Cloud Analytic Services (CAS) CLI plug-in version of 1.12.18 or higher. After the failure, an error that is similar to the following occurs:
2022-01-27 10:27:17,324 p=21257 u=root n=ansible | TASK [Import published inventory scans results to specified CAS server] ********************************************************************************************************************
2022-01-27 10:27:19,622 p=21257 u=root n=ansible | failed: [localhost] (item=/opt/sas/viya/inventory/publishedCSVFiles/SASViyaInventory.csv) => {"ansible_loop_var": "item", "changed": true, "cmd": "/opt/sas/viya/inventory/.sas/sas-cas-cli-1.13.21-20211004.1633305600 --profile saasnow_admin-timeStamp-viya35-deployment1 tables import csv --server cas-shared-default --caslib SystemData --contains-header-row --force --replace --superuser --source-file /opt/sas/viya/inventory/publishedCSVFiles/SASViyaInventory.csv \n", "delta": "0:00:02.122358", "end": "2022-01-27 10:27:19.594865", "item": "/opt/sas/viya/inventory/publishedCSVFiles/SASViyaInventory.csv", "msg": "non-zero return code", "rc": 1, "start": "2022-01-27 10:27:17.472507", "stderr": "", "stderr_lines": [], "stdout": "1 error occurred:\n * The request could not be understood by the server due to malformed syntax.", "stdout_lines": ["1 error occurred:", " * The request could not be understood by the server due to malformed syntax."]}
2022-01-27 10:27:19,622 p=21257 u=root n=ansible | failed: [localhost] (item=/opt/sas/viya/inventory/publishedCSVFiles/SASViyaInventory.csv) => {"ansible_loop_var": "item", "changed": true, "cmd": "/opt/sas/viya/inventory/.sas/sas-cas-cli-1.13.21-20211004.1633305600 --profile saasnow_admin-timeStamp-viya35-deployment1 tables import csv --server cas-shared-default --caslib SystemData --contains-header-row --force --replace --superuser --source-file /opt/sas/viya/inventory/publishedCSVFiles/SASViyaInventory.csv \n", "delta": "0:00:02.122358", "end": "2022-01-27 10:27:19.594865", "item": "/opt/sas/viya/inventory/publishedCSVFiles/SASViyaInventory.csv", "msg": "non-zero return code", "rc": 1, "start": "2022-01-27 10:27:17.472507", "stderr": "", "stderr_lines": [], "stdout": "1 error occurred:\n * The request could not be understood by the server due to malformed syntax.", "stdout_lines": ["1 error occurred:", " * The request could not be understood by the server due to malformed syntax."]}
The error above occurs for four CSV files that are imported to CAS. However, only one CSV file failure is shown.
To work around the problem, run the following commands to download a CAS CLI that does not have this problem. Place the CLI in the home directory for the user that is running viya-plan-backup.yml:
curl -O https://support.sas.com/repos/admincli/100.0/admincli-100.0-x64_ubuntu_linux_14-tar/sas-cas-cli-1.12.15-20201102.1604275200.txz
tar -Jxvf ./sas-cas-cli-1.12.15-20201102.1604275200.txz
rm ~/.sas/admin-plugins/sas-cas-cli*
cp ./sas-cas-cli-1.12.15-20201102.1604275200 ~/.sas/admin-plugins
chmod +x ~/.sas/admin-plugins/sas-cas-cli-1.12.15-20201102.1604275200
tar -Jxvf ./sas-cas-cli-1.12.15-20201102.1604275200.txz
rm ~/.sas/admin-plugins/sas-cas-cli*
cp ./sas-cas-cli-1.12.15-20201102.1604275200 ~/.sas/admin-plugins
chmod +x ~/.sas/admin-plugins/sas-cas-cli-1.12.15-20201102.1604275200
After performing these steps, re-execute viya-plan-backup.yml.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | Viya | |
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-02-16 14:52:43 |
| Date Created: | 2022-02-16 11:58:24 |