Hello,

since a few weeks we use ORACLE instead of TBASE.
Now I got a problem with report sorting:
"Sorterror 6: No more files can be created in this moment"
The Session continues correctly and the report comes out, but it isn't sorted correct!!

I think this is because of null-values in a sort field.
TBASE treated String-Fields without a value as an empty string.
Now Oracle treats it as NULL (like every "normal" database should do :o )
Am I correct?

My question is:
Is there a BAAN-Function to check a string-field for NULL?
Then I could replace the NULL-fields with empty strings manually in the program script (before the record is send to the report!!).

Thanks for help...

Martin

function isspace(var) can be used to check the var for spaces.

It might also be a problem in the tmpspace of oracle

Regards,
Klaas

function isspace(var) can be used to check the var for spaces.

It might also be a problem in the tmpspace of oracle

Regards,
Klaas

Well, I also know "isspace(..)", but this function only checks for spaces, not for a database-null!!
But I solve my problem just an hour ago (call me an idiot!!):
My client refered to a temp-space, that did not exist anymore!!
I did not recognize this solution, because the "bug" didn't occur every time I run the session. Only if a wide range of records was selected!!

Anyway: Thanks for help!!

Hi,

We are getting the same error only when a large range of records is selected. However we are running W2K/SQL2K (so different platform to above). Any ideas?

TIA.

Restart of Baan server fixed problem, but not convinced it was solely a Windows problem - the eventlogs showed no errors...

The problem is definetly not related to null values in the database.

Just as a hint: Baan is not storing any nulls in Oracle anyway, but empty strings. If you look at the oracle tables, then you will find, that all fields are declared "not null".

I think your problem is routed somewhere else: In certain cases Baan is not relying only on the sorting capabilities of the database, but sorts itself by using the sort binary in $BSE/bin. In your case he could not do this anymore, either because there was not enough space in $BSE/tmp or he could not start the sort process.

Regards

Markus

Baan uses Oracle to sort the majority of its queries. All you have to do is look at the SQL generated to see that it will include an ORDER BY clause. TEMP space in Oracle is crucial to healthy sorting. Baan reports do use the native sort function of the operating system on the pre-output file that Baan reports utilize. It is used when you select Ascending, Descending, or Presorted from the Sort Mode in the report Input Fields section.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.