Monday, May 20, 2013

Can't install Jitterbit Server because of error in installing postgres

Usually this issue happen when you try installing Jitterbit Server Community version in Windows Server. You will get an error like 'No USER/postgres found'.

1. Go to Server Manager-User-Add User.
2. Create new user account for postgres. Be sure to remember the user ID and password.
3. Run the setup again.
4. When the wizard asked for postgres credentials, put the username and password that created earlier.
5. Continue with installation.

Sunday, May 19, 2013

Oracle JDBC not appear in Driver list in Jitterbit Connection Parameter.

1. Download Oracle Instant Client. Get ojdbc14.jar file.
2. Goto - C:\Program Files\Jitterbit Integration Server\tomcat\webapps\axis\WEB-INF\lib
3. Paste the ojdbc14.jar file here.
4. Goto - C:\Program Files\Jitterbit Integration Server
5. Open up JdbcDrivers.conf file.
6. Edit the file by putting the information as below.
<Driver>
<Name>Oracle</Name>
<Class>oracle.jdbc.OracleDriver</Class>
<Subprotocol>oracle:thin</Subprotocol>
</Driver>
7. Restart Jitterbit services in service.msc
8. Open up the driver list in Jitterbit again, click refresh.
9. You may see the driver is already listed.

Jitterbit Tomcat Server Won't Start

This issue usually happen when you installing the Jitterbit or Java program has been updated. You will realize this error when you fail to login to Jitterbit server although you have supplied correct password.

1. Goto Start-Run. Type services.msc and then hit Enter.
2. Find Jitterbit Tomcat Server. Click Start. If it won't start, try this.
  • Goto - C:\Program Files\Java\jdk1.7.0\bin
  • Copy msvcr100.dll file.
  • Goto - C:\Program Files\Jitterbit Integration Server\tomcat\bin
  • Paste it here.
3. Click Start Jitterbit Tomcat Server in services again.
4. If the service can be started, you should be able to login to the Jitterbit Integration Environment.