Bryan S

We are having an issue when we attempt to insert a KB Article into an E-Mail
Msg in CRM. When we try to do a full text search in the look up articles box
we get the following error:

A SQL Server Error occurred. For more information, contact your system
administrator.

We get the same error when we select Keyword and Title search, but we can
search by article number and do a subject browse.

There is nothing in any of the event logs or the the sql logs.

Imran

install the rollup update 2.. support.microsoft.com/kb/922815

--
Regards,

MS CRM Certified Professional

http://microsoftcrm3.blogspot.com

Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com



"Bryan S" wrote:

> We are having an issue when we attempt to insert a KB Article into an E-Mail
> Msg in CRM. When we try to do a full text search in the look up articles box
> we get the following error:
>
> A SQL Server Error occurred. For more information, contact your system
> administrator.
>
> We get the same error when we select Keyword and Title search, but we can
> search by article number and do a subject browse.
>
> There is nothing in any of the event logs or the the sql logs.
>
>

Bryan S

I installed the rollup Update 2 as described, and still no change. Any other
suggestions?

"Imran" wrote:

> install the rollup update 2.. support.microsoft.com/kb/922815
>
> --
> Regards,
>
> MS CRM Certified Professional
>
> http://microsoftcrm3.blogspot.com
>
> Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com
>
>
>
> "Bryan S" wrote:
>
> > We are having an issue when we attempt to insert a KB Article into an E-Mail
> > Msg in CRM. When we try to do a full text search in the look up articles box
> > we get the following error:
> >
> > A SQL Server Error occurred. For more information, contact your system
> > administrator.
> >
> > We get the same error when we select Keyword and Title search, but we can
> > search by article number and do a subject browse.
> >
> > There is nothing in any of the event logs or the the sql logs.
> >
> >

Bryan S

I installed the rollup Update 2 as described, and still no change. Any other
suggestions?

"Imran" wrote:

> install the rollup update 2.. support.microsoft.com/kb/922815
>
> --
> Regards,
>
> MS CRM Certified Professional
>
> http://microsoftcrm3.blogspot.com
>
> Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com
>
>
>
> "Bryan S" wrote:
>
> > We are having an issue when we attempt to insert a KB Article into an E-Mail
> > Msg in CRM. When we try to do a full text search in the look up articles box
> > we get the following error:
> >
> > A SQL Server Error occurred. For more information, contact your system
> > administrator.
> >
> > We get the same error when we select Keyword and Title search, but we can
> > search by article number and do a subject browse.
> >
> > There is nothing in any of the event logs or the the sql logs.
> >
> >

Bryan S

I installed the rollup Update 2 as described, and still no change. Any other
suggestions?

"Imran" wrote:

> install the rollup update 2.. support.microsoft.com/kb/922815
>
> --
> Regards,
>
> MS CRM Certified Professional
>
> http://microsoftcrm3.blogspot.com
>
> Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexpert@gmail.com
>
>
>
> "Bryan S" wrote:
>
> > We are having an issue when we attempt to insert a KB Article into an E-Mail
> > Msg in CRM. When we try to do a full text search in the look up articles box
> > we get the following error:
> >
> > A SQL Server Error occurred. For more information, contact your system
> > administrator.
> >
> > We get the same error when we select Keyword and Title search, but we can
> > search by article number and do a subject browse.
> >
> > There is nothing in any of the event logs or the the sql logs.
> >
> >

bryanb@globalgrowth.com.au

On Dec 14, 6:27 am, Bryan S <Bry...@discussions.microsoft.com> wrote:
> It had to do with the full text index. here are the instructions i got from
> Microsoft:
>
> Lets try to setup the Catalog for Indexing on the CRM implementation. I have
> outlined the steps below. Before performing these steps, please make sure
> you have a backup of the databases.
>
> a. Launch SQL Server Management Studio (user should have admin access to SQL
> and
> MSCRM database).
> b. Expand the server, expand databases, expand Your_Company_Name_MSCRM, and
> then
> expand tables.
> c. Right-click the DocumentIndex table, click Full-Text Index Table, and then
> click Define Full-Text Indexing on a Table.
> d. On the Select Table Columns page, select the following items, and then
> select
> the default options on the remaining pages of the wizard:
> * Title
> * KeyWords
> * Search Text
> e. Under the Your_Company_Name _MSCRM database, click Full-Text Catalogs.
> f. In the right pane, right-click ftcat_documentindex, and then click Rebuild
> Catalog.
> g. Right-click ftcat_documentindex, and then click Start Full Population.
> h. Right-click ftcat_documentindex, and then click Start Incremental
> Population.
> i. In Enterprise Manager, expand Support Services, right-click Full-Text
> Search,
> and then click Start.
> Note:
> Please make sure that the account you are using to perform this task is a
> member
> of the PrivUserGroup and SQLAccessGroup CRM security groups in the AD. This
> should
> ensure that you have access to MSCRM related information.
>
> "bry...@globalgrowth.com.au" wrote:
> > On Nov 30, 12:25 am, Bryan S <Bry...@discussions.microsoft.com> wrote:
> > > I installed the rollup Update 2 as described, and still no change. Any other
> > > suggestions?
>
> > > "Imran" wrote:
> > > > install the rollup update 2.. support.microsoft.com/kb/922815
>
> > > > --
> > > > Regards,
>
> > > > MS CRM Certified Professional
>
> > > >http://microsoftcrm3.blogspot.com
>
> > > > Chat with me on MSN / Gmail / Skype : ID Is :.. mscrmexp...@gmail.com
>
> > > > "Bryan S" wrote:
>
> > > > > We are having an issue when we attempt to insert a KB Article into an E-Mail
> > > > > Msg in CRM. When we try to do a full text search in the look up articles box
> > > > > we get the following error:
>
> > > > > A SQL Server Error occurred. For more information, contact your system
> > > > > administrator.
>
> > > > > We get the same error when we select Keyword and Title search, but we can
> > > > > search by article number and do a subject browse.
>
> > > > > There is nothing in any of the event logs or the the sql logs.
>
> > I am having the same problem. Did you manage to resolve this issue?

That sorted it out. Thanks a heap for the reply.