Aswad's Blog

2016-05-25T21:32:00.001+05:30

#pragmasys #msdynamicscrm #freshers #walkin

Pragmasys MSCRM Team: MSCRM 2011 Ribbon and SiteMap Editor

2011-07-07T19:25:00.000+05:30

Pragmasys MSCRM Team: MSCRM 2011 Ribbon and SiteMap Editor: "Pragmasys team is pleased to release the initial version of the PragmaTools for MSCRM 2011 aimed at imporving developer efficiency and accur..."

OPENINGS FOR SIEBEL DEVELOPERS

2011-06-19T14:15:00.002+05:30

Company: Pragmasys Consulting LLP (http://www.pragmasys.in) is a startup consulting organization focusing on providing business solutions to its Customers in the Enterprise Solutions space. With strong partnership with Oracle and Microsoft, Pragmasys provides services such as – Implementation Advisory, Solution Architecture consulting, Enterprise Design consultancy, end to end product implementation, performance tuning. To fuel our growth, we are looking for strong expertise in the Enterprise solutions space currently in the areas of Siebel CRM, MS CRM and OBI.

Why should you join? If you want to gain hardcore consulting experience on your profile and gain new skills and abilities, this is a right opportunity for you.

Location: Pune

1. Designation: Siebel Developer
Experience: Fresher (who has completed siebel training) / 1-2 yrs of experience in siebel configuration

Desired Profile:
Key Requirements:
* Good knowledge and experience in-
o Siebel Configuration/ eScripting
o Siebel Workflows

* Preferable skills-
o Siebel 7.x +

For more information please visit www(dot)pragmasys(dot)in

Workflow Queries

2011-06-14T16:48:00.000+05:30

1.Query to know the Policy by which required workflow is fired.

select c.name as policy_name, d.DEFAULT_VALUE as workflow_name
from S_ACTION_DEFN a, S_ESCL_ACTION b, S_ESCL_RULE c,S_ACTION_ARG d
where a.row_ID = d.action_id
and b.action_id = a.row_ID
and c.row_id = b.RULE_ID
and d.DEFAULT_VALUE = 'Account Notify Children'

2.To know all Steps of a workflow

SELECT P.NAME PROCESS, S.NAME STEP --A.NAME ARG,A.VAL_TYPE_CD VAL_TYPE, A.VAL VAL
FROM S_WF_STEP P, S_WF_STEP S
WHERE P.TYPE_CD = 'PROCESS'
AND P.STATUS_CD = 'ACTIVE'
AND P.ROW_ID = S.PROCESS_ID
AND P.NAME = 'Status Change' --- WF Name

3.To Know All Workflows and Step in which particular Business Service is called

select B.NAME PROCESS_NAME , A.NAME PROCESS_STEP, A.SERVICE_NAME BUSINESS_SERVICE , A.METHOD_NAME METHOD
from S_WF_STEP A , S_WF_STEP B
where A.PROCESS_ID = B.ROW_ID
and A.SERVICE_NAME = 'Change Subscriber Status' -- Business Service Name
and B.STATUS_CD = 'ACTIVE'
order by 1,2,3

4.To Know the workflow Process and step which uses particular method of business Service

select b.name as process_name , a.name as process_step, a.service_name , a.method_name
from S_WF_STEP a , s_wf_step b
where a.process_id = b.row_id and
a.method_name = 'Change Subscriber Status' -- Name of the Bus Service Method
and b.status_cd = 'ACTIVE'
order by 1,2,3

5.To know all workflows and steps which uses particular workflow process as a subprocess

select P.NAME MAIN_PROCESS, S.NAME PROCESS_STEP , s.method_name SUB_PROCESS
from S_WF_STEP p, S_WF_STEP S
where P.TYPE_CD = 'PROCESS'
AND P.STATUS_CD = 'ACTIVE'
and s.process_id = p.row_id
and s.type_cd = 'SUB_PROCESS'
and s.method_name = 'Check Latest Order' -- Name of Subsprocess

6.Query to know All the input arguments passed to the method of particular Business Service through particular workflow

SELECT P.NAME PROCESS, S.NAME STEP, s.service_name BS_NAME , s.method_name , A.NAME ARGUMENT ,A.VAL_TYPE_CD VALUE_TYPE, A.VAL VALUE
FROM S_WF_STEP P, S_WF_STEP S, S_WF_STEP_ARG A
WHERE P.NAME = 'Account Online Status Update' -- Name of Workflow
AND P.TYPE_CD = 'PROCESS'
AND P.STATUS_CD = 'ACTIVE'
AND P.ROW_ID = S.PROCESS_ID
AND S.ROW_ID = A.STEP_ID
AND A.INPUT_FLG = 'I'
AND s.service_name is not null
AND s.method_name is not null
ORDER BY 1,2,3,4,5

SIEBEL and BI Publisher Integration

2011-05-12T20:30:00.000+05:30

Pre-requisites:-
Siebel Version 8.1.1.x
BIP Version >= 10.1.3.4.1

1. Enable following Siebel Server components:-
• Siebel Application Object Manager (AOM)(for example, Call Center Object Manager (ENU))
• Siebel Enterprise Integration (EAI)
• XMLP Report Server component

2. Copy JAR files to the Oracle BI Publisher Server and Siebel Server
BI Server Path: ORACLE_HOME/oc4j_bi/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib
Siebel Server Path: SIEBSRVR_ROOT\CLASSES
• XSLFunctions.JAR
• SiebelCustomXMLP.JAR
• SiebelCustomXMLP_SIA.JAR
• Siebel.JAR
• SiebelXMLP.JAR

3. Go to BIP Server->Admin tab, select Properties under Runtime Configuration.
• Disable External Reference attribute=False

4. Import an archive file to apply the new Siebel Reports features for 8.1.1.x
Lock the Below Projects
• XMLP Integration Project
• Table XML
• Symbolic Strings
• Reports UI
• User Preferences

5. E.g. Import the BIP_8113.sif
Make changes to tools.cfg(SymStrPrefix=SBL_) before importing sif.

6. Apply Schema of below tables to server database.
• S_REPOUTPT_PSTN
• S_REP_TMPL_PSTN
• S_XMLP_REPOUTPT
• S_XMLP_REP_TMPL
• S_XMLP_RPT_VIEW

7. Copy fonts:

• C:\WINDOWS\Fonts to JAVA_HOME\lib\fonts

8. Add an explicit reference to JAR files for the Oracle BI Publisher Server
• Administration - Server Configuration screen->Enterprises-> Profile
Configuration view.

• XMLPJvmSubsys=/classes/SiebelXMLP.jar;/classes/
xdoparser.jar;/classes/fix6312772.jar;/classes/
xdocore.jar;/classes/xmlparserv2-904.jar;/classes/
versioninfo.jar;/classes/share.jar;/classes/
jewt4.jar;/classes/jdbc12.jar;/classes/
i18nAPI_v3.jar;/classes/collections.jar;/classes/
bipres.jar;/classes/bicmn.jar;/classes/
siebel.jar;/classes/XSLFunctions.jar;/classes/
SiebelCustomXMLP.jar;/classes/SiebelCustomXMLP_SIA.jar

Through SRVRMGR : FROM CMD ->SIEBSRVR->BIN->SRVRMGR /g SERVERIP /e ENTERPRISE /u SADMIN /P SADMIN
change param CLASSPATH=SIEBSRVR_ROOT\classes\SiebelXMLP.jar;SIEBSRVR_ROOT\classes\
xdoparser.jar;SIEBSRVR_ROOT\classes\fix6312772.jar;SIEBSRVR_ROOT\classes\
xdocore.jar;SIEBSRVR_ROOT\classes\xmlparserv2-904.jar;SIEBSRVR_ROOT\classes\
versioninfo.jar;SIEBSRVR_ROOT\classes\share.jar;SIEBSRVR_ROOT\classes\jewt4.jar;
SIEBSRVR_ROOT\classes\jdbc12.jar;SIEBSRVR_ROOT\classes\i18nAPI_v3.jar;
SIEBSRVR_ROOT\classesvcollections.jar;SIEBSRVR_ROOT\classes\bipres.jar;
SIEBSRVR_ROOT\classes\bicmn.jar;SIEBSRVR_ROOT\classes\Siebel.jar;
SIEBSRVR_ROOT\classes\XSLFunctions.jar;SIEBSRVR_ROOT\classes\SiebelCustomXMLP.jar
for named subsystem XMLPJvmSubsys

9. Configuring the Outbound Web Service for the Oracle BI Publisher Server

• Using your browser, enter the following URL to retrieve the Web service definition.
http://:/xmlpserver/services/PublicReportService_v11?wsdl
• Save the definition as PublicReportService_v11.WSDL.
• Using Siebel Tools, delete the PublicReportService outbound Web service and related integration objects
• In Siebel Tools, choose File, New Objects, the EAI tab, Web Service, and then click OK.
• Check the Deploy Integration Object(s) and Proxy Business Service(s) checkbox, and then click Finish.
• Administration - Web Services screen, then the Outbound Web Services view
• Note : Typically, there is no need to change this address because it is automatically populated when you configure the business service and Web service in Siebel Tools using the Web service wizard.

10. Creating Views
• Navigate to the Administration - Application screen ->Views.
• In the Views list, create the following new views, and complete the necessary fields:
• Report Job List View
• All Report Output List View
• All Template View
• Manager's Report Output List View
• Manager's Template View
• My Template View
• Report Standard Template Registration Admin View

11. Create the following new responsibilities
• XMLP_ADMIN Administrator role for the Oracle BI Publisher Server with no
access limitations.
• XMLP_DEVELOPER Assign this responsibility to allow for uploading reports from the Oracle BI Publisher Server to the Siebel application.
• XMLP_SCHEDULER Assign this responsibility to allow for scheduling of reports.
• XMLP_SIEBEL_GUEST Assign this responsibility to limit access to reports. This responsibility only allows for generation, viewing, and deletion of user’s own reports.

12. Associate the new views with the appropriate responsibility as shown in
the following table.
View Responsibility
• Report Job List View ->XMLP_SCHEDULER
• All Report Output List View ->XMLP_ADMIN
• All Template View ->XMLP_ADMIN
• Manager's Report Output List View -> XMLP_ADMIN
• Manager's Template View -> XMLP_ADMIN
• My Template View -> XMLP_ADMIN
• Report Standard Template Registration Admin View -> XMLP_ADMIN

13. Process of Authenticating User Access to the Oracle BI Publisher Server
• Import and administer the Web service used by the Siebel Security Model by doing the following:
• Navigate to the Administration - Web Services screen, then the Inbound Web Services view.
• Import the BIPSiebelSecurityWS.XML file from the SIEBEL_TOOLS_ROOT\REPPATCH directory
(where Siebel Tools is installed).
• In the Address field of the Service Ports subview, replace the existing address with the URL used to access the EAI Object Manager.
• Address:http://SIEBELSERVERIP/eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute

14. Create Super User -> Go to BIP Server->Admin->Security Configuration

Security Model section choose Siebel Security Model from the Security Model drop down List

Parameter Value
Security Model:Siebel Security
Siebel Web Service Endpoint:http://SIEBELSERVERIP /eai_enu/start.swe?SWEExtSource=WebService&SWEExtCmd=Execute
Administrator Username: SADMIN
Administrator Password: administrator password

Log in to the Oracle BI Publisher Enterprise application using the Siebel administrator credentials entered.

15. Click the Admin tab, select Roles and Permissions (in the Security Center section), and then add SiebelCRMReports folder to the following roles:
• XMLP_ADMIN
• XMLP_SCHEDULER
• XMLP_DEVELOPER
• XMLP_SIEBEL_GUEST

16. Create New Template Using:
• Import the XML Data source from Data in Word.
• Create From or table and insert the field.
• Save as .rtf.
• Go Tool ->Translate Template-> Extract Text
• Save as xlf.
• Go to Export and convert it to XLFo Style Sheet and save as .xls.
• Export both .xlf, xls and rtf to respective folder of Server_root/xmlp/XMLP/xlif , Server_root/xmlp/XMLP/Template

17. To upload pre configured report layout templates to the Oracle BI Publisher Server
• Administration - BI Publisher Reports screen, then the Reports – Standard Templates view.
• From the application-level menu, select Edit, and then Select All.
• Click Upload Files.

Changing the Password for the Siebel Administrator Database Account

2011-04-27T16:27:00.001+05:30

Use the following procedure to modify the password for the Siebel administrator database account. You must also change the corresponding password parameter for the Siebel Enterprise and change the password in the Windows Registry.

To change the password for the Siebel administrator database account

Change the Siebel administrator's password for the Enterprise as follows:
Log into a Siebel employee application, such as Siebel Call Center.
Navigate to Administration - Server Configuration, and then Enterprises.
Click the Parameters tab.
In the Enterprise Parameters list, select the Password parameter.
In the Value field, enter the new password, then commit the record.
Log out of the Siebel application (all users must log out).
Change the Siebel administrator's password in the database.
For more information, refer to your RDBMS documentation on changing passwords.

Change the Siebel administrator's password in the Windows registry of each Siebel Server in your Siebel Enterprise as follows:
Make a copy of the Siebel Gateway Name Server parameters file, siebns.dat, located in the Admin folder of the Gateway Name Server root directory.
Edit the copy of siebns.dat using a text editor, and locate the new encrypted Siebel administrator password by navigating to the entry similar to the following:
[/enterprises/EnterpriseName/parameters/Password]
Persistence=full
Type=string
Value="9HtkUOUf"
Length=16

The Value parameter contains the new encrypted Siebel administrator password.

In the Windows Registry, navigate to the following entry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\siebsrvr_EnterpriseName_SiebelServerName

where EnterpriseName is the name of your Siebel Enterprise and SiebelServerName is the name of the Siebel Server.

Right-click ImagePath, and select Modify.
The ImagePath value is shown.

Change the old encrypted password listed (the value following the -ep flag) with the new Siebel administrator password you located in the siebns.dat file in Step b):
C:\sia81\siebsrvr\bin\siebsvc -s siebsrvr -i siebel_siebel -a "-g localhost:2320 -e siebel -s siebel -l ENU -u SADMIN -ep 9ntkUOUf" -t 120 -h C:\sia81\siebsrvr

CAUTION: Changing the Windows Registry can corrupt the Windows Registry file and require a reinstallation of the operating system. Take care when modifying the Windows Registry, therefore, and ensure you have a backup copy of the Windows Registry file.

Stop and restart the Siebel Server system service.

go to SWEApp/bin and open eapps.cfg
change anon user password if anon user is same as sadmin.
If password is encrypted go to cmd prompt
C:\sba81\gtwysrvr\BIN>encryptstring newpassword >string.txt
then copy encrypted password from string.txt to eapps.config anon password.
do iisreset

Siebel - Unlock Repository Objects Using Database Queries

2011-04-27T16:10:00.001+05:30

UNLOCK REPOSITORY OBJECTS

VIEW
UPDATE SIEBEL.S_VIEW BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE = NULL, BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL
WHERE BC.ROW_ID = ‘1-CDGI-1MIPC’;
COMMIT;

TABLE
UPDATE SIEBEL.S_TABLE TAB SET TAB.OBJ_LOCKED_FLG = 'N', TAB.OBJ_LOCKED_DATE = NULL, TAB.OBJ_LOCKED_BY = NULL, TAB.OBJ_LOCKED_LANG = NULL
WHERE TAB.NAME = ‘S_APPLICATION’
AND TAB.ROW_ID = '1-CDGI-E5E5';
COMMIT;

BUSCOMP
UPDATE SIEBEL.S_BUSCOMP BC SET BC.OBJ_LOCKED_FLG = 'N', BC.OBJ_LOCKED_DATE = NULL, BC.OBJ_LOCKED_BY = NULL, BC.OBJ_LOCKED_LANG = NULL
WHERE BC.ROW_ID = ‘1-CDGI-CD6C’;
COMMIT;

BUSSERVICE
UPDATE SIEBEL.S_SERVICE SERV SET SERV.OBJ_LOCKED_FLG = 'N', SERV.OBJ_LOCKED_DATE = NULL, SERV.OBJ_LOCKED_BY = NULL, SERV.OBJ_LOCKED_LANG = NULL
WHERE SERV.ROW_ID = '1-CDGI-1I9E2';
COMMIT;

APPLET
UPDATE SIEBEL.S_APPLET APPL SET APPL.OBJ_LOCKED_FLG = 'N', APPL.OBJ_LOCKED_DATE = NULL, APPL.OBJ_LOCKED_BY = NULL, APPL.OBJ_LOCKED_LANG = NULL
WHERE APPL.ROW_ID = '1-CDGI-D8I';
COMMIT;

PROJECT
UPDATE SIEBEL.S_PROJECT AS PROJ SET PROJ.LOCKED_FLG = 'N', PROJ.LOCKED_DATE = NULL
WHERE PROJ.NAME = 'Account Hierarchy';
COMMIT;

Note:-
How to find out the row id of any object?
Go to Siebel tools
Select object(Applet/BC/View) -> Help -> About Record -> Details
Row# will give the Row Id details.

WC2011 Final @ Wankhede Stadium

2011-04-03T23:27:00.001+05:30

Winning moments of Cricket World Cup 2011 captured by me @ Wankhede Stadium!

How to Import CSV data in Siebel - Scriptless Solution

2010-10-24T22:47:00.000+05:30

Import CSV data in Siebel with following options :-
Ability to add data from menu item
Popup applet should browse for csv file
Popup Applet will pass csv file path to business service which in turn will call the workflow
Create IO for corresponding to entity for which data is being imported
Workflow will call read csv BS and then insert data using EAI siebel adapter business service

1.Create popup applet of class CSSWEFRImpExp.
Create Applet method menu item on applet where import option should be available
Command : Import
Menu Text:Import
Create new command with following properties :-
Name:Import
Method:GotoApplet
Method Argument:Name of popup applet
2.Use following applet user properties of popup applet :-
Property Name :Import business service; Value:Copy of Workflow Process Manager Business Service(ref step 3)
Property Name :Import Method ; Value: RunProcess
3.Make Copy of Workflow Process Manager Business Service
Add Business service user prop
ProcessName : Name of workflow which will make use of read csv BS
4.Create Integration Object and Integration Component Corresponding to entity being imported
5.Give appropriate user key
6.Create Workflow
7.Add start step
8.Add new step for Business service Name:Read CSV File Method:CsvToPropSet
Input Property :FileName
Output Property :SiebelMessage
Note that filepath will be transferred from popup applet to business service to workflow user property with name "FileName"
9.Add new step for Business service Name:EAI Siebel Adapter Method:Insert
Input Property:SiebelMessage
10.Add new step for end
11.Make suitable provision for error handling.

Note : CSV file should be in the following format
Line 1 : # Integration Object Name
Line 2 : # "Integration Component Name.Column Name1",Integration Component Name.Column Name2 and so on
Line 3 : data 1
Line n : data n

Now you are ready to import records in siebel from csv file that too without writing single line of script!!

Pragmasys Consulting LLP Hiring 2009/2010 BE/BTECH Pass Outs from Pune University

2010-05-23T12:19:00.000+05:30

Company: Pragmasys Consulting LLP (http://www.pragmasys.in) is a startup consulting organization focusing on providing business solutions to its Customers in the Enterprise Solutions space. With strong partnership with Oracle and Microsoft, Pragmasys provides services such as – Implementation Advisory, Solution Architecture consulting, Enterprise Design consultancy, end to end product implementation, performance tuning. To fuel our growth, we are looking for strong expertise in the Enterprise solutions space currently in the areas of Siebel CRM, MS CRM and OBI.

Why should you join? If you want to gain hardcore consulting experience on your profile and gain new skills and abilities, this is a right opportunity for you.

Location: Pune

You should be willing to travel to client locations in India- metro cities, IT Centres according to need, monthly 15 days travel involved. Company takes care of accommodation and other expenses.

1. Designation: Siebel developers
Experience: Freshers

Desired Profile:

Strong programming background
Good background of database concepts – PL/SQL.
An exposure to UNIX/Shell scripting will be an advantage.
Good exploring capability and very fast learning curve

Eligibility Criteria :

B.Tech/B.E.(2009/2010 Pass Out)
An aggregate of 60 % in Std X, XII, & Graduation(all semesters including optional subjects).
Less than 2 years of gap in academic career.

"GOD" Sachin Tendulkar

2010-02-13T00:36:00.000+05:30

सचिनच्या ‘ रेकॉर्डब्रेक ’ आयुष्याचा

शोध घेणारी ही फोटोबायोग्राफी

घसरगुंडीवर खेळणा-या या सचिनच्या करिअरला कधी खाली घसरत येणे माहितच नव्हतं

शाळकरी सचिनचे आंतरशालेय सामने..

बाळाचे पाळण्यात दिसणारे पाय दिसतात, असे म्हणतात ते चूक नाही..

आपला सवंगडी अजित रानडेसह...

डॉन बॉस्कोसोबतची खेळी पाहून सचिन भारतासाठी खेळणार असे भाकीत गोंधळेकर पंचांनी वर्तवले होते

गुरुवर्य आचरेकर सरांच्या तालमीत...

स्पर्धात्मक सामन्यात झळकावलेल्या शतकाचा आनंद

गोर्धनादास शिल्ड विजेता संघ- वयाच्या बाराव्या वर्षी सचिन सिनिअर्सच्या बरोबरीने खेळला

सोळाव्या वर्षी पदार्पणाच्या सामन्यातच इराणी करंडक स्पर्धेत सचिनने शतक झळकावले

सचिनचे आंतरराष्ट्रीय पदार्पण- १९८९, कराची....

Siebel - Unique Constraint Violation Error On Check In ,Check Out,Get

2010-02-12T22:38:00.000+05:30

There are several reasons for Unique Constrain Violation error on check-in/check-out/get operations:
I]If you are using your own ODBC datasource to connect to the Oracle database,there are chances that hidden parameters are not set properly.
To solve this error please follow steps given below :-
1.Go to start->Run
2.Type regedit,press enter
3.Go to following path :-
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\]
where is your ODBC Connection name
4.Set following keys if there is mismatch :-
PacketSize = 0
EnableScrollableCursors = 0
ColumnsAsChar = 1
ColumnSizeAsCharacter = 1
II]If you re-initialize local database without re-extracting you will get same error.You have to extract local database before reinitializing it.
III] If you use one db extract for multiple developers unique constraint will be violated. The Siebel check in/out process relies on unique row ids. If you are reusing the local database for multiple developers the row ids can not be unique.