Problem Note 64728: "ERROR: Column 'ROWNUM' not found or cannot be accessed" occurs when you use PROC FEDSQL with explicit pass-through with an Oracle caslib
 |  |  |  |  |
You encounter an error when you use PROC FEDSQL under the following conditions:
- You use explicit pass-through with an Oracle caslib.
- The caslib contains NUMREADNODES = 0.
In this scenario, you receive the following error:
ERROR: Column "ROWNUM" not found or cannot be accessed
ERROR: Column "SYSDATE" not found or cannot be accessed
ERROR: The action stopped due to errors. ERROR: The FedSQL action was not successful.
ERROR: Column "SYSDATE" not found or cannot be accessed
ERROR: The action stopped due to errors. ERROR: The FedSQL action was not successful.
For example, you encounter this issue when you run code similar to the following:
LIBNAME mycas SASIOCA SESSREF=mySession;
caslib oralib datasource=(srctype="oracle" username="SCOTT" password="tiger"
path="ora11g" schema="SCOTT" numReadNodes=0);
proc fedsql sessref=mySession _method;
create table casuser.tb_teste{options replace=true} as
select * from connection to oralib (
select sysdate as c1, rownum as c2 from Employee
);
quit;
caslib oralib datasource=(srctype="oracle" username="SCOTT" password="tiger"
path="ora11g" schema="SCOTT" numReadNodes=0);
proc fedsql sessref=mySession _method;
create table casuser.tb_teste{options replace=true} as
select * from connection to oralib (
select sysdate as c1, rownum as c2 from Employee
);
quit;
To work around this issue, do not use NUMREADNODES = 0 in the caslib.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Oracle | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates
When you use the FedSQL procedure with explicit pass-through and an Oracle caslib, the following error occurs: "ERROR: Column 'ROWNUM' not found or cannot be accessed..." You encounter this issue when you use NUMREADNODES = 0 in the caslib.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-09-06 09:53:43 |
| Date Created: | 2019-09-04 12:49:55 |