An error ocurred. Please contact your system administrator

Hi Carlos,

The NullPointerExceptions generally tell us that Formspider Middletier isn't able to get a connection from Oracle Database. There may be several reasons for that:

1. web.xml file - inside Tomcat/webapps/fs-1.x.x/WEB-INF/ directory - is missing or corrupted.
2. If you install FS with FSInstaller, context.xml file - inside Tomcat/webapps/fs-1.x.x/META-INF/ directory - is missing or corrupted.
3. If you install manually and put your database connections under global context file, context.xml file - inside Tomcat/conf/ directory - is missing or corrupted.
4. ojdbc driver JAR file is not suitable for your database and/or JAVA version.

To solve this connection problem:

#1. Stop Tomcat.

#2. Make sure that there are similar lines in your web.xml like those below.

  <context-param>
    <param-name>engineJdbcName</param-name>
    <param-value>jdbc/formspider_ds</param-value>
  </context-param>

Please keep in mind this param-value of your web.xml.

#3. If there is a context.xml file inside Tomcat/webapps/fs-1.3.0/META-INF/ directory, make sure that there are similar lines in this context.xml like those below.

 <Resource name="jdbc/formspider_ds" 
                  auth="Container"
                  type="oracle.jdbc.pool.OracleDataSource" 
                  driverClassName="oracle.jdbc.OracleDriver"
                  url="jdbc:oracle:thin:@DB_URL:DB_PORT:DB_SID"
                  user="FORMSPIDER_SHEMA" 
                  password="FORMSPIDER_SHEMA_PASSWORD" 
                  factory="oracle.jdbc.pool.OracleDataSourceFactory"
                  scope="Shareable"
                  connectionCacheName="formspider_ds_cache0"
                  connectionCachingEnabled="true"
                  connectionCacheProperties="{MinLimit=5, InitialLimit=5, ValidateConnection=true, MaxLimit=15, InactivityTimeout=900, AbandonedConnectionTimeout=900, PropertyCheckInterval=45, ConnectionWaitTimeout=60}" />

Please fill database url, port, sid and formspider schema name and password with yours; and make sure that name parameter is the same as the param-value that you have kept in mind from #2.

#4. If there is not a context.xml file inside Tomcat/webapps/fs-1.3.0/META-INF/ directory, make sure that there are similar lines in the context.xml inside Tomcat/conf/ directory like those below.

   <Resource name="jdbc/formspider_ds" 
                  auth="Container"
                  type="oracle.jdbc.pool.OracleDataSource" 
                  driverClassName="oracle.jdbc.OracleDriver"
                  url="jdbc:oracle:thin:@DB_URL:DB_PORT:DB_SID"
                  user="FORMSPIDER_SHEMA" 
                  password="FORMSPIDER_SHEMA_PASSWORD" 
                  factory="oracle.jdbc.pool.OracleDataSourceFactory"
                  scope="Shareable"
                  connectionCacheName="formspider_ds_cache0"
                  connectionCachingEnabled="true"
                  connectionCacheProperties="{MinLimit=5, InitialLimit=5, ValidateConnection=true, MaxLimit=15, InactivityTimeout=900, AbandonedConnectionTimeout=900, PropertyCheckInterval=45, ConnectionWaitTimeout=60}" />

Please fill database url, port, sid and formspider schema name and password with yours; and make sure that name parameter is the same as the param-value that you have kept in mind from #2.

#5. After you are sure about the above, and still getting NullPointerException. You should replace your ojdbc dirver JAR file with another.

   If there is a JAR file named ojdbc14.jar inside Tomcat/webapps/fs-1.3.0/WEB-INF/libs, replace it with ojdbc5.jar.
   If there is a JAR file named ojdbc5.jar inside Tomcat/webapps/fs-1.3.0/WEB-INF/libs, replace it with ojdbc14.jar.

I hope this helps,

Best Regards,
Serdar Gokcen,