SBL-DAT-00430: An internal error occurred retrieving a field value for '%1'. The field has an invalid logical index.

Applies to:

Product Release: V7 (Enterprise)
Version: 7.5.3 [16157]
Database: Microsoft SQL Server 7.0 SP 3
Application Server OS: Microsoft Windows 2000 Server
Database Server OS: Microsoft Windows 2000 Server

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

Symptoms

SBL-DAT-00430

Dear Sir or Madam,

When we start an Export in Contact Targeting, we get the Error Message:
"An internal error occurred retrieving a field value for '(SLA 9) S_AREA_LS.ORG Brick Name'. The field has an invalid logical index.(SBL-DAT-00430)".

I found SR related to that, but all solution doesn't work in our configuration.
1. Link is aktive
2. Join is aktive.
3. I check with and without "Force Active" and "Link Spec"

I attached the Log file and the sif of the related Product "Pharma Address" and "Pharma Prof. Targeting".

You can contact me at istein@deloitte.com

Kind Regards

Solution

Message 1

For the benefit of other Users:

Problem:

The customer was getting the following error when trying to Export in Contact Targeting.

"An internal error occurred retrieving a field value for '(SLA 9) S_AREA_LS.ORG Brick Name'. The field has an invalid logical index.(SBL-DAT-00430)".


Resolution:

The customer was asked to uncheck the Primary Join in the ‘Brick’ Link and replicate the behavior. The expected result was achieved once it was unchecked.

Applies to:

Siebel Tools - Version: 8.1.1 SIA [21111] - Release: V8
Information in this document applies to any platform.

Symptoms

Tested this Issue in 8.1.1 SIA with Sample DB

Steps to reproduce the issue

1. Created a Task Base UI with one Step which has Contact Form Applet
2. In this Applet there are two MVG's. One MVG is based on Account BC and another MVG is based on CUT Address.
3. Started the Task Base UI and Opened the Account MVG. Added the Record and removed the same record.
4. Closed the MVG and Click the Submit Button.
5. Following Error is encountered


---------------------------
Siebel
---------------------------
[1] Task controller encountered another error while trying to handle the following error. Please use the Pause button to pause the task, or the Cancel button to cancel the task.(SBL-BPR-00537)
[2] An error has occurred committing the record 1-1YH of business component 'Account'. The user key of the record is
Party Name = ""
Location = "Outlet"
Primary Organization Id = "1-1DG"
S_ORG_EXT_SS.Conflict Id = ""
(SBL-DAT-60241)
[3] An internal error occurred retrieving a field value for ''. The field has an invalid logical index.(SBL-DAT-00430)

---------------------------
OK
---------------------------

Solution

For the benefit of the others readers:

CR#12-1V05905 and the FR#12-1V0NEIB was created as a product defect for this issue.

Following QF need to apply to rectify the issue 8.1.1 [21112] QF0060 BugID: SBA: 9037942

Thank you,
Siebel Technical Support