Problem Note 61581: "ERROR: CLI describe error...SQLSTATE=42501" occurs when you add a new business unit in SAS® Anti-Money Laundering
 |  |  |  |  |
If you are adding a new business unit to SAS® Anti-Money Laundering and your database is DB2, you might see the following error when executing the db_create ant script:
ERROR: CLI describe error: [IBM][CLI Driver][DB2/AIX64] SQL0551N The statement
failed because the authorization ID does not have the required authorization or privilege to perform the operation.
Authorization ID: "FCFBU2". Operation: "SELECT". Object:
failed because the authorization ID does not have the required authorization or privilege to perform the operation.
Authorization ID: "FCFBU2". Operation: "SELECT". Object:
"FCFBU2.<table_name>". SQLSTATE=42501
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for x64 | 7.1 | |||
| 64-bit Enabled AIX | 7.1 | |||||
| 64-bit Enabled Solaris | 7.1 | |||||
| Linux for x64 | 7.1 | |||||
A fix for this issue for SAS Compliance Solutions 7.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A5T.html#61581| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-01-09 14:41:51 |
| Date Created: | 2017-12-14 15:28:26 |