Re: Stored procedure failing after IDS4 server crash
Drop and rebuild SPL
Put a trace in the SPL, if you have a node depth of 16 then the Blade
fails and you need to tweak the code
Paul Watson
Tel: +44 1414161772
Mob: +44 7818003457
GO FURTHER with DB2
GET THERE FASTER with Informix.
Attend the IDUG 2006 North America Conference.
Tampa, Florida, USA. 7-11 May 2006.
Visit http://www.iiug.org/conf for more information.
> -----Original Message-----
> From: Gary [mailto:gary@mcxdigital.com]
> Posted At: Tuesday, April 11, 2006 4:36 AM
> Posted To: comp.databases.informix
> Conversation: Stored procedure failing after IDS4 server crash
> Subject: Stored procedure failing after IDS4 server crash
>
>
> I am trying to assist a friend in Africa with an IDS 9.4 FC3
> problem on
> AIX 5.2
>
> The server crashed with the following log information.
>
> 15:29:42 Assert Warning: I/O error, Primary Chunk
[cutting]
Hi Paul
Thanks for your assistance. When you talk about node depth, are you
talking about the Node Datablade ? We only allow 4 levels. I did some
further tests yesterday and we ran the Function using Informix SQL
editor. The following error occured which is an Excalibur Text Blade
error.
execute function
loadfiles(70517,'CENPOCDF2003-2004B-00224152','A3-Station1','CENPOCDF2003-2004B-00224152
-
00224152\\0000106.TIF','0000106','image/tiff','C:\\capture\\image\\00224152\\0000106.TIF','c:\\capture\\output\\1.0\\A3-Station1\\00224152\\0000106.TIF','c:\\capture\\image\\00224152\\0000106.ocr','1.0',50722,1401);
-- [Informix][Dynamic Server 2000][workflow] SQL Error (-937) : [UET31]
- Internal Error: (-60) returned from TRL to etxgl_init_sim7
This will make sense as the function imports the Sblob into a table
which has two excalibur indexes on to sblob fields. Below is the
function I am running. Is it possible that these indexes got corrupted
during the crash and just need to be recreated ?
create function "informix".loadfiles(RefID integer,DocRef
char(50),UserName char(25),Summary lvarchar,FileName
varchar(255),upl_type varchar(40,0),upload_name varchar(120,0),
export_file --varchar(120,0), ocr_file varchar(255,0),SectionId node,
ObjSize integer, OcrSize integer)
returning varchar(255);
define ProcessId integer;
define UserId integer;
define DocId integer;
define docresult varchar(255);
let ProcessId =(select process_id from process where node_id =
SectionId);
let UserId = (select user_id from user_profile where upper(user_name) =
upper(UserName));
Insert into document values (0,RefID,DocRef,CURRENT year to
minute,UserId, Summary,
FileName,upl_type,export_file,FileToBlob(upload_name,'client'),FileToBlob(ocr_file,'client'),ObjSize,OcrSize);let DocID = dbinfo('sqlca.sqlerrd1');
let docresult = (select path from document where doc_id = DocID);
return docresult;
end function;