Record merge error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Record merge error

Author

Topic

PVETSL
Starting Member

2 Posts

Posted - 2009-08-24 : 08:37:21

Hi,

I am new to this forum and SQL 2005. Not sure this the correct area to post this, but here goes.

We have a server running CRM4 and SQL 2005. It was an upgrade from CRM3 and SQL 2000. When trying to merge records in CRM, we get an invalid argument error. When running a trace in CRM we get the following Trace as follows: -

>Crm Exception: Message: Type Mismatch: Type of Attribute: CustomerAddress.objecttypecode is: System.Int32. However, Type of passed-in value is: System.String, ErrorCode: -2147220989, InnerException: System.ArgumentException: Type Mismatch: Type of Attribute: CustomerAddress.objecttypecode is: System.Int32. However, Type of passed-in value is: System.String

This seems to be an SQL issue?
What would be the best way to troubleshoot this, please?

I have run a basic DBCC check on the database with no errors.

Thanks for your time in advance.

Regards,

PETSL.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-08-24 : 10:40:48

quote:
Originally posted by PVETSL

Hi,

I am new to this forum and SQL 2005. Not sure this the correct area to post this, but here goes.

We have a server running CRM4 and SQL 2005. It was an upgrade from CRM3 and SQL 2000. When trying to merge records in CRM, we get an invalid argument error. When running a trace in CRM we get the following Trace as follows: -

>Crm Exception: Message: Type Mismatch: Type of Attribute: CustomerAddress.objecttypecode is: System.Int32. However, Type of passed-in value is: System.String, ErrorCode: -2147220989, InnerException: System.ArgumentException: Type Mismatch: Type of Attribute: CustomerAddress.objecttypecode is: System.Int32. However, Type of passed-in value is: System.String

This seems to be an SQL issue?
What would be the best way to troubleshoot this, please?

I have run a basic DBCC check on the database with no errors.

Thanks for your time in advance.

Regards,

PETSL.

Seems to be an application error. You'll need to capture what value the app is attempting to pass in, and fix it

PVETSL
Starting Member

2 Posts

Posted - 2009-08-25 : 10:55:36

Hi,

Thanks for your response, should I be able to see this information from the same trace? What should I be looking for?

Again thanks for taking the time and effort.

Regards,

Peter.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources