Search This Blog

SBL-DAT-00509: Definition for table '%1' does not exist.

Applies to:

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

Symptoms


Following an upgrade from 7.5.3 to 8.1 the following error is seen on every view:

  SBL-DAT-00509 - Definition for table '' does not exist.

Changes

Customer upgraded from 7.5.3 to 8.1.  No other changes made.

Cause


Account Bus Comp View Mode used an MVLink that referenced a Link that was modified in the upgrade.

Customer found that their configuration had been altered by the upgrade.

The customer had configured a custom link in 7.5.3 as follows:
Name: Account/Employee
Parent BC: Account
Child BC: Employee
Inter Table: S_PARTY_PER
Inter Parent Column: PARTY_ID
Inter Child Column: PERSON_ID
Primary ID Field: Primary Contact Id
Cascade Delete: None
Assoc List Sort Spec: Last Name, First Name
Vis. Rule Applied: Never

Configuration in 8.1 (Post upgrade)
BC: Account
Bus Comp View Mode: Personal (Owner Type: Person, Visibility MVField: BLB Account Team Full Name, Visibility MVLink: BLB Employee Account Team)

MultiValue Link: BLB Employee Account Team (Link: Account/Employee)

In 8.1 Link Account/Employee has no intersection table. Configuration is:
Parent BC: Account
Child BC: Employee
Destination Field: OU_Id

During the upgrade, the custom Link: "Account/Employee" was replaced with a new Link in 8.1 Standard repository with the same name as the custom Link. This broke the configuration of the Account Bus Comp View Mode

Solution


The issue arose because a custom link defined in 7.5.3 (Account/Employee) had been replaced by a standard Link of the same name introduced in the upgrade to 8.1. This "broke" the configuration of the Bus Comp View Mode, as the MVField had no relationship to the Link.

The error message produced is generic and should be enhanced to allow better diagnosis and root cause analysis. There is an existing Enhancement Request: Bug 12-1NC00U9: Enhance error message SBL-DAT-00509 - Definition for table '' does not exist.  Details of this specific case have been added to the Bug.

After creating a new Link as per the 7.5.3 configuration and using this in the MVLink definition, the errors were no longer seen.

References

BUG:12-1NC00U9 - ENHANCE ERROR MESSAGE SBL-DAT-00509 - DEFINITION FOR TABLE '' DOES NOT EXIST.
NOTE:976056.1 - CONFIGURATION OF MORE THAN ONE BUSCOMP VIEW MODE WITH THE SAME OWNER TYPE

Applies to:

Product Release: V7 (Professional)
Version: 7.8.2.3 [19221] DEU
Database: Oracle 10.2.0.1
Application Server OS: IBM AIX 5L 5.2
Database Server OS: IBM AIX 5L 5.2

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

Symptoms

SBL-DAT-00509

Dear Support-Web,

We encountered problems after we tried to enable the table “S_EVT_ACT” for MLOVs (Columns “CAL_TYPE_CD” and “EVT_STAT_CD”).

For enabling we followed the bookshelf “Configuring Siebel eBusiness Applications” -> “Process of Enabling MLOVs”:

• For the column “”CAL_TYPE_CD” we have entered the translation table “S_LST_OF_VAL” and the LOV-Type “ACTIVITY_DISPLAY_CODE”.
• We have changed the LOV-Type “ACTIVITY_DISPLAY_CODE” to “Translate=Y” and “Multilingual=Y”.
• We have ensured, that the Siebel-Standard Values for “ACTIVITY_DISPLAY_CODE“are activated in both languages.
• We have cleared the Lov-Cache
• We have verified, that the pick list is bounded and that this column is not listed in Table 55 “Columns That Cannot Be MLOV Enabled”.

After applying and compiling our changes we get the following error, when we try to navigate to an Action or Calendar- Screen:
- - -
Definition for table '' does not exist.(SBL-DAT-00509)
- - -

When we don’t enable this column for multilingual use, we run into the following problem:
Activities, which are created in one language are nor visible in the calendar of another language, because these values won’t be translated.

When we tried to enable the column “EVT_STAT_CD” for multilingual use, we also run into the error: Definition for table '' does not exist.(SBL-DAT-00509)

Please advice! We appreciate your help!

Regards

Solution

Message 1

For the benefit of other readers:

# Issue:

We encountered problems after we tried to enable the table “S_EVT_ACT” for MLOVs (Columns “CAL_TYPE_CD” and “EVT_STAT_CD”).

For enabling we followed the bookshelf “Configuring Siebel eBusiness Applications” -> “Process of Enabling MLOVs”:

• For the column “”CAL_TYPE_CD” we have entered the translation table “S_LST_OF_VAL” and the LOV-Type “ACTIVITY_DISPLAY_CODE”.
• We have changed the LOV-Type “ACTIVITY_DISPLAY_CODE” to “Translate=Y” and “Multilingual=Y”.
• We have ensured, that the Siebel-Standard Values for “ACTIVITY_DISPLAY_CODE“are activated in both languages.
• We have cleared the Lov-Cache
• We have verified, that the pick list is bounded and that this column is not listed in Table 55 “Columns That Cannot Be MLOV Enabled”.

After applying and compiling our changes we get the following error, when we try to navigate to an Action or Calendar- Screen:
- - -
Definition for table '' does not exist.(SBL-DAT-00509)
- - -

When we don’t enable this column for multilingual use, we run into the following problem:
Activities, which are created in one language are nor visible in the calendar of another language, because these values won’t be translated.

When we tried to enable the column “EVT_STAT_CD” for multilingual use, we also run into the error: Definition for table '' does not exist.(SBL-DAT-00509)

[...]

Message 2

[...]

# Solution:

In a standard repository version 7.8 SIA the LOV type EVENT_STATUS is used by the following columns:

EVT_STAT_CD in table S_EVT_ACT
ACT_EVT_STAT_CD in table S_ACT_EMP

and the LOV type ACTIVITY_DISPLAY_CODE is used by the following columns:

CAL_TYPE_CD in table S_EVT_ACT
ACT_CAL_TYPE_CD in table S_ACT_EMP
ACT_CAL_TYPE_CD in table S_ACT_CAL_RSRC

Note that all these columns have the 'LOV Bounded' property set to TRUE.

The customer had set to S_LST_OF_VAL the 'Translation Table Name' property of the following columns only:

EVT_STAT_CD in table S_EVT_ACT
CAL_TYPE_CD in table S_EVT_ACT

The issue was resolved once they set also the 'Translation Table Name' property of the other columns mentioned above.

Note that this task is part of the Process of Enabling MLOVs described in the Bookshelf:

Configuring Siebel eBusiness Applications
Creating and Administering Lists of Values
Configuring the Multilingual List of Values in Siebel Tools

Applies to:

Product Release: V7 (Enterprise)
Version: 7.7.1 [18306] Fin Svcs
Database: Oracle 9i
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Sun Solaris 2.8

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

Symptoms

Hi,

Please refer previous SR Number: 38-2628032281 at CitiCapital.

At that time we don't have business approval to go ahead on work on this. Now we request you to go ahead and troubleshoot the issue.

The Issue :

On deletion of any contact or call report record we are getting an error. The error message is attached in the previous SR.

With this message I am trying to atatched my Local.

User name is am20912
password is avadya

Let me know if you need any other information.

Thanks & Regards

Solution

Message 1

From the generated log files, I found the following error message.

SBL-DAT-00509: Definition for table 'CX_CMG_NON_CITY' does not exist.

Upon my further testing, I found the following link is causing the problem.

Link : FINCORP Call Report/Contact(Non Citi)

This link has InterTable “CX_CMG_NON_CITY” but this particular Table in not in the customers database.

This issue got resolved after inactivating this Link.


No comments:

Post a Comment