Oracle Error Ora-03124 Two-task Internal Error
xinhuan I am getting ORA-03124: two-task internal error (DBD ERROR: OCIStmtExecute) when using DBD::Oracle version 1.23. This is a select query. Oracle server is 11g and client is also 11g. The select statement is like this: select col1, col2 from table where key = '12335|678999|345667'; The interesting thing is the query worked at the very first time, and failed on second time and onwards. My question is: does DBD::Oracle 1.23 (latest version) support Oracle 11g client and server? If it is, is this a known bug in Oracle 11g server or client or in DBD::Oracle module? Thanks, --xinhuan Posted on 2009-08-21 10:15:05-07 by byterock in response to 11339 The ora-03124 has nothing to do with DBB::Oracle as this is either a disk/space issue a license issue (as in you do not have the correct one) or you are trying to stuff too much data into a single row or field. You will have to look at you oracle logs to see what is going wrong. As it ran once I would go the too much data in a row or field and it might have something to do with non UTF8 chars By they way no one but me actually look at this list (and I only when I have some spare time) You would be much better off posting on the DBI mailing list or raise a RT ticket (This article is based on a thread on the CPAN::Forum.) Suggest a change English about the translations
- 03124 "two-task internal error" If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: ORA - 03124 "two-task internal error" Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch http://perlmaven.com/ora-03124-two-task-internal-error-dbd-error-ocistmtexecute to Threaded Mode 08-05-2001,07:27 AM #1 prashk View Profile View Forum Posts Junior Member Join Date Aug 2001 Posts 3 Hello, I am importing a large file having 300000 rows into a table. After importing around 29000 rows I get the error code ORA 03124 " two task internal error" and the action recommended by Oracle is to "contact the ORacle customer http://www.dbasupport.com/forums/showthread.php?14162-ORA-03124-quot-two-task-internal-error-quot support representative" . Is this an Oracle bug? I am migrating a table column from Long raw to blob and for this , I am exporting the table with the long raw column. Dropping the table and again creating the table with a Blob column and then importing the file. I get this error and am stuck. Can somebody give some suggestions/help? Thanks Reply With Quote 08-06-2001,05:29 AM #2 birdax1 View Profile View Forum Posts Visit Homepage Member Join Date Sep 2000 Posts 100 Check the free space in the tablespace. Also check the following things 1) The record length of the record 2) Is the table default tablespace is system. 3) Check the records in 251 -- 253 for the datatype mismatch I hope this is of some help? The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office. Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle
not be able to provide a lot of details butI'm hitting the following error:ORA-03124: two-task internal errorThe application is failing on an update statement. I've enabledtracing to grab the bind variables and http://grokbase.com/t/freelists.org/oracle-l/079m9at5nj/ora-03124-two-task-internal-error-any-thoughts I can run the statement manuallywithout error.The update statement is pretty simple:UPDATE MYTABLE SET http://knowledgebase.progress.com/articles/Article/P155898 ACOL = :1 WHERE BCOL = :2From the trace:Bind#0oacdty=01 mxl=4001(12000) mxlc=00 mal=00 scl=00 pre=00oacflg=01 fl2=1000000 frm=01 csi=871 siz=4000 off=0kxsbbbfp=ffffffff7b17bfd0 bln=4000 avl=00 flg=05Bind#1oacdty=01 mxl=2000(360) mxlc=00 mal=00 scl=00 pre=00oacflg=01 fl2=1000000 frm=01 csi=871 siz=2000 off=0kxsbbbfp=ffffffff7b169dd8 bln=2000 avl=19 flg=05value="7036874417766400004"Thanks!This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not oracle error the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.--http://www.freelists.org/webpage/oracle-l reply Tweet Search Discussions Search All Groups oracle-l 4 responses Oldest Nested Alvaro Jose Fernandez Hi, When you manually run the update, which value exactly are you using for oracle error ora-03124 ACOL? I'm seeing that the passed bind length for ACOL (bind #0, siz=4000) would be some reason for the crash . Are you using OCI/ODBC/???? Hey all, I'll apologize up front for not be able to provide a lot of details but I'm hitting the following error: ORA-03124: two-task internal error The application is failing on an update statement. I've enabled tracing to grab the bind variables and I can run the statement manually Alvaro Jose Fernandez at Sep 20, 2007 at 7:19 pm ⇧ Hi,When you manually run the update, which value exactly are you using forACOL?I'm seeing that the passed bind length for ACOL (bind #0, siz=4000)would be some reason for the crash . Are you using OCI/ODBC/????Hey all,I'll apologize up front for not be able to provide a lot of details butI'm hitting the following error:ORA-03124: two-task internal errorThe application is failing on an update statement. I've enabledtracing to grab the bind variables and I can run the statement manuallywithout error.The update statement is pretty simple:UPDATE MYTABLE SET ACOL = :1 WHERE BCOL = :2From the trace:Bind#0oacdty=01mxl=4001(12000) mxlc=00 mal=00 scl=00 pre=00oacflg=01 fl2=1000000 frm=01 csi=871 siz=4000 off=0kxsbbbfp=ffffffff7b17bfd0 bln=4000 avl=00 flg=05Bind#1oacdty=01 mxl=2000(360) mxlc=00 mal=00 scl=00 pre=00oacflg=01 fl2=1000
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Global Sites Braz