SBL-DAT-00407: Operation is not allowed on sql object in forward only mode.

Applies to:

Siebel Data Quality - Version: 7.5.3.6 [16186] and later   [Release: V7 and later ]
Siebel CRM - Version: 7.5.3.6 [16186] and later    [Release: V7 and later]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.6 [16186] FRA
Database: Oracle 8.1.7.3
Application Server OS: Microsoft Windows 2000 Advanced Server SP 2
Database Server OS: Microsoft Windows 2000 Advanced Server SP 2

This document was previously published as Siebel SR 38-1623076586.

Symptoms

The user observed the following behavior in Siebel version 7.5.3.6 [16186] FRA:
- When you are on a list applet (for example Contact List Aplet), if you use the "Goto Last" functionality in order to navigate to the last record, and next you use the Excel Export functionality, you will get the error:
"Operation is not allowed on sql object in forward only mode (SBL-DAT-00407)"

The issue is reproducible with Siebel standard application.

The user wants to know if there is a workaround for this behavior or if this is a product defect.

Cause

The mentioned behavior is caused by a product defect.

If you navigate to the last record in a multi-record list using CTRL-ALT-L or the vertical scroll bar, and the upper right corner of the list applet lists reads "xx from Last" you will encounter the following error if you try to export any records from the List Applet: - SBL-DAT-00407 - Operation is not allowed on sql object in forward only mode.

This occurs as export is designed to run in forward only mode, so that the exported list is in the same order as in the list applet in Siebel.

Change Request# 12-CUOB8E entitled "Export doesn't work in some cases" has been logged as a product defect to address this behavior. This Change Request has been released noted for Siebel version 7.5.3.x and the behavior is no longer reproducible in Siebel version 7.7.x.

Solution

Workaround:
Please hit CTRL-ALT-F prior to initiating export to navigate back to the start of the list.

Applies to:

Siebel Universal Customer Master - Version: 8.0.0.6 [20423] and later   [Release: V8 and later ]
Information in this document applies to any platform.
""""Checked for relevance on 16-NOV-2010""""

Symptoms

Background
-------------------
Recently the UCM environments were upgraded from Siebel UCM 8.0.0.2 to 8.0.0.6.

Problem
-------------
Since this installation the real time publish has stopped working.  In the logs, following error reported :-

ObjMgrSqlObjLog Execute 4 0000000c49a3c57c:0 2009-02-24 10:33:30 Begin: Execute SqlObj 'CIF System' at 1330b3d8

ObjMgrBusCompLog Warning 2 0000000c49a3c57c:0 2009-02-24 10:33:30 (sqlobj.cpp (29138)) SBL-DAT-00398: Field '*' does not exist in definition for business component 'CIF System'.

Please ask your systems administrator to check your application configuration.

ObjMgrSqlObjLog Execute 4 0000000c49a3c57c:0 2009-02-24 10:33:30 End: execute SqlObject at 1330b3d8

ObjMgrBusCompLog Warning 2 0000000c49a3c57c:0 2009-02-24 10:33:30 (fasvccifpubsub.cpp (4991)) SBL-DAT-00407: Operation is not allowed on sql object in forward only mode.

Please ask your systems administrator to check your application configuration if the problem persists.

ObjMgrBusCompLog Delete 4 0000000c49a3c57c:0 2009-02-24 10:33:30 BusComp "CIF System Privilege" at 13317fe8 was deleted

ObjMgrBusCompLog Delete 4 0000000c49a3c57c:0 2009-02-24 10:33:30 BusComp "CIF System" at 1330ae70 was deleted

ObjMgrBusServiceLog Error 1 0000000c49a3c57c:0 2009-02-24 10:33:30 (fasvccifpubsub.cpp (1015)) SBL-IAI-00513: UCM Publish Subscribe service: Internal error when RealTimePublishMethod method is invoked



The publish worked as expected in Siebel 8.0.0.2.


Environment
--------------------
Siebel version : 8.0.0.6
Database version : Oracle 10.2
OS version : Windows 2003

Cause

The behaviour was re-produced, and change request has been created :-

Bug 12-1PU4QVW - Publish and Subscribe not working in both "Real Time" and "Daily Batch" modes.

Solution

For Siebel 8.0.0.6, following quick fix has been created, and can be downloaded via Patches and Downloads :-

Bug ID: SBA: 8349404
Patch Abstract: 8.0.0.6 20423 SBA QF0609 SEBL_ARU

References

BUG:12-1SEPOB3 - UCM PUBLISH NOT WORKING AFTER INSTALLING SIEBEL 8.0.0.6 SIA

Applies to:

Product Release: V7 (Enterprise)
Version: 7.7.2.2 [18356]
Database: Oracle 9.2.0.6
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: HP-UX 11i

This document was previously published as Siebel SR 38-2440648061.

Symptoms

Hi,

We were trying to Uncheck the Forecast flag for all the Opportunities in the Detail tab for our testing purposes so that we can only check a couple of Revenue items and do a roll up to check the calculations.

When we do an Edit -> Select All and Set the Forecast flag = 'N' and do a Change Record, Siebel gives a system error and the changes are not done.

Also the current Query is lost and the user has to refresh the Forecast record to display all the line items.

When we manually select all and do the changes it works fine.

Solution

Message 1

FOR THE BENEFIT OF OTHERS:

When using Edit > Select All and "Change Records" feature in Forecast Details, an error occurs.

This error is reproducible the error using a sample DB and SADMIN. It is only reproducible from the SECOND time you change all the records on.

For ex. If the Forecast is a brand new one, then the “Select All > Change Records” operation will work. If you try it again, then it will fail. From this time on, you can log out and log in again that the error will still continue to occur. Now if you delete and recreate it, then you will be able to change it once.

STEPS TO REPRODUCE:
1) Logon to Siebel CallCenter as SADMIN using Sample DB.
2) Go to Forecasts > My Forecasts and create a new record:
a. Forecast Series: Global Product Forecast
b. Forecast Date: 1/1/2001
3) Save the record. The Forecast Details will be created.
4) Drilldown in the Forecast Date field.
5) Ensure that many Forecast Details records were created (approx. 136 records)
6)With the Forecast Details list Applet in focus, choose Edit > Select All.
7) Once all the Forecast Details records are highlighted, choose Edit > Change Records.
8) In the “Change Records” popup applet, choose Field: Forecasted and Value: N
9)If no error message is displayed, then repeat steps 6 to 8 again, but now choose Value: Y.

The following error message will be displayed and the records WILL NOT be changed.

(CONT'D)

Message 2

(CONT'D)

The following error message will be displayed and the records WILL NOT be changed.

We detected an Error which may have occurred for one or more of the following reasons:

"Operation is not allowed on sql object in forward only mode. Please ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00407)"

WORKAROUND:
Select the records manually using <SHIFT> instead of Select All.

CR # 12-14UGUEK has been logged to address this behavior.

Thank you.

Best regards,
Siebel Technical Support