Command Line Parameter for Siebel Application.
/c : Configuration file
/h : Debugger mode
/d : Default database.
/s : Spool
/u : UserId
/p : Password
Note: For Spooling in WF simulator process, Need to pass /s before /h in debug arguments in Siebel tool.
Showing posts with label Siebel Admin. Show all posts
Showing posts with label Siebel Admin. Show all posts
Thursday, January 14, 2010
Friday, January 8, 2010
Siebel Client / Tool / system Performance
Siebel Client / Tool / System Performance
Siebel Tool and Client should run smoothly otherwise it irritates a lot on work.
As per my understanding, Apart from my previous post, For improving performance of Siebel Tool / Client And System, you need to regularly delete all *.log ,*.txt and *.dmp and spool.txt of Siebel Log directory on your local.
Also delete all temporary files of your local system, That resides in TEMP Folder.You can check your temp file directory.
Go to Run and Type %TEMP%
Delete all file of this dir, but don't delete structure. Means don't delete any folder only files should be deleted.You can use Dos CMD for same.
I have written following bat file that regularly delete all temp file as well as all siebel logs after a time interval.
log.bat
REM*****************************
REM Delete Log and temp file
REM*******************************
cls
cd C:\Program Files\Siebel\8.0\web client\LOG
del /F *.txt
del /F *.log
del /F *.dmp
cd\
cd C:\Program Files\Siebel\8.0\Tools\LOG
del /F *.log
del /F *.dmp
cd\
DEL /F /S /Q %TEMP%
On Production Server,You can use environment variable SIEBEL_LOG_ARCHIVES = 3, It will keep only recent 3 copy of a log and will delete old.
You can use window scheduler to schedule this after a regular time interval(Like reboot).
Siebel Tool and Client should run smoothly otherwise it irritates a lot on work.
As per my understanding, Apart from my previous post, For improving performance of Siebel Tool / Client And System, you need to regularly delete all *.log ,*.txt and *.dmp and spool.txt of Siebel Log directory on your local.
Also delete all temporary files of your local system, That resides in TEMP Folder.You can check your temp file directory.
Go to Run and Type %TEMP%
Delete all file of this dir, but don't delete structure. Means don't delete any folder only files should be deleted.You can use Dos CMD for same.
I have written following bat file that regularly delete all temp file as well as all siebel logs after a time interval.
log.bat
REM*****************************
REM Delete Log and temp file
REM*******************************
cls
cd C:\Program Files\Siebel\8.0\web client\LOG
del /F *.txt
del /F *.log
del /F *.dmp
cd\
cd C:\Program Files\Siebel\8.0\Tools\LOG
del /F *.log
del /F *.dmp
cd\
DEL /F /S /Q %TEMP%
On Production Server,You can use environment variable SIEBEL_LOG_ARCHIVES = 3, It will keep only recent 3 copy of a log and will delete old.
You can use window scheduler to schedule this after a regular time interval(Like reboot).
Thursday, January 7, 2010
Dataexp / Dataimp utilities
Repository:
--------------
As per my understanding, Siebel repository resides in around 148 tables.For better access,there is also a binary form of repository called SRF,compiled and stored on all siebel servers.
1.Seed data
2.Repository Data
3.User Data
Siebel database utilities
----------------------------
Dataexp/Dataimp utilities :
As per my understanding, This utility is very nice for importing data from one db to other.but this utility has not been documented anywhere.So before doing any migration, take proper backup.It needs to be used on siebel instruction only.But It works very well all time.No matter what is source database and what is destination data base.you can import data base from production to local, local to prod .Before import, Truncate table that removes all old records and sync with new.
Close thick client and tool as well.
Cmd syntax:
C:\Program Files\Siebel\8.0\Tools\BIN\Dataexp /U USERNAME /P PASSWORD /C "ODBC NAME" /D SIEBEL TABLE OWNER /F C:\export.dat /L c:\log.txt
It imports table by table and continuously prompt for table name.
Same for import.
--------------
As per my understanding, Siebel repository resides in around 148 tables.For better access,there is also a binary form of repository called SRF,compiled and stored on all siebel servers.
1.Seed data
2.Repository Data
3.User Data
Siebel database utilities
----------------------------
Dataexp/Dataimp utilities :
As per my understanding, This utility is very nice for importing data from one db to other.but this utility has not been documented anywhere.So before doing any migration, take proper backup.It needs to be used on siebel instruction only.But It works very well all time.No matter what is source database and what is destination data base.you can import data base from production to local, local to prod .Before import, Truncate table that removes all old records and sync with new.
Close thick client and tool as well.
Cmd syntax:
C:\Program Files\Siebel\8.0\Tools\BIN\Dataexp /U USERNAME /P PASSWORD /C "ODBC NAME" /D SIEBEL TABLE OWNER /F C:\export.dat /L c:\log.txt
It imports table by table and continuously prompt for table name.
Same for import.
Monday, January 4, 2010
Siebel Tool / Client Performance / Hangs
Siebel Tool / Client Performance/ Hangs
1.Always Close siebel tool/client from file->Exit, Because improper close of siebel tool, Kept log of all transaction and don't delete all after tool close. When you close tool from file->Exit, it removes/ deletes all transaction log saved in S_DOCK_TXN_LOG
2.Truncate table S_DOCK_TXN_LOG .It will delete all transaction log that has not been deleted automatically because of improper exit of siebel tool.
S_DOCK_TXN_LOG : Keep tracks of all DB changes(field level) through application.
3.Make AutoStopDB = TRUE in tool.cfg and client.cfg
4.Don't remove server name from odbc,that is readyment server.
5.Remove additional parameter of local ConnectString
ConnectString = C:\PROGRA~1\Siebel\8.0\Tools\LOCAL\sse_data.dbf -q -m -x NONE
6.In ODBC, Supply user id and password of SIEBEL.
1.Always Close siebel tool/client from file->Exit, Because improper close of siebel tool, Kept log of all transaction and don't delete all after tool close. When you close tool from file->Exit, it removes/ deletes all transaction log saved in S_DOCK_TXN_LOG
2.Truncate table S_DOCK_TXN_LOG .It will delete all transaction log that has not been deleted automatically because of improper exit of siebel tool.
S_DOCK_TXN_LOG : Keep tracks of all DB changes(field level) through application.
3.Make AutoStopDB = TRUE in tool.cfg and client.cfg
4.Don't remove server name from odbc,that is readyment server.
5.Remove additional parameter of local ConnectString
ConnectString = C:\PROGRA~1\Siebel\8.0\Tools\LOCAL\sse_data.dbf -q -m -x NONE
6.In ODBC, Supply user id and password of SIEBEL.
Friday, December 11, 2009
Siebel Tool / thick Clien Installation Problem
Some time when we install Siebel Tool/Application, Siebel installation hangs when it reaches to language pack installation.
This happens because of default web Browser.
Simple set default web browser as IE. Restart System.
Control Panel -> Add remove Program -> Set Program Access and Defaults
OS : Window
It will work.
Danish
This happens because of default web Browser.
Simple set default web browser as IE. Restart System.
Control Panel -> Add remove Program -> Set Program Access and Defaults
OS : Window
It will work.
Danish
Friday, November 27, 2009
Unlock Project from Back End
When we unlock project locally, following column need to populate null:
These colmuns are part of S_PROJECT TABLE.
LOCKED_BY
LOCKED_DATE
LOCKED_FLG
LOCKED_LANG
These colmuns are part of S_PROJECT TABLE.
LOCKED_BY
LOCKED_DATE
LOCKED_FLG
LOCKED_LANG
Tuesday, November 17, 2009
diccache.dat rulcache.dat
diccache.dat : this is used for sync. local db with server
rulcache.dat : rulcache.dat for all assignment rules
Stay in Bin folder.
rulcache.dat : rulcache.dat for all assignment rules
Stay in Bin folder.
Saturday, November 14, 2009
Error :The user Id or password that you entered incorrect
Hi ,
Recently , I got a error message when I opend my dedicated client.
Error : 'The user Id or password that you entered incorrect.Spelling...'
Solution : LocalDbODBCDataSource parameter in cfg file needs to be updated and also provide your user Id and password on System DSN level.
Recently , I got a error message when I opend my dedicated client.
Error : 'The user Id or password that you entered incorrect.Spelling...'
Solution : LocalDbODBCDataSource parameter in cfg file needs to be updated and also provide your user Id and password on System DSN level.
Thursday, August 28, 2008
Siebel - Importing Views & Lov
Hi Friend , I was installing a siebel finance setup here in offsite , imported Dat & DDl sync done properly. But how can I register all view in Administration-Application-Views.So that all the views get visible on fron end.So i exported all the view in excel form fron end from dedicated client & by using EIM I imported all the views on siebel server.but one thing noticable we can not change , even add any view in Siebel administrator responsibilty , so we need to create new responsibility & associate all view to that and then assigned to user.Now it is working fine.Same we do for LOV , but only LOV can not be exported so before exporting Lov , we need to export LOV Type ,taken in exel from LOV Explorer at fron end. One thing also whenever change siebel repository name , need to restart tool .
Subscribe to:
Posts (Atom)