User not found error
Hi,
I am running the scraper from unix command mode. It was working fine in the morning. Suddenly, I got the below error in the error file:
An error occurred while executing the SQL statement. The error was User not found: SA.
java.sql.SQLException: User not found: SA
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.screenscraper.util.DataMain.getConnection(DataMain.java:97)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:292)
at com.screenscraper.util.DataMain.executeSelect(DataMain.java:317)
at com.screenscraper.data.DScrapingSession.getAllScripts(DScrapingSession.java:76)
at com.screenscraper.business.BScrapingSession.getAllScripts(BScrapingSession.java:54)
at com.screenscraper.scraper.ScriptManager.loadScripts(ScriptManager.java:198)
at com.screenscraper.scraper.ScriptManager.getScripts(ScriptManager.java:108)
at com.screenscraper.model.ModelMainFrame.handleAppEvent(ModelMainFrame.java:587)
at com.screenscraper.controller.ControllerMainFrame.handleAppEvent(ControllerMainFrame.java:30
6)
at com.screenscraper.controller.ControllerMainFrame.init(ControllerMainFrame.java:70)
at com.screenscraper.controller.ControllerMain.init(ControllerMain.java:78)
at com.screenscraper.controller.ControllerMain.
at com.screenscraper.controller.ControllerMain.launchWorkbench(ControllerMain.java:582)
at com.screenscraper.controller.ControllerMain.main(ControllerMain.java:555)
Any help on the above error is appreciated
Thanks,
User not found error
Hi,
This likely either indicates that the database process somehow isn't running, or that the database has become corrupted. My recommendation would be to first try killing any Java processes on your machine. After that, ensure that whatever user account is running screen-scraper has read/write access to the entire screen-scraper directory. Once that's done, try launching screen-scraper again. Unfortunately, if that fails, you may just need to try re-installing screen-scraper.
Hopefully that helps. If not, please feel free to post a reply.
Kind regards,
Todd Wilson