#1  
Old 8th December 2018, 12:47 AM
Bernie07 Bernie07 is offline
Junior Member
 
Join Date: Dec 2018
Posts: 4
Default Assertion fehlgeschlagen (nxsqlCondExp.pas, Zeile 16986

Hello,
since the new nexusDB Version 4.5 I get an error if I call a stored procedure like

call STAT_UMSAETZE_STUNDEN (Date '2017-01-01',2254, -1)

The stored procedure is

CREATE PROCEDURE STAT_UMSAETZE_BETRAEGE
( IN INBUCHUNGSDATUMVON DATE,
IN INKOST BIGINT)
READS SQL DATA
BEGIN
select kundenrechnungen.geschaeftsstelle OUTGS,
OUTJAHR,
OUTMONAT,
sum (kundenrechnungenpositionen.gesamtpreis) OUTBETRAG
from (select *,
extract (year from buchungsdatum) OUTJAHR,
extract (month from buchungsdatum) OUTMONAT
from kundenrechnungen) kundenrechnungen, kundenrechnungenpositionen
where (kundenrechnungen.recnum=kundenrechnungenpositione n.rechnung)
and (buchungsdatum>=INBUCHUNGSDATUMVON)
and ((INKOST=-1) or (INKOST=COALESCE(kundenrechnungenpositionen."Koste nstelle MA",0)))
group by kundenrechnungen.geschaeftsstelle, OUTJAHR, OUTMONAT;

END

If I call the select statement direct in the Enterprise Manager it works correct. But If I calling the stored procedure I get an Assertion error.

With the NexusDB Version 4 (the previous version we used for a long time) there were no problems.

How can I solve this?

Best wishes
Bernhard
  #2  
Old 8th December 2018, 04:22 PM
Eivind Eivind is offline
Administrator
 
Join Date: Mar 2008
Posts: 203
Default

Quote:
Originally Posted by Bernie07 View Post
Hello,
since the new nexusDB Version 4.5 I get an error if I call a stored procedure like

call STAT_UMSAETZE_STUNDEN (Date '2017-01-01',2254, -1)

The stored procedure is

CREATE PROCEDURE STAT_UMSAETZE_BETRAEGE
( IN INBUCHUNGSDATUMVON DATE,
IN INKOST BIGINT)
READS SQL DATA
BEGIN
select kundenrechnungen.geschaeftsstelle OUTGS,
OUTJAHR,
OUTMONAT,
sum (kundenrechnungenpositionen.gesamtpreis) OUTBETRAG
from (select *,
extract (year from buchungsdatum) OUTJAHR,
extract (month from buchungsdatum) OUTMONAT
from kundenrechnungen) kundenrechnungen, kundenrechnungenpositionen
where (kundenrechnungen.recnum=kundenrechnungenpositione n.rechnung)
and (buchungsdatum>=INBUCHUNGSDATUMVON)
and ((INKOST=-1) or (INKOST=COALESCE(kundenrechnungenpositionen."Koste nstelle MA",0)))
group by kundenrechnungen.geschaeftsstelle, OUTJAHR, OUTMONAT;

END

If I call the select statement direct in the Enterprise Manager it works correct. But If I calling the stored procedure I get an Assertion error.

With the NexusDB Version 4 (the previous version we used for a long time) there were no problems.

How can I solve this?

Best wishes
Bernhard
In the EM, run the following statement:

EXECUTE IMMEDIATE SYS_REPARSEALL()

and then try calling your procedure again. There was a bug discovered that affected EXTRACT; the above will recreate all procedures and functions and fix that particular problem. If by chance that does not help, please include tables we need in an email to us for investigation.
  #3  
Old 11th December 2018, 09:54 PM
Andreas Schachtner Andreas Schachtner is offline
Member
 
Join Date: Jul 2009
Posts: 36
Default

see my issue #2194 in the tracker.

The new Sys_ReparseAll () function in 4.5 should repair the wrong stream's in your stored procedures;
  #4  
Old 11th December 2018, 11:38 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Assertion fehlgeschlagen (nxsqlCondExp.pas, Zeile 16986

> see my issue #2194 in the tracker.
>
> The new Sys_ReparseAll () function in 4.5 should repair the wrong
> stream's in your stored procedures;


Are you saying that the new function *does* fix the problem in issue
#2194?

--
Eivind Bakkestuen [NDD]
  #5  
Old 12th December 2018, 01:21 AM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Assertion fehlgeschlagen (nxsqlCondExp.pas, Zeile 16986

Eivind Bakkestuen [NDD] wrote:

> > see my issue #2194 in the tracker.
> >
> > The new Sys_ReparseAll () function in 4.5 should repair the wrong
> > stream's in your stored procedures;

>
> Are you saying that the new function does fix the problem in issue
> #2194?


please check the contents of the table that is returned by executing
SYS_ReparseAll().

It will contain information if the reparsing has resulted in an error for any
of your stored routines.
  #6  
Old 12th December 2018, 11:39 PM
Bernie07 Bernie07 is offline
Junior Member
 
Join Date: Dec 2018
Posts: 4
Default

Thanks for your answer.

In which cases Fails the call of a stored procedure? I ask this because I have many of stored procedure and all works fine. Only the one, I have posted has this Problem.


Is there a documentation About SYS_REPARSEALL how to apply this fix?


Best wishes
Bernhard
  #7  
Old 18th December 2018, 10:03 AM
Eivind Eivind is offline
Administrator
 
Join Date: Mar 2008
Posts: 203
Default

Quote:
Originally Posted by Bernie07 View Post
Thanks for your answer.

In which cases Fails the call of a stored procedure? I ask this because I have many of stored procedure and all works fine. Only the one, I have posted has this Problem.


Is there a documentation About SYS_REPARSEALL how to apply this fix?


Best wishes
Bernhard
Until you can quote the exact error message you are receiving or give us something to reproduce, we can't say why your stored procedure is failing.

SYS_REPARSEALL should be in the latest helpfile update, although it might not fix the problem you are seeing. Have you tried running it yet?


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Memory leak in nxsqlCondExp.pas Fabien nexusdb.public.support 1 8th August 2007 12:13 PM
2.05 compile problems with nxsqlCondExp.hpp Steve JORDI Support Newsgroups 7 18th June 2006 09:17 PM
2.05 compile problems with nxsqlCondExp.hpp Steve JORDI nexusdb.public.support.cbuilder 7 18th June 2006 09:17 PM
2.05 compile problems with nxsqlCondExp.hpp (C++) Steve JORDI nexusdb.public.support 2 17th June 2006 04:45 AM
Assertion Error nxSQLCondExp.pas 7417 Jirayu nexusdb.public.support 5 30th July 2003 12:37 AM


All times are GMT +11. The time now is 06:46 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.