Hi,

I have been getting the following error messages (always together) in one of our CS/TextWorks dbs:

SQL Server error(s)
Error on 'APP-DB1\SQLEXPRESS': Incorrect syntax near 's'.
Error on 'APP-DB1\SQLEXPRESS': Unclosed quotation mark after the character string ".

I have re-indexed all fields, but the error messages continue.

Accessing the same db via the web interface doesn't produce the error messages.

We are using CS/TextWorks v. 9 sp. 1.

Any help, ideas, assistance would be greatly appreciated. Thank you.

I have tried dumping the data and reloading it, but the errors still persist in this one db.

Today I tried converting it again from DB/TextWorks and here is a copy of the CSUpdates.log

5/1/2007 2:44:56 PM: Begin Convert Textbases operation

5/1/2007 2:44:56 PM: Convert 2 DB/TextWorks textbases in folder: E:\CSDATA\Textbases\NewAssetMan\
1. newAssetLoc
2. newAssetMan

Create converted Content Server textbases in folder: E:\CSDATA\Textbases\NewAssetMan\
SQL Server instance: APP-DB1\SQLEXPRESS (local)

Maximum records to buffer: 30000

5/1/2007 2:44:56 PM: Begin processing textbase 'newAssetLoc' (1 of 2)
5/1/2007 2:44:56 PM: Verifying access...
Space used by current textbase: 327 KB
Space required by converted textbase may be significantly greater.
5/1/2007 2:44:59 PM: Dumping records from current textbase...
5/1/2007 2:44:59 PM: 313 records dumped.
5/1/2007 2:44:59 PM: Creating textbase...
5/1/2007 2:45:01 PM: Loading textbase...

Inmagic Content Server
SQL Server error(s):
Error on 'APP-DB1\SQLEXPRESS': Incorrect syntax near 's'.
Error on 'APP-DB1\SQLEXPRESS': Unclosed quotation mark after the character string ''.

5/1/2007 2:45:05 PM: Finished processing textbase 'newAssetLoc' - operation FAILED

5/1/2007 2:45:05 PM: Begin processing textbase 'newAssetMan' (2 of 2)
5/1/2007 2:45:05 PM: Verifying access...
Space used by current textbase: 4,427 KB
Space required by converted textbase may be significantly greater.
5/1/2007 2:45:08 PM: Dumping records from current textbase...
5/1/2007 2:45:09 PM: 5568 records dumped.
5/1/2007 2:45:09 PM: Creating textbase...
5/1/2007 2:45:16 PM: Loading textbase...

Inmagic Content Server
SQL Server error(s):
Error on 'APP-DB1\SQLEXPRESS': Incorrect syntax near 's'.
Error on 'APP-DB1\SQLEXPRESS': Unclosed quotation mark after the character string ''.

5/1/2007 2:46:05 PM: Finished processing textbase 'newAssetMan' - operation FAILED

5/1/2007 2:46:05 PM: Operation complete. Processed 2 textbases.
5/1/2007 2:46:05 PM: Successfully processed 0 textbases.
5/1/2007 2:46:05 PM: Failed to process 2 textbases.
5/1/2007 2:46:05 PM: See log file 'E:\CSDATA\Textbases\NewAssetMan\CSUpdates.log' for details.

Note that the errors also occur while the db is being converted.

I have checked all of our largest dbs and they do not have this problem.

Any help would be appreciated. Thank you.

Hi

I do not know the cause of the errors you are getting - I have not come across these before.

But there is an alternative way to convert DB/Text databases to CS, which will probably work for you:

Use DB/TextWorks to dump all records to a file
Use CS/TextWorks File - New Textbase to create the new textbase, copying from the existing TBA file (Use the drop down list in the "Files of Type" window to select a TBA)
Use CS/TextWorks to Load the dumped file (Manage Textbases - Load New Textbase)

You should probably delete the textbases that were created during the previous conversion attempts, using the CS Admin program.

I hope this helps
Regards
Norma

Thanks for the information.

I did as you suggested, but the error messages appear at the end of the import into the primary database , and again when getting records and sorting them into a report (any report format).

The issue may be specific to your SQL Collation.

Open the textbase, and choose Display>Textbase Information, and see what it says for the Collation here (towards the top):

SQL Database: '_InmTB_239'
Owner: 'DOMAIN\user'
Collation: SQL_Latin1_General_CP1_CI_AS

And here (at the bottom):

SQL Server: machine\SQLSERVER'
Version: 8.00.760
Language: English (United States)
Default collation: SQL_Latin1_General_CP1_CI_AS
Edition: Standard Edition (2)
Version level: SP3
Machine name: machine
Lock timeout: 5000

If the first collation is not one of the following:

SQL_Latin1_General_CP1_CI_AS
SQL_Latin1_General_CP1_CI_AI

I would recommend adding the following section to your INMCSRV.INI file (when CS/TextWorks and Content Server Administration are both closed):

[Advanced]
SQLCollation=SQL_Latin1_General_CP1_CS_AI

Then try creating the textbase and doing the import again.

Notes:

• The textbase collation is set when the textbase is created, so you need to set the collation in the INMCSRV.INI file before you create the textbase.
  
  
• AI means "accent-insensitive" (in other words, a search for Francais will also find Français), which I'm guessing is what you'd prefer.

Thank you for the idea.

Collation information for the db is:

near the top:

SQL Server: 'APP-DB1\SQLEXPRESS'
SQL Database: '_InmTB_115'
Owner: '_Inmagic_Content_Server'
Collation: SQL_Latin1_General_CP1_CI_AS

near the bottom:

SQL Server: 'APP-DB1\SQLEXPRESS'
Version: 9.00.3042.00
Language: English (United States)
Default collation: SQL_Latin1_General_CP1_CI_AS
Edition: Express Edition (4)
Version level: SP2
Machine name: APP-DB1
Lock timeout: 5000

Thanks for the idea.

I ended up contacting Inmagic Support who were able to recreate the error messages.

After much work (importing one record at a time until the first occurance of the error messages) I was able to figure out what the problem was.

Both of the dbs have Access Control fields. Both dbs have "Children's Department" in the Access Control fields.

By editing the Access Control fields and then re-indexing the fields the error messages disappeared.

These entries do not cause any problems in the DB/TextWorks versions of the dbs, but were the cause of all of my grief in CS/TextWorks.

After a quick glance at CS Help > Access Control I didn’t see that apostrophe marks are not allowed.