“Specified database file already in use” Error when try to connect local Database

Problem: Specified database file already in use

When you check the log file If you see the error below, that means ODBC Connection setting of Local Database should be changed.

GenericLog    GenericError    1    000000024ccd0e30:0    2010-10-31 14:12:58
08001: [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Specified database file already in use

GenericLog    GenericError    1    000000024ccd0e30:0    2010-10-31 14:12:58    (wraprmtcmn.cpp (63) err=1114276 sys=540) SBL-DCK-00164: Error connecting to datasource SEAW Local Db default instance (ERSINERSOY).

GenericLog    GenericError    1    000000024ccd0e30:0    2010-10-31 14:12:58    Error connecting to datasource %1 (%2).
Solution: Set as empty Start line and Server Name properties on Local ODBC Connection

GenericLog        GenericError        1        000000024ccd0e30:0        2010-10-31 14:12:58

08001: [Siebel Database][ODBC Driver][Adaptive Server Anywhere]Specified database file already in use

 

GenericLog        GenericError        1        000000024ccd0e30:0        2010-10-31 14:12:58        (wraprmtcmn.cpp (63) err=1114276 sys=540) SBL-DCK-00164: Error connecting to datasource SEAW Local Db default instance (ERSINERSOY).

 

GenericLog        GenericError        1        000000024ccd0e30:0        2010-10-31 14:12:58        Error connecting to datasource %1 (%2).

Database Extract Job Failed with Unable to find node in database(SBL-SMI-00077) Error

Problem: “SBL-SMI-00077” Database Extract Job Error.

If your database extract job failed with SBL-SMI-00077 error, first you should check the log file because SBL-SMI-00077 Error is a generic error. If you see “Unable to find node in database” error in the log file then you can be sure it is related missing Mobile Web Clients settings.

Solution: Siebel Bookshelf – Remote and Replication Manager Administration Guide > Setting Up Mobile Web Clients > “Registering a Mobile Web Client” steps should be applied.

Published in: on 9 Kasım 2010 at 5:53 pm  Yorum Yapın  
Tags: , ,

Web Service Publisher Business Service In Siebel

There is a BS named Web Service Publisher. It can be used to get Web Service list and generate WSDL of a web Service. It is very useful if you want to integrate Siebel Web Services with Service Repository via exposing this BS as a Inbound Web Service.

You can find Business service simulator samples below,

Simulator Input

<?xml version=”1.0″ encoding=”UTF-8″?><?Siebel-Property-Set EscapeNames=”true”?><Test_spcService
Service_spcName=”Web Service Publisher”
Method_spcName=”GetWebServiceList”
Iterations=”1″
></Test_spcService>

Input Arguments Input

<?xml version=”1.0″ encoding=”UTF-8″?><?Siebel-Property-Set EscapeNames=”true”?><PropertySet
Namespace=”*”
WebService=”*”
></PropertySet>

Published in: on 8 Mart 2010 at 5:25 pm  Yorum Yapın  
Tags: , ,

Read CSV File Business Service In Siebel

In Siebel vanilla there is an undocumented BS named Read CSV File.

This BS is very useful especially for testing. Using this BS you can read a file based on Integration Object  and you can use it for unit testting purposes. Also i can be an alternative to load data into Siebel. You can find detail information about this BS below,

http://blogs.oracle.com/siebelessentials/2008/10/encounter_with_the_read_csv_fi.html

Published in: on 9 Temmuz 2009 at 12:03 pm  Yorum Yapın  
Tags: , , , ,

Regular Expressions In Siebel with Non English Character Set support

You can find basic information about How Regular expressions can be used in Siebel in below links,

http://siebeldev.blogspot.com/2009/04/regular-expression-validation.html

http://download.oracle.com/docs/cd/B40099_02/books/eScript/eScript_JSReference252.html

For the Non English character set support, RexExp pattern should be writed with Unicode characters.

You can get information about Unicode below link,

http://www.unicode.org/

You can find a simple pattern about Turkish First Name  validation below,

“^[\u0041-\u005A]{1}\u002E?[\u0041-\u005A|\u0061-\u007A|\u0130|\u0131|\u00D6|\u00F6|\u00DC|\u00FC|\u00C7|\u00E7|\u011E|\u011F|\u015E|\u015F]*$”

Pattern explanation:

First character should be Upper Case(\u0041-\u005A]{1})

Second character could be “.” (\u002E?)

Other characters can be anything in Turkish Alphabet([\u0041-\u005A|\u0061-\u007A|\u0130|\u0131|\u00D6|\u00F6|\u00DC|\u00FC|\u00C7|\u00E7|\u011E|\u011F|\u015E|\u015F])

Published in: on 9 Temmuz 2009 at 11:51 am  Comments (2)  
Tags: , , , , , , , ,

Difference Between Object and Project Compile In Siebel

Hi,

In theory, there is no difference between object and project compile in Siebel but in fact sometimes there is. I crashed a Siebel bug which is related object compile and i wasted lots of time to find the problem 🙂 This is not very common, most of times object compile is working pretty good but in this case below, it doesn’t.

Click here to see bug detail

My suggestion is if you are compiling your changes via Object compile and they are not working, please compile your changes via project compile(compile all projects you change) and test it again. It can be related object compile problem.

Regards.

Published in: on 24 Mart 2009 at 12:14 am  Yorum Yapın  

Popup Visibility Auto All BC Property Is Not Working In Siebel

Hi,
Recently, i tried to test “Popup Visibility Auto All” behavior in my local env. It was not working as documented “Siebel Security Guide“. After some research and long metalink(Service request) chat, we found that there is a siebel bug which is related object compile.
Let’s imagine,
  • Your Account BC’s visibility auto all property is checked.
  • You created a new view named “All Accounts” whichs applet visibility type is “All” and whichs visibility applet’s BC is Account.
  • You added this view in a screen.
  • You added this view in an user’s responsibility.
  • You compiled all objects you changed via Object compile.
In theory, after all you can see all accounts in pick and MVG applets but practically you can’t. Because there is a bug related object compile. To see this behavior you should compile your changes via project compile(you have to compile all projects that you changed) or you should perform a full compile.
For detail information, you can read “3-864970731” SR on metalink3.
Regards.
Published in: on 23 Mart 2009 at 11:59 pm  Comments (2)  

What happens If the Applet visibility Type Is Null?

Hi,

“What happens if the Applet visibility Type Is Null” is very common question which is has an answer in Bookshelf. I am just copied it below,

Visibility Settings
A view not set up with visibility settings (the properties Visibility Applet and Visibility Applet Type are
blank) means the following:

When navigating from another view to this view without visibility settings using the Show drop-down
list, the queries context and record focus are kept from the previous view, assuming that the same
business components and search specifications are relevant.
However, when navigating to a view without visibility settings using the Site Map or the Screen Tabs,
the view behaves as if the most restrictive visibility would apply to this view. (Normally this means
Personal or Sales Rep visibility, depending on the corresponding visibility settings of the business
component of the view’s Thread Applet property.)

Resource: Siebel 7.8 Bookshelf Object Type Reference Document, Page 306.

Regards.

Published in: on 5 Şubat 2009 at 9:05 pm  Yorum Yapın  
Tags: ,

Using Siebel Iff function without ELSE part in Applet or BC Search Spec

Let’s thing you have a requirement that if Login name is DUMMY, show only records in which name field equal to “3Com” otherwise show all the records which means you don’t want to make a filtering if Login Name is not equal to DUMMY.

You can not use “IIf” function without else part like below becasue of it is giving syntax error.

IIf((LoginName() = “DUMMY”), [Name]=”3Com”)

But you can not use “IIf” function like this below which is giving syntax error.

Instead of this you can do a trick this using “Id” column which is always not null and active.

IIf((LoginName() = “DUMMY”), [Name]=”3Com”,[Id] IS NOT NULL)

Sure, it has some performance impact but i can not find better way 😦 What about you?

Published in: on 5 Şubat 2009 at 8:42 pm  Yorum Yapın  
Tags: ,

Nişanlandım da vuruldum

Merhaba,

Cumartesi günü akrabalar arasındaki bir tören ile nişanlandım. Vurulacağım tarih ise Ağustos ya da Ekim olacak gibi gözüküyor. Kesinleştiğinde sizlere haber veriyor olacağım.

Sağlıcakla.

Published in: on 20 Mayıs 2008 at 7:49 am  Comments (2)