Usage Note 50121: The error "java.sql.SQLException: Unable to execute query: SQL passthru expression contained these errors" occurs with SAS® Marketing Optimization
If you put a SAS Marketing Optimization input data library and the associated tables in a folder other than the Shared Data folder in SAS® Management Console, when you try to create SAS Marketing Optimization input data from the library, you might get the following error:
java.sql.SQLException: Unable to execute query: SQL passthru expression contained these errors:
This error is actually caused by insufficient permission for the folder where the SAS Marketing Optimization metadata objects (library, tables) are place within the Shared Data folder in SAS Management Console.
If you want to enable placing SAS Marketing Optimization input library and tables in a folder other than Shared Data, before you try to create input data within SAS Marketing Optimization, an administrator needs to perform the following steps:
- In SAS Management Console, select Environment Management ► Access Control Templates.
- Right-click Properties for a SAS Marketing Optimization template.
- Click Permission Pattern.
- Add users and groups that would be responsible for creating SAS Marketing Optimization input data and granting their permissions. For example, if sasdemo is the user to create SAS Marketing Optimization input data, it can be placed under the Marketing Optimization Administrator group, and the administrator can add this group to the Permission Pattern tab.
- In the SAS Management Console folder where the user will place his input library or tables, apply the Marketing Optimization Access Control Template.
- Right-click the folder (for example, MO Sample Input Properties). Click the Authorization tab and then click Access Control Templates.
- In the pop-up window, in the Add and Remove Access Control Template box, move Foundation ► Marketing Optimization Template from Available to Currently Using.
Once the steps above are completed, any library or tables that are place under the specific SAS Management Console folder should have the user or group (for example, Marketing Optimization Administrators) defined with permissions granted. The user would have no problem creating input data from the specific library.
Operating System and Release Information
SAS System | SAS Marketing Optimization | Microsoft® Windows® for x64 | 6.1 | | 9.3 TS1M2 | |
64-bit Enabled AIX | 6.1 | | 9.3 TS1M2 | |
64-bit Enabled HP-UX | 6.1 | | 9.3 TS1M2 | |
64-bit Enabled Solaris | 6.1 | | 9.3 TS1M2 | |
HP-UX IPF | 6.1 | | 9.3 TS1M2 | |
Linux for x64 | 6.1 | | 9.3 TS1M2 | |
Solaris for x64 | 6.1 | | 9.3 TS1M2 | |
*
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.
Date Modified: | 2013-07-24 15:02:55 |
Date Created: | 2013-06-05 15:31:59 |