Results 1 to 4 of 4

Thread: Sqlstate=57012

  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Unanswered: Sqlstate=57012

    I work whith PHP 4.3.1 and DB2-400

    When I execute this query

    SELECT * FROM BIBLIO.MOBRAS TBMOBRAS
    LEFT OUTER JOIN HUMIGES.MOBRASPLUS TBPLUS
    ON
    TBMOBRAS.OROBR = TBPLUS.OROBR
    WHERE
    TBMOBRAS.ORPL='HE'
    AND TBMOBRAS.ORSE='HE'
    AND TBMOBRAS.ORTP = ' P'
    AND TBMOBRAS.OROBR='40500'
    AND TBMOBRAS.ORVAR=' 1'

    I get this error message...

    Warning: SQL error: [IBM][CLI Driver][AS] SQL30040N Execution failed because of unavailable resources that will not affect the successful execution of subsequent commands and SQL statements: Reason "0x0", Type of Resource "0x1409", Resource Name "", Product ID "QSQ04040". SQLSTATE=57012 , SQL state 57012 in SQLExecDirect in /home/httpd/html/sistema/include/dblib.php on line 17

    dblib line 17 --> $qid = odbc_exec($conn,$query." with none");

    I think this is caused by BLOB field in HUMIGES.MOBRASPLUS table, because when I drop the field the problem is solved.

    does any body know where comes the problem from.

    Regards
    Emilio.

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    In documentation there is a note:
    "The application cannot process the command or SQL
    statement because the specified resource has run out. The current
    transaction is not rolled back and the application remains
    connected to the remote database."


    Do you have enough resources? Disk space, memory, etc?

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    grofaty thank for your comment, but is not this, I have disk space, memory and all the resources that I need.

    I solved the problem clearing the JOIN and doing two SELECT's, I do not like this, but resolve fast

    Any think about this is wellcome.

    Regards
    Emilio

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    If the tables are large, they can use up a large amount temporary tablespace. Consider making it larger and see what happens. Also look at sort heaps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •