Analytics Software

Hi Gurus,

I have been getting this problem after migration:

7000 : null : com.sunopsis.sql.l: Oracle Data Integrator Timeout: connection with URL jdbc:oracle:thin:@<IP ADDRESS>: and user <USER>
com.sunopsis.sql.l: Oracle Data Integrator Timeout: connection with URL jdbc:oracle:thin:@10.38.20.20:1527:BBP and user SAPSR3.
at com.sunopsis.sql.SnpsConnection.a(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.t(SnpsConnection.java)
at com.sunopsis.sql.SnpsConnection.connect(SnpsConnection.java)
at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)
at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
at com.sunopsis.dwg.cmd.e.i(e.java)
at com.sunopsis.dwg.cmd.h.y(h.java)
at com.sunopsis.dwg.cmd.e.run(e.java)
at java.lang.Thread.run(Thread.java:810)

I can run the interfaces using my local agent; But when I'll be executing this using a UNIX server, connection times out and render the process error. I encountered the same problem during development. Fixed it by adjusting the userpref.xml and odiparams. But for some reason, it's not working after migration to a different server. Any ideas why ?

Thanks!