[resolved] TIS: Configuring Execution Job Server as Service - debug error

[Anonymous]

We've got jsl.exe running fine on 3 of our other servers, but I'm running into an issue trying to load it to our QA server.
My TalendJobServer.properties and jsl.ini are identical to the files on the working servers
I run jsl.exe -debug in C:\Talend\JobServer\conf:

C:\Talend\JobServer\conf>jsl.exe -debug
Debugging Talend JobServer.
Now starting JVM

and it pops up an error (see pic 1)

jsl.exe - Unable To Locate Component
This application has failed to start because MSVCR71.dll was not found. Re-installing the application may fix this problem.

I hit Enter, and this message comes up (pic 2)

Error loading: C:\Program Files\Java\jdk1.6.0_05\jre\bin\client\jvm.dll

Then I hit Ctrl-C and get this (pic 3)

Stopping Talend JobServer.
Trying to stop service via JNI call to java/lang/System.exit
Done
Exiting
C:\Talend\JobServer\conf>

and this is what gets populated in the jsl.log

:1222883595tart loading params
:1222883595:Loaded module path
:1222883595:After JVM type check
:1222883595:After service options
:1222883595:After ini file options
:1222883595arams:
:1222883595:-cp
:1222883595:C:\Talend\JobServer;C:\Talend\JobServer\lib\jmxremote_optional.jar;C:\Talend\JobServer\lib\log4j-1.2.15.jar;C:\Talend\JobServer\lib\commons-io-1.3.2.jar;C:\Talend\JobServer\lib\jsl.jar
:1222883595:-Djava.library.path=C:\Talend\JobServer\jsysmon-20061229\native\windows\
:1222883595:-Dcom.sun.management.jmxremote
:1222883595:-Dtalend_props=C:\Talend\JobServer\conf\TalendJobServer.properties
:1222883595rg.talend.remote.jobserver.service.WindowsJobServer
:1222883595:-Dservice.stop.port=0 -Dservice.path=C:\Talend\JobServer\conf\ -Dservice.name=TalendJobServer -Dservice.inifile=C:\Talend\JobServer\conf\jsl.ini -cp C:\Talend\JobServer;C:\Talend\JobServer\lib\jmxremote_optional.jar;C:\Talend\JobServer\lib\log4j-1.2.15.jar;C:\Talend\JobServer\lib\commons-io-1.3.2.jar;C:\Talend\JobServer\lib\jsl.jar -Djava.library.path=C:\Talend\JobServer\jsysmon-20061229\native\windows\ -Dcom.sun.management.jmxremote -Dtalend_props=C:\Talend\JobServer\conf\TalendJobServer.properties org.talend.remote.jobserver.service.WindowsJobServer
:1222883595:service starting
:1222883595:starting java
:1222883595:java starting 1
:1222883595earching for JVM path in ini file
:1222883595:Found JVM path in ini file
:1222883596:stopping service
:1222883596:Call JVM
:1222883596:Call JVM

but when i run start_rs.bat in C:\Talend\JobServer, it runs fine:

INFO MultiServerSocket - MultiFileServerMain Started on 0.0.0.0/0.0.0.0:8001
INFO OSInformationAgent - Talend OS Information agent Version: 2.0.0
INFO OSInformationAgent - Create the MBean server with service URL: service:jmx
:jmxmp://localhost:8888
INFO MultiServerSocket - MultiJobServerMain Started on 0.0.0.0/0.0.0.0:8000
WARN OsInfoRetriever - Unsupported OS: OS Windows 2003 5.2 x86. Some informatio
ns will not be available.
WARN OsInfoRetriever - Unsupported OS: OS Windows 2003 5.2 x86. Some informatio
ns will not be available.
INFO OsInfoRetriever - JSysmon library load and monitoring started: false
INFO OSInformationAgent - Register the OsInfoRetrieverMBean
INFO OSInformationAgent - Create and start the JMX connector server
INFO OSInformationAgent - The JMX connector server successfully started.

[Anonymous]

The MSVCR71.dll is part of the .NET Framework and it a C Runtime Library.
All else being equal between your other installations maybe the server does not have the .NET Framework installed or it was corrupted.

[Anonymous]

Is there a way to determine for sure which MSVCR71.dll file this is referencing? There is one in the C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\ however this appears to be the same file across the board (on Dev & Prod, which are working and being used now, as well as on QA, which is where I?m trying to set up the Job Server).
Also, I can run start_rs.bat without issue, which then shows the QA server as active in the WebApp (see pics)

[Sebastiao_Qlik]

The issue concerns the jsl.exe. The error message says that jsl cannot find a dll library.
Maybe try to add the path to the MSVCR71.dll library to the PATH variable of Windows should fix the problem.
Note: This program is only for installing the jobserver as a Windows service.
On contrary, the start_rs.bat script only starts the jobserver and has nothing to do with Windows services.
This is why running this script does not fail.

[Anonymous]

Where do I find that file?
How do I make sure changes to the PATH variable are persistant?

[Sebastiao_Qlik · Accepted solution]

Hi strpdsnk,
I thought you had found it in C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\
Otherwise, try http://www.dll-files.com/dllindex/dll-files.shtml?msvcr71
How do you edit the PATH variable? -> http://www.computerhope.com/issues/ch000549.htm
Another possibility is to put your dll in C:\Winnt\System32 so that you don't need to modify your PATH variable.

[Anonymous]

Awesome, thank you! Copying the file to C:\WINDOWS\system32 seems to have done the trick.
I appreciate it!

[_AnonymousUser]

I have one Column timestamp. I am assuming yyyy-MM-dd HH:mm:ss format but it might be chance to get different format. Can I convert them in my format or I mark them as Null?
ex: if Input source is 02-12-2007 00:00:00 then if I convert this into 2007-12-02 00:00:00 or Null.

[_AnonymousUser]

sorry wrong post here.