since 9.14.1150: ORA-03120: two-task conversion routine: integer overflow

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Jan Zimmermann
Posts: 17
Joined: Mon 25 Mar 2013 10:29

since 9.14.1150: ORA-03120: two-task conversion routine: integer overflow

Post by Jan Zimmermann » Fri 12 Feb 2021 08:06

Hello Devart & COmmunity,

i have an ORA-03120: two-task conversion routine: integer overflow since 9.14.1150.
Oracle Version: "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.9.0.0.0" multitenant
.net core 3.1
If i change the devart Version to 9.13.1127 my Unit Test runs again.

sql:

Code: Select all

INSERT  INTO T2003_PROCESS  
                                     (T2003_ID,
                                      T2003_T2000_ID,
                                      T2003_QUEUE,
                                      T2003_SUBSCRIBER,
                                      T2003_PRIO,
                                      T2003_CONTENT,
                                      T2003_COMPRESSED,
                                      T2003_STATUS_ID,
                                      T2003_LOOP,
                                      T2003_CREATED_AT,
                                      T2003_CREATED_BY,
                                      T2003_MOD_AT,
                                      T2003_MOD_BY)
                              VALUES (:T2003_ID,
                                      :T2003_T2000_ID,
                                      :T2003_QUEUE,
                                      :T2003_SUBSCRIBER,
                                      :T2003_PRIO,
                                      :T2003_CONTENT,
                                      :T2003_COMPRESSED,
                                       1,
                                      0,
                                      SYSDATE,                                      
                                      USER,
                                      SYSDATE,
                                      USER)
DDL:

Code: Select all

CREATE TABLE "T2003_PROCESS" 
   (	"T2003_ID" NUMBER, 
	"T2003_T2000_ID" NUMBER, 
	"T2003_QUEUE" VARCHAR2(100 CHAR), 
	"T2003_SUBSCRIBER" VARCHAR2(100 CHAR), 
	"T2003_PRIO" NUMBER, 
	"T2003_CONTENT" BLOB, 
	"T2003_COMPRESSED" NUMBER(1,0), 
	"T2003_LOOP" NUMBER, 
	"T2003_MAINTENANCE_LOOP" NUMBER, 
	"T2003_STATUS_ID" NUMBER DEFAULT 0, 
	"T2003_STATUS_MSG" VARCHAR2(4000 CHAR), 
	"T2003_CREATED_AT" DATE DEFAULT sysdate, 
	"T2003_CREATED_BY" VARCHAR2(100 CHAR) DEFAULT user, 
	"T2003_MOD_AT" DATE DEFAULT sysdate, 
	"T2003_MOD_BY" VARCHAR2(100 CHAR) DEFAULT user)
VALUES: (Inserted with Dapper)

Code: Select all

		T2003_COMPRESSED			false		bool?
		T2003_CONTENT				{byte[66]}	byte[]
		T2003_CREATED_AT			null			System.DateTime?
		T2003_CREATED_BY			null			string
		T2003_ID					381837		decimal
		T2003_LOOP					null			decimal?
		T2003_MAINTENANCE_LOOP	null			decimal?
		T2003_MOD_AT				null			System.DateTime?
		T2003_MOD_BY				null			string
		T2003_PRIO					100			decimal?
		T2003_QUEUE				null			string
		T2003_STATUS_ID				null			decimal?
		T2003_STATUS_MSG			null			string
		T2003_SUBSCRIBER			"Test"		string
		T2003_T2000_ID				29765457	decimal?
Any Ideas?

Shalex
Site Admin
Posts: 9210
Joined: Thu 14 Aug 2008 12:44

Re: since 9.14.1150: ORA-03120: two-task conversion routine: integer overflow

Post by Shalex » Sat 13 Feb 2021 12:54

Could you please send us a small complete test project so that we can reproduce the error in our environment?

Jan Zimmermann
Posts: 17
Joined: Mon 25 Mar 2013 10:29

Re: since 9.14.1150: ORA-03120: two-task conversion routine: integer overflow

Post by Jan Zimmermann » Sat 13 Feb 2021 14:26

test project send.

interresting fact: if i comment out the T2003_SUBSCRIBER = "Test" (VARCHAR2) the failure is gone. Integer overflow..?!?

DmitryGm
Devart Team
Posts: 10
Joined: Fri 11 Dec 2020 10:27

Re: since 9.14.1150: ORA-03120: two-task conversion routine: integer overflow

Post by DmitryGm » Mon 22 Feb 2021 14:40

Thanks for your test project, but we are unable to reproduce the error in our environment with dotConnect for Oracle of version 9.14.1180 as well as with the previous version.

We can include the string T2003_SUBSCRIBER = "Test", and the program still works well.

Please send us the exact text of the error with its full stack trace.

hansjoergp
Posts: 24
Joined: Wed 31 May 2017 14:33

Re: since 9.14.1150: ORA-03120: two-task conversion routine: integer overflow

Post by hansjoergp » Tue 23 Feb 2021 07:35

We have the same error described in the post "ORA-01483 and ORA-03120 with newest version". There are also examples.
It seems that the error happens only with Oracle 18 and 19 and maybe it depends also with the charset (in our case NLS_CHARACTERSET = WE8MSWIN1252)

Post Reply