FiveTech Support Forums

Hello,

I am having a strange problem running on a terminal server connecting to ADS on a Windows 2008 server. I am building index keys for a database and the system is only keeping the last index from each file, in the sample below, the only keys kept are txno+arcode TAG S6 in &Pdd.ropx01.cdx and txno+STR( invbal-recv, 12, 2 ) TAG SH in &Pdd.ropx02.cdx (DESCENDING). If I run the same exact process on Windows Server 2008, the search keys are built correctly.

Does anyone have any ideas what would cause this problem?

Thank you,

INDEX ON txno+ref TAG S1 TO &Pdd.ropx01.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON ref TAG S2 TO &Pdd.ropx01.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+ourref TAG S3 TO &Pdd.ropx01.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+bl TAG S4 TO &Pdd.ropx01.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+DTOS( refdate ) TAG S5 TO &Pdd.ropx01.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+arcode TAG S6 TO &Pdd.ropx01.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+ref TAG SA TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+DTOS( refdate ) TAG SB TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+ourref TAG SC TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+bl TAG SD TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+arcode TAG SE TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+STR( invbal, 12, 2 ) TAG S7 TO &Pdd.ropx02.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+STR( invbal, 12, 2 ) TAG SF TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+STR( recv, 12, 2 ) TAG S8 TO &Pdd.ropx02.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+STR( recv, 12, 2 ) TAG SG TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+STR( invbal-recv, 12, 2 ) TAG S9 TO &Pdd.ropx02.cdx
DBCLEARINDEX()
SysRefresh()
INDEX ON txno+STR( invbal-recv, 12, 2 ) TAG SH TO &Pdd.ropx02.cdx DESCENDING
DBCLEARINDEX()
SysRefresh()

viewtopic.php?f=3t=12534start=0#p63152

&&

Thank You, however that was a different issue related to the field length which exceeded the maximum. I am able to get search keys built on the server itself, but not on the terminal server.