Question Re: DBUnload cut sometimes data in Technology Q&A

DBUnload cut sometimes data

Former Member — Fri, 08 Feb 2013 02:25:59 GMT

Hi, I'm new to sybase, and I encounter strange error. When try to unload database using dbunload.exe -xx from my code it cut data when column has some KB of data. What can be wrong or has anyone had such error ?

Re: DBUnload cut sometimes data

MCMartin — Fri, 08 Feb 2013 07:03:15 GMT

Please post the SQLA Version you are using

Re: DBUnload cut sometimes data

former_SQLA_member1694872 — Fri, 08 Feb 2013 07:39:08 GMT

How exactly are you running the command?

Re: DBUnload cut sometimes data

Former Member — Fri, 08 Feb 2013 09:03:28 GMT

Well version is 11.0.1.2044 and I'm running the command from C# which look like this dbunload.exe -xx -q -y -c "{0}" -t {1} -r "{2}" .", conString, tables.ToString(), Path.Combine(dirPath, "reload.sql")); where conString is connection string, tables is array of table I'm unloading and the last one is path to reload.sql

Re: DBUnload cut sometimes data

Former Member — Fri, 08 Feb 2013 09:13:49 GMT

Whats more. I have a in one column data which has someting from around 200KB to around 800KB its binary data for image. And sometimes dbunload cut it to size of 512KB and my program cannot read that

Re: DBUnload cut sometimes data

MarkCulp — Fri, 08 Feb 2013 09:14:39 GMT

Please explain exactly what you mean by "it cut data"? How are you looking at the data? Perhaps an example table definition and sample output would help us understand what problem you are having.

Re: DBUnload cut sometimes data

Former Member — Sun, 10 Feb 2013 23:21:07 GMT

Are you are using a driver (eg ODBC) to connect to the database?

We saw a problem where for large results, the driver would truncate the data because it did not allocate enough memory to hold the complete result.

Is the data truncated when you run dbunload directly from the command line?

Re: DBUnload cut sometimes data

Former Member — Mon, 11 Feb 2013 02:37:56 GMT

Yes I'm using ODBC driver to connect to database, I think it is Sybase jConnect JDBC. Probably I didn't it use directly from command line because I need application to do this. The biggest problem is that on my instance of application dbunload started to work correctly however on the other one it fails. And I did nothing here. Any idea ?

Re: DBUnload cut sometimes data

VolkerBarth — Mon, 11 Feb 2013 07:19:06 GMT

I'd still recommend to use the exact command directly from the command line to see if that truncates data, too. (I have never ever run into this issue...).

IIRC, 11.0.1.2044 is the original 11.0.1 maintenance release and rather "old" nowadays, so you might as well try to use a current v11.0.1 EBF - cf. Breck's helpful EBF list here...

Re: DBUnload cut sometimes data

Former Member — Tue, 12 Feb 2013 08:01:58 GMT

I did unloaded database from command line then I reloaded it using dbisql from command line and data wasn't trucated at all. But I think on the other machine it would fail, but I will check this out soon. To point that out I changed nothing so far. I'll keep you informed if this is fixed.