Skip to content

Posts from the ‘Uncategorized’ Category

EBS list of username with responsibility

select d.full_name,a.USER_NAME USER_ID, a.EMPLOYEE_ID, c.RESPONSIBILITY_NAME
from apps.FND_USER a, apps.FND_USER_RESP_GROUPS b, apps.FND_RESPONSIBILITY_VL c, apps. per_all_people_f d
where a.USER_ID=b.USER_ID and b.RESPONSIBILITY_ID=c.RESPONSIBILITY_ID and a.employee_id=d.person_id and sysdate between d.effective_start_date and d.effective_end_Date group by a.USER_NAME,a.EMPLOYEE_ID,c.RESPONSIBILITY_NAME,d.full_name order by a.USER_NAME

delete responsibility for user EBS

If you want to delete responsibility for user, you can’t delete the responsibility filed in user define forms.

See this forum thread for more detail

You can able to disable the responsibility using end date field.

System Administrator –> Security –> User –> Define — > query the user (F11, Ctrl+F11)

ebs

OBIEE 11.1.1.7.0

OBIEE 11.1.1.7.0 was released earlier this week . So this is the time to upgrade your OBIEE to higher version.

Refer this site for upgrade

Cannot open connection to FALSE The Synch Manager component on the server is most likely unavailable.

When I’m trying to configure local database extract for developers, After login of user, it shows below error

Unable to connect server

Cannot open connection to FALSE The Synch Manager component on the server is most likely unavailable.

I checked that appropriate component running or not, but its running

srvrmgr:siebsrvr01> list comp SynchMgr

SV_NAME CC_ALIAS CC_NAME CT_ALIAS CG_ALIAS CC_RUNMODE CP_DISP_RUN_STATE CP_STARTMODE CP_NUM_RUN_TASKS CP_MAX_TASKS CP_ACTV_MTS_PROCS CP_MAX_MTS_PROCS CP_START_TIME CP_END_TIME CC_INCARN_NO CC_DESC_TEXT
———- ——– ———————– ——– ——– ———– —————– ———— —————- ———— —————– —————- ——————- ———– ———— ————
siebsrvr01 SynchMgr Synchronization Manager SynchMgr Remote Interactive Online Auto 0 100 1 1 2013-03-27 15:07:24

1 row returned.

The problem is we need to edit the siebel tools tools.cfg file and changed the  DockConnString parameter of local datasource

DockConnString = servername of siebel server running

oracle.as.provisioning.weblogic.ASDomain._addTemplate(ASDomain.java:4224)

While I’m trying to configure Oracle OBIEE 11.1.1.6.0, I got a deployment base setup failed. So often I check with installation log files it shows below error

oracle.as.provisioning.exception.ASProvWorkflowException: Problem invoking WLST – Traceback (innermost last):
File “/tmp/tmp1364695495957.py”, line 15, in ?
File “/tmp/WLSTOfflineIni6851419804217349118.py”, line 89, in addTemplate
Oracle BI SYSMANOracle BI JDBC
at com.oracle.cie.domain.script.jython.CommandExceptionHandler.handleException(CommandExceptionHandler.java:51)
at com.oracle.cie.domain.script.jython.WLScriptContext.handleException(WLScriptContext.java:1538)
at com.oracle.cie.domain.script.jython.WLScriptContext.addTemplate(WLScriptContext.java:420)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)

com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.jython.WLSTException: com.oracle.cie.domain.script.ScriptException: com.oracle.cie.domain.template.dependency.SelectionConflictException: The following prerequisites were found to be missing:
Oracle BI SYSMANOracle BI JDBC
at oracle.as.provisioning.weblogic.ASDomain._addTemplate(ASDomain.java:4224)
at oracle.as.provisioning.weblogic.ASDomain.addTemplate(ASDomain.java:4020)
at oracle.as.provisioning.engine.WorkFlowExecutor._addTemplates(WorkFlowExecutor.java:1396)
at oracle.as.provisioning.engine.WorkFlowExecutor.executeWLSWorkFlow(WorkFlowExecutor.java:473)
at oracle.as.provisioning.engine.Config.executeConfigWorkflow_WLS(Config.java:866)
at oracle.as.install.bi.biconfig.standard.StandardWorkFlowExecutor.executeHelper(StandardWorkFlowExecutor.java:31)
at oracle.as.install.bi.biconfig.standard.ConfigTemplateTask.doExecute(ConfigTemplateTask.java:34)
at oracle.as.install.bi.biconfig.standard.AbstractProvisioningTask.execute(AbstractProvisioningTask.java:70)
at oracle.as.install.bi.biconfig.standard.StandardProvisionTaskList.execute(StandardProvisionTaskList.java:61)
at oracle.as.install.bi.biconfig.BIConfigMain.doExecute(BIConfigMain.java:113)
at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:371)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)
at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:105)
at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)
at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:64)
at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:160)
at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:81)
at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:86)
at java.lang.Thread.run(Thread.java:662)

 

I got more confused about this error, Why I got this error even all prerequisites setup completed successfully. Finally I realized this issue may be happen due to incomplete Software downloaded zip file. Because Sometimes thesoftware files are downloaded done with partially.So I try to find out chksum file value of  OBIEE downloaded five files using cksum and compare this output value with related Oracle software downloaded site, Yes Now I got  One software file was not completely downloaded. So Again I downloaded that appropriate file and then I can able to configure without failure message.

 

Oracle OBIEE 11.1.1.6.0 step by step installation guide on linux

Please find the attached document about Oracle OBIEE 11.1.1.6.0 step by step installation guide on linux

 

Oracle OBIEE 11 installation guide

 

Unable to find node in database while doing database extract in siebel

I am facing this below issues while I’m trying to configure database extract for multiple users.

GenericLog      GenericError    1       0000051651517293:0      2013-03-30 11:19:58     Unable to find node in database^M

GenericLog      GenericError    1       0000051651517293:0      2013-03-30 11:19:58     Message: GEN-13,

the problem comes because I’m not register mobile client for this siebel application. first register mobile client using following method.

Step 1:

Create users in database and give to sse_role privilege to theses users

Step 2:

create new employee from Administration- User as same user id

Step 3:

Administration – Siebel Remote tab–> Mobile Client

bip_83

Here Mobile Client — User id

User Id — User Id

Last Name :  M

First Name : Balaji

No need other value for this row and save this mobile client

Step 4:

Administration — Server Management — jobs

create new tab– > Database Extract  and Requested Server is your siebel server name

bottom of the tab –> create new parameter –> Client Name — list of users

Client Database encryption method  – None

Encrypt client Db password — False

Now submit the job and then the new job will be created successfully

Generate New Database job remain in queue

When you’re trying to create generate new database component for siebel, this job remain in queue long time. Here Check the apporpriate siebel component are enabled or not.

Check remote server component enabled or not through server manager

srvrmgr:siebsrvr01> list compgrp

If it’s not enable, enable the remote component.

srvrmgr:siebsrvr01>enable compgrp remote

Restart the siebel server

srvrmgr:siebsrvr01> list compgrp Remote

CG_NAME CG_ALIAS CG_DESC_TEXT CG_DISP_ENABLE_ST CG_NUM_COMPONENTS SV_NAME CA_RUN_STATE
————- ——– ———————— —————– —————– ———- ————
Siebel Remote Remote Siebel Remote Components Enabled 8 siebsrvr01 Running

1 row returned.

srvrmgr:siebsrvr01> list comp DbXtract

SV_NAME CC_ALIAS CC_NAME CT_ALIAS CG_ALIAS CC_RUNMODE CP_DISP_RUN_STATE CP_STARTMODE CP_NUM_RUN_TASKS CP_MAX_TASKS CP_ACTV_MTS_PROCS CP_MAX_MTS_PROCS CP_START_TIME CP_END_TIME CC_INCARN_NO CC_DESC_TEXT
———- ——– —————- ——– ——– ———- —————– ———— —————- ———— —————– —————- ——————- ———– ———— ————
siebsrvr01 DbXtract Database Extract DbXtract Remote Batch Online Auto 0 10 2013-03-27 15:07:24

1 row returned.

srvrmgr:siebsrvr01>

enable event log level for siebel component

In some situations, If we are getting error from siebel application, We can’t able to find out what exactly happen from log file. So in this case we should increase the log level for certain components. then We run the report again, If  once error raised, you should read the log file from server, Here It notified what exact happen for this components.

We can able to increase the log level using two methods.

1.Server Manager

2.Siebel application

 

Server Manager

connect the server manager

srvrmgr -g siebeldev:2320 -e ACEDEVCRM81 -s siebsrvr01 -u sadmin -p password

 

srvrmgr:siebsrvr01> change evtloglvl % = 5 for server siebsrvr01 component XMLPReportserver
Command completed successfully.

For revert back

srvrmgr:siebsrvr01> change evtloglvl % = 1 for server siebsrvr01 component XMLPReportserver
Command completed successfully.

Siebel Application :

Site Map — Administration- Server Configuration — Servers

Components — XMLPReportserver

 

specified driver could not be loaded due to system error seor823.dll

I installed siebel tools on my windows 7 64bit machine and after i try to open siebel tools application but its showing error

“An internal error has occurred within the authentication subsystem for the Siebel application”

So I just checked in my odbc driver, it seem like okay. but the issues was  we need to add the odbc datasource name in odbc32bit.

So I execute 32bit odbc ” c:\Windows\SysWOW64\odbcad32.exe”

I added the datasource name and just test it test connection, it shows error

“specified driver could not be loaded due to system error seor823.dll”

I installed 64bit client on my machine before but I can’t able to connect 64bit using by odbc32bit.  Install Oracle client 32 bit on windows 7 and set the path.  remove the 64bit client path from environmental variables and restart the machine. now try to connect database using by odbc it’s successful.

Now I can able to open my siebel tools 8.1.1.54

Follow

Get every new post delivered to your Inbox.

Join 135 other followers