- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Getting DB error: SQL error 1722 occurred
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Getting DB error: SQL error 1722 occurred
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 04-25-2010 7:34 AM
Dear Gurus,
After the unicode migration, our system starts properly but when I hit enter after giving user name and password, it comes out with the following error:
DB error: SQL error 1722 occurred
Thus nobody is able to login. This is a ECC 6 / Oracle 10g system.
Any suggestions?
Rgds
- SAP Managed Tags:
- Oracle Database
Accepted Solutions (0)
Answers (16)
Answers (16)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Dear Stefan,
The cause was not mentioned in SAP's solution but: --
1) The solution involved dipgntab
2) SAP Note 46272
3) Close look at TSORA, TAORA, IAORA tables
4) A few more things
REQUEST EVERYONE THAT PLEASE DO NOT USE THE SOLUTION AT YOUR INSTALLATIONS AS THE SOLUTION IS VERY SPECIFIC TO OUR SITUATION
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Dear Stefan,
The cause was not mentioned in SAP's solution but: --
1) The solution involved dipgntab
2) SAP Note 46272
3) TSORA, TAORA, IAORA tables
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello,
We raised an message to SAP.
The solution provided by SAP was very specific to our scenario so I am not pasting it here as it can be dangerous to any other installation
Anyhow, we decided to go for a re-import
thank you everyone
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
this happens if the post installation tasks of sapinst has not been run
Edited by: Jens Reppe on Apr 27, 2010 1:15 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Dear Stefan,
Thanks for you time
I tried logging in different clients with different user IDs but still the same error is coming
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello Sandy,
ok lets try a different approach (even if i am suprised that the SAP* user is not working).
Oracle provides a script to identify the rows in the table, that are causing the ORA-01722. The problem is that this script has to be exectued for every varchar2 column. In case of RSEUMOD that is pretty much.
For the script itself - check metalink note #231213.1 (for metalink access check sapnote #758563).
If this check script also does not find any mismatch, then you have an issue in the ABAP DDIC (or SAP kernel / DBSL).
Regards
Stefan
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Pasting part 8 -
This is the last part
WDY_VIEW_HORIZ NOT NULL NUMBER(10)
WDY_VIEW_VERT NOT NULL NUMBER(10)
WDY_CONTXT_HORIZ NOT NULL NUMBER(10)
WDY_CONTXT_VERT NOT NULL NUMBER(10)
WDY_METHOD_VERT NOT NULL NUMBER(10)
WDY_WINDOW_HORIZ NOT NULL NUMBER(10)
WDY_WINDOW_VERT NOT NULL NUMBER(10)
WDY_VIEW_G_FLAG NOT NULL VARCHAR2(3)
DEBUGGER NOT NULL VARCHAR2(3)
FBALV_GRID NOT NULL VARCHAR2(3)
WDY_ED_KIND NOT NULL VARCHAR2(3)
ENHNAME NOT NULL VARCHAR2(90)
ENHCOMPOSITE NOT NULL VARCHAR2(90)
ENHSPOT NOT NULL VARCHAR2(90)
ENHSPOTCOMPOSITE NOT NULL VARCHAR2(90)
DEBUG_SESS_BRP NOT NULL VARCHAR2(3)
PRX_XML_TAB NOT NULL VARCHAR2(3)
PRX_EXPERT NOT NULL VARCHAR2(3)Please advice....thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello Sandy,
thanks for the output.
I have compared the column definitions with one ouf our ECC 6.0 EHP4 systems. The structure is nearly identical until some EHP specific columns .. here are the differences (the first column is your table definiton - the second is ours)
PRX_XML_TABNOTNULLVARCHAR2(3) | CIB_STARTVARCHAR2(3)
PRX_EXPERTNOTNULLVARCHAR2(3) | PRX_XML_TABVARCHAR2(3)
+ PRX_EXPERTVARCHAR2(3)
+ PRX_TREE_ORDERVARCHAR2(3)
+ NOENHANCEMENTSVARCHAR2(3
So maybe there is just an inconsistency in the ABAP DDIC (you could check this with SE14), but for further checks you need to login successfully once.
You said:
> Thus nobody is able to login. This is a ECC 6 / Oracle 10g system.
Have you also tried to login with a different user or was this just a assumption after you have tried it with your user?
Normally the table RSEUMOD does not store content for every user (normally just for these guys who are using the development tools like SE80) - so the other user should be able to login. Have you already tried it with the "SAP*" user?
If you are able to login with different users you can run the consistency check in SE14 (database object and runtime object).
Regards
Stefan
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Pasting part 7
ETLOG_DURATION NOT NULL VARCHAR2(3)
ETPATH_OBJECTS NOT NULL VARCHAR2(765)
ETPATH_VARIANTS NOT NULL VARCHAR2(765)
ETPATH_WEBDYNPRO NOT NULL VARCHAR2(765)
ETWAIT_TIME_REC NOT NULL VARCHAR2(12)
ETWAIT_TIMEMODUS NOT NULL VARCHAR2(12)
ETEUWTIME_HLIGHT NOT NULL VARCHAR2(12)
ETEUWTIME_RESP NOT NULL VARCHAR2(12)
ETTIMEOUT_RFC NOT NULL VARCHAR2(12)
ETTIMEOUT_WDY NOT NULL VARCHAR2(12)
ETDBG_CMD NOT NULL VARCHAR2(90)
ETDBG_OBJ NOT NULL VARCHAR2(765)
ETEXTOOL_USER NOT NULL VARCHAR2(120)
ETEXTOOL_PROJ NOT NULL VARCHAR2(120)
ETXML_VIEW NOT NULL VARCHAR2(45)
ETSCRRATIO_PAR NOT NULL NUMBER(3)
ETSCRRATIO_SCR NOT NULL NUMBER(3)
ETSCRRATIO_XML NOT NULL NUMBER(3)
ETLOG_OPTIONS NOT NULL VARCHAR2(30)
ETWDYURL NOT NULL VARCHAR2(765)
ETVARMAX NOT NULL VARCHAR2(15)
ETPATH_SCREENS NOT NULL VARCHAR2(765)
ETNEWEDITCNTRL NOT NULL VARCHAR2(3)
ETBLOCKINDENT NOT NULL VARCHAR2(6)
ETCASESENSITIVE NOT NULL VARCHAR2(3)
ETUPPERCASE_CMD NOT NULL VARCHAR2(3)
ETUPPERCASE_ARG NOT NULL VARCHAR2(3)
ETBREAKSCRLINE NOT NULL VARCHAR2(9)
ETBREAKLINEFLG NOT NULL VARCHAR2(3)You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Pasting part 6
PROTOCOL NOT NULL VARCHAR2(30)
APPSERVER NOT NULL VARCHAR2(396)
APPPORT NOT NULL VARCHAR2(30)
APPSERVICE NOT NULL VARCHAR2(396)
MIMEPATT NOT NULL VARCHAR2(540)
SHOWNSPACE NOT NULL VARCHAR2(3)
TAGFILTER NOT NULL VARCHAR2(30)
WDYAPPL NOT NULL VARCHAR2(90)
FORMAL_EQ_ACTUAL NOT NULL VARCHAR2(3)
EXC_WO_OTHERS NOT NULL VARCHAR2(3)
WITH_TRY_ENDTRY NOT NULL VARCHAR2(3)
SEOFORM_EQ_ACT NOT NULL VARCHAR2(3)
SEOEXC_WO_OTHERS NOT NULL VARCHAR2(3)
SEOWITH_TRYENDTR NOT NULL VARCHAR2(3)
SEOFUNC_CALL NOT NULL VARCHAR2(3)
WORKLIST NOT NULL VARCHAR2(3)
CONV_EXITS_OFF NOT NULL VARCHAR2(3)
ETLOG_XMLC NOT NULL VARCHAR2(3)
ETLOG_MSGY NOT NULL VARCHAR2(3)
ETLOG_TXT NOT NULL VARCHAR2(3)
ETLOG_LEVELS NOT NULL VARCHAR2(3)
ETLOG_XMLE NOT NULL VARCHAR2(3)
ETLOG_SELOPT_DEF NOT NULL VARCHAR2(3)You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Pasting part 5
PROSEC NOT NULL VARCHAR2(3)
INTERFACES NOT NULL VARCHAR2(3)
DOCU NOT NULL VARCHAR2(3)
CONTENTS NOT NULL VARCHAR2(3)
LOCALS_DEF NOT NULL VARCHAR2(3)
LOCALS_IMP NOT NULL VARCHAR2(3)
MACS NOT NULL VARCHAR2(3)
CODING NOT NULL VARCHAR2(3)
WIDTH NOT NULL NUMBER(10)
HEAD_WIDTH NOT NULL NUMBER(10)
START_LAST NOT NULL VARCHAR2(3)
REP_START NOT NULL VARCHAR2(3)
RIS_START NOT NULL VARCHAR2(3)
RL_START NOT NULL VARCHAR2(3)
WMR_START NOT NULL VARCHAR2(3)
WCB_START NOT NULL VARCHAR2(3)
WHB_START NOT NULL VARCHAR2(3)
TWB_START NOT NULL VARCHAR2(3)
ESI_START NOT NULL VARCHAR2(3)
BR_INIT NOT NULL VARCHAR2(3)
WTX_START NOT NULL VARCHAR2(3)
ENH_START NOT NULL VARCHAR2(3)
ITS_NAME NOT NULL VARCHAR2(396)
ITS_RFCD NOT NULL VARCHAR2(96)
ITS_RFC_AL NOT NULL VARCHAR2(3)
ITS_PATH NOT NULL VARCHAR2(120)
ITS_LO_PUB NOT NULL VARCHAR2(3)
CH_HTML NOT NULL VARCHAR2(3)
CH_BUSI NOT NULL VARCHAR2(3)
ITS_HTTPS NOT NULL VARCHAR2(3)
ITS_ITSPAT NOT NULL VARCHAR2(396)
HTMLEDIT NOT NULL VARCHAR2(396)You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Pasting part 4
HTTP_DEBUG NOT NULL VARCHAR2(3)
HTTP_USER NOT NULL VARCHAR2(36)
HTTP_IPMCH NOT NULL VARCHAR2(3)
NOBITMAP NOT NULL VARCHAR2(3)
NEWSVERS NOT NULL VARCHAR2(18)
SAP_BITMAP NOT NULL VARCHAR2(120)
OWN_BITMAP NOT NULL VARCHAR2(384)
O_PUBLIC NOT NULL VARCHAR2(3)
NO_CONST NOT NULL VARCHAR2(3)
W_INHERIT NOT NULL VARCHAR2(3)
W_COMPRI NOT NULL VARCHAR2(3)
NO_INSTANC NOT NULL VARCHAR2(3)
NO_STATIC NOT NULL VARCHAR2(3)
ALI_DISP NOT NULL VARCHAR2(3)
GROUP_INH NOT NULL VARCHAR2(3)
SETTINGSON NOT NULL VARCHAR2(3)
W_SIGNAT NOT NULL VARCHAR2(3)
HEADER NOT NULL VARCHAR2(3)
ATTRIBUTES NOT NULL VARCHAR2(3)
MTD_DEF NOT NULL VARCHAR2(3)
MTD_IMP NOT NULL VARCHAR2(3)
EVENTS NOT NULL VARCHAR2(3)
TYPES NOT NULL VARCHAR2(3)
PUBSEC NOT NULL VARCHAR2(3)
PRISEC NOT NULL VARCHAR2(3)You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Pasting part 3
S5EXTERNAL NOT NULL VARCHAR2(3)
S5INHSUPER NOT NULL VARCHAR2(3)
S5INHSUB NOT NULL VARCHAR2(3)
S5IMPLSUPR NOT NULL VARCHAR2(3)
S5IMPLSUB NOT NULL VARCHAR2(3)
S5COMPSUPR NOT NULL VARCHAR2(3)
S5COMPSUB NOT NULL VARCHAR2(3)
S5COMPWHOL NOT NULL VARCHAR2(3)
S5COMPPART NOT NULL VARCHAR2(3)
S5ASSOCPRD NOT NULL VARCHAR2(3)
S5ASSOCSUC NOT NULL VARCHAR2(3)
S5DEPPRED NOT NULL VARCHAR2(3)
S5DEPSUCC NOT NULL VARCHAR2(3)
S5RTSUPER NOT NULL VARCHAR2(3)
S5RTWHOLE NOT NULL VARCHAR2(3)
S5CMPHIER NOT NULL VARCHAR2(3)
S5OBJNAME NOT NULL VARCHAR2(3)
S5OBJID NOT NULL VARCHAR2(3)
S5WITHID NOT NULL VARCHAR2(3)
S5DEVCLASS NOT NULL VARCHAR2(3)
SYNTAXCH NOT NULL VARCHAR2(3)
EDC_CMPMOD NOT NULL VARCHAR2(3)
EDC_WNDMOD NOT NULL VARCHAR2(3)
EDC_CMPCHA NOT NULL VARCHAR2(3)CLASSNAME NOT NULL VARCHAR2(90)
WB99 NOT NULL VARCHAR2(3)
FBREF NOT NULL VARCHAR2(3)
EDITCNTRL NOT NULL VARCHAR2(3)
INDENT NOT NULL VARCHAR2(3)
STYLE NOT NULL VARCHAR2(3)
SHOW_STYLE NOT NULL VARCHAR2(3)
ALL_ERRORS NOT NULL VARCHAR2(3)
RFC_CHECK NOT NULL VARCHAR2(3)
RFC_DESTCH NOT NULL VARCHAR2(96)
LINE_SIZE NOT NULL NUMBER(10)You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Pasting part 2
WBO_QPOPUP NOT NULL VARCHAR2(3)
WBO_FPOPUP NOT NULL VARCHAR2(3)
WBO_OBJCHK NOT NULL VARCHAR2(3)
WBO_DOCU NOT NULL VARCHAR2(3)
EDIT_PATH NOT NULL VARCHAR2(384)
RELEASED NOT NULL VARCHAR2(3)
CLASS_ALL NOT NULL VARCHAR2(3)
CLASS_BO NOT NULL VARCHAR2(3)
CLASS_ORG NOT NULL VARCHAR2(3)
CLASS_IF NOT NULL VARCHAR2(3)
API_ONLY NOT NULL VARCHAR2(3)
USEOBJNAME NOT NULL VARCHAR2(3)
KOMPRMODE NOT NULL VARCHAR2(3)
CUA_FCLENG NOT NULL VARCHAR2(6)
CUA_TXLENG NOT NULL VARCHAR2(6)
CUA_FRONT NOT NULL VARCHAR2(24)
HOST NOT NULL VARCHAR2(96)
S5UPDATED NOT NULL VARCHAR2(3)
S5CLASSES NOT NULL VARCHAR2(3)
S5OBJTYPES NOT NULL VARCHAR2(3)
S5INTRFACE NOT NULL VARCHAR2(3)
S5PUBLIC NOT NULL VARCHAR2(3)S5PROTECT NOT NULL VARCHAR2(3)
S5PRIVATE NOT NULL VARCHAR2(3)
S5MODELLED NOT NULL VARCHAR2(3)
S5IMPLEM NOT NULL VARCHAR2(3)
S5RELEASED NOT NULL VARCHAR2(3)
S5OBSOLETE NOT NULL VARCHAR2(3)
S5BUSOBJ NOT NULL VARCHAR2(3)
S5GUI NOT NULL VARCHAR2(3)
S5OLE NOT NULL VARCHAR2(3)
S5ORGTYPES NOT NULL VARCHAR2(3)
S5OTHERS NOT NULL VARCHAR2(3)
S5LOCAL NOT NULL VARCHAR2(3)
S5GLOBAL NOT NULL VARCHAR2(3)
S5NORELEAS NOT NULL VARCHAR2(3)
S5INTERNAL NOT NULL VARCHAR2(3)You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Dear Stefan,
I am able to post the output only in small parts so will update the message multiple times
Pasting part 1
UNAME NOT NULL VARCHAR2(36)
MOTIF NOT NULL VARCHAR2(3)
PCMODE NOT NULL VARCHAR2(3)
LOWERCASE NOT NULL VARCHAR2(3)
TASKNR NOT NULL VARCHAR2(60)
SUBTASKNR NOT NULL VARCHAR2(60)
SELTYPE NOT NULL VARCHAR2(9)
DEVCLASS NOT NULL VARCHAR2(90)
PROGNAME NOT NULL VARCHAR2(120)
FGROUP NOT NULL VARCHAR2(78)
SERVICE NOT NULL VARCHAR2(42)
O2APPL NOT NULL VARCHAR2(90)
TAGLIB NOT NULL VARCHAR2(90)
TBMODE NOT NULL VARCHAR2(3)
TBLISTBR NOT NULL VARCHAR2(12)
TBMAXSEL NOT NULL NUMBER(10)
VARIANT NOT NULL VARCHAR2(42)
LOOPMAX NOT NULL NUMBER(10)
SYSTEM NOT NULL VARCHAR2(30)
TBCONVERT NOT NULL VARCHAR2(3)
TBCOUNT NOT NULL VARCHAR2(3)
TBALV_GRID NOT NULL VARCHAR2(3)
TBALV_STAN NOT NULL VARCHAR2(3)
RFCDEST NOT NULL VARCHAR2(96)GRA_EDITOR NOT NULL VARCHAR2(3)
GRA_FPAINT NOT NULL VARCHAR2(3)
GRA_ZOOM NOT NULL NUMBER(10)
GRA_GRID NOT NULL NUMBER(5,2)
GRA_GRIDU NOT NULL VARCHAR2(6)
GRA_AUTOG NOT NULL VARCHAR2(3)
WBO_VIEW NOT NULL VARCHAR2(3)
WBO_VDATUM NOT NULL VARCHAR2(3)
WBO_VOWNER NOT NULL VARCHAR2(3)
WBO_SCREEN NOT NULL VARCHAR2(3)
WBO_DSORT NOT NULL VARCHAR2(3)You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Dear Stefan,
Thanks
The table name is RSEUMOD
I have spooled the output of "DESC SAPSID.RSEUMOD;" but its huge. Do you really want me to paste it over here?
Below pasted it the extract from /usr/sap/SID/DVEBMGS00/work/dev_w0
C SELECT * FROM "RSEUMOD" WHERE "UNAME" = :A0;
B ***LOG BY4=> sql error 1722 performing SEL on table RSEUMOD [dbtrtab#6 @ 3908] [dbtrtab 3908 ]
B ***LOG BY0=> ORA-01722: invalid number [dbtrtab#6 @ 3908] [dbtrtab 3908 ]
B *** ERROR => missing return code handler abdebug#?[17883] does not handle return code 1 from dbcrtab#9[1679]
==> calling sap_dext to abort transaction [dbeh.c 84]
M ThIUsrDel: th_rollback_usrdelentry = 1
M ***LOG R47=> ThResFree, delete (001024) [thxxmode.c 1384]
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello Sandy,
yes please post that content here in the "" tags.
We have to crosscheck, if the table definition is correct or not (i can crosscheck this with one of our systems).
Maybe there is an incosistency between the ABAP DDIC and the Oracle table itself.
By the way which kernel version are you using?
Regards
Stefan
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Hello Sandy,
ORA-01722: invalid number
Cause: The attempted conversion of a character string to a number failed because the character string was not a valid numeric literal. Only numeric fields or character fields containing numeric data may be used in arithmetic functions or expressions. Only numeric fields may be added to or subtracted from dates.
Action: Check the character strings in the function or expression. Check that they contain only numbers, a sign, a decimal point, and the character "E" or "e" and retry the operation.
Please take a look at the correspoding work process trace files and check which table (and column) is causing that problem.
Please also post the table description here (SQL command "desc <SAP_SCHEMA>.<TABLE>")
Regards
Stefan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- SAP Analytics Cloud - Performance statistics in Technology Blogs by SAP
- CF Deployment Error: Error getting tenant t0 in Technology Q&A
- SAP Cloud connector uninstallation error in Technology Q&A
- Unify your process and task mining insights: How SAP UEM by Knoa integrates with SAP Signavio in Technology Blogs by SAP
- Deployment Error "ABAP language version is not supported for objecttype WAPA." in Technology Q&A
| User | Count |
|---|---|
| 89 | |
| 10 | |
| 9 | |
| 9 | |
| 9 | |
| 6 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.