Techlogbooks

We often face the username or password error while logging into local Siebel tools or client, even though we have correct credentials. This normally happens from the ODBC level, i.e. you might have tried to test the connection from ODBC with a different username and password and forgot to clear it from the corresponding odbc connection.  This leads to either Check out or check in Error or it will throw error while logging in if the credentials used in ODBC not exists in this local database.  In this example you can see, say first scenario, I am using USER as username and at odbc level I have tested connection with SADMIN and not cleared the credentials. In such cases, if I have right credentials at odbc level it will allow you to login, but with credentials at ODBC level, not with the username or password you have entered at login screen. . In the second scenario, if you were able to login with the credentials at ODBC level and when you try to...

During the Siebel EAI integration process there will be some scenarios of error logging in workflow process based on the response from the external system. Instead of having the additional attributes/columns in the error logging table, you can utilize only the Error code and Error Message columns to pass both the Workflow errors as well as error response from external system. As you can see in the below in the expression editor, you can check if there is any workflow error by checking on the default process property Error Code, if not pass the process property you have created to hold the response message in the same workflow. This way you can utilize the same columns for multiple purpose instead of keeping null if the error is otherwise.  The ampersand (&) identifies the text that immediately follows the ampersand as the name of a process property

There are times when we have do some import and export to and from the siebel application and we do without any hasseles. But if you recently patched up your environments with the 8.1.1.11, you might face an error some thing like below while exporting. Error writing XML to file ‘D:\XXXXXX-XXXX.xml’. (SBL-EAI-04262) File could not be created as the directory specified for the file creation is not valid.(SBL-EAI-50228) This error is specifically due to the enhanced security in the latest patch, which will allow you to write files only to the specified directory annd this affects both siebel thin and thick client. To workaround this restriction there is a CFG parameter EAIFileTransportFolders, for which you need to create an entry in tools and your application cfg for the specific folders where you want to export. [EAIFileTransportConfigSubsys]  EAIFileTransportFolders = c:\Myfiles;d:\users\ExportedFiles If you want to export anywhere into your local machine, the...

In order to test your changes in the local we need to setup the Debug setting in Tools to be able to launch the Thick client. In tools, go to View->Options , a dialog box opens up then Click on Debug tab which looks as below screen shot. For the first time you have enter some paths in this dialog box as below. Executable – Provide the client Siebel.exe file path name, usually its under Client folder of you installation. CFG file – Provide the client CFG path with file name, make sure you have client local path specified inside the file. Browser – Provide the Internet Explorer exe file path Working Directory -   Usually its under the BIN folder within Client. You can also try the ENU under BIN if its not working. Provide USERNAME and PASSWORD and select data source as Local.   PS: Make sure you have compiled your changes into your .srf (local srf) which is specified in the client cfg mentioned in the de...

Which processor you use to exclude the duplicate records ? Firstly we need to identify the duplicates by using the “Duplicate check” processor providing the attributes on which you want list duplicates. Take only the output records of this processor from “Non-Duplicated” port, thereby eliminating duplicates from the data stream. Which Processor is used to eliminate Duplicates ? In order to eliminate duplicates, we can use “Group and Merge” processor, which in turn has 3 sub-processors i.e. Input, Group and Merge. Add Attributes to Input Sub-processor to be considered in this data stream. Add the Attribute(s) on which to eliminate the duplicate to the “Group” sub processor. In the Merge Sub-process, select the relevant Merge function, by default its “Most Common Value” Consider the Merged output results for the De-duplicated records. What is the difference between “Lookup and Return” and “Lookup Check” Processors ? Lookup and Return, does the look up on t...

1.     What are the types of external souces from which you can import data into EDQ? EDQ can import from different types of sources like text(.txt, .dsv etc), excel (.xls, csv), and all types of databases like Oracle, DB2, Postgresql, Mysql, Microsoft Sql Server, Sybase etc.. 2.      What are the objects you create in EDQ to import files or from database? First of all we need to create a Data store pointing to file or database and then create and run the staged data to import data. In case of file you can either give the local path or if its server give the server credentials and path of the file to select the file. 3.     What is the Staged data? Staged data is where you store the intermediate or final results within your EDQ space, it’s like a EDQ table which stores the Processed data from the processes 4.      What is the different between Staged data and Reference data? Staged data is...

What is the main purpose of Lookup and Return? Lookup and return is one of the main processor used in the EDQ for the data enrichment. This processors takes one or more attributes as input and returns one or more attributes as output as per the reference data definition. If you multiple files/sources to read the data, how are going bring all data together in one stream? First of all create snapshot of all the files and add a reader processor for each file and then by using the Merge processor you can bring all the files together. P.S : All the files has to be in the same format to bring together in merge process/ you can selectively choose few columns from each file in Merge processor How will you identify and eliminate duplicates in EDQ ? In order to just identify  duplicates  we can use Duplicate check processor by passing one or more  attributes on which duplicates needs to be identified. In order to eliminate/merge these duplicate, we can use Gr...