SBL-DBC-00111: An error has occurred writing to a record.

Applies to:

Siebel Consumer Goods - Version: 8.0.0.2 SIA [20412] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Issue: Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

The OOTB Mass Sales Update button in Sales Value Planning Screen / CG SVP Category Baseline List Applet is causing strange numbers to come up (see attachment).

The error occurs due to the following insert:

UPDATE dbo.S_CG_CAT_BASELN SET
DB_LAST_UPD_SRC = ?,
DB_LAST_UPD = GETUTCDATE(),
LAST_UPD = ?,
LAST_UPD_BY = ?,
MODIFICATION_NUM = ?,
BASELN_SALES = ?
WHERE
ROW_ID = ? AND MODIFICATION_NUM = ?

0 : (00008)User
1 : (00038)2009-07-15 19:25:49
2 : (00012)1-4UOX
3 : (00010)25597
4 : (00032)1013324653189909
5 : (00016)1-18JLOD
6 : (00010)25596

SBL-DBC-00111: An error has occurred writing to a record. [Microsoft][SQL Native Client]Numeric value out of range

Cause

Cause Determination: Bug 10571878 - Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

Root Cause: Regression caused by 8.0.0.6 patch (which fixed the SVP drilldown issue).

Solution

Solution:

Install:

 8.0.0.6 20423 SBA QF0653
 8.0.0.9 Fix Pack

References

SVP, Sales Volume Planning, SBL-DBC-00111, Mass Update

Applies to:

Siebel Consumer Goods - Version: 8.0.0.2 SIA [20412] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Issue: Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

The OOTB Mass Sales Update button in Sales Value Planning Screen / CG SVP Category Baseline List Applet is causing strange numbers to come up (see attachment).

The error occurs due to the following insert:

UPDATE dbo.S_CG_CAT_BASELN SET
DB_LAST_UPD_SRC = ?,
DB_LAST_UPD = GETUTCDATE(),
LAST_UPD = ?,
LAST_UPD_BY = ?,
MODIFICATION_NUM = ?,
BASELN_SALES = ?
WHERE
ROW_ID = ? AND MODIFICATION_NUM = ?

0 : (00008)User
1 : (00038)2009-07-15 19:25:49
2 : (00012)1-4UOX
3 : (00010)25597
4 : (00032)1013324653189909
5 : (00016)1-18JLOD
6 : (00010)25596

SBL-DBC-00111: An error has occurred writing to a record. [Microsoft][SQL Native Client]Numeric value out of range

Cause

Cause Determination: Bug 10571878 - Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

Root Cause: Regression caused by 8.0.0.6 patch (which fixed the SVP drilldown issue).

Solution

Solution:

Install:

 8.0.0.6 20423 SBA QF0653
 8.0.0.9 Fix Pack

References

SVP, Sales Volume Planning, SBL-DBC-00111, Mass Update

Applies to:

Siebel Consumer Goods - Version: 8.0.0.2 SIA [20412] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Issue: Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

The OOTB Mass Sales Update button in Sales Value Planning Screen / CG SVP Category Baseline List Applet is causing strange numbers to come up (see attachment).

The error occurs due to the following insert:

UPDATE dbo.S_CG_CAT_BASELN SET
DB_LAST_UPD_SRC = ?,
DB_LAST_UPD = GETUTCDATE(),
LAST_UPD = ?,
LAST_UPD_BY = ?,
MODIFICATION_NUM = ?,
BASELN_SALES = ?
WHERE
ROW_ID = ? AND MODIFICATION_NUM = ?

0 : (00008)User
1 : (00038)2009-07-15 19:25:49
2 : (00012)1-4UOX
3 : (00010)25597
4 : (00032)1013324653189909
5 : (00016)1-18JLOD
6 : (00010)25596

SBL-DBC-00111: An error has occurred writing to a record. [Microsoft][SQL Native Client]Numeric value out of range

Cause

Cause Determination: Bug 10571878 - Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

Root Cause: Regression caused by 8.0.0.6 patch (which fixed the SVP drilldown issue).

Solution

Solution:

Install:

 8.0.0.6 20423 SBA QF0653
 8.0.0.9 Fix Pack

References

SVP, Sales Volume Planning, SBL-DBC-00111, Mass Update

Applies to:

Siebel Consumer Goods - Version: 8.0.0.2 SIA [20412] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Issue: Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

The OOTB Mass Sales Update button in Sales Value Planning Screen / CG SVP Category Baseline List Applet is causing strange numbers to come up (see attachment).

The error occurs due to the following insert:

UPDATE dbo.S_CG_CAT_BASELN SET
DB_LAST_UPD_SRC = ?,
DB_LAST_UPD = GETUTCDATE(),
LAST_UPD = ?,
LAST_UPD_BY = ?,
MODIFICATION_NUM = ?,
BASELN_SALES = ?
WHERE
ROW_ID = ? AND MODIFICATION_NUM = ?

0 : (00008)User
1 : (00038)2009-07-15 19:25:49
2 : (00012)1-4UOX
3 : (00010)25597
4 : (00032)1013324653189909
5 : (00016)1-18JLOD
6 : (00010)25596

SBL-DBC-00111: An error has occurred writing to a record. [Microsoft][SQL Native Client]Numeric value out of range

Cause

Cause Determination: Bug 10571878 - Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

Root Cause: Regression caused by 8.0.0.6 patch (which fixed the SVP drilldown issue).

Solution

Solution:

Install:

 8.0.0.6 20423 SBA QF0653
 8.0.0.9 Fix Pack

References

SVP, Sales Volume Planning, SBL-DBC-00111, Mass Update

Applies to:

Siebel Consumer Goods - Version: 8.0.0.2 SIA [20412] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Issue: Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

The OOTB Mass Sales Update button in Sales Value Planning Screen / CG SVP Category Baseline List Applet is causing strange numbers to come up (see attachment).

The error occurs due to the following insert:

UPDATE dbo.S_CG_CAT_BASELN SET
DB_LAST_UPD_SRC = ?,
DB_LAST_UPD = GETUTCDATE(),
LAST_UPD = ?,
LAST_UPD_BY = ?,
MODIFICATION_NUM = ?,
BASELN_SALES = ?
WHERE
ROW_ID = ? AND MODIFICATION_NUM = ?

0 : (00008)User
1 : (00038)2009-07-15 19:25:49
2 : (00012)1-4UOX
3 : (00010)25597
4 : (00032)1013324653189909
5 : (00016)1-18JLOD
6 : (00010)25596

SBL-DBC-00111: An error has occurred writing to a record. [Microsoft][SQL Native Client]Numeric value out of range

Cause

Cause Determination: Bug 10571878 - Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

Root Cause: Regression caused by 8.0.0.6 patch (which fixed the SVP drilldown issue).

Solution

Solution:

Install:

 8.0.0.6 20423 SBA QF0653
 8.0.0.9 Fix Pack

References

SVP, Sales Volume Planning, SBL-DBC-00111, Mass Update

Applies to:

Siebel Consumer Goods - Version: 8.0.0.2 SIA [20412] and later   [Release: V8 and later ]
Information in this document applies to any platform.

Symptoms

Issue: Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

The OOTB Mass Sales Update button in Sales Value Planning Screen / CG SVP Category Baseline List Applet is causing strange numbers to come up (see attachment).

The error occurs due to the following insert:

UPDATE dbo.S_CG_CAT_BASELN SET
DB_LAST_UPD_SRC = ?,
DB_LAST_UPD = GETUTCDATE(),
LAST_UPD = ?,
LAST_UPD_BY = ?,
MODIFICATION_NUM = ?,
BASELN_SALES = ?
WHERE
ROW_ID = ? AND MODIFICATION_NUM = ?

0 : (00008)User
1 : (00038)2009-07-15 19:25:49
2 : (00012)1-4UOX
3 : (00010)25597
4 : (00032)1013324653189909
5 : (00016)1-18JLOD
6 : (00010)25596

SBL-DBC-00111: An error has occurred writing to a record. [Microsoft][SQL Native Client]Numeric value out of range

Cause

Cause Determination: Bug 10571878 - Mass Sales Update button in SVP Screen causes the SBL-DBC-00111 and SQL Native Client]Numeric value out of range

Root Cause: Regression caused by 8.0.0.6 patch (which fixed the SVP drilldown issue).

Solution

Solution:

Install:

 8.0.0.6 20423 SBA QF0653
 8.0.0.9 Fix Pack

References

SVP, Sales Volume Planning, SBL-DBC-00111, Mass Update