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



תגובות

הוסף רשומת תגובה

פוסטים פופולריים מהבלוג הזה

Profile Attributes and Open UI

תמונה
Yes, Profile Attributes! As the ever attentive, up-to-date Siebel CRM expert that you are when you read this, you know that in Siebel Open UI (since version 15), it is no longer allowed/supported to  set  Profile Attributes from browser-side script. But  getting  them is not a problem, since the  GetProfileAttr  function works perfectly fine. Recently I found a few vanilla Profile Attributes that came quite handy in my work in Open UI JavaScript: Navigation Type : stores the navigation type such as "NAVIGATION_TAB" ActiveViewName : does what it says on the tin IsOpenUI : returns "1" when the application runs in Open UI Is SUI Theme : when "TRUE", the application theme is Synergy (aka SUI) Position:  returns the currently active position Primary Responsibility Name : guess what this one is… Profile Image : returns the URL of the user's profile image Org.Name : returns the name of the user's organization Here's a sample line of ...
המשך לקרוא

SBL-BPR-00191: The rowId of the active row of the primary buscomp '%1', '%2', does not match the Primary Id

Applies to: Product Release: V7 (Enterprise) Version: 7.5.3 [16157] ESN Database: Oracle 9.2.0.2 Application Server OS: Microsoft Windows 2000 Server SP 3 Database Server OS: Microsoft Windows 2000 Server SP 3 This document was previously published as Siebel SR 38-1386997031. Symptoms SBL-BPR-00191 We have a error with a workflow. This WF is excuted by policy when a particular activity is closed. The WF Business Object is 'Action'. Inside this WF, there is a subprocess that invokes a Business Service that creates a new activity. In a second subprocess, the region Id of this new activity is updated using the standar update method funcionality of Siebel workflow process. Error processing Siebel Operation for: Business Object 'Action' Business Component 'Action' Primary Id ''1-5NEI6' Operation 'Insert'(SBL-BPR-00100) -- The rowId of the active row of the primary buscomp 'Action', '1-4SNCV', does not match the Prima...
המשך לקרוא

SBL-SVC-00150

Applies to: Siebel CRM - Version: 7.5.3 [16157] and later   [Release: V7 and later ] z*OBSOLETE: Microsoft Windows 2000 Product Release: V7 (Enterprise) Version: 7.5.3 [16157] Database: IBM DB2/UDB 7.2 Application Server OS: Microsoft Windows 2000 Advanced Server SP 2 Database Server OS: IBM AIX 4.3.3 This document was previously published as Siebel SR 38-1153677971. Symptoms SBL-SVC-00150In callcenter (development environment) Group News administration > All News, when the ‘Status’ field of a news story is changed from ‘Submitted’ to ‘Completed’, the following error pops up. You cannot change the current field’s value from ‘Submitted’ to ‘Completed’. Rule validation failed: ‘[Total Approvers] = 0’ (SBL-SVC-00150) When the status field of a news story is changed from ‘Submitted’ to ‘Pending Approval’, the following error pops up. You cannot change the current field’s value from ‘Submitted’ to ‘Pending Approval’. R...
המשך לקרוא