ORA-00942: table or view does not exist or ORA-00904: Invalid identifier

Error: ORA-00942: table or view does not exist
Reason: This error occurs when new table/view exists in logical schema (Siebel repository) but not present in physical database

Error: ORA-00904: “Field Name”: invalid identifier 
Reason: This is also because of mismatch between logical schema and physical database

How to resolve: To fix both issues, we have to sync physical database with Siebel repository. To do so, Siebel provides DDL Sync utility. DDLsync utility compares the logical schema (schema definition in Siebel repository) with physical schema (physical table/column definitions in database) and applies all differential changes on Physical schema so that both are in sync. But there are exceptional cases as well.
          1. Custom column that is in physical schema but not in Siebel repository (logical schema) will not be deleted
          2. Custom index that is in physical schema but not in Siebel repository (logical schema) will not be deleted

After running DDL Sync utility, if you still face the issue, please let us know. We will try our best to fix it. If you have any other issue, please share with us.
To get more updates on recent activities, follow ‘TechOneStop on Facebook/Twitter/LinkedIn or join our website as followers.

Siebel Incremental Repository Merge – errors that we faced

Incremental Repository Merge is the new feature that has been introduced from Siebel onward. It makes the Siebel repository upgradation process faster and easier without going through major upgrade project. Recently we have performed IRM for one of our clients. During the process, we have faced many errors/issues. Here we have discussed few major, frequently occurred errors during IRM.

Error Message:
Importing file “D:Siebel8.1Tools_1tempIRM_PRIOR_CUST.dat”.22001: [DataDirect][ODBC Oracle driver][Oracle]ORA-12899: value too large for column “SIEBEL”.”S_ACCELERATOR”.”INACTIVE_FLG”  (actual: 4, maximum: 1) 
Reason n Solutions:
This error comes up because of incorrect registry settings on ODBC data source. 
To fix this issue, follow below steps:
Step 1: Start the Microsoft ODBC Administrator 
Step 2: On the ODBC Data Source Administrator dialog box, select System DSN tab and copy the DSN name
Step 3: In Windows registry, locate following registry entry  [HKEY_LOCAL_MACHINESOFTWAREODBCODBC.INISiebel_DSN_Name]

Step 4: Verify following registry keys are set properly or not. These keys are required in order for the ODBC driver to behave correctly. If keys are not present, then add new key like below
                                      PacketSize = 0

Error Message:
ERROR::SBL-DEV-62155: CommitCopyInstance EXITING with error – The same values for ‘Column Name’ already exist
Reason n Solutions: 
This error comes up when the database is not running in binary sort order mode. During Incremental Repository Merge, it is mandatory to set the parameter NLS_SORT to BINARY which helps database to in Binary mode.

Error Message:
ERROR::c: MAP ENTRY with same id exists
ERROR::BUT strNamePath and ParentId are different
ERROR::SBL-DEV-62252: Could not create HASH entry
ERROR::Type – Workflow Process, strNamePath – eMail Response – Create Activity: 0

Reason n Solutions:
This behavior typically occurs when an object already exists in the New Customer Repository but the workflow process which is trying to insert, has a different set of attributes. This is due to one particular workflow, could be ignored.

Error Message:
ERROR::SBL-DEV-62111: NON-REQUIRED FKey not found in ‘New Standard Repository’
ERROR::Type – WF Branch Connector, strNamePath – ABO Bulk Request – ApplyProductPromotion

Reason n Solutions:
This is because of one/more non-required foreign keys from the ‘Prior Customer Repository’ are not present in the workflow definition and that’s why the particular workflow object was inserted into the ‘New Customer Repository’ with a NULL value during IRM process. This is also one of those generic errors which can be ignored.

Error Message:
ERROR::SBL-DEV-62155: CommitCopyInstance EXITING with error – 1-3ZGTMC.
ERROR::SBL-DEV-62194: INSERTION FAILED. Type View, NamePath – SWLS Technician Breaks View
ERROR::SBL-DEV-62194: INSERTION FAILED. Type Applet, NamePath – SWLS Technician Breaks Display Applet

Reason n Solutions:
This error occurs when a new Siebel object is added to the standard Siebel repository but it has the same key details as a custom object that already exists in the ‘Prior Customer Repository’. This error also can be ignored.

Error Message:
Failure: 161782 rows of EIM_EMPLOYEE had NULL in STATUS_CD 
Reason n Solutions:
This error comes up when IRM process tries to populate siebel base table using interface tables. So before staring IRM process, clear all interface tables from siebel database (part of siebel best practice during repository merge or upgrade) to avoid this error.

Error Message:
ERROR::SBL-DEV-62102:  -> aborted with error: The same values for ‘Sequence’ already exist.
Reason n Solutions:
When repository merge process starts to re-sequence objects automatically, this error may occur. It is an acceptable error message which doesn’t need any fix, can be ignored.

Error Message:
ORA-00942: table or view does not exist
Reason n Solutions:
This error occurs when table/view definition exists in logical schema but not in physical schema. So run DDL sync utility to create new tables/views in physical database. 

Error Message:
ORA-00904: “JOB_TYPE_CD”: invalid identifier  
Reason n Solutions:
This is also because of mismatch between Siebel physical database and logical database. Here also we just need to run DDL Sync utility to sync both databases.

These are few major issues/errors that we generally face during Siebel Incremental Repository Merge in Siebel. If you have faced any other issue, please let us know. We will try our best to help you.
To get more updates on recent activities, follow ‘TechOneStop on Facebook/Twitter/LinkedIn or join our website as followers.

Check our Youtube videos on Siebel Open UI training, you will like it.

Your version of the Siebel High Interactivity Framework for IE, required for use of this Siebel application, may not be current

‘Your version of the Siebel High Interactivity Framework for IE, required for use of this Siebel application, may not be current’ – this is one of the most common errors during Siebel application launch on Internet Explorer browser but good thing is that we can fix this error quite easily.

Steps to fix Siebel High Interactivity Framework for IE issue:

  1. Navigate to browser settings > Internet Options and click on Security tabYour version of the Siebel High Interactivity Framework for IE
  2. Under the Security tab, click on ‘Trusted Sites‘ and add Siebel URL to the trusted zone
    Example: If the Siebel application URL looks like ‘http://localhost:8080/sales_enu’, then you just add ‘http://localhost:8080’ in the trusted site zone. Also you make sure that the checkbox for ‘Require server verification (https:) for all site in this zone’ is unchecked.
  3. On the Security screen only, click on ‘Custom Level‘ button and verify  properties like ActiveX control are enabled.

Now save all browser settings, close the browser and relaunch Siebel application. This should fix Siebel High Interactivity Framework issue.

Do you still see the same error?

Well! then you need to perform few more extra steps to launch Siebel application successfully. Sometimes the ActiveX file of Siebel high interactivity framework becomes corrupted or damaged. So you need to delete the damaged ActiveX file and download a fresh copy of ‘Siebel High Interactivity Framework’.

Extra steps to fix Siebel High Interactivity Framework for IE issue:

  1. Navigate to browser settings > Internet Options > General and then click on ‘SettingsYour version of the Siebel High Interactivity Framework‘ button available under ‘Browsing history’ section 
  2. On the ‘Website Data Settings’ pop up window, click on ‘View objects’ button under ‘Temporary Internet Files’ tab. It will display all downloaded program files with statuses. If you see only one file ‘Siebel High Interactivity Framework’ with ‘Damaged’ status, then just delete the file. But if there is more than one copy of ‘Siebel High Interactivity Framework’ file, then you right click on each file and change the status to ‘Damaged’ and delete.

Remember, you can only change the status of the file if you have admin rights, otherwise ask your system administrator to do it.

Then close the browser, open Siebel application and you will get a pop up asking to download a fresh copy of ActiveX file.

Still no luck!! Same message appears again and again! Please feel free to comment here and we will try to help you further.

Keep in touch, follow TechOneStop on Facebook / Twitter / LinkedIn / Goolge+.

Want to know more about Siebel Open UI? Watch our Siebel Open UI YouTube videos or read our articles on Siebel Open UI training.

Not able to see control or list column in Applet

Sometimes it happens in Siebel, though you have added control or list column in an applet but it is not visible on UI. Have you ever faced such issue? No! well you may face 🙂

There could be many reasons behind this like field is inactive or does not exist in business component anymore or Visible property is false for that column in Applet. I hope you have checked all these. Also check item identifier of control or list column inside that applet. We all know what is item identifier, right!! It helps Siebel to identify the control or list column in applet web template and it is unique number generated by Siebel automatically. If same item identifier is assigned to more than one control or list column, then this situation may occur where control or list column will not be displayed on UI. 
To fix it, follow below steps:
1) Check the item identifier for the control/list column which is not displayed on UI
2) Copy the item identifier and again query with that in siebel tools 
3) If there is more than one control/list column with the same number, then delete both control/list columns from that applet and drag-drop them once again. It will generate unique number for those controls.
Now compile all changes and check, it should display control or list column on Applet. After doing this, if you can not see, please let us know. 
Please feel free to comment here. To get more updates on recent activities, follow ‘TechOneStop on Facebook/Twitter/LinkedIn or join our website as followers.
We have a very good open ui training series, you may like it. Check our youtube video on Siebel Open UI training.

Integrate third party application with Siebel/Open UI using Symbolic URL

To increase productivity/sales, data visibility among various business units is very important for an organization. So it should have way out to integrate different business processes across applications. To meet this business requirement, Oracle has provided many integration tools within Siebel application, one of such tools is Symbolic URL. Using symbolic URL, we can integrate third party application winth Siebel. Lets see how.
So start our discussion with an example. Suppose we want to display market statistics (like stock price, stock analysis) of accounts in Siebel application where statistics come from third party application. Here we will use rediff.com as third party application which will give us market statistics. 
Let’s say we have 3 accounts Infosys, Oracle and Yahoo. As per business requirement, we have to display market statistics of these 3 accounts. 
Rediff  URLs to display stock details are like below: 
Infosys     >      http://search.rediff.com/dirsrch/default.asp?src=web&MT=infosys
Oracle      >      http://search.rediff.com/dirsrch/default.asp?src=web&MT=oracle
Yahoo      >      http://search.rediff.com/dirsrch/default.asp?src=web&MT=yahoo

For symbolic URL, it is mandatory to have one static unique URL for each account. So, lets start configuration step by step.
Step 1:
– Create a project or lock an existing project in Siebel tools. Here we have created a new project ‘Symbolic URL Test’ to keep all symbolic URL related changes in one place.

Step 2: 

– Create a calculated field under Account BC to display market statistics as per account name. We have created a calculated field with below specs:
                 Field Name          = Account Portfolio
                 Calculated            = True
                 Calculated Value  = “Account_Portfolio”

Step 3:

– Create a list applet (Account Portfolio Web Applet) based upon Account BC and the field 
   ‘Account Portfolio’
– Modify the applet web template as ‘ePortal URL Applet’ in Base Read Only mode
– Don’t add any control in the applet
– Change the Class from CSSFrameList to CSSFrameListWeb
– Change the list column properties of ‘Account Portfolio’
                HTML display mode  =   DontEncodeData
                Field Retrieval Type   =   Symbolic URL

Step 4: 

– Create view (Account Portfolio Web View) with SIS account Entry Applet and Account Portfolio List applet so that upper applet displays account details and lower applet is for market statistics from third party application rediff.com

Step 5: 

– Add the view in Account Screen as details view and compile everything

Step 6: 

– Go to siebel application and register the view ‘Account Portfolio Web View’ and add it with responsibility

Step 7:

– Goto Application – Integration > WI Symbolic URL and from the dropdown, select Symbolic URL 
– Add symbolic URL with name Account_Portfolio, Siebel may add suffix to the Symbolic URL
– Set the value for URL as ‘http://search.rediff.com/dirsrch/default.asp?src=web&’ 
   because next part of the URL i.e MT works as variable (like : MT = Infosys / Oracle / Wipro)
– Set SSO Disposition as IFrame
– Set the argument for MT, specify from where the argument will get value in run time
   Here it looks like below: 
                Argument type            =  Field
                Argument Value          =  Name
                Append as Argument  =  True
So in run time, Siebel will get value from ‘Name’ field and append it to the original URL (Like http://search.rediff.com/dirsrch/default.asp?src=web&MT=infosys)

Step 8:
– Except ‘MT’ argument, we need to add few more arguments like below 
                src with Arg Type = Constant and value = Web
                IsrecordSensitive with type = Command and value = TRUE
                IFrame with type = Command and set proper Value

That’s all, now goto Account screen and check it is working as per our requirement or not.
If you have any doubt/question, please leave your comment here. To get more updates on recent activities, follow ‘TechOneStop on Facebook/Twitter/LinkedIn or join our website as followers.

Watch our Youtube videos on Siebel Open UI training:

Configure Siebel Home page Using Microsite VBC

Siebel has so many built in functionalities, it is hard to find in any other CRM (On Premise/Cloud). Have you seen customized home page in Siebel, mainly in Partner Portal application? Here is the screenshot what we have customized for Siebel Partner Portal Home Page. 

Configure Siebel Home page Using Microsite

Is it difficult to configure!! To meet such requirement, we have to modify HTML script which is responsible to build user interface. In any CRM, except Siebel or Open UI, first we have to find out the HTML/CSS file which is responsible to display message on Home page, then change HTML script, test it. If anything is not in proper place, then again modify the template and test it. 
Lot of work, isn’t!! Now see, how easily we can meet such requirement in Siebel or Open UI.
In Siebel, customized home page is derived from Microsite. Siebel provides specialized business component ‘ERM Microsite Section Body VBC’ to display data from Microsite. Throughout this article, we will use Partner Portal Home page to describe configuration steps. So our applet name is ‘ePortal Cat Splash Applet’ which is based upon ‘ERM Microsite Section Body VBC’ business component and view is ‘Home Page View (SCW)’.

This is two step configuration. First configure Microsite VBC in Siebel Tools and then Administration-Microsite in Siebel Client.

Step 1:
–  Select the business component ‘ERM Microsite Section Body VBC’ in Siebel tools and expand   
   BusComp User Properties in OBLE
–  Check user property ‘MicrositeSection’ is already present or not. If not, then create an user property    with name ‘MicrositeSection’ and Value ‘Body’
–  Compile all changes

Step 2:
–  Go to Administration-Content Center > Content Sets and add new content. If you have the content      file ready, then upload it by clicking on ‘Add Content’ button otherwise create new content.
–  Here we will create a new content ‘eChannel Home Screen Content’, so click on New button and    
   give the content name and title.

Step 3:
–  Below in ‘Asset’ tab, click on New to upload asset which will be displayed on home page
–  If you don’t have any file to upload for home page, then just build one blank file with .DOC or    
   .HTML extension. We will modify it once the file is uploaded.
–  Give the asset Name, title and browse the file on popup applet. File format could be anything
   (example .JPG, .DOCX, .HTML), then click on ‘OK’ button to upload. There are few advanced        
   properties as well, like Language Code, Private, Data Length. We could leave these as it is.
–  To modify the file, click on ‘Check Out’ button if it is not grayed out already and then ‘Edit HTML’.    Don’t worry! no need to write any HTML script here. It will open one popup applet just like word      document. We could build our custom template within few minutes. Once template is ready, save it 
   and do check in.

Step 4:
–  Go to Administration – Microsite > Page Administration, create a new page and click on Publish
   For partner portal home page, we have used below specification.
                      Page Title: eChannel Home Screen
                      View : Home Page View (SCW)
                      Content Set : eChannel Home Screen content

Step 5:
–  Now navigate to Portal Screen Administration to check the Screen is already listed or not. In our   
   example, screen name is ‘eChannel Home Screen’ which contains the view ‘Home Page View   
–  If not present, create a new portal screen. This portal screen name must be same as the screen       
   name used in Siebel tools.

That’s all, Open the eChannel application and verify siebel partner portal home page. See how we can build our custom home page without any HTML script! Siebel is fun, Isn’t it!!

If you have any doubt or question, feel free to comment here. To get more updates on recent activities, follow ‘TechOneStop on Facebook/Twitter/LinkedIn or join our website as followers.