History/Activity-NTEXT Field - character issue (RollupByid, Unicod

Ok, here's the deal, and lets see if it get broken here when I past it in, 

1. Try to view cirtain customer's history and get sql error (soap exception, 
you know the one that really doesn't tell you anything).

2. Look at customer's "History" by using advanced find to find all the 

3. Notice that one of the activities has it's 5000 character NTEXT Field 
filled with what appears to be a "copy/paste" from an outlook e-mail, to 
which I can open just fine.

4. out of sheer desperation of trying to figure out what the problem is, I 
went into the activitypointerbase table and emptied out the description ( set 
description = '' )

5. History works fine.

6. Updated the field back to the orginal text, broken again.

Copying and pasting from e-mail is often used in our company, and even from 
the web. 

I honestly think this is a buggy thing, however; I have to do several things 
as we have several customers "History" that we cannot view.

1. Microsoft Fixes CRM so it can read what's in there, because obviously the 
ntext field of the TASK allows whatever was pasted into it to be saved by SQL.

2. We write some custom jscript that does a regular expression on the 
contents on the onChange event that strips out all odd characters.

3. We write some SQL Job that does the same every so often on the ntext field.

Beats me, just thought I'd share, if anyone else has the issue.
6/1/2007 6:07:01 PM
crm 35858 articles. 1 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 21


Similar Artilces:

Public Calendar Replication Issues
I am running Exchange 2003 with SP2 and I have to server each with a Public folder store. All the public folder replicate fine expect the Public Calendars, every item in the public calendars replicate except for reoccurring appointments. Has anyone seen this before? ...

Outlook 20067 & Outlook Connector: Hotmail account Issue Passwords not remembered
Hello, I'm using the Outlook Connector with Outlook 2007 to access a few Hotmail based email accounts. Everytime I start Outlook and sometimes between, I'm prompted to reinput the Hotmail account passwords regardless whether or not I check the box to remember the password. Any suggestions as to what may be going wrong - or is it a known issue ? Thanks in advance, Steve How many is a few and which value do you have set for your automatic send/receive interval? 2 or 3 accounts with a send/receive interval set to longer than 10 minutes should be ok. V...

Wait activity not firing in workflow, very strange one
First thanks all for your time on this strange case, can't figure work why it is happening like this. A simple work flow is fired when an entity is created, so Oncreate... Wait formxxx.xxx.value = 'yes' End wait Dosomething OK firstly it is Network Service account running the workflow service, and it has the complete permission as a domain administrator, so no permission issue here. Secondly we have two CRM system, which is exactly the same besides one has rollup 2 applied and the other doesn't. All this workflow things runs perfectly fine on the one where NO rollup ...

office 2004 (excel & word) afp file path issue on tiger server (10.4.9)
g'day, we have just changed over to an xserve (running 10.4.9, HFS+ with ACLs) and are experiencing the following problem with office 2004 excel & word files only - surprisingly powerpoint files are not affected: all excel and word files without spaces in either file- path or -name open just fine, however all files with spaces in file-path or -name generate the following error message... <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_1.png" alt="excel error message" /> for the above we used the following example file: -rwxr--r-- 1 daniel...

Subform within tabs issue
I've been trying to incorportate a subform within a tab. When I go from design view to form view the subform takes over all the screen space, I cannot see the tabs or the top of the form. Any ideas? ...

create rule based on the DISPLAYED from field
Hi Group, I'm using Outlook 2007. Is it possible to create a rule that searches the text displayed in the "from" field? I would like to delete messages with certain offensive words in the "from" field, but I'm unable to find any rule that does that. I can see the words of "interest" if I go to Message options / Internet headers, but how do you build a rule based on that ? thank you, andy use a 'words in the header' rule. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchan...

Text Form Field Maximum Character Length
I want to have a text form field that has a maximum character limit of 300 characters. I go into properties and set the max length to 300 and select calculate on exit, but it doesn't stop entries over the 300 characters. Any suggestions? It is Word 2003. -- Thanks, Angie ...

eConnect 10 SP2 with Analytical Accounting Issue
Hi All, I am trying to integrate Receivable Transactions (Invoice ,Debit or Credit Memos) with distributions and Analytics Accounting Information by using eConnect, i was getting the following error related to Analytical Accounting while running the integration The procedure or Function 'taAnalyticsDistribution' expects parameter '@I_vDOCNMBR' which was not supplied. But actually i am passing the DOCNMBR value along with AA XML Nodes this is my xml <eConnect xmlns:dt='urn:schemas-microsoft-com:datatypes'> <...

Security Issue 08-26-04
Hello, I performed a test installation, with only 1 BU (TEST). In the RBU I made a new role with only "user" rights (access level) for accounts. To my surprise, the account (in the BU TEST) with the new role could not only see all accounts (assigned to other accounts, no teams,) but could also change the info in the account fields!! So, access level = User, people with that role should have the priveliges: 1. Records they own, 2. Shared with them, 3. Shared with a team of wich the user is a member. Those three conditions are not valid for the existing records and the user should not...

tab character not work
Hi all, I want to insert tab space in a cell so I tried: ="Hello ," & CHAR(9) & "world", but it will still get "Hello,world" instead of "Hello,___world" (___ is the tab space). In vba, I tried using vbTab, but it is still not working. Do anyone know how to insert a tab in either cell or vba? I am using Excel 2007. Any help would be appreciated. Tab characters don't work like they do in MSWord. (You should be seeing a little square where that tab character is, though.) Maybe you can either use spaces--or create a table in MSW...

Active X and Data Grid
I am trying to access a SQL database and get a list for the user to select from to be used in additional queries. I have created an ActiveX Data Object and a Data Grid Object, and I am trying to figure out how to link the two. In visual basic, in the properties, there is a line called datasource that links the two that isn't present in VBA. Any help would be appreciated. "Richard Mogy" wrote ... > I am trying to access a SQL database and get a list for the user to select > from to be used in additional queries. > > I have created an ActiveX Data Object and a D...

AutoFill Form Field
How do I get a field to autofill the same value as the previous record when I goto a new record. The field's control source is the table field. Can I use autofill in Default value? -- Gator Hi, Private Sub controlname_AfterUpdate() Me.controlname.DefaultValue = Chr(34) & Me.controlname & Chr(34) End Sub Thus if the user enters XYZ it will set the DefaultValue property to "XYZ" which will be used for the next entry. Jeanette Cunningham "Gator" <Gator@discussions.microsoft.com> wrote in message news:F2EE9FB9-48A7-4EAC-8EFC-541324F5D10D@microsof...

How to Rename Active Directory
hi I need to Rename my Active Directory my current name company.local I need to change it 123compay.com Please help me. -- shivaj ------------------------------------------------------------------------ shivaj's Profile: http://forums.techarena.in/members/151956.htm View this thread: http://forums.techarena.in/active-directory/1294587.htm http://forums.techarena.in Howdie! shivaj wrote: > I need to Rename my Active Directory > > my current name company.local > > I need to change it 123compay.com It is possible from Server 2003 on...

Change default value of From: field
Hey all, Is there a registry hack or something similar that can make my default 'from' address something other than my primary address? I can easily type the alternate address in for every email but that's a huge pain. Any help is much appreciated. What type of email account? If IMAP or POP3, no hack needed - change it on the Account settings dialog. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com/ Outlook Tips by email: mailto:dailytips-subscribe-request@lists.o...

Sync Issues Folder #2
I have installed MS Office 2003 and I am using it with Excahnge server. For some reason, the "Sync Issues" folder under my mailbox folder has been renamed to "Sync Issues1". I'd like to get the name changed back to the original "Sync Issues". I can't use the usual folder rename as this is a special outlook folder related to the server sync. features in Outlook 2003. I am using Outlook in cached mode. How can I get ths folder back to its orginal name? ...

Contact and Calendar issues
I recently upgraded fron Vista to windows 7. Then I downloaded Windows Live Mail without a login. I was happy to see that all my old mail, my contacts and my calendar appeared in the new mail program. Then I created a Windows Live login and signed in. My mail still works fine but more that half of my contacts are missing and if I am not signed in, I can't see anything on my calendar. I am not interested in all the social networking feature of Windows Live, I really only want to share a calendar with my family on my home network. What did I do wrong and how can I get my ...

Non-Breaking Space + Print Issue
I have two questions for the group. 1) I'm having the same problem as others with getting the Y axis labels to print completely. It appears that the last character of the axis label is cut in half. I've seen someone post the code for a non-breaking space, but I can't find it. 2) I have some bubble charts that I'm trying to print. When I print them directly from excel, they print as squares with inscribed circles. The same happens when I print from Word and the chart is copies as a picture file from Excel to Word. Once the Word document is PDF'd, the bubble cha...

Word 2008 "Draft View" font drawing issues
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel When I work in &quot;draft view,&quot; which is most of the time, and I'm scrolling, the program often doesn't properly redraw the text. As a result, the ends of lines of text disappear or sometimes I see double images of text. I can redraw the text either by doing a &quot;select all&quot; or by flipping to &quot;print layout view,&quot; both of which are complete time-wasters. <br><br>I didn't have this problem in Word 2004 when I was in &quot;normal view,&quot...

Deletion of Fields
Haven't seen this asked in a while... any chance of field deletion in the future? We have about 20 extra fields we do not use/need. Kristina ps We have a test environment, I would be happy to give things a try if anyone has done this already... Kristina, There is a way to do this. First, make sure the field isn't being used in any forms, views or maps. This needs to be done manually. Though there are tables you can query to determine some of this information. Then, use the sp_ReplDropColumn command to remove the field. This will ensure that replication "sees" the ...

SFO Offline Issue 10-21-04
When attempting to go offline or do an initial sync of SFO I receive an error saying that SFO cannot go offline. The logged on user does not have the sufficient privileges, or the CRM server was not found. Outlook is running in online mode and all functionality other than syncing/offline is working. What did I miss? All CRM functionality via IE works, none of the CRM buttons in Outlook are functional (an error occurred whil trying to synchronize the data to the CRM system), via SFO client I can access all data. Thanks, Steve check the crmaddin.dll in outlook com addins. If you do not s...

Compact and Repair Vista Issue
Does anyone know a fix around loosing your data when doing a compact and repair in Microsoft Access on Vista? We have a quoting software, when they select yes to optimize the database (compact and repair) it wipes their entire database clean along with the backup copy on the desktop. Please help...big problem! Thanks Ashley Ashley, can you provide any more details of this problem? What version of Access? Does this happen always? Occasionally? One in a blue moon? Is the database split? If so, is it the front end or back end that disappears? Does it make any difference if you create ...

copi field
Hey. i have made a form with about 15 fields. And now i want to make a button, wich copi the text in one of my fields. is it posible, maybe made with "visual basic"??? hope someone can help me. thanks david ...

Make a field mandatory after entity creation... CRM 4
Hi.. Our company uses MS CRM 4.0 to manage Customer Support Service. So we have a person who receives the emails from our customers and creates the cases. We have two custom fields to control the correct response time to our customers.. The first one is created by this person, and it's the "email reception time". So after she created the case and filled the "email reception time", one of our consultants receives the case and starts working on it.. We have a second custom field which is the "response time". This field must be filled by the consultant. ...

Issues with Outlook crashing
Only a few of my users have the CRM Outlook client installed at this stage. They have just informed me that they had been having a lot of issues with Outlook crashing. They were pretty sure it was related to the CRM client, so 2 of them uninstalled it, and seem to no longer be having problems. >From what they were saying, there seemed to be 2 different issues: 1 - Outlook crashed when opening/sending emails 2 - Outlook crashed when setting up appointments I haven't been able to recreate the first issue, but I believe it's probably related to Microsoft KB931270 (Error message when...

Keydown Event while in a data Entry Field
I have a Keydown event checking for F10 on a data entry form. In my form I have 10 data entry fields. Let say I put data in the first 5 and after typing in the 6th (without moving out of the field) I hit the F10 key. The F10 logic processing only recognizes the values in fields 1-5 and nothing in field 6. I there a way to commit the values that were started to be typed in Field 6 in the start of the logic of the F10 keydown event. Thanks, Don OK I figured out a work around, but I would still like to hear of other ways of accomplishing the same thing. my workaround: Af...