Wednesday, March 15, 2017

failed to load the jni shared library

After installation of java 1.6 from post, i tried to start SpagoBIStudio_5.1.0 using below command

SpagoBI.exe -vm "C:\Program Files (x86)\Java\jdk1.6.0_30\bin"

it failed with error "failed to load the jni shared library"

Problem :
incorrect version of java used

Solution :
I am trying to start 64 bit version of spagoBI server with 32-bit version of java.
install 64-bit versionof java and then try below command

SpagoBI.exe -vm "C:\Program Files\Java\jdk1.6.0_30\bin"

java was started but returned exit code 13

try to start SpagoBIStudio_5.1.0 studio

java was started but returned exit code 13

Problem:
I have installed java (1,7/1.8) on system, because of spagoBI compatibility issue, was using incorrect version of java.

Solution:
Install correct version of Java (in my case it is 1.6)

Thursday, February 23, 2017

Add Random Data in Spreadsheet

To add random data in spreadsheet you can use macro code, advantage to use this no more manual work. Use below code to generate data.

Public Sub ran()
Dim b As Range
    For i = 1 To 800000
        Dim r As Double
        r = Int(Timer * Rnd())
        Cells(i, 20).Value = 0
        Cells(i, 21).Value = "USD"
        Cells(i, 22).Value = ""
        Cells(i, 23).Value = "A clever fox just jump over the lazy dog"
        Cells(i, 24).Value = r
    Next i
End Sub

Dynamic data generated in "r" variable and rest of data is static.

Friday, February 10, 2017

Talend Startup Error

I have installed java 1.7 and 1.8 both on my machine and JAVA_HOME environment variable set to 1.7.
Here i am trying to start talend but it throws error:


"The Studio does not support Java 8. Java 7 is the recommended JVM version to be used"

Now how to start Talend on machine if both java version is installed on your machine

Solution

  • Open Cmd
  • Move to installed directory of Talend and run below command
  • TOS_DI-win32-x86.exe -vm "C:\Program Files (x86)\Java\jdk1.7.0_65\bin"

Friday, January 27, 2017

Xampp Starting Error

Try to start xampp on some day and getting below error


"Port 80 in use by "unable to open process" with PID 4:

How to proceed:
  • Open Task manager
  • Look for the PID with number 4, probable it will be "NT Kernel and system"
  • Open CMD and check the processes that are running with port number 80
netstat -o -n -a | findstr 0.0:80

  • After searching on google, came to know that the PID process is related to SQL server Reporting server. 
  • Go to services
  • Stop all services related to SQLServer
  • Stop and start services for apache and mysql
  • It Works!!!!


Other Possible Processes :

Skype
IIS
VMWork Station

web stats