Requisite BugsEye - error on search

[Former Member]

Hi All,

We have just completed an exercise of moving SAP & Bugseye from one host to another. After a few hurdles we eventually got the application running and have been able to login successfully. However upon doing any search we see the following error returned:

Error: Error writing to servlet

null

Upon investigating requisite.log I can see numerous java errors. This one happens at regular intervals:

08 Aug 2008 07:40:49,974 ERROR - Prototypejava.sql.SQLException: Io exception: The Network Adapter could not establish the connection

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:334)

at oracle.jdbc.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3649)

at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)

at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:368)

at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:549)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:349)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:141)

at org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41)

at org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150)

at org.logicalcobwebs.proxool.Prototyper.sweep(Prototyper.java:95)

at org.logicalcobwebs.proxool.PrototyperThread.run(PrototyperThread.java:42)

And this one happens at the time of search:

08 Aug 2008 07:38:23,481 guest,7 QUERY - PERFORMING COMMIT

08 Aug 2008 07:38:23,488 guest,7 FATAL - java.lang.NullPointerException

at com.requisite.bugsi.servlet.OutputFormat.getCurrencyFormat(OutputFormat.java:165)

at com.requisite.bugsi.servlet.OutputFormat.<init>(OutputFormat.java:70)

at com.requisite.bugsi.servlet.StateServlet.getFormatObject(StateServlet.java:1940)

at com.requisite.bugsi.servlet.StateServlet.getCurrencyFormatedString(StateServlet.java:1760)

at com.requisite.bugsi.servlet.ItemDisplay.getPricingDisplayString(ItemDisplay.java:886)

at com.requisite.bugsi.servlet.ItemDisplay.displayBody(ItemDisplay.java:592)

at com.requisite.bugsi.servlet.ItemDisplay.display(ItemDisplay.java:321)

at com.requisite.bugsi.servlet.ItemDisplay.display(ItemDisplay.java:306)

at com.requisite.bugsi.servlet.PageView.display(PageView.java:95)

at com.requisite.bugsi.servlet.ItemView.displayPage(ItemView.java:289)

at com.requisite.bugsi.servlet.ItemView.display(ItemView.java:377)

at com.requisite.bugsi.servlet.ItemView.doGet(ItemView.java:263)

at com.requisite.bugsi.engine.CommandObjectManager.executeCommandObject(CommandObjectManager.java:261)

at com.requisite.bugsi.servlet.BugsI.doCommand(BugsI.java:1230)

at com.requisite.bugsi.servlet.BugsI.doGet(BugsI.java:719)

at com.requisite.bugsi.servlet.BugsI.doPost(BugsI.java:162)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.inqmy.services.servlets_jsp.server.RunServlet.runSerlvet(RunServlet.java:149)

at com.inqmy.services.servlets_jsp.server.ServletsAndJspImpl.startServlet(ServletsAndJspImpl.java:833)

at com.inqmy.services.httpserver.server.RequestAnalizer.checkFilename(RequestAnalizer.java:672)

at com.inqmy.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:314)

at com.inqmy.services.httpserver.server.Response.handle(Response.java:173)

at com.inqmy.services.httpserver.server.HttpServerFrame.request(HttpServerFrame.java:1288)

at com.inqmy.core.service.context.container.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:36)

at com.inqmy.core.cluster.impl5.ParserRunner.run(ParserRunner.java:55)

at com.inqmy.core.thread.impl0.ActionObject.run(ActionObject.java:46)

at java.security.AccessController.doPrivileged(Native Method)

at com.inqmy.core.thread.impl0.SingleThread.run(SingleThread.java:148)

We are running BugsEye 4.0.8.12 with SAP J2EE 6.20 engine. Any help would be appreciated.

- Natalie

[jason_boggans]

Hi Natalie,

You can run the attached intermedia index lexer to see if this resolves the issue.

Regards,

Jason

[Former Member]

Hi Jason,

Thanks for the SQL (which I already had from when we did the installation a few years ago).

I ran it and it was successful - but I still get the same error when performing a search:

'Error: Error writing to servlet

null'

- Natalie

[Former Member]

Hello Experts,

I am also facing the error

'Error: Error writing to servlet

null'

after moving the server to a different DC usin gP2V technology.

could you please helpo us in resolving the same?

Regards,

Saikrishna

[masa_139]

Hi,

What is Oracle version? Is Oracle context running for search?

Regards,

Masa

[Former Member]

Hi Masa,

It's Oracle 9.2.0.7.

With the Oracle text, we THINK it is running (we didn't actually do the DB part, others did). Is there any definitive test to know for certain?

- Natalie