Guru Of Geeks

Many a times while working with Java applications, in my case scala (spark), which use your hostname (not localhost) but the actual name you gave to your system, like I use rohit.tuplejump.com , will fail to connect throwing an UnknownHostException. If you do a hostname -f, it will say "Name or service not known" Many people use the solution of adding the this entry to /etc/hosts but that needs to be changed every time your public IP changes. The better solution is to use the nss-myhostname package. The package is generally installed on any linux distribution, in case it isn't you can search and install it using your package manager. On Fedora you can do, $ sudo yum install nss-myhostname Then edit your /etc/nsswitch.conf to add myhostname in the line which begins with "hosts:". This will tell the system to use bind your system hostname to your public IP address. On my system this line looked like, hosts:      files mdns4...

After installing BPM 8.5 release 6, following error occurs when trying to upload a server file on Process Designer: The ProcessDesignerInstallationDirectory\workspace.metadata.log shows: ! ENTRY teamworks . appserver . websphere 4 0 2015 - 06 - 10 12 : 33 : 53.028 ! MESSAGE [ com . lombardisoftware . server . ejb . repositoryservices . ManagedAssetsClientAPI createManagedAssetAE ] CWLLG2212E : Received bad status 302 on server request to update managed asset cd <BPM Dir>/bin ./wsadmin.sh - connType NONE - lang jython  wsadmin>bpdServer=AdminConfig.list("BPMProcessCenter").split()  wsadmin>bpdServer  ['(cells/PCCell1/nodes/Node1/servers/server1|server-bpm.xml#BPMProcessCenter_1385413578191)']  wsadmin>print AdminConfig.showAttribute(bpdServer[0],'useHTTPSURLPrefixes')   false  wsadmin>  wsadmin>AdminConfig.modify(bpdServer[0], [['useHTTPSURLPrefixes', 'true']])  ''  wsadmin>print AdminConfig.showAttrib...

In horizontally clustered environment, cluster-enabled application is deployed on multiple physical machines. Each machine is available for requests. Horizontal clusters offers protection over hardware failure, increases efficiency, provides load balancing and process failover. However, since there are many number of physical machines involved the installation and maintenance cost increases proportionally. In Vertical clustering, multiple application server instances are hosted on the same physical machine. This type of clustering provides increased efficiency, load balancing and process failover. However, if hardware fails then there may not be ready alternative.

Introduction In this post I explain how to connect to MS SQL data sources from OBIEE 11g using the bundled DataDirect SQL Server Wired Protocol ODBC driver. Environment OBIEE Plus 11.1.1.6 running on Solaris 10, Sun Sparc 64 architecture and install under the /oracle/Obiee11 directory. OBIEE Database repository on MS SQL 2008 running on Windows 2008 (64b). MS SQL 2008 SR2 running on Windows Server 2008 SP2 , 64 architecture. DataDirect 5.3 MS SQL Wired Protocol ODBC driver that is bundled with Oracle Business Intelligence. Configuration Process Add the path to the ODBC driver's library directory to the LD_LIBRARY_PATH variable in the /oracle/Obiee11/instances/instance1/bifoundation/OracleBIApplication/coreapplication/setup/ user.sh file. ################################ # DataDirect Wired Protocol ODBC drivers ################################# LD_LIBRARY_PATH=/oracle/Obiee11/Oracle_BI1/bifoundation/odbc/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH ...

Problem(Abstract) A WSVR0605W message in the SystemOut.log might be misleading because this message normally indicates a "hung thread" situation. However, when a JCA adapter is set up for polling, the same message might occur in the log because, at the interval between polling, the adapter changes its state from polling to "sleep" and does not wake up until the next polling cycle starts. This adapter behavior is working as designed. Symptom The SystemOut.log file shows: ThreadMonitor W   WSVR0605W: Thread "Default : 0" (<ThreadID>) has been active for xxx milliseconds and may be hung.  There is/are 1 thread(s) in total in the server that may be hung. at java.lang.Thread.sleep(Native Method) at java.lang.Thread.sleep(Thread.java:939) at com.ibm.j2ca.base.internal.PollEventManagerWorker.run(PollEventManagerWorker.java:96) at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419) at com.ibm.ejs.j2c.wo...

Websphere DSN connection test : SQLSTATE=08004 ERRORCODE=-1060, SQLSTATE=08004 DSRA0010E: SQL State = 08004, Error Code = -1,060. User  does not have the CONNECT privilege Solution: Grand connect privilege and validate the connection. -- Thank You. Regards, Guru

​ set the "useHTTPSURLPrefixes" parameter to 'true' in your cluster-bpm.xml file. The entry would usually look like this:     <bpdServer xmi:type="BPMConfiguration:BPMProcessCenter" xmi:id="BPMProcessCenter_1404198504697" useHTTPSURLPrefixes="true" httpProtocolOnly="true">​ -- Thank You. Regards, Guru

RQP Report Query Processor DEF RQP-DEF-0000;Unable to set the Cognlstab variable. RQP-DEF-0001;Unable to locate the file indicated by cognistab. RQP-DEF-0002;Out of memory. RQP-DEF-0003;Unable to set locale information. RQP-DEF-0004;Unable to find current locale in language table. RQP-DEF-0011;Unable to load the character set for the current locale.  RQP-DEF-0014;Specify a table name to retrieve metadata column information.  RQP-DEF-0015;Specify a procedure name to retrieve stored procedure parameter metadata.  RQP-DEF-0018;The SQL variable is no longer valid. The request may have been destroyed or released. RQP-DEF-0020;The database connection information is either missing or invalid.  Please check the report and database access permissions. RQP-DEF-0024;Supply a valid prompter. RQP-DEF-0028;Unable to initialize the temp file subsystem. RQP-DEF-0029;Unknown initialization error. RQP-DEF-0034;More than one model was found. RQ...

Problem(Abstract) In IBM InfoSphere Information Server, enough memory must be allocated to run istool commands. Insufficient memory allocation in the computer that runs the istool command might cause the command to fail. Symptom In the following example, the istool query command fails and displays an OutOfMemoryError error in a JAVA heap message: istool workbench query -domain myserver -username myname -password mypasswrd -queryname "BI Report Models" Initializing query engine ..... JVMDUMP0061 Processing dump event "systhrow", detail "java/lang/OutOfMemoryError" - please wait. JVMDUMP0321 JVM requested Snap dump using '/data/IBM/InformationServer/Clients/istools/cli/Snap.2091125.10000 Cause By default, 64 MB of memory is allocated to run istool commands. This amount of memory is not sufficient to run metadata workbench commands. Resolving the problem On th...

So I'm doing a lot of posts in the DB2 Basics area this week. That's because they are quick for me to write, and they're questions I get all the time. So bear with me if you read for the more detailed Commerce topics – I'm not abandoning them. DB2 Client DB2 databases can be cataloged on DB2 servers or DB2 clients. Before trying cataloging, make sure you at least have the DB2 client installed. DB2 Clients are free (no licensing required). All App servers should have DB2 clients already installed on them. Web servers should not. You can download DB2 Clients here: https://www-304.ibm.com/support/docview.wss?uid=swg27007053 Select the same version and FixPack as the servers you're connecting to. Then select the proper OS. Finally, select "IBM Data Server Client" (9. versions) or "Administration Client" (8. versions). Installation and Instance creation are outside the scope of this post. Make sure you have all the inputs...

This procedure describes how to set up database connectivity for an Oracle content store. You must perform this procedure on each computer where you install Content Manager. Procedure On the computer where the Oracle client is installed, go to the ORACLE_HOME/jdbc/lib directory. Copy the correct library file for your version of the Oracle client to the c10_location \webapps\p2pd\WEB-INF\lib directory on the computer where Content Manager is installed and where notification is sent to an Oracle database. If you are using Oracle 10g, you must have ojdbc14.jar. If you are using Oracle 11g, you must have ojdbc5.jar. The files are available from an Oracle client or server install, and can also be downloaded from the Oracle technology Web site. ​

CMSYSPROPS This table has the Content Store Version. CMOBJNAMES This table has the names of all the objects in the content store. CMOBJPROPS1 Users, Roles \ Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table. CMOBJPROPS2 Report scheduling information is stored. This table has fields like hour, day week etc CMOBJPROPS3 Stores Screen Tip and Object description provided while creating the objects are stored here CMOBJPROPS4 Stores the printer paper setting details like height and width of A3 , A4 , letter and 11X17 paper orientations CMOBJPROPS6 Has the details of the all packages which were published using the FM. CMOBJPROPS7 This table stores the XML of all reports and models. This is basically to maintain the metadata about the structure of the reports and models. CMOBJPROPS10 Contact information is stored in this table. This table has columns like Contact Email and C...

Problem(Abstract) On starting Cognos Services, the services do not start and give errors in cogserver.log. On looking at Content store observed that only seeing 5 CM* tables present. There should be more than this. Symptom Any of these messages may be present in the log files CM 1127 1 Audit.cms.CM Warning CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-CFG-5023 Content Manager is unable to initialize the content store by using the initialization file "D:\Program Files\cognos\c8\configuration\schemas\content\oracle\dbInitScript_oracle.sql&quo t;. ORA-00955: name is already used by an existing object 5. 09:41:12, 'com.cognos.pogo.services.DefaultHandlerService', 'pogo', 'Failure'. DPR-DPR-1035 Dispatcher detected an error. 8. 09:41:12, CM-CFG-5131 A Content Manager configuration error occurred during the initialization of Content Manage...

If you try to run the dsjob command you will get something like this: $ dsjob dsjob: error while loading shared libraries: libvmdsapi.so: cannot open shared object file: No such file or directory Presuming that you have selected the default path names during the installation of your server, the following will setup the environment: $ export DSHOME=/opt/IBM/InformationServer/Server/DSEngine $ export PATH=$PATH:$DSHOME/bin:/opt/IBM/InformationServer/Server/PXEngine/bin $ export APT_CONFIG_FILE=/opt/IBM/InformationServer/Server/Configurations/default.apt $ . /$DSHOME/dsenv You could even include the above into the  ~/.bashrc file so they are executed automatically

Login in to WAS admin console I n the Administrative console, select Servers > Server Types > WebSphere application servers . Select your server and view the Communication > Ports section for a list of ports being used by your server. For the SCA samples, use the WC_defaulthost port number. In the example port configuration shown in the screen below, this is port 9080.