ERROR: 'set schema 'sor'' error ^ found "'" (at char 16) expecting `TO' or `'=''

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web4

  • via Google Groups by Gagneet Singh, 6 months ago
    ERROR: 'set schema 'sor'' error ^ found "'" (at char 16) expecting `TO' or `'=''
  • via Google Groups by Pratibha Sharma, 1 year ago
    ERROR: 'select * as x from CTG_DWH..AGG_MOD_TY11 limit 0' error ^ found "AS" (at char 10) expecting a keyword
  • Stack trace

    • org.netezza.error.NzSQLException: ERROR: 'set schema 'sor'' error ^ found "'" (at char 16) expecting `TO' or `'='' at org.netezza.internal.QueryExecutor.getNextResult( at org.netezza.internal.QueryExecutor.execute( at org.netezza.sql.NzConnection.execute( at org.netezza.sql.NzStatement._execute( at org.netezza.sql.NzPreparedStatament.execute( at at dbfit.fixture.Execute.doRows( at fit.Fixture.doTable( at fitlibrary.traverse.AlienTraverseHandler.doTable( at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable( at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable( at fitlibrary.DoFixture.interpretWholeTable( at at fitlibrary.DoFixture.interpretTables( at dbfit.DatabaseTest.interpretTables( at fit.Fixture.doTables( at fit.FitServer.process( at at fit.FitServer.main(

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.