Change plan and backout.method and the character #

[Beth Tuttle]

Sometimes, it is really hard to search ITRC, here, and sc-resources for a problem.  In this case, my keywords are change plan and #.

7.10 app/7.11 rte&web - Web or Windows client

When editing a change (logging or assessment & planning phases), if I put a # as the first character on the line of either plan or backout_method and save the change record, the # will disappear.  It is not saved in the db.

This does not happen on two added fields we have - justificaiton and test plan which are under the same high level tabs.

Any clues?  If no responses here, I'll probably head towards support.

[Jacob Heubner]

What are the data types for the fields where it doesn't work, and the types for the fields where it does?

If I try starting the Description field (the "action" array) in an Incident ticket, the system removes the #.  This is a TEXT type field in the dbdict.  I'm betting it has to do with the datatypes themselves, rather than any kind of coding.  The same thing happens with the < > and = signs as well.

[Beth Tuttle]

Talked to our MS SQL dba.  Not a SQL problem.  He suspects java.  Guess I'll be opening a case.

[Beth Tuttle · Accepted solution]

The problem was that I had a second tab which contained the same field.  When I removed the second instance of the field, the problem went away.