error code : 710 table renamed or dropped
Hi,
we are getting error number 710 when the RCMSServer process was trying to
insert a row to 'rcms_process_req' , and it has the table reference to 'user'.
But at this point of time, you could see user table has been dropped
even we tried to update the statistics on the table but still of no use.
can any one help me in resolving this problem/error.
please do the needful.
update statistics medium for table rcms_process_req ;
Statistics updated.
09/19/06 07:52:23.890101 RCMSServer[22895].ERR-DebugUtils.c/42 [Couldn't
INSERT 'RCMANORD' row into 'rcms_process_req' with parameters = |3230|
]
09/19/06 07:52:23.898190 RCMSServer[22895].ERR-DebugUtils.c/47 [ --- SQLCODE =
-710 : Table (snssadmn.user) has been dropped, altered or rena
med.
]
09/19/06 07:52:23.898889 RCMSServer[22895].ERR-DebugUtils.c/52 [ --- ISAMCODE
= 0 : Unknown error message 0.
]
many thanks!!
nanda
This is because the table was modified and the SPL has not been
updated. It could be called directly or by Trigger. I like the
really simple....
UPDATE STATISTICS FOR ROUTINE;
This works great when you have to do everything and are to lazy to
program each one out. This isn't the best idea if you have allot of
SPL being used. If you know which function/procedure is causing this
then do just that one...
UPDATE STATISTICS FOR PROCEDURE %NAME%;
UPDATE STATISTICS FOR FUNCTION %NAME%;
This update takes care of funtions and procedures...
Eric B. Rowell
On 9/20/06, MADHUSUDHAN NANDA <nandu_madhu@yahoo.com> wrote:
>
> Hi,
>
> we are getting error number 710 when the RCMSServer process was trying to
> insert a row to 'rcms_process_req' , and it has the table reference to
'user'.
> But at this point of time, you could see user table has been dropped
>
> even we tried to update the statistics on the table but still of no use.
>
> can any one help me in resolving this problem/error.
>
> please do the needful.
>
> update statistics medium for table rcms_process_req ;>
> Statistics updated.
>
> 09/19/06 07:52:23.890101 RCMSServer[22895].ERR-DebugUtils.c/42 [Couldn't
> INSERT 'RCMANORD' row into 'rcms_process_req' with parameters = |3230|
> ]
> 09/19/06 07:52:23.898190 RCMSServer[22895].ERR-DebugUtils.c/47 [ --- SQLCODE
=
> -710 : Table (snssadmn.user) has been dropped, altered or rena
> med.
> ]
> 09/19/06 07:52:23.898889 RCMSServer[22895].ERR-DebugUtils.c/52 [ --- ISAMCODE
> = 0 : Unknown error message 0.
> ]
>
> many thanks!!
> nanda
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Run update stats on the SPL
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
Web: www.oninit.com
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 European Conference.
Vienna, Austria. 2-6 October 2006
Visit http://www.iiug.org/conf for more information.
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On
> Behalf Of MADHUSUDHAN NANDA
> Sent: 20 September 2006 11:30
> To: ids@iiug.org
> Subject: error code : 710 table renamed or dropped [7506]
>
>
> Hi,
>
> we are getting error number 710 when the RCMSServer process
> was trying to insert a row to 'rcms_process_req' , and it has
> the table reference to 'user'.
> But at this point of time, you could see user table has been dropped
>
> even we tried to update the statistics on the table but still
> of no use.
>
> can any one help me in resolving this problem/error.
>
> please do the needful.
>
> update statistics medium for table rcms_process_req ;>
> Statistics updated.
>
> 09/19/06 07:52:23.890101
> RCMSServer[22895].ERR-DebugUtils.c/42 [Couldn't INSERT
> 'RCMANORD' row into 'rcms_process_req' with parameters = |3230| ]
> 09/19/06 07:52:23.898190
> RCMSServer[22895].ERR-DebugUtils.c/47 [ --- SQLCODE = -710 :
> Table (snssadmn.user) has been dropped, altered or rena med.
> ]
> 09/19/06 07:52:23.898889
> RCMSServer[22895].ERR-DebugUtils.c/52 [ --- ISAMCODE = 0 :
> Unknown error message 0.
> ]
>
> many thanks!!
> nanda
>
>
> **************************************************************
> *****************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
Hi ,
Thanks a lot for your support.
i will run the stats on all and will check out the same.
many thanks
nanda
Eric Rowell <erowell@gmail.com> wrote:
This is because the table was modified and the SPL has not been
updated. It could be called directly or by Trigger. I like the
really simple....
UPDATE STATISTICS FOR ROUTINE;
This works great when you have to do everything and are to lazy to
program each one out. This isn't the best idea if you have allot of
SPL being used. If you know which function/procedure is causing this
then do just that one...
UPDATE STATISTICS FOR PROCEDURE %NAME%;
UPDATE STATISTICS FOR FUNCTION %NAME%;
This update takes care of funtions and procedures...
Eric B. Rowell
On 9/20/06, MADHUSUDHAN NANDA wrote:
>
> Hi,
>
> we are getting error number 710 when the RCMSServer process was trying to
> insert a row to 'rcms_process_req' , and it has the table reference to
'user'.
> But at this point of time, you could see user table has been dropped
>
> even we tried to update the statistics on the table but still of no use.
>
> can any one help me in resolving this problem/error.
>
> please do the needful.
>
> update statistics medium for table rcms_process_req ;>
> Statistics updated.
>
> 09/19/06 07:52:23.890101 RCMSServer[22895].ERR-DebugUtils.c/42 [Couldn't
> INSERT 'RCMANORD' row into 'rcms_process_req' with parameters = |3230|
> ]
> 09/19/06 07:52:23.898190 RCMSServer[22895].ERR-DebugUtils.c/47 [ --- SQLCODE
=
> -710 : Table (snssadmn.user) has been dropped, altered or rena
> med.
> ]
> 09/19/06 07:52:23.898889 RCMSServer[22895].ERR-DebugUtils.c/52 [ ---
ISAMCODE
> = 0 : Unknown error message 0.
> ]
>
> many thanks!!
> nanda
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
MADHUSUDHAN.NANDA
---------------------------------
Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates
starting at 1¢/min.