Open operation on table XXXX failed because the path does not exist

[barbola]

Since yesterday sometimes when I go into Transactions > Sales > Sales Trx Entry, I'm getting this error "An open operation on table 'IV_Cost_Variance_TEMP' failed because the path does not exist.

When I do a lookup and select a sales invoice, I get the same error with table SOP_Report_TEMP so I have to manually enter the document number.

Then when I try to print, I get the same error on table SOP_Document_TEMP.

Nobody else is getting these errors, and I dont' get them all the time. I can still do what I want to do in the system. The only documentation on Customer Source refers to Pervasive and we are on SQL2000.

Nothing out of the ordinary shows up on a dexsql log file.

thanks,
Barb

Thanks!
Barb E.

 

[winthropdc]

Please turn on DEXSQL.LOG logging. Add or change the following DEX.INI settings.

SQLLogSQLStmt=TRUE
SQLLogODBCMessages=TRUE
SQLLogAllODBCMessages=TRUE

I am interested to see if you are getting Collation errors which is why the TEMP tables are failing.

If you run this command it will check the Collation for your Server, DYNAMICS, Master and TWO DBs. You could also check your Company DB.

select @@servername, serverproperty( 'Collation')
union all
select 'DYNAMICS', databasepropertyex( 'DYNAMICS','Collation')
union all
select 'TWO', databasepropertyex( 'TWO','Collation')
union all
select 'master', databasepropertyex( 'master','Collation')

SQL 2000 allows a different collation per database, but GP can only function when the Server, Master and GP databases are all the same collation. The reason is that the TempDB has the same collation as the Master DB and so when temporary tables are used, the join commands to the temporary tables from the GP databases only works when the collations of the databases are the same.

If this is the issue we need to look at changing the Master db using the REBUILDM.EXE command.

David Musgrave
Senior Development Consultant
MBS Services - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

mailto:dmusgrav@nospam-microsoft.com

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.

 

[barbola]

The results of the query has 2 columns. One is the db name the other is:

SQL_Latin1_General_CP1_CI_AS

This shows for all db's.

I actually got no results from the dexsql.log but I will try again right from the time I log in to getting the error, and logging out again.

(and we don't have a TWO database anymore - it was of no use to us so we did not recreate it when we went to 7.5)

thanks.


Thanks!
Barb E.

 

[barbola]

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
SQLSTATE01000) Native Err5701) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'master'.*/
/*
/* Date: 04/20/2004 Time: 10:25:09
SQLSTATE01000) Native Err5703) stmt(0):*/
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.*/
/*
/* Date: 04/20/2004 Time: 10:25:09
SQLSTATE00000) Native Err5703) stmt(0):*/
*/
/*
/* Date: 04/20/2004 Time: 10:25:09
SQLSTATE00000) Native Err5703) 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.