assert failed IDS 7.31 UC 5
Hello every body, I need help
i've a ProLiant 800 with SCO OpenServer 5 release 3.2v5.0.5 and IDS 7.31 UC 5.
When i run the next store procedure i get the error
File: mtex.c Line: 446
29:11:38 Results: Exception Caught. Type: MT_EX_OS, Context: mem
29:11:38 Action: Please notify Informix Technical Support.
The af file report
ess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers
64 INSERT fiscalia NL Not Wait -223 0 7.31
Last parsed SQL statement :
execute procedure sp210pdb()
User-created Temp tables :
partnum tabname rowsize
10002f x31 8
10002e x3 844
and the engine down.
the store procedure is
INSERT INTO pdb
SELECT DISTINCT pdb_codigo,0 AS pdb_versin,
0 AS pdb_tpers, 0 AS pdb_fecver,
spnull(APELLIDO) || "," || spnull(NOMBRE) AS pdb_nomyap,
spnull(ALIAS) AS pdb_alias,
pdb_docum AS pdb_docum,
spedad(F_NACIM) AS pdb_edad, F_NACIML AS pdb_fecnac,
spsexo(SEXO) AS pdb_sexo, BARRIO AS pdb_ocupac,
SECC_PROX AS pdb_lugnac, x_personas.pdb_nyapad AS pdb_nyapad,
x_personas.pdb_nyamad AS pdb_nyamad, NACIONAL AS pdb_nacion,
0 AS pdb_estado, "" AS pdb_pront
FROM x_personas;
the table pdb is a synonym.
When i run the insert as a query it is ok and inserts all rows, but when i run in the store procedure the engine down.
I drop synonym and recreate it, drop distributions, check de table but nothing work.
The same store procedure work fine in other server ProLiant 1850R with SCO OpenServer 5.0.5 and IDS 7.31 UC5
I can't migrate to other IDS and don't have support.
I'll apreciate your help.
Very thanks.
Ing. Susana Barea
Poder Judicial Mendoza
sbarea@jusmendoza.gov.ar
sending to informix-list
Could you please post the output of "onstat -g dic" from the assertion
failure file (af.xxxx).
Thank you,
Wurdalak
"Susana Barea" <sbarea@jus.mendoza.gov.ar> escribi' en el mensaje
news:cedvls$gv6$1@news.xmission.com...
>
> Hello every body, I need help
>
> i've a ProLiant 800 with SCO OpenServer 5 release 3.2v5.0.5 and IDS 7.31
UC 5.
>
> When i run the next store procedure i get the error
>
> File: mtex.c Line: 446
> 29:11:38 Results: Exception Caught. Type: MT_EX_OS, Context: mem
> 29:11:38 Action: Please notify Informix Technical Support.>
> The af file report
> ess SQL Current Iso Lock SQL ISAM F.E.
> Id Stmt type Database Lvl Mode ERR ERR Vers
> 64 INSERT fiscalia NL Not Wait -223 0 7.31
>
> Last parsed SQL statement :
>
> execute procedure sp210pdb()>
> User-created Temp tables :
> partnum tabname rowsize
> 10002f x31 8
> 10002e x3 844
>
> and the engine down.
>
> the store procedure is
>
> INSERT INTO pdb
> SELECT DISTINCT pdb_codigo,0 AS pdb_versin,
> 0 AS pdb_tpers, 0 AS pdb_fecver,
> spnull(APELLIDO) || "," || spnull(NOMBRE) AS pdb_nomyap,
> spnull(ALIAS) AS pdb_alias,
> pdb_docum AS pdb_docum,
> spedad(F_NACIM) AS pdb_edad, F_NACIML AS pdb_fecnac,
> spsexo(SEXO) AS pdb_sexo, BARRIO AS pdb_ocupac,
> SECC_PROX AS pdb_lugnac, x_personas.pdb_nyapad AS pdb_nyapad,
> x_personas.pdb_nyamad AS pdb_nyamad, NACIONAL AS pdb_nacion,
> 0 AS pdb_estado, "" AS pdb_pront
> FROM x_personas;>
> the table pdb is a synonym.
>
> When i run the insert as a query it is ok and inserts all rows, but when i
run in the store procedure the engine down.
> I drop synonym and recreate it, drop distributions, check de table but
nothing work.
>
> The same store procedure work fine in other server ProLiant 1850R with SCO
OpenServer 5.0.5 and IDS 7.31 UC5
>
> I can't migrate to other IDS and don't have support.
>
> I'll apreciate your help.
>
> Very thanks.
>
> Ing. Susana Barea
> Poder Judicial Mendoza
> sbarea@jusmendoza.gov.ar
>
>
>
> sending to informix-list