Dynamics Community Forum Thread Details

Error message 10232 when hitting F3 on reference number in screen 03020

We havea customer that is running Dynamics SL 11 FP1. When the user opens screen Quick Invoices and prepayments (03.020.00) and hits F3 on the Reference number field, the system sends the following error message:

System message 10232

Assertion failure!

File: sqlodbc.cpp

Line: 3907

Expression: strlen(paramname)>0

Hit OK to stop program, and report the error to Solomon Software, noting the failed expression, file name and line number.

After hitting OK, another message appear:

System message 10093

Parameter name does not exist:

Debugging info: sqlsubst Cursosr(82) select apdoc.refnbr,apdoc.doctype,apdoc.venid, apd

Optional info: ='%'

Hitting OK again, another message pop up:

Programming Bulletproof error 10105

Error in setsqlparm. Sql instruction has less parameters that expected. Text SQL:

[Select apdoc.refnbr,apdoc.doctype,apdoc.vendid,apdoc.invcnbr, apdoc.ponbr,apdoc.origdocamt, apdoc.batnbr from apdoc WITH (NOLOCK) where docclass=@parm1 and (apdoc.doctype='vo' or apdoc.doctype='pp') and apdoc.refnbr like @parm2 and status <> 'v' order by refnbr desc OPTION(FAST 500)]

and after click OK again, it opens the Possible values screen but it's complety empty.

Finally when you click on Acept, the original screen(03.020.00) is completely frezzed out and we have to close it.

If we try to type a refnbr directly into the Refnbr field, the screen populates with the info of the reference typed.

I did check the PVrec for the refnbr and it looks the same as the original PVRec in the csv carpet under the DB.

Any ideas why is this happening and how can we correct this situation?

Regards

Quick Links