SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 61581: "ERROR: CLI describe error...SQLSTATE=42501" occurs when you add a new business unit in SAS® Anti-Money Laundering

DetailsHotfixAboutRate It

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:
       "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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingMicrosoft® Windows® for x647.1
64-bit Enabled AIX7.1
64-bit Enabled Solaris7.1
Linux for x647.1
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.