Sometimes in GIFTS, I get an error like: 'Error occurred while executing SQL Statement: DUMP TRAN gifts WITH NO_LOG
Technical Support Info: [SQLExecute] Error #3146 ODBC Call failed.'
Technical Support Info: [SQLExecute] Error #-2147217900 [Microsoft][ODBC SQL Server Driver][Sql Server] Incorrect syntax near the keyword 'TRAN'
It only occurs when I perform certain actions that generate a large number of database transactions, such as the creation of new codes or the running of a recalculation utility:
This error can occur if GIFTS attempts to dump the SQL transaction log but cannot because the GIFTS database login does not have the permissions needed to do so. To resolve this error, please follow the following:
Log in to the Administrator Module and select Setup > Preferences .
De-select the option to Dump Transactions during Batch Procedures .