Data migration of large Sybase tables may cause TEMPDB errors

Problem: During data migration of a large Sybase table using SSMA 5.x for Sybase ASE, the following error may occur: “Can’t allocate space for object ‘temp worktable’ in database ‘tempdb’ because ‘system’ segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to…

0

‘Login Failed’ ERRORLOG message from SSMA 5.1 for Oracle’s sequence emulator

Problem: Sporadically, the SSMA 5.1 Oracle sequence emulator causes login failure (Error: 18456, Severity: 14, State: 8) error messages to be written to the SQL Server ERRORLOG when used from an application using SQL authentication.   Steps to reproduce the problem: After migrating an Oracle sequence to SQL Server 2008R2, where the SQL Server target…

2