sqlunload: quotify.c:38: quotify: Assertion `bufle

Attempting to use myexport to test migration of a database; however sqlunload fails for every take unload. [informix@argus UNLOAD]$ myexport testdb Building schema file ... Waiting for data exports to complete... Database selected. 0 row(s) unloaded. Database closed. [informix@argus UNLOAD]$ cat testdb.exp/xrefr00367.unl.out sqlunload: quotify.c:38: quotify: Assertion `buflen > len' failed. ksh: line 98: 18969: Abort(coredump)

This looks like a problem in sqlcmd code. I will take a look, but hopefully Jonathan can join the conversation. As for testing myexport, you can try adding the -E option which uses dbaccess and external tables (assuming your engine is 11.50 or later) instead of sqlunload. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 28, 2016 at 9:39 AM, Adam Tauno Williams < awilliam@whitemiceconsulting.com> wrote: > Attempting to use myexport to test migration of a database; however > sqlunload fails for every take unload. > > [informix@argus UNLOAD]$ myexport testdb > Building schema file > .... > Waiting for data exports to complete... > Database selected. > 0 row(s) unloaded. > Database closed. > > [informix@argus UNLOAD]$ cat testdb.exp/xrefr00367.unl.out > sqlunload: quotify.c:38: quotify: Assertion `buflen > len' failed. > ksh: line 98: 18969: Abort(coredump) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a113c6c7688f8d90538b25edf

Adam: The comments in Jonathan's code in quotify.c suggest that the SQL passed in from myexport may have unbalanced quote characters in it. Can you uncomment the following two lines in myexport, rerun it, and send me the output: # strn=sprintf( "FMT=%s\\ ", FMT ); # Just for debugging # printf "%s\\ ", strn; # Just for debugging Let's see if I've introduced a bug in the most recent release. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Thu, Jul 28, 2016 at 9:39 AM, Adam Tauno Williams < awilliam@whitemiceconsulting.com> wrote: > Attempting to use myexport to test migration of a database; however > sqlunload fails for every take unload. > > [informix@argus UNLOAD]$ myexport testdb > Building schema file > .... > Waiting for data exports to complete... > Database selected. > 0 row(s) unloaded. > Database closed. > > [informix@argus UNLOAD]$ cat testdb.exp/xrefr00367.unl.out > sqlunload: quotify.c:38: quotify: Assertion `buflen > len' failed. > ksh: line 98: 18969: Abort(coredump) > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a1144c0d6cd3d6b0538b28394