Here is my dexsql.log after getting the error when trying to print a historical invoice. I changed some names to generic terms. Anyone see anything I don't? I'm installing some SP's this weekend, maybe that will help. So far I haven't had any instances from other users getting this error - just me.
/* Date: 04/20/2004 Time: 10:25:02
stmt(26548288):*/
SELECT TOP 25 ITEMNMBR,ITEMDESC,NOTEINDX,ITMSHNAM,ITEMTYPE,ITMGEDSC,STNDCOST,CURRCOST,ITEMSHWT,DECPLQTY,DECPLCUR,ITMTSHID,TAXOPTNS,IVIVINDX,IVIVOFIX,IVCOGSIX,IVSLSIDX,IVSLDSIX,IVSLRNIX,IVINUSIX,IVINSVIX,IVDMGIDX,IVVARIDX,DPSHPIDX,PURPVIDX,UPPVIDX,IVRETIDX,ASMVRIDX,ITMCLSCD,ITMTRKOP,LOTTYPE,KPERHIST,KPTRXHST,KPCALHST,KPDSTHST,ALWBKORD,VCTNMTHD,UOMSCHDL,ALTITEM1,ALTITEM2,USCATVLS_1,USCATVLS_2,USCATVLS_3,USCATVLS_4,USCATVLS_5,USCATVLS_6,MSTRCDTY,MODIFDT,CREATDDT,WRNTYDYS,PRCLEVEL,LOCNCODE,PINFLIDX,PURMCIDX,IVINFIDX,INVMCIDX,CGSINFLX,CGSMCIDX,ITEMCODE,TCC,PriceGroup,PRICMTHD,PRCHSUOM,SELNGUOM,KTACCTSR,LASTGENSN,ABCCODE,Revalue_Inventory,Tolerance_Percentage,Purchase_Item_Tax_Schedu,Purchase_Tax_Options,ITMPLNNNGTYP,STTSTCLVLPRCNTG,CNTRYORGN,DEX_ROW_ID FROM dbname.dbo.IV00101 WITH ( NOLOCK) WHERE ITEMNMBR = '3006' ORDER BY ITEMNMBR ASC
/* Date: 04/20/2004 Time: 10:25:02
stmt(26549872):*/
EXEC dbname.dbo.zDP_SOP60100SS_1 4, 'docnumber', 16384, 0
/* Date: 04/20/2004 Time: 10:25:03
stmt(26497400):*/
EXEC DYNAMICS.dbo.zDP_ACTIVITYSS_1 'company name.', 'userid'
/* Date: 04/20/2004 Time: 10:25:03
stmt(26501344):*/
EXEC DYNAMICS.dbo.zDP_SY02000SS_1 23, 'userid', 0, 2, 605
/* Date: 04/20/2004 Time: 10:25:03
stmt(26553640):*/
EXEC dbname.dbo.zDP_SOP40100SS_1 1
/* Date: 04/20/2004 Time: 10:25:03
stmt(26532296):*/
EXEC dbname.dbo.zDP_SY00700SS_1 'SOP_Print_Options'
/* Date: 04/20/2004 Time: 10:25:03
stmt(26501344):*/
EXEC dbname.dbo.zDP_SOP40300SS_1 7
/* Date: 04/20/2004 Time: 10:25:05
stmt(26547496):*/
EXEC dbname.dbo.zDP_SOP10104F_1 4,'docnumber','',4,'docnumber','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ'
/* Date: 04/20/2004 Time: 10:25:05
stmt(26546704):*/
EXEC dbname.dbo.zDP_SOP30200SS_1 'docnumber', 4
/* Date: 04/20/2004 Time: 10:25:05
stmt(26502136):*/
BEGIN UPDATE dbname.dbo.SOP30200 SET TIMESPRT = 4 WHERE SOPTYPE = 4 AND SOPNUMBE = 'docnumber' SELECT @@rowcount END
/* Date: 04/20/2004 Time: 10:25:05
stmt(26497400):*/
EXEC DYNAMICS.dbo.zDP_ACTIVITYSS_1 'company name.', 'userid'
/* Date: 04/20/2004 Time: 10:25:05
stmt(26502136):*/
EXEC DYNAMICS.dbo.zDP_SY02000SS_1 23, 'userid', 0, 2, 90
/* Date: 04/20/2004 Time: 10:25:06
stmt(26546704):*/
EXEC dbname.dbo.zDP_SOP30200SS_1 'docnumber', 4
/* Date: 04/20/2004 Time: 10:25:06
stmt(26502136):*/
EXEC dbname.dbo.zDP_SY01300SS_1 2, 0, 7163
/* Date: 04/20/2004 Time: 10:25:06
stmt(26502928):*/
EXEC DYNAMICS.dbo.zDP_SY01301L_1 NULL,NULL
/* Date: 04/20/2004 Time: 10:25:06
stmt(26503720):*/
EXEC dbname.dbo.zDP_SOP50200L_1 'userid',-2147483648,-32768,'',-2147483648,-32768,'','userid',2147483647,32767,'ÞÞÞÞÞÞÞÞÞÞÞ',2147483647,32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ'
/* Date: 04/20/2004 Time: 10:25:06
stmt(26555640):*/
BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY01301SI 1, 7163, 'userid', 0, 0, 0, 0, 0, 0.00000, 2, '', 2, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 23, 'company name.', @num OUT SELECT @num END
/*
/* Date: 04/20/2004 Time: 10:25:09
SQLSTATE

01000) Native Err

5701) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.*/
/*
/* Date: 04/20/2004 Time: 10:25:09
SQLSTATE

01000) Native Err

5703) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.*/
/*
/* Date: 04/20/2004 Time: 10:25:09
SQLSTATE

00000) Native Err

5703) stmt(0):*/
*/
/*
/* Date: 04/20/2004 Time: 10:25:09
SQLSTATE

00000) Native Err

5703) status(0):*/
SWSTATUS DUMP*/
/* Date: 04/20/2004 Time: 10:25:09
stmt(26555640):*/
if exists(select value from master.dbo.syscurconfigs where config = 1123 and (value = 40 or value = 50)) SELECT char(255) 'C1',255 'C2' else exec master..smDEX_Max_Char
/* Date: 04/20/2004 Time: 10:25:09
stmt(26502136):*/
BEGIN SET DATEFORMAT ymd
SET NOCOUNT ON
SET CURSOR_CLOSE_ON_COMMIT OFF
SET ANSI_NULLS OFF
SET ANSI_WARNINGS OFF
SET ANSI_NULL_DFLT_ON ON
SET ANSI_PADDING OFF
SET NUMERIC_ROUNDABORT OFF
END
/* Date: 04/20/2004 Time: 10:25:11
stmt(26502136):*/
EXEC DYNAMICS.dbo.zDP_SY01301SS_1 1
/* Date: 04/20/2004 Time: 10:25:11
stmt(26553640):*/
EXEC dbname.dbo.zDP_SOP50200L_1 'userid',2,-32768,'',-2147483648,-32768,'','userid',2,32767,'ÞÞÞÞÞÞÞÞÞÞÞ',2147483647,32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ'
/* Date: 04/20/2004 Time: 10:25:11
stmt(26500552):*/
EXEC dbname.dbo.zDP_SOP50300L_1 'userid',2,'',-32768,-32768,'',-2147483648,-2147483648,-2147483648,'userid',2,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ',32767,32767,'ÞÞÞÞÞÞÞÞÞÞÞ',2147483647,2147483647,2147483647
/* Date: 04/20/2004 Time: 10:25:11
stmt(26501344):*/
BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY01301SD 1, @num OUT, 0, 'DYNAMICS.dbo.SY01301' SELECT @num END
/* Date: 04/20/2004 Time: 10:25:12
stmt(26536000):*/
EXEC dbname.dbo.zDP_MC40500SS_1 'userid', 3, 'RM_Transaction_InquiryDoc'
/* Date: 04/20/2004 Time: 10:25:12
stmt(26493080):*/
DROP TABLE ##1971024
thanks,
Barb
Thanks!
Barb E.