Error trying to create cube partition

I've converted 4 AS2000 databases to AS2005. In just one of these databases, I am not able to add any partitions to any of the cubes. As soon as I click the "New Partition" link, get the following error:

The wizard will close because of the following error: An item with the same key has already been added (mscorlib).

I get this error if I try to create a parition from either Visual Studio 2005 or SQL Server Management Studio. AS2005 version is 9.00.2047.00. I can add paritions to cubes in other databases on the same server.

I've been all over looking for help on this, with no luck at all.

If anyone can help me, I'd sure appreciate it.

Most likely something went wrong with the database during migration.

It is possible your database had some problems even before migrated and then migration wizard created AS2005 database with the wrong structure.

It is hard to say what exactly you are having. First go through your AS2000 database structure and make sure it is all valid. Make sure you got the latest AS2000 service pack.

Then migrate your database again and try creating a new AS2005 project based on migrated database. You do that by going through new project wizard and selecting "Import Analysis Ser...."

Go through your new database, open every object in editor and make sure there are no errors and all the object relationships are set right. One area is to pay attention is Dimensions Usage tab in cube editor.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I've checked the AS2000 datbase structures and it's all valid: cubes, dimenions, security roles, partitions, data. Everything there checks out from Analysis Manager as well as from our front-end application that uses OWC to connect to these cubes. The latest service pack is installed.

I have checked all of the objects in the AS2005 databases. There are no errors, and the cubes function properly.

I could migrate the database again, but it's got over 150 cubes, and over 400 seucirty roles. I really hate to do it unless I absolutely have to. Thanks for your suggestion...it may be my last resort.

Error translations

I'm importing data from a flat file into a SQL Server table. Yes, I have this thing mapped correctly, data converted correctly, data scrubbed correctly. I've tested this against 14 successive files dumped from the source system and everything works perfectly...until today. Now I'm getting the following gobbledygook.

I have absolutely no clue where to even begin looking. I've already inspected every single column in the input file that is converted to something other than a string. Absolutely nothing shows up as being an overflow or truncation issue. I've calculated the maximum length of every single text column being imported and none of them overflow the destination either. Where do I even start in this completely uninformative junk to even try to figure out where the issue is?

Error: 0xC02020C7 at Load Tables, MLBAMBio [1656]: The attempt to send a row to SQL Server failed with error code 0x80004005.

Error: 0xC0047022 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "MLBAMBio" (1656) failed with error code 0xC02020C7. 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.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC02020C7. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread7" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0202009 at Load Tables, MLBAMBio [1656]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E57.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E57 Description: "The statement has been terminated.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E57 Description: "String or binary data would be truncated.".

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread1" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread7" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread3" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread1" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread3" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread9" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread9" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Error: 0xC0047039 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADCANCELLED. Thread "WorkThread2" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. There may be error messages posted before this with more information on why the thread was cancelled.

Error: 0xC0047021 at Load Tables, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread2" has exited with error code 0xC0047039. There may be error messages posted before this with more information on why the thread has exited.

Information: 0x40043008 at Load Tables, DTS.Pipeline: Post Execute phase is beginning.

Information: 0x402090DD at Load Tables, Biography [951]: The processing of file "D:\FTPtransfersource\curbio.csv" has ended.

Error: 0xC02092B5 at Load Tables, MLBAMBio [1656]: A commit failed.

Error: 0xC0047018 at Load Tables, DTS.Pipeline: component "MLBAMBio" (1656) failed the post-execute phase and returned error code 0xC02092B5.

Have you tried changing the OLEDBsource &* connection manager, as I have fixed it earlier for the "DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread9" has exited" issues (trying to workaround).|||Can you set up error redirection to capture the rows that are causing the problem?|||

I would start looking for the field(s) that make it fail.

If the error redirection does not help, try splitting your file in halves (binary search) until you get close to the source of the problem.

Thanks.