SBL-SMI-00077: Component error, see the trace file for more information

Applies to:

Siebel Remote - Version 8.0 [20405] and later
Information in this document applies to any platform.

Symptoms

Database Extract (DbXtract) tasks fail with errors. Reviewing detailed DbXtract*.log file following errors/messages can be noticed:

GenericLog GenericError 1 000000084b553068:0 2010-01-20 10:00:34 Unable to find node in database
...
GenericLog GenericError 1 000000084b553068:0 2010-01-20 10:00:35 Message: Internal error occurred in a procedure., Additional Message: Updated 0 rows
Trace TracingInfo 3 000000084b553068:0 2010-01-20 10:00:35 UTLNodeSetRouteActive
Trace TracingInfo 3 000000084b553068:0 2010-01-20 10:00:35 Error while processing client "SADMIN". Results may be incomplete.
...
Trace TracingInfo 3 000000084b553068:0 2010-01-20 10:00:35 Unable to find node in database
Trace TracingInfo 3 000000084b553068:0 2010-01-20 10:00:37 ERROR: 1 client(s) failed with errors, 0 client(s) successful
GenericLog GenericError 1 000000084b553068:0 2010-01-20 10:00:37 (smisched.cpp (894) err=1376333 sys=0) SBL-SMI-00077: Component error, see the trace file for more information

Cause

SBL-SMI-00077 is just a generic message that suggests the real cause of problem should be searched elsewhere in log .

"Unable to find node in database" error can be explained by fact that  Mobile Web Client user attempted to be extracted (SADMIN in this example) was not defined properly.
This can be checked by inspecting Administration - Siebel Remote > Mobile Clients screen. Or alternately, by querying table S_NODE for the list of existing / active mobile clients:

select * from SIEBEL.S_NODE where NODE_TYPE_CD = 'REMOTE' and NAME='[user_name]' and EFF_END_DT is NULL;

Solution

In case there are no records there, as per details in Siebel Bookshelf - Remote and Replication Manager Administration Guide > Setting Up Mobile Web Clients > "Registering a Mobile Web Client" - these steps should be applied before attempting to extract the Mobile user.

Applies to:

Siebel Remote - Version: 7.5.2 [15051] to 8.1.1 [21112] - Release: V7 to V8
Information in this document applies to any platform.

Symptoms

When trying to extract a mobile users' database, DbXtract task failed with error message:
"SBL-SMI-00077: Component error, see the trace file for more information"

This is only a generic error message - as it indicates, the real cause for the failure should be searched somewhere else in the corresponding task log file (DbXtract_*.log) on server.
In this case, even if some time ago extracting databases for users worked fine in same environment, now this error appears for any mobile client attempted.

Changes

To gather more details, event log levels for DbXtract component should increased by using srvrmgr command line utility, running these commands (in this order, one by one):

srvrmgr> change evtloglvl %=5 for comp dbxtract
srvrmgr> change evtloglvl sql%=1 for comp dbxtract
srvrmgr> change evtloglvl sqlparse%=4 for comp dbxtract
(Please remember to revert to previous or default logging levels - i.e. "... evtloglvl %=1 ..." once troubleshooting DbXtract is no longer required to avoid log files growing excessively).

Cause

>>From detailed DBXtract log the root cause for these errors was:

DBXTRACT: File "/siebel/xxxxxxxx/siebsrvr/sqltempl/dbxlogin.sql" not found.
…
>>
Script file dbxlogin.sql (along with some others from same location - sqltempl directory) is a required file that is used as "template" for database extracts and other server tasks.

Solution

One should check for the file/directory presence. That proved indeed file was missing in this case.
To avoid re-installation of whole server environment, if only one file might be found missing,  this directory contents from this environment can be compared with the same on another machine with EXACT same Siebel product version installed (!) where DbXtract works fine and copy that file from here.
In case such a "working" environment is not available, the only solution would be to re-install the Siebel server.

Please note is advisable to only copy the file(s) that are proved to be missing; do not overwrite the complete directory contents - there might be cases of customers who have been provided in past  with modified comdb*.sql file from Oracle | Siebel Technical Support or Expert Services for various other purposes; if that may be the case, these files should not be overwritten.

DbXtract task should complete fine afterwards.

References

 

 

 

Applies to:

Siebel Anywhere - Version: 7.5.3.5 [16183] and later   [Release: V7 and later ]
Siebel Remote - Version: 7.5.3.5 [16183] and later    [Release: V7 and later]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.5.3.5 [16183]
Database: Oracle 9.2.0.4
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: HP-UX 11.0

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

Symptoms

We are extracting everyone. We used a notepad file to export everyone. Now Database extract says exited with error. The reason being there were three client names that were not valid mobile users. Did all of our 150 valid mobile user go through okay? How can I check? Please see the urgency of this because our production system is now shut down.

Cause

Enhancement Request 12-TBTZAV

Solution

Message 1

For the benefit of others:

Valid nodes were extracted successfully. DbXtract log reported errors on failed clients, but did not provide information on valid users. We verified that .UAF, .DAT and .TOC files were created under the users' outboxes and the mobile clients were initialized successfully.

Technical Support reproduces this behavior inhouse. When running dbxtract for multiple users, if there is an invalid node name in the list of mobile users, the task status on the UI will show 'SBL-SMI-00077: Component error, see the trace file for more information' eventhough valid nodes were actually extracted successfully.

Enhancement Request 12-TBTZAV was raised to have a more meaningful message on the UI. For example, in this case it would be better if the task status reads "147 users extracted successfully, 3 users not extracted".

As always, please note that all Change Requests are reviewed, prioritized and possibly fixed in future releases.

Regards,

Applies to:

Siebel Remote - Version: 8.0.0.11 SIA[20440] and later   [Release: V8 and later ]
Information in this document applies to any platform.
Product Release: V8
Database: Oracle Server
Application Server OS: All Supported
Database Server OS: All Supported

Symptoms

Siebel Remote: Database Extract (DbXtract) task fails with generic SBL-SMI-00077 error (that indicates relevant error is somewhere else in the log file) and the relevant error being Oracle RDBMS one:

[DataDirect][ODBC Oracle driver][Oracle]ORA-29275: partial multibyte character

Detailed logging level DbXtract_*.log files would look like:
(note that base table involved or variables' values may vary - could be other than S_CONTACT or those listed in this example)

SQLError Statement 0 000000074f561360:0 2012-03-07 10:34:15 SQL Statement:
select mtx.*
from SIEBEL.S_DOCK_INITM_01 di
,SIEBEL.S_CONTACT mtx
where di.NODE_ID = '1-7LIVG'
and di.DOCK_NAME = 'PTY-C'
and di.PR_TBL_ROW_ID = mtx.PAR_ROW_ID
and di.VIS_STRENGTH >= 25
DBCLog DBCLogError 1 000000074f561360:0 2012-03-07 10:34:15 [DataDirect][ODBC Oracle driver][Oracle]ORA-29275: partial multibyte character

Trace TracingInfo 3 000000074f561360:0 2012-03-07 10:34:15 DBXTRACT: Database returned error.
Trace TracingInfo 3 000000074f561360:0 2012-03-07 10:34:15 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-29275: partial multibyte character

Cause

"ORA-29275: partial multibyte character"
It seems there may be some char data in table that are not AL32UTF8 encoded - or respecting DB's characterset parameters.

Solution

Problem was identified as only occurring when using Oracle Client 11g version; it would not occur with 10g client installed on same Siebel Remote server.
Based on current Siebel System Requirements and Supported Platforms (SR&SP) documentation, for Siebel 8.0 version the supported client Connectivity Software is "Oracle 10g client and Data Direct ODBC Driver 5.0".

It it important to ensure that Oracle Client installed on Siebel Servers comply with most recent SR&SP document for respective Siebel product version.

In case despite running on a supported platform same error would occur, following these steps may help troubleshooting that:

1- Check and confirm the exact versions of Oracle RDBMS server and client versions used - for instance from Siebel server, start a SQL*Plus session from cmd prompt and connect to DB (as SADMIN, Siebel table owner or any other valid DB account).
Upon successful connection that should show exact version details of both Oracle client and server DB.

2- Check and ensure following entries are correctly set in the ODBC DSN used for Siebel Server:
ColumnsAsChar=1
ColumnSizeAsCharacter=1

These should be defined in:
- for Windows systems: in registry under [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\($EnterpriseName)_DSN]
- for Unix systems: in file $SIEBEL_HOME/sys/.odbc.ini - under section [($EnterpriseName)_DSN].

3- Finally, by running previously identified query from DbXtract log may not return any results or ORA-29275 error if after hitting that, the "Part 4: Deleting from temporary tables" of extract - cleanup still happens, so S_DOCK_INITM_nn table would be empty.

So following approach should be used to determine if there is data in S_CONTACT table that would have wrong multibyte encoding:

3.a) Check first how many records there are in that base table:

SELECT COUNT(*) FROM S_CONTACT;

3.b) Based on actual size, one can determine how to break up the selects. For example, if above count returns 100K, two queries could be run: one for 1 to 50K rows and the other for the second half. Once found the half that returns the ORA-29275 error, then start breaking that in half and so on...

i.e.
SELECT * FROM S_CONTACT WHERE rownum > 1 AND rownum < 1000;
SELECT * FROM S_CONTACT WHERE rownum > 999 AND rownum < 2000;
...

This should help determining where the problem record(s) may be. Above generic approach could be automated by writing a small PL/SQL program especially for high cardinality tables.
Alternately a separate SR may be logged with Oracle RDBMS team to assist in identifying that(those) record(s) .
And once identified those rows could be updated (from UI or using EIM, scripting) to eliminate any suspect character(s) causing the error followed by retrying the DbXtract task.

References

NOTE:788156.1 - AL32UTF8 / UTF8 (Unicode) Database Character Set Implications
NOTE:477174.1 - Database Extract 7.x and 8.x Performance Troubleshooting
NOTE:781927.1 - Performance Tuning Guidelines for Siebel CRM Application on Oracle Database

 

Applies to:

Siebel Remote - Version: 7.7.2.12[18393] to 8.1 [21039] - Release: V7 to V8
Information in this document applies to any platform.

Symptoms

Database Extract (DbXtract) task may fail while extracting a mobile user with following errors:

[DataDirect][ODBC Oracle driver][Oracle]ORA-00904: "PRIMARY_TABLE"."X_custom_column": invalid identifier
Error while writing to file "" for target client "USERNAME".
SBL-SMI-00077: Component error, see the trace file for more information
With detailed logging levels in place for DbXtract component (as per details in Note 477125.1):
srvrmgr> change evtloglvl %=5 for comp DbXtract
srvrmgr> change evtloglvl sql%=1 for comp DbXtract
srvrmgr> change evtloglvl sqlparse%=4 for comp DbXtract
resulted logs will include information helping determine exact table name that caused this error ("PRIMARY_TABLE" - above is only its alias)

Note that for other RDBMS platforms used (MS SQL Server or IBM DB2), database error code and ODBC details would be of course different, but the other error lines would be identical:

- for instance in case of SQL Server:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'X_custom_column'.
Error while writing to file "" for target client "USERNAME".
SBL-SMI-00077: Component error, see the trace file for more information

Changes

Recent configuration changes in Siebel Tools on Table object(s) identified in detailed log - custom extension tables (CX_*), custom extention columns for standard base tables (X_*).

Cause

Relevant error in this case ("ORA-00904: [table].[column] : invalid identifier") is caused by:
1- Invalid definition(s) for these object(s) - Table custom Extension Column(s) in Siebel Repository
OR
2- Discrepancy between server's dictionary file (diccache.dat) and Repository information.

Solution

Existence of custom extension column ("X_custom_column" in this example) should be checked for that Siebel base table. Then should be verified same column was created at physical database level by using DBA specific commands appropriate for each RDBMS used (i.e. for Oracle's case: "DESC [table_name]" command from a sqlplus, SQLDeveloper or other similar tool).

After ensuring those exists, following steps should be applied:

1- Apply/Activate changes made in Tools on table objects,
2- stop Siebel Server service;
3- find and delete/move any dic*.dat file found under [Siebel_server_root] directory - please refer to Related Note: "Why is there a dicdata.dat and a diccache.dat file? (Doc ID 475633.1)" for additional details on these files;
4- restart Siebel service - diccache.dat file should be re-created in [Siebel_server_root]\bin\;
5- run again a "Generate New Database Template" (GenNewDb) task on server (this is mandatory if schema changes were applied since the database Schema Version would be increased!);
6- re-extract (DbXtract) mobile users' database and check this completes fine.

References

NOTE:475633.1 - Why is there a dicdata.dat and a diccache.dat file?
NOTE:477125.1 - How can users enable component tracing for the Database Extract component and read the log files in Siebel versions 7.x?

Applies to:

Siebel Remote Server - Version: 7.5.3.5 [16183] to 8.1 [21039] - Release: V7 to V8
IBM AIX on POWER Systems (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.3 [16157] FIN
Database: IBM DB2 7.2 FixPack 3SA
Application Server OS: IBM AIX 5L 5.1
Database Server OS: IBM AIX 5L 5.1

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

Symptoms

SBL-SMI-00077We are receiving the below error when running the Database Extract component, for creating local databases for our developers. The database connect parameters for the component seem to be ok (user, pwd, ODBC name, table owner, table owner pwd). Please let us know what further information we can provide.

SBL-DCK-00164: Error connecting to datasource (null) ((null))

Thank you.

Cause

This behavior occurred when the mobile client extracted did not have a corresponding employee record. This was because the employee record has been deleted.

Solution

Message 1

For the benefits of other customers, the Database Extract component was erroring out with

Target client "SYDGCML" does not have any valid employees.
SBL-SMI-00077: Component error, see the trace file for more information

This behavior occurred when the mobile client extracted did not have a corresponding employee record. This was because the employee record has been deleted.

This behavior is resolved by clearing out the mobile client records manually. The steps for this are provided by Siebel Technical Support.

Change Request 12-JNNQK7 has been raised to request for a check when an employee record is being deleted such that it would deactivate and delete the corresponding mobile client when the employee record is deleted.

If you encounter this behavior, please raise a Service Request with Siebel Technical Support quoting this Service Request.

Thank you.
 

Applies to:

Siebel Remote Server - Version: 7.5.3.11 [16199] to 8.1 [21039] - Release: V7 to V8
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.2.216 [16084]
Database: IBM DB2/UDB 7.2
Application Server OS: Sun Solaris 2.8
Database Server OS: Sun Solaris 2.8

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

Symptoms

SBL-SMI-00077We had installed our pre-production environment without problems, but when we tried a Database Extract we have the following error:

Final code = 2100077
Finish information = SMI-00077: Error del componente; consulte el archivo de seguimiento para obtener más información.

I ran the Generate New Database process with no problems.
I am attaching the "DbXtract_16461.log" file; in this file I found the following message:

[IBM][CLI Driver][DB2/SUN] SQL0440N No function by the name "NEXTSEQ" having compatible arguments was found in the function path. SQLSTATE=42884

This message occurs when the user is doing an upgrade process, but I am installing a new environment.

Do you have any idea how can I solve this issue?

Thanks in advance.

Cause

Database specific issue

Solution

Message 1

For the benefit of other users:

Customer installed their pre-production environment without problems, but when they tried to perform a Database Extract, they received following error:

“Finish information = SMI-00077: Error del componente; consulte el archivo de seguimiento para obtener más información.”

The main error message found in the DbXtract*.log file is as follows:

‘SQL0440N No function by the name "NEXTSEQ" having compatible arguments was found in the function path. SQLSTATE=42884’

This ‘SQL0440N - No function by the name "<function-name>" having compatible arguments was found in the function path’ error message usually occurs in a reference to function "<function-name>" (i.e. NEXTSEQ), when the database manager cannot find a function it can use to implement the reference. There are several reasons why this could occur:

(a). "<function-name>" was either incorrectly specified or does not exist in the database.

(b). A qualified reference was made, and the qualifier was incorrectly specified.

(c).The user's function path does not contain the schema to which the desired function belongs, and an unqualified reference was used.

(d).The wrong number of arguments was included.

(e).The right number of arguments was included, but the data types of one or more of the arguments are incorrect.

<Ctd..>

Message 2

<Ctd...>

(f).The function does not exist in the database with a create timestamp earlier than the time the package was bound (applies to static statements).

Following SQL statement was run against the database to check if the NEXTSEQ function exists in the database.

Select * from sysibm.sysfunctions where name = 'NEXTSEQ';

According to the query results, we found that the NEXTSEQ function does not exist in the database.

In order to have NEXTSEQ function in the database you need to install the stored procedures and user-defined functions on your Siebel Database Server. First you must transfer them to the Siebel Database Server and install the Siebel Database Server components.

The behaviour resolved after customer ran NEXTSEQ.SQL script from the ‘siebproc.sql’ file to create the missing function ‘NEXTSEQ’ in the database. After that they performed a new Database Extract and it worked perfectly.

Please refer to Bookshelf, Siebel Server Installation Guide for UNIX > Chapter 7 Installing the Siebel Database Server for DB2 Universal Database > Siebel Database Server Software Installation > “Installing the Stored Procedures and User-Defined Functions" for information about installing Stored Procedures and User-Defined Functions.

<Ctd...>

Message 3

<Ctd...>

We recommend obtaining the assistance of a Database Administrator (DBA) to perform this.

Thank you.
Best Regards
Siebel Technical Support

Key words: Database Extract, SMI-00077, SQL0440N, NEXTSEQ, NEXTSEQ.SQL, siebproc.sql, Stored Procedures, User-Defined Functions