Bartender 9.3 - Insert Error For Dbo.btprintjoboptions
Hello,
In the Eventviewer we get a message every couple of minutes stating that BT cannot insert a row into dbo.BtPrintJobOptions.
+++++++++++++++++
Table: BtPrintJobOptions,
Command: INSERT INTO dbo.BtPrintJobOptions([ActionID],[AllowFormatCaching],[AllowGraphicCaching],
[AllowSerialization],[AllowStaticGraphics],[AllowStaticObjects],[AllowVariableDataOptimization],
[AutoPrintAgain],[BoxesID],[DataItemName],[DataItemTypeID],[EllipsesID],[EnablePrinterCodeModifier],
[EnablePrompting],[IgnoreCase],[LinesID],[LogPrintJob],[NumberLabels],[OccurrenceID],[PrintJobID],
[PrintToFile],[RefreshDatabases],[ShowPrinterCode],[TrueTypeTextID],[Unsupported1DBarCodesID],
[Unsupported2DBarCodesID],[WarnWhenUsingTrueTypeFonts])
VALUES(-2147483493,0,0,1,1,1,1,0,-2147483513,N'',-2147483507,-2147483513,0,1,0,-2147483513,0,0,-2147483507,
-2142400471,0,0,0,-2147483508,-2147483513,-2147483513,1);
SELECT SCOPE_IDENTITY();
Inner Message: Cannot insert the value NULL into column 'PrintOnBothSides',
table 'BarTender.dbo.BtPrintJobOptions'; column does not allow nulls.
INSERT fails.
++++++++++++++++
The column PrintOnBothSides is indeed NOT NULL in the table. It's also missing from the INSERT.
What could be the problem?
How can we solve it?
BarTender 9.3 SR1, build 2715
Windows 2008R2
SQL Server 2005 SP4 (9.0.5000)
-
You can try installing a new system database and seeing if you get the same errors when logging to a new database - this lets you know if it's a problem with client logging the information. If it doesn't reproduce in a new system database then it's a problem with your system database. If it's a problem with the database, then I would just start logging to a new database, but if it's a problem with the client, then I would look into reinstalling that client.
0 -
Hello,
Thank you for your answer.
Yesterday we had a lot of problems with BarTender. Labels could not be printed.
One of the error-messages we found was the one above. We didn't know if it was related to our problems or not. So I asked in this forum.
Later we did a reboot of our server and that solved our problems.
The error-messages still occur. However it doesn't seem to have any negative effects on the workings of BarTender. Nobody is complaining.
We don't have much knowledge of BarTender around here. And no test-system.
So I will never get permission to re-install a new system database. :-(
So I guess we'll have to live with this error for now.
Thank you for your quick reply.
Regards,
Frank
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
2 Kommentare