Skip to main content
Participant
April 6, 2010
Question

POST XML common-info request returns "internal error"

  • April 6, 2010
  • 1 reply
  • 1246 views

Hello I have a program that sents an HTTP-POST XML "common-info" request.  But the server returns an "internal error".

When I read the XML returned from the "common-info" call all I get is what I posted above.

<results><status code="internal-error"><exception>java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot insert the value NULL into column 'SESSION_COOKIE', table 'breeze5.dbo.PPS_USER_SESSIONS'; column does not allow nulls. INSERT fails. 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.TDSRPCRequest.processReplyToken(Unknown Source) at


There is no session cookie returned from the server for me to use.

I tested out the same call exccept this time I just typed in the URL into my browser ( http://<server>/api/xml?action=common-info ) and it returns the correct XML with the session cookie.

Any ideas why when I post XML the server is returning an "internal error" and complains about inserting a NULL value in the table?

Any ideas are greatly appreciate.

    This topic has been closed for replies.

    1 reply

    number333Author
    Participant
    April 8, 2010

    I ended up figuring out the issue.

    In my program when I made my initial POST call to common-info I was including the "session" query string but it was empty.

    When I excluded the "session" query string in my initial common-info call that is when the error message when away.

    Not sure why this was only happening on one server, but who knows.