weird and unexpected errors -908 on archecker

Hi Folks I am working with archecker with the option of table level restore, which has been working fine on my lab systems. I am now testing a script on my customer's staging system, with same ifmx version (14.10 FC4) which looks ok in terms of connections (dbaccess under the soctp INFORMIXSERVER works fine), onstat works fine etc... but when I launch the same archecker script that works 'at home' I got the following log file, saying basically that I had errors -908 and the table has not been captured nor restored STATUS: Arguments [-bdvs -X -f /tmp/aga031.cmd] STATUS: AC_STORAGE /tmp STATUS: AC_MSGPATH /tmp/ac_msg.log STATUS: AC_VERBOSE on STATUS: AC_TAPEBLOCK 62 KB STATUS: AC_IXBAR /appli/informix/ids/etc/ixbar.1 STATUS: AC_SCHEMA /tmp/aga031.cmd TIME: [2022-02-16 16:53:40] All old validation files removed. STATUS: Dropping old log control tables STATUS: Temporary workspace has been set STATUS: Restore only physical image of archive ERROR: "Prepare (name check)" failed ERROR: -908: (rgetlmsg() returned -1227) ERROR: "Execute (name check)" failed ERROR: -410: (rgetlmsg() returned -1227) ERROR: "Prepare (table_exists)" failed ERROR: -908: (rgetlmsg() returned -1227) ERROR: "Prepare (lg_name_ptnum_count)" failed ERROR: -908: (rgetlmsg() returned -1227) ERROR: "Execute (lg_name_ptnum_count)" failed ERROR: -410: (rgetlmsg() returned -1227) STATUS: Target table [afc] already created STATUS: SQL [SET INDEXES, TRIGGERS, CONSTRAINTS FOR afc DISABLED] STATUS: Extracting table aga031:afc into aga031:afc STATUS: Using IBM's PSM version 14.10.FC4W1 as the Storage Manager. XBSA API version is 1.0.3. STATUS: Determined Storage Manager to be psm. STATUS: dbspace name: aga031dbs aid: 79711 STATUS: Object Name /IDS_INST1shm Path /IDS_INST1shm/aga031dbs/0 Resource ND STATUS: starting to scan dbspace 22 created on 2022-02-14 17:03:27. STATUS: Archive timestamp 0XEFFD47BF. ERROR: "Execute (acu_name_save)" failed ERROR: -908: (rgetlmsg() returned -1227) ERROR: Unable to open table aga031:afc ERROR: Table aga031.afc is being skipped STATUS: Scan PASSED STATUS: Control page checks PASSED STATUS: Table checks PASSED STATUS: Table extraction commands 1 STATUS: Tables found on archive 0 STATUS: Tables not located on archive 1 STATUS: LOADED: aga031:afc produced 0 rows TIME: [2022-02-16 16:54:47] Physical Extraction Completed TIME: [2022-02-16 16:54:47] Unload Completed STATUS: archecker completed Physical Restore pid = 273170 exit code: 3 Any idea ? ------------------------------ [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. ------------------------------ #Informix

Eric: I think that the -1227 error is the root cause: $ finderr 1227-1227 Message file not found. 4GL cannot locate a file of message texts. The file should have a suffix of .iem and be in the product directory, $INFORMIXDIR/msg. Reinstall such files from the distribution materials. If you have started to modify the user-message file, 4glusr.msg, check that its compiled form has been replaced in the correct directory. Something is not right with the path to INFORMIXDIR so archecker can't find the message files. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that 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.

Sounds like you env is wrong somewhere, we know 908 is Attempt to connect to database server (servername) failed. But you are seeing -1227 instead 'cos it can't find the error message files Cheers Paul

Yes. Looks like messy install Thanks Télécharger Outlook pour Android