Login Register Actian.com  

Actian Community Forum


Go Back   Actian Community Forums > Ingres Forums > Database General
Reload this Page E_QE0018 Illegal parameter in control block
 

Reply
Page 1 of 2 1 2
 
LinkBack Thread Tools Display Modes
Old 2012-02-22   #1 (permalink)
Ingres Community
 
Join Date: Mar 2007
Location: Lyon France
Posts: 38
Default E_QE0018 Illegal parameter in control block
Hi

I would like to know if somebody can help me about :

The update statement below fails with E_QE0018 Illegal parameter in control block error

update citachesmandats
set log_idc_sup='O',
mod_jou='now'
where afr_idf='12.000224'
and tut_idf=1329914774
and mandat_idf=1329915872
and log_idc_sup='N'

Key
Column Name Type Length Nulls Defaults Seq
tache_mandat_idf integer 4 no yes 1
afr_idf varchar 9 no yes
tut_idf integer 4 no yes
mandat_idf integer 4 no yes
tache_idf integer 4 no yes
tache_cat varchar 4 no yes
article_cod varchar 5 no yes
tache_num integer 4 no yes
tache_tri integer 4 no yes
tache_lib varchar 2048 no yes
mod_jou ingresdate no yes
log_idc_sup varchar 1 no yes


Secondary indexes:Index Name Structure Keyed On
itache1 isam afr_idf, tut_idf, mandat_idf, tache_idf

Thanks
hermoune is offline   Reply With Quote
Old 2012-02-22   #2 (permalink)
fba
Ingres Community
 
fba's Avatar
 
Join Date: Dec 2009
Location: Belgium/France
Posts: 196
Default
Just to make sure. Do you get the same error if you replace mod_jou='now' by mod_jou=date('now') in your update?
Do you see other errors in the errlog.log file?
__________________
Frédéric Barbier
fba is online now   Reply With Quote
Old 2012-02-22   #3 (permalink)
Ingres Community
 
Join Date: Mar 2007
Location: Lyon France
Posts: 38
Default
Yes the same error appears with mod_jou=date('now')

and even with just set log_idc_sup='O' without mod_jou.

but non error with

update citachesmandats
set afr_idf = afr_idf
where afr_idf='12.000224'
and tut_idf=1329914774
and mandat_idf=1329915872
and log_idc_sup='N'
hermoune is offline   Reply With Quote
Old 2012-02-22   #4 (permalink)
Ingres Community
 
kschendel's Avatar
 
Join Date: Mar 2007
Location: Pittsburgh, PA
Posts: 1,661
Default
Ingres version and platform? Try setting II_DBMS_LOG to see if there's anything useful there.

QE0018 usually (not always) means that a called facility, usually DMF, has returned an error or warning status, but there's no error code set in the usual place in the returned request control block. So, maybe DMF reported an error, rightly or wrongly, and then lost track of it.
kschendel is offline   Reply With Quote
Old 2012-02-23   #5 (permalink)
Ingres Community
 
Join Date: Mar 2007
Location: Lyon France
Posts: 38
Default
The version is
version II 9.1.1 (su9.us5/103)
platform solaris
hermoune is offline   Reply With Quote
Old 2012-02-23   #6 (permalink)
Ingres Community
 
bilgihan's Avatar
 
Join Date: Aug 2008
Location: Munich, Germany
Posts: 271
Default
Any further messages in errlog.log when "E_QE0018 Illegal parameter in control block error" occurs?
Last edited by bilgihan; 2012-02-23 at 12:58 AM.
bilgihan is offline   Reply With Quote
Old 2012-02-24   #7 (permalink)
Ingres Community
 
Join Date: Mar 2007
Location: Lyon France
Posts: 38
Default
Yes :
Wed Feb 22 16:32:54 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
hermoune is offline   Reply With Quote
Old 2012-02-24   #8 (permalink)
Ingres Community
 
kschendel's Avatar
 
Join Date: Mar 2007
Location: Pittsburgh, PA
Posts: 1,661
Default
In order to progress, we'll really need to see the DBMS log (ingsetenv II_DBMS_LOG some-file-writable-by-ingres), or you'll need to run an instrumented version of the DBMS server, or you'll need to pin this down to a repeatable case that Tech Support can follow up on. E_QE0018 is a symptom, not a cause.
kschendel is offline   Reply With Quote
Old 2012-02-29   #9 (permalink)
Ingres Community
 
Join Date: Mar 2007
Location: Lyon France
Posts: 38
Default
This is a part of logfile

ILEMSUN ::[32924 , 1184 , 00000001]: Wed Feb 22 08:49:54 2012 E_SC051D_LOAD_CONFIG Finished loading configuration parameters for configuration '(DEFAULT)' of server type 'STAR'.
ILEMSUN ::[32924 , 1184 , 00000001]: Wed Feb 22 08:49:54 2012 E_SC0129_SERVER_UP Ingres 2006 Release 2 Release II 9.1.2 (a64.sol/100) Server -- Normal Startup.
ILEMSUN ::[32924 , 1184 , 087c2480]: Wed Feb 22 08:49:55 2012 I_TP0232_BEGIN_PHASE1 2PC/RECOVERY : Phase 1 begins.
ILEMSUN ::[32924 , 1184 , 087c2480]: Wed Feb 22 08:49:55 2012 I_TP0207_BEGIN_CDB_REC 2PC/RECOVERY : Building CDB list for recovery begins.
ilemsun ::[32868 IIGCN, 1076 , 00000007]: Wed Feb 22 08:49:57 2012 E_GC0153_GCN_SRV_STARTUP Server Registration: class RMCMD, address 32935
ilemsun ::[32935 , 1199 , ffffffff]: Wed Feb 22 08:49:57 2012 E_RE0001_RMCMD_UP Visual DBA RMCMD Server -- Normal Startup.
ILEMSUN ::[32915 , 1130 , 13f18700]: Wed Feb 22 11:34:57 2012 E_US0010 Database does not exist: 'ojv_gdc_com_devc'.
ILEMSUN ::[32915 , 1130 , 13f18700]: Wed Feb 22 11:34:57 2012 E_SC0123_SESSION_INITIATE Error initiating session.
ILEMSUN ::[32915 , 1130 , 13efa360]: Wed Feb 22 13:59:28 2012 E_US0010 Database does not exist: 'ojv_gdc_comd_ev'.
ILEMSUN ::[32915 , 1130 , 13efa360]: Wed Feb 22 13:59:28 2012 E_SC0123_SESSION_INITIATE Error initiating session.
ILEMSUN ::[32915 , 1130 , 13efa360]: Wed Feb 22 13:59:33 2012 E_US0010 Database does not exist: 'ojv_gdc_com_d_ev'.
ILEMSUN ::[32915 , 1130 , 13efa360]: Wed Feb 22 13:59:33 2012 E_SC0123_SESSION_INITIATE Error initiating session.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:24:43 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:24:43 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:24:45 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:24:45 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:24:56 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:24:56 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:26:20 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:26:20 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:28:48 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:28:48 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:29:11 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:29:11 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:30:04 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:30:04 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:30:24 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:30:24 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:31:13 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:31:13 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:40:55 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:40:55 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:41:45 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:41:45 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:42:01 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:42:01 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:42:31 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:42:31 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:46:40 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:46:40 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:53:35 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 14:53:35 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:20:59 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:20:59 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:21:28 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:21:28 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:31:18 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:31:18 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:32:19 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:32:19 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:32:54 2012 E_DM93F5_ROW_LOCK_PROTOCOL Row Locking Protocol error.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:32:54 2012 E_QE0018_BAD_PARAM_IN_CB Illegal parameter in control block.
ilemsun ::[32868 IIGCN, 1076 , 00000007]: Wed Feb 22 16:40:10 2012 E_GC0154_GCN_SRV_SHUTDOWN Registered server shutdown: class RMCMD, address 32935
ilemsun ::[32935 , 1199 , ffffffff]: Wed Feb 22 16:40:10 2012 E_RE0002_RMCMD_DOWN Visual DBA RMCMD Server Normal Shutdown.
ILEMSUN ::[32924 , 1184 , 087cb8a0]: Wed Feb 22 16:40:17 2012 I_SC051E_IIMONITOR_CMD IIMONITOR: 'set server shut' issued by 'ingres' from Terminal: batch
ilemsun ::[32868 IIGCN, 1076 , 00000005]: Wed Feb 22 16:40:17 2012 E_GC0154_GCN_SRV_SHUTDOWN Registered server shutdown: class STAR, address 32924
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:40:18 2012 I_SC051E_IIMONITOR_CMD IIMONITOR: 'set server shut' issued by 'ingres' from Terminal: batch
ILEMSUN ::[32915 , 1130 , 087d7fe0]: Wed Feb 22 16:40:18 2012 E_SC0271_EVENT_THREAD The SCF alert subsystem event thread has been altered. The operation code is 0 (0 = REMOVE, 1 = ADD, 2 = MODIFY).
ilemsun ::[32868 IIGCN, 1076 , 00000001]: Wed Feb 22 16:40:18 2012 E_GC0154_GCN_SRV_SHUTDOWN Registered server shutdown: class INGRES, address 32915
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:40:18 2012 E_SC0235_AVERAGE_ROWS On 92511. select/retrieve statements, the average row count returned was 6.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:40:18 2012 E_SC0128_SERVER_DOWN Server Normal Shutdown.
ILEMSUN ::[32915 , 1130 , 1453e100]: Wed Feb 22 16:40:18 2012 E_CL2518_CS_NORMAL_SHUTDOWN The Server has terminated normally.
ILEMSUN ::[32915 , 1130 , 00000001]: Wed Feb 22 16:40:18 2012 E_CL2518_CS_NORMAL_SHUTDOWN The Server has terminated normally.
ilemsun ::[32918 IIGCC, 1148 , ffffffff]: Wed Feb 22 16:40:19 2012 E_GC2002_SHUTDOWN Communication Server normal shutdown.
ilemsun ::[32868 IIGCN, 1076 , 00000003]: Wed Feb 22 16:40:19 2012 E_GC0154_GCN_SRV_SHUTDOWN Registered server shutdown: class COMSVR, address 32918
ilemsun ::[32921 IIGCD, 1166 , 00000000]: Wed Feb 22 16:40:20 2012 E_GC4801_SHUTDOWN Data Access Server normal shutdown.
ilemsun ::[32868 IIGCN, 1076 , 00000004]: Wed Feb 22 16:40:20 2012 E_GC0154_GCN_SRV_SHUTDOWN Registered server shutdown: class DASVR, address 32921
ilemsun ::[II_ACP , 1115 , 087a2100]: Wed Feb 22 16:40:22 2012 E_DM9815_ARCH_SHUTDOWN Archiver was told to shut down.
hermoune is offline   Reply With Quote
Old 2012-02-29   #10 (permalink)
Ingres Community
 
bilgihan's Avatar
 
Join Date: Aug 2008
Location: Munich, Germany
Posts: 271
Default
This looks like known bug 122176. Contact Actian support for detail.
bilgihan is offline   Reply With Quote

Reply
Page 1 of 2 1 2

Bookmarks

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Actian  |  Download Software  |  Enterprise Support  |  Contact Us  |  Terms of Use  |  Actian Corporation  |  Top
© 2011 Actian Corporation. All Rights Reserved