#1 2009-04-14 12:11:41

**_jcooper9099_**

API calls failing, Anybody else?

I have had simple API calls begin failing with long error messages like the one below. This has happened repeatedly in the last two months. Anybody else

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "ConnectProNA3" requested by the login. The login failed. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at macromedia.jdbc.base.BaseConnection.connect(Unknown Source) at macromedia.jdbc.base.BaseConnection.setupImplConnection(Unknown Source) at macromedia.jdbc.base.BaseConnection.open(Unknown Source) at macromedia.jdbc.base.BaseDriver.connect(Unknown Source) at macromedia.jdbc.MacromediaDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.macromedia.airspeed.db.DBConnection.init(DBConnection.java:137) at com.macromedia.airspeed.Context.getConnection(Context.java:781) at com.macromedia.airspeed.Context.prepareStatement(Context.java:681) at com.macromedia.airspeed.dal.DAL.checkPermissions(DAL.java:134) at com.macromedia.airspeed.Context.checkPermissions(Context.java:841) at com.macromedia.breeze.sco.Reports$ReportBulkObjects.execute(Reports.java:3282) at com.macromedia.airspeed.ActionHandler.executeOrQueue(ActionHandler.java:138) at com.macromedia.airspeed.ActionDispatcher.dispatch(ActionDispatcher.java:268) at com.macromedia.airspeed.ActionDispatcher.dispatch(ActionDispatcher.java:307) at com.macromedia.airspeed.servlet.XMLHandler.execActionList(XMLHandler.java:382) at com.macromedia.airspeed.servlet.XMLHandler.execute(XMLHandler.java:95) at com.macromedia.airspeed.servlet.XMLHandler.service(XMLHandler.java:142) at com.macromedia.airspeed.servlet.BaseServlet.service(BaseServlet.java:299) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)</exception>
  <exception>com.macromedia.airspeed.StatusException$InternalError: <status code="internal-error"/> at com.macromedia.airspeed.ActionDispatcher.dispatch(ActionDispatcher.java:289) at com.macromedia.airspeed.ActionDispatcher.dispatch(ActionDispatcher.java:307) at com.macromedia.airspeed.servlet.XMLHandler.execActionList(XMLHandler.java:382) at com.macromedia.airspeed.servlet.XMLHandler.execute(XMLHandler.java:95) at com.macromedia.airspeed.servlet.XMLHandler.service(XMLHandler.java:142) at com.macromedia.airspeed.servlet.BaseServlet.service(BaseServlet.java:299) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "ConnectProNA3" requested by the login. The login failed. at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source) at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source) at macromedia.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unknown Source) at macromedia.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) at macromedia.jdbc.base.BaseConnection.connect(Unknown Source) at macromedia.jdbc.base.BaseConnection.setupImplConnection(Unknown Source) at macromedia.jdbc.base.BaseConnection.open(Unknown Source) at macromedia.jdbc.base.BaseDriver.connect(Unknown Source) at macromedia.jdbc.MacromediaDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at com.macromedia.airspeed.db.DBConnection.init(DBConnection.java:137) at com.macromedia.airspeed.Context.getConnection(Context.java:781) at com.macromedia.airspeed.Context.prepareStatement(Context.java:681) at com.macromedia.airspeed.dal.DAL.checkPermissions(DAL.java:134) at com.macromedia.airspeed.Context.checkPermissions(Context.java:841) at com.macromedia.breeze.sco.Reports$ReportBulkObjects.execute(Reports.java:3282) at com.macromedia.airspeed.ActionHandler.executeOrQueue(ActionHandler.java:138) at com.macromedia.airspeed.ActionDispatcher.dispatch(ActionDispatcher.java:268) ... 13 more

**_michael_**

Re: API calls failing, Anybody else?

You should definitely open a ticket with Adobe on this.  That's a pretty serious error.  Recommend providing them with your account info, the API you called, and approx time you called the API and received this error.  Good luck!