Error when attempt to import customizations to different server.

When attempting to import customizations from our development server to our
production service we are receiving a "SQL Server error occurred". We are
not seeing any errors in the SQL log but we are seeing errors in the IIS
Error Log.

2006-11-02 21:17:33 W3SVC1 POST /MSCRMServices/ImportXml.asmx - 80
CRMSvcAcct xx.xx.xx.xx
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 500 0 0
2006-11-02 21:17:33 W3SVC1 POST
/tools/systemcustomization/ImportCustomizations/importCustomizationsGrid.aspx
- 80 CRMSvcAcct
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST
/MSCRMServices/notification.asmx - 80 - xx.xx.xx.xx
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 2 2148074254
2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
- 80 - xx.xx.xx.xx
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 1 0
2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
- 80 DEV-CRM02$ xx.xx.xx.xx
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 200 0 0
2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
- 80 - xx.xx.xx.xx
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 2 2148074254
2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
- 80 - xx.xx.xx.xx
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 1 0
2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
- 80 DEV-CRM02$ xx.xx.xx.xx
Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 200 0 0

We started with importing all the customization at the same time and then
down to one by one. We still throw the error on a single entity (account).

Our guess is that this is an authentication error based on code (500, 401)
but this only occurs on one entity that is exported in the customization file
all the others work.

Any ideas of what we are doing wrong?

ReeceWilliams
Thu Nov 02 17:27:01 CST 2006

Have you changed the datatype of any custom attributes in account? That
causes SQL errors in import.
The other thing to do is turn on tracing during the import. It spits out a
lot of dross, but it will give you a more specific SQL error message.

HTH,
R.

"George McRae" wrote:

> When attempting to import customizations from our development server to our
> production service we are receiving a "SQL Server error occurred". We are
> not seeing any errors in the SQL log but we are seeing errors in the IIS
> Error Log.
>
> 2006-11-02 21:17:33 W3SVC1 POST /MSCRMServices/ImportXml.asmx - 80
> CRMSvcAcct xx.xx.xx.xx
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 500 0 0
> 2006-11-02 21:17:33 W3SVC1 POST
> /tools/systemcustomization/ImportCustomizations/importCustomizationsGrid.aspx
> - 80 CRMSvcAcct
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
> 2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST
> /MSCRMServices/notification.asmx - 80 - xx.xx.xx.xx
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 2 2148074254
> 2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> - 80 - xx.xx.xx.xx
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 1 0
> 2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> - 80 DEV-CRM02$ xx.xx.xx.xx
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 200 0 0
> 2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> - 80 - xx.xx.xx.xx
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 2 2148074254
> 2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> - 80 - xx.xx.xx.xx
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 1 0
> 2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> - 80 DEV-CRM02$ xx.xx.xx.xx
> Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 200 0 0
>
> We started with importing all the customization at the same time and then
> down to one by one. We still throw the error on a single entity (account).
>
> Our guess is that this is an authentication error based on code (500, 401)
> but this only occurs on one entity that is exported in the customization file
> all the others work.
>
> Any ideas of what we are doing wrong?
>

GeorgeMcRae
Fri Nov 03 08:12:02 CST 2006


Thanks that was right on.
-George

"Reece Williams" wrote:

> Have you changed the datatype of any custom attributes in account? That
> causes SQL errors in import.
> The other thing to do is turn on tracing during the import. It spits out a
> lot of dross, but it will give you a more specific SQL error message.
>
> HTH,
> R.
>
> "George McRae" wrote:
>
> > When attempting to import customizations from our development server to our
> > production service we are receiving a "SQL Server error occurred". We are
> > not seeing any errors in the SQL log but we are seeing errors in the IIS
> > Error Log.
> >
> > 2006-11-02 21:17:33 W3SVC1 POST /MSCRMServices/ImportXml.asmx - 80
> > CRMSvcAcct xx.xx.xx.xx
> > Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 500 0 0
> > 2006-11-02 21:17:33 W3SVC1 POST
> > /tools/systemcustomization/ImportCustomizations/importCustomizationsGrid.aspx
> > - 80 CRMSvcAcct
> > Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
> > 2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST
> > /MSCRMServices/notification.asmx - 80 - xx.xx.xx.xx
> > Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 2 2148074254
> > 2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> > - 80 - xx.xx.xx.xx
> > Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 1 0
> > 2006-11-02 21:17:49 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> > - 80 DEV-CRM02$ xx.xx.xx.xx
> > Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 200 0 0
> > 2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> > - 80 - xx.xx.xx.xx
> > Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 2 2148074254
> > 2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> > - 80 - xx.xx.xx.xx
> > Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 401 1 0
> > 2006-11-02 21:18:19 W3SVC1 xx.xx.xx.xx POST /MSCRMServices/notification.asmx
> > - 80 DEV-CRM02$ xx.xx.xx.xx
> > Mozilla/4.0+(compatible;+MSIE+6.0;+MS+Web+Services+Client+Protocol+1.1.4322.2300) 200 0 0
> >
> > We started with importing all the customization at the same time and then
> > down to one by one. We still throw the error on a single entity (account).
> >
> > Our guess is that this is an authentication error based on code (500, 401)
> > but this only occurs on one entity that is exported in the customization file
> > all the others work.
> >
> > Any ideas of what we are doing wrong?
> >