Informix

Expand all | Collapse all

onbar PSM: -284 error when running onsmsync -g (recycle backup

  • 1.  onbar PSM: -284 error when running onsmsync -g (recycle backup

    Posted Sun April 19, 2020 09:37 AM
    Hi Folks,

    having a stupid error -284 when running onsmsync -g , which ends in not complete the media recycling operation.
    here is what the onbar log says
    2020-04-19 07:50:28 27813 27812 Applying expiration policies...
    2020-04-19 07:50:28 27813 27812 bar_exp_spaces_by_policy: s_bkp_obj_from_tltab_stmt: SQLCODE=-284 using aid=38 oid=7
    2020-04-19 07:50:28 27813 27812 SQL -284 A subquery has returned not exactly one row.
    2020-04-19 07:50:28 27813 27812 Informix Primary Storage Manager session 700 closed
    2020-04-19 07:50:28 27813 27812 /opt/informix/engines/ifmx.14.10.FC3/bin/onsmsync complete, returning 148 (0x94)

    Not sure in which table this error occurs. I am trying to access with Informix SE to the PSM_CATALOG_PATH tables but no database name to use ...

    Any idea on how to fix this ?

    Thanks, as always
    Eric

    ------------------------------
    [eric] [Vercelletto] []
    [Founder]
    [kandooerp.org]
    [Pont l'Abbé] [France]
    [+33 626 52 50 68]

    Disclaimer: My own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.
    ------------------------------


  • 2.  RE: onbar PSM: -284 error when running onsmsync -g (recycle backup

    Posted Sun April 19, 2020 09:45 AM

    onmode –I 284 ?

     






  • 3.  RE: onbar PSM: -284 error when running onsmsync -g (recycle backup

    Posted Sun April 19, 2020 10:02 AM

    Brilliant idea Paul

    Should I create a RFE for this new option ��

     






  • 4.  RE: onbar PSM: -284 error when running onsmsync -g (recycle backup

    Posted Mon April 20, 2020 11:51 AM
    Hi Eric,

    there's PSM_DEBUG and PSM_DEBUG_LOG, very similar to BAR_DEBUG[_LOG].
    Maybe this can shed more light on your problem?

    BR,
     Andreas

    ------------------------------
    Andreas Legner
    ------------------------------



  • 5.  RE: onbar PSM: -284 error when running onsmsync -g (recycle backup

    Posted Tue April 21, 2020 01:46 AM

    Hi Andreas

     

    Nice try, and cool functionality, now I know with lot of details what onsmsync does, but the bar_log file gives an error probably with a function name and a prepared statement name, and the psm log (in 2100+ lines) does not mention any error nor function name or anything similar.

     

    This is starting to be annoying because backup objects volume is growing and I cannot clear them ...

     

    Should I log a ticket ?