[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ORA-06550

Posted on 2011-05-11
10
Medium Priority
?
1,836 Views
Last Modified: 2012-06-21
While copying information from Microsoft Sql Server 2008 R2 (64bit) to my Oracle 10g Database using the SQL Server Import and Export Wizard I get the following error below:

Messages
Error 0xc020844b: Data Flow Task 1: An exception has occurred during data insertion, the message returned from the provider is: ORA-06550: line 1823, column 1:
PLS-00123: program too large (Diana nodes)

 (SQL Server Import and Export Wizard)
 
Error 0xc0047022: Data Flow Task 1: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination - GB_ELECTORAL_DB_COPY" (61) failed with error code 0xC020844B while processing input "Destination Input" (64). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020c4: Data Flow Task 1: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.
 (SQL Server Import and Export Wizard)
 
Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.  The PrimeOutput method on component "Source - Query" (1) returned error code 0xC02020C4.  The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.  There may be error messages posted before this with more information about the failure.
 (SQL Server Import and Export Wizard)
 
0
Comment
Question by:dpdmembers
  • 5
  • 5
10 Comments
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35740753
Looks like it's a bug.  Never saw that specific error before so had to search around:

http://www.orafaq.com/forum/t/87774/2/
0
 

Author Comment

by:dpdmembers
ID: 35740896
No help at all
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35740933
ummmm, OK....  If 'might be a bug' doesn't help...

Did it ever work?  
Is this the first time you've tried this?  
Are you on the latest Oracle patches?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:dpdmembers
ID: 35740943
First time..latest patches
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35740965
"I solved this problem by setting the batch size to 200"

http://www.devart.com/forums/viewtopic.php?t=17859&sid=8ddcecfebbba411b3c09662733f66b3f
0
 

Author Comment

by:dpdmembers
ID: 35741025
How do you set the batch size?
0
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1000 total points
ID: 35741592
I don't know SSIS but in looking around:

The batch size is controlled by the SSIS buffer controls DefaultBufferMaxRows and DefaultBufferSize properties of a data flow task.

http://ssisbatchgeocoder.codeplex.com/documentation
0
 

Author Comment

by:dpdmembers
ID: 35747077
I am currently using Microsoft SQL 2008, so how do I set the buffer in that program?
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35747780
I'm not a SQL Server person.  Only Oracle.  From the link I found and posted I was thinking there is a properties section somewhere in the SSIS tool.
0
 

Author Closing Comment

by:dpdmembers
ID: 36145634
Not an Expert
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question