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 for Me (Login required).

    Search for additional results

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