Search This Blog

SBL-DAT-00292: An error has occurred picking the current row. Please continue or ask your systems administrator to check your application configuratio

Applies to:

Siebel Tools - Version: 7.7.2.6 SIA [18372] - Release: V7
Information in this document applies to any platform.

Symptoms


A custom Business Service assigns products to an application. The Pick method works fine when using Business Service simulator. However, when invoking the Business Service using Workflow Process Manager, it throws the error "An error has occurred picking the current row. Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)"

Cause

The log file shows some extra errors:
SBL-SCR-00141: Siebel eScript runtime error occurred in procedure 'BusComp_PreSetFieldValue' of BusComp [Opportunity Product]:
ConversionError 1616: Undefined and Null types cannot be converted to an object.
ObjMgrBusCompLog Error 1 0 2010-03-04 16:00:55 (buscomp.cpp (19589)) SBL-DAT-00292: An error has occurred picking the current row.

The issue is caused by the code line:
if (TheApplication().ActiveBusObject().Name() == 'FINS Application') {
because in the workflow manager there is no ActiveBusObject and the Name method is applied on a null object.

Solution


The issue was solved by removing the ActiveBusObject method call.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.8.2.5 [19227]
Database: IBM DB2 8.2
Application Server OS: Microsoft Windows 2003 Server SP2
Database Server OS: IBM AIX 5L 5.3

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

Symptoms

SBL-DAT-00292

We have customized Siebel in regards to the Price List associated to an account. We use the currency in the price list and pick that into the Account/Currency Code field. It works fine for price lists in the same currency, but it gives us an error if we change the price list to another price list in a different currency. We get this message:
- - -
[1] An error has occurred picking the current row.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)
[2] This operation is not allowed when there are no records displayed.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)
- - -
I can't find anywhere in tools where the price list is being constrained by the currency code.

Can you provide me any guidance?

Solution

Message 1

For the benefit of other readers:

# Issue:

We have customized Siebel in regards to the Price List associated to an account. We use the currency in the price list and pick that into the Account/Currency Code field. It works fine for price lists in the same currency, but it gives us an error if we change the price list to another price list in a different currency. We get this message:
- - -
[1] An error has occurred picking the current row.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)
[2] This operation is not allowed when there are no records displayed.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215)
- - -

I can't find anywhere in tools where the price list is being constrained by the currency code.

# Resolution:

In a standard Siebel repository version 7.8 the field 'Price List' in BC 'Account' has the following pick map:
- - -
Field: Currency Code
Constrain: TRUE (checked)
Picklist Field: Currency Code
- - -

The customer had set the 'Constrain' property to FALSE to change this constraint pick map to a copy pick map.

However there is also the following user property in standard BC 'Account' that clears the field 'Price List' when the field 'Currency Code' is updated:
- - -
Name: On Field Update Set 1
Value: "Currency Code", "Price List", ""
- - -

[...]

Message 2

[...]

> This user property was the cause of the errors mentioned above.

The issue was resolved by removing this user property and renaming the other 'On Field Update Set n' user properties to ensure that at least one of the 'On Field Update Set' and 'On Field Update Set 1' are defined. Otherwise the system would totally ignore the 'On Field Update Set' user property for the BC as mentioned in posting 38-1190451491 on SupportWeb.

Applies to:

Siebel Tools - Version: 7.5.2.216 SIA [16084] and later   [Release: V7 and later ]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.2.216 [16084] Pub Sect
Database: Oracle 9i
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-1097354321.

Symptoms

SBL-DAT-00284, SBL-DAT-00292

We have changed the Activity List Applet with Navigation by adding the Account Number to the screen.
When attempting to pick and Account from the Picklist the following message appears when you click Ok having chosen an Account :

1) an error has occured picking the current row
2) You cannot currently update this record . Please check the No Update properties on the Applet, Business Component and Link

When the OK button is selected if you then re choose the same Account it works correctly i.e the Acount Name and Number are returned to the Activity List Applet ?

Please advise...

Cause

Product Defect, CR 12-IJ5C4I, "Cannot associate account to activity in case CUT Address is read only"

Solution

Behavior:
When associating an account with an activity following errors were seen:

1) an error has occured picking the current row
2) You cannot currently update this record . Please check the No Update properties on the Applet, Business Component and Link


Reason:
User property BC Read Only Field in buscomp CUT Address.

Action:
Change Request of type Product Defect, CR 12-IJ5C4I, "Cannot associate account to activity in case CUT Address is read only", has been logged.

Workaround:
The user property has been replaced by a script. Because there was the need to update in admin mode views SetFieldValue event was used.

This issue was resolved with 7.5.3.6 Fix Pack and found to be not applicable for version 7.7 and above.

Keywords: action, activity, business address, BC Read Only Field


Applies to:

Siebel Tools - Version: 7.5.2.211 SIA [16061] to 8.1.1.3[21219] - Release: V7 to V8
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.2.211 [16061] Life Sci
Database: Oracle 9.2.0.2
Application Server OS: Sun Solaris 2.8
Database Server OS: Sun Solaris 2.8

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

"" Checked for Relevance on 10-SEP-2010 ""

Symptoms

The customer found that in their development environment then a user navigates to Protocols screen > Activity plans view and creates a new record, saving the record results in the following errors:

Errors:

[1] Wrong field values or value types detected in field Template. Please re-enter your field values. If you need additional assistance, please refer to the documentations. (SBL-UIF-00299)
[2] An error has occurred picking the current row. Please continue or ask your systems administrator to check your application configuration if the problem persists. (SBL-DAT-00292)
[3] An error has occurred creating business component “ used by the business object ‘Activity Template’.(SBL-DAT-00222)

Although the customer has made several configuration changed to this functionality, they were able to confirm that the problem was not due to this by running the srf from their test environment (where the problem does not occur) in their development environment and the error still occurred.

Cause


In order to troubleshoot this error further, the customer used How Should Client Side Logging Be Set? (Doc ID 475587.1) to implement increased client side logging on their dedicated client.

From the log file, the first error that occurs:

ObjMgrBusServiceLog Create 4 2004-01-26 11:08:36 Business Service 'Workflow Process Manager' was created 6652de0
ObjMgrBusServiceLog InvokeMethod 4 2004-01-26 11:08:36 Begin: Business Service 'Workflow Process Manager' invoke method: '_RunProcessRemoteAsync' 6652de0
EngInv EngInv 3 2004-01-26 11:08:36 Workflow engine requested to perform method '_RunProcessRemoteAsync'.
EngInv Arg 4 2004-01-26 11:08:36 Input: @0*0*2*0*0*0*7*EventId6*1-DX9T9*ProcessId6*1-DX5T
ObjMgrBusServiceLog Create 4 2004-01-26 11:08:37 Business Service 'Server Requests' was created 6655680
ObjMgrLog Error 4 2004-01-26 11:08:37 0x6eaf:
ObjMgrLog Error 4 2004-01-26 11:08:37 An error has occurred creating business component '' used by business object 'Activity Template'.
Please ask your systems administrator to check your application configuration.

So from the log file and the input argument to the workflow process manager, a workflow process with a row_id = “1-DX5T” (i.e. ProcessId6*1-DX5T) was being triggered by a run time event with a row_id = ‘1-DX9T’ (i.e. EventId6*1-DX9T9).

In the Run-Time Events Administration screen, a run-time event based on the ‘WriteRecord’ event on the ‘Employee’ business component was identified as the runtime event in question. It was being triggered by the creation of the activity plan and so triggered the workflow process.

The customer had created this workflow process which should only be triggered when a new employee is added. When an activity plan was created, an activity team was also created – from the log file, there is an insert statement into the S_ACT_EMP intersection table to create the association between the new activity and the employee and this fires the WriteRecord event on the Employee business component.

Solution


The customer was advised that given their requirements for the workflow process, either the ‘NewRecord’ or ‘WriteRecordNew’ events would be better options to use for the run time event

Please refer to the Bookshelf:
- 7.5  Siebel Personalization Administration Guide > Run-time Events > Run-time Events and Action Sets > Definitions of Events
- 7.7 and higher Siebel Personalization Administration Guide > Tracking Run-Time Events >
Definitions of Events

•    NewRecord - Triggered after a new row is added to the business component.
•    WriteRecord - Triggered after a row is written to the database.
•    WriteRecordNew -Triggered after a new row is written to the database. Fires along with WriteRecord.



Applies to:

Product Release: V7 (Professional)
Version: 7.8.2.3 [19221]
Database: Oracle 9.2.0.6
Application Server OS: Microsoft Windows 2003 Server SP1
Database Server OS: Sun Solaris 9

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

Symptoms

SBL-BPR-00162

Hi Support,
        We are upgrading from Siebel 7.5.3.12 to 7.8.2 SIA and are using Siebel eMedia application.
        We are facing an issue in the Quotes screen after performing the upgrade. When we create a quote and try to add a new line item to it, the list price of the corresponding product is not getting populated in the Quote - Line Items.
          We have verified that the product has a valid List Price and we are able to view it in the Product pick applet.

             We Observed that in 7.5 for Quote Item Business Component having a User Property "Orginal List Price Field" which is populating the List Price in Quote Item from the Price List Item Business Component. where as in 7.8 its not populating the List Price.

   Can you please have a look into this issue.
Regards,

Solution

Message 1

For the benefit of others:

SUMMARY:
The customer reported that after upgrading from Siebel 7.5.3.12 to 7.8.2 SIA the list price of the corresponding product is not getting populated when adding a new Quote Line Item and it gets the following error message:

"[1] An error has occurred picking the current row.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00292)
[2] This operation is not allowed when there are no records displayed.

Please execute a query that returns at least one record or add a new record.(SBL-DAT-00215) ".

The customer is using Dynamic Pricing. He has activated the necessary workflows and followed the Technical Note 643-Enabling the Dynamic Pricing Procedure for Customer Order Management.

However he has activated only the CalculatePrice, CalculatePriceAll and Product Recommendation Signal signals and has inactivated the other signals specified in the Tech Note.

RESOLUTION:
It has been found that the error experienced when picking products in quote line items can be solved by making the following change in Siebel Tools (as described in SR # 38-2575798357 for Reuters):
- under Business Component "Quote Item" for field "Product" select "Product" pick map
- change the "Sequence" property from this pick map from 38 to 99 (or the maximum sequence for all pick maps)

more...

Message 2

more....

Change Request # 12-18U9C44 has been logged to document the relation between the Product pick map in BC Quote Item - class CSSBCQuoteItem and pricing engine.

After making this change and recompiling the SRF this first error has been solved.

However the list price was still not getting populated for the product in the quote item.
Base Price field and all fields related to pricing are populated by the pricing workflows and signals.

After activating the SetFieldValue signal the reported issue has been solved.

Kind regards,
Laura Doicin
Siebel Technical Support

Keywords: List Price, Quote Line Item, Pricing, SBL-DAT-00292, SBL-DAT-00215, Dynamic Pricing, Signals


No comments:

Post a Comment