Page 1 of 1

DataStage 8 to SQL server 2005 error

Posted: Wed Jul 18, 2007 5:36 am
by fkana
Hi,

I hope someone out there knows what the following error means:

main_program: Fatal Error: Non-positive length [persistence\archive.C:2427]

We get this error when we load 4 -12 million records into a table. It loads up to a certain point everytime and aborts with the above error. More or less on 10 million records everytime. We get the same error whether we use a SQL Server Enterprise or ODBC Enterprise stage(s).

Any help will be highly appreciated.

Thanks.

Faeez

Posted: Wed Jul 18, 2007 6:04 am
by chulett
A search on 'Non-positive length' turned up zero hits, so no-one has posted about it before. To me, that looks like the kind of error that only the vendor would be able to track down. I'd suggest you contact your official Support provider and let us know what comes of it.

Posted: Wed Jul 18, 2007 3:45 pm
by ArndW
What is the average length of a record - could this error be happening on some typical power-of-two boundary? It probably won't solve it, but will help support get a handle on the cause.

Posted: Wed Jul 18, 2007 6:13 pm
by ray.wurlod
The other possibility is some kind of arithmetic overflow, for example if DataStage were counting the number of bytes transmitted or something. Certainly not something we mere mortals could affect!