Latest News
Active session in oracle
Below sql statement will show the active session for database select user_name, status, osuser, machine, a.sql_text from v$session b, v$open_cursor a where a.sid = b.sid AND status=’ACTIVE’ output USER_NAME STATUS OSUSER MACHINE SQL_TEXT —————————— ——– —————————— —————————————————————- ———————————————————— KNS ACTIVE kmanchikalapudi WIN-SNRV23P3O51 select pos#,intcol#,col#,spare1,bo#,spare2 from icol$ where KNS ACTIVE kmanchikalapudi WIN-SNRV23P3O51 select i.obj#,i.ts#,i.file#,i.block#,i.intcols,i.type#,i.fla KNS ACTIVE …
Read MoreLogOut/LogOff on KFS with CAS
Open immutableBar.tag, which is located at kfs/work.web-root/WEB-INF/tags/portal/ Search for <c:otherwise> and comment the code between otherwise. add below code & save file <a href=”/cas/logout?” style=”color:#FFFFFF;text-decoration:none;font-weight:bold;”>logoff</a>
Read MoreHow to Deal With OutOfMemory in tomcat
These errors are rather commonly seen during development phases, and even on production servers. These errors are even more annoying than others, because they do not show any stack trace. The reason for this is that a stack trace would not be of help for these errors. The code that fails with an Out Of…
Read MoreDisable Impersonating User or Backdoor
Open immutableBar.tag, which is located at work/web-root/WEB-INF/tags/portal/ or work/web-root/WEB-INF/tags/rice-portal/ Search for <c:otherwise> and comment the code between otherwise.
Read MoreWebservice security
To disable webservice security in KFS project, Search for kim.soapExposedService.jaxws.security in build.properties Replace value to flase Execute ant target dist-local & followed by make-source. Here is sample… WSDL url: http://localhost:8080/kfs-dev/remoting/kimIdentityServiceSOAP?wsdl Request <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:kim=”http://rice.kuali.org/wsdl/kim”> <soapenv:Header/> <soapenv:Body> <kim:getPrincipal> <principalId>admin</principalId> </kim:getPrincipal> </soapenv:Body> </soapenv:Envelope> Response <soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/”> <soap:Body> <ns2:getPrincipalResponse xmlns:ns2=”http://rice.kuali.org/wsdl/kim”> <return> <active>true</active> <entityId>1100</entityId> <principalId>admin</principalId> <principalName>admin</principalName> </return> </ns2:getPrincipalResponse> </soap:Body>…
Read MoreChart of Accounts (COA)
COA is a list of the accounts used by an organisation. The list can be numerical, alphabetic, or alpha-numeric. Each nominal ledger account is unique to allow its ledger to be located. The list is typically arranged in the order of the customary appearance of accounts in the financial statements, profit and loss accounts followed…
Read MoreNew User for KFS 3.0 / Rice 1.x
Here is the list of table to create user in database & insert record on below tables. KRIM_ENTITY_T KRIM_PRNCPL_T KRIM_ENTITY_NM_T KRIM_ENTITY_ENT_TYPE_T KRIM_ENTITY_EMAIL_T
Read MoreStart tomcat 6 with debug
Pls follow the below steps to enable tomcat 6.x in debug Open catalina.bat, can be located at <TOMCAT_HOME>/bin Add below lines set JPDA_TRANSPORT=dt_socket set JPDA_ADDRESS=6666 Save file & close it Start tomcat <TOMCAT_HOME>/bin/catalina.bat jpda start Start eclipse & configure Remote Java Application for port 6666
Read MoreDROP all tables, views, stored procedures, & Sequences from Schema
Below script will help to delete all tables, constrains from user Begin for c in (select table_name from user_tables) loop execute immediate (‘drop table ‘||c.table_name||’ cascade constraints’); end loop; for c in (select view_name from user_views) loop execute immediate (‘drop view ‘||c.view_name); end loop; for c in (select sequence_name from user_sequences) loop execute immediate (‘drop…
Read MoreAuthentication vs. Authorization
It is easy to confuse the mechanism of authentication with that of authorization. In many host-based systems (and even some client/server systems), the two mechanisms are performed by the same physical hardware and, in some cases, the same software. It is important to draw the distinction between these two mechanisms, however, since they can be…
Read More