SAP Knowledge Base Article - Preview

2395374 - Error: 'HY000:ERROR: CREATE TABLE AS SELECT not permitted in read-only session' when attempting to create a report using temp table in Crystal Reports

Symptom

  • Unable to create a new report off a Command Object.
  • When attempting to create a report using a custom SQL Query it fails.
  • When attempting to create a new report connecting to Netezza using an ODBC connection in Crystal Reports, and entering in a Command Object an SQL Query that uses a temp table, it fails with the error:
          
    "Database Connector Error: 'HY000:ERROR: CREATE TABLE AS SELECT not permitted in read-only session [Database Vendor Code: 46 ]'"


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
        
  • IBM Netezza

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR, Temp Table , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.