SAP Knowledge Base Article - Preview

2501768 - SQL0104N An unexpected token "UR"

Symptom

SUM shows below error while running during an Upgrade. 

DB6REGIS.LOG:
==========
1 ETQ000 ==================================================
1 ETQ399 Executing SQL script '../var/DB6REGIS.TQL'.
2 ETQ399 Connecting to database 'db6'.
4 ETQ393 START DB6REGIS
4 ETQ010 Date & Time: *****************
3 ETQ398 SQL: SELECT distinct REG_VAR_NAME NAME, REG_VAR_VALUE VALUE, AGGREGATE_NAME AGGNAME     
3 ETQ398XSQL: FROM TABLE(REG_LIST_VARIABLES()) WITH UR
4 ETQ010 Date & Time: *****************
1EETQ008 Error message: DBSL error 99 (db code -104):
1EETQ009XSQL0104N  An unexpected token "UR" was found following "T_VARIABLES())  WITH".
1EETQ009XExpected tokens may include:  "END-OF-STATEMENT".  SQLSTATE=42601
1EETQ003 exit code: "20"
4 ETQ399 Rollback.


Read more...

Environment

    DB2 LUW (Linux,Unix and Windows), DB6 Database versions 9.1 and 9.5.

    Product

    SAP ERP 6.0

    Keywords

    DB6REGIS.TQL, REG_LIST_VARIABLES, END-OF-STATEMENT, CHK_DB6_REG_PRE , PREP_INIT, SUM, UPGRADE , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

    About this page

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

    Search for additional results

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