We've installed the "SQL Assistant 13.10.0.05", but when we want to view the history window this is disabled.
Some web sites told us we need to run the AccessDataBaseEngine.exe and we did it, but It didn't work.
Could you help us with this?
After SQL Assistant (SQLA) v14.0 is updated, the History from the previous version is not automatically inserted to the SQLA History table created in Version 14.0. Because of this condition, the following manual work-around can be used, if recovery of the SQLA history is desired. Note: Your prior SQLA version’s history list has not been lost. J
INSERT INTO newhist (
EndDate, Source, Elapsed, RowCnt, ErrCd, Msg, Notes,
StmtCnt, StmtType, SQLType,
DBSTime, FetchTime, Seq
[RUNDATE]+[RUNTIME] AS Expr4,
Format([ELTIME],"hh:nn:ss"".000""") AS Expr5,
0 AS Expr1,
0 AS Expr2,
' ' AS Expr3,
Format([DBMSTIME]," hh:nn:ss"".000""") AS Expr6,
Format([FETCHTIME]," hh:nn:ss"".000""") AS Expr7,
[QTCOUNTER]-(SELECT MIN(QTCOUNTER) FROM oldhist )
+1+(SELECT MAX(Seq) FROM oldhist ) AS Expr8
Perform SQL Run (about to append old history to new history)
Click on the “! Run” icon as in the screen below . The “Enter Parameter Value”, “Seq” panel will come up. Enter the number of records + “1” found in the “newhist” table into the Seq field. This will cause the Surrogate Sequential number for the records appended to newhist, to start at the current number of records in newhist + “1”. E.g., if newhist contains 100 records, then the first Sequential number of the records appended will be “101”.
Enter the newhist number of records + 1. Click OK. The SQL will run.
Validate SQL Run: The SQL may either run or fail with an error message. However, if there is no error message, it will not report back when complete. Wait 5-10 seconds and observe the content of newhist
Verify Content of “newhist” table link: After running the SQL, open the newhist table and all of both the old and new entries should be present. The number of records should equal the total of the oldhist records + the newhist records, that existed before running the SQL.
This ends the process to recover the Old History of SQL Assistant, by merging to the current history.
Verify the SQL History under SQL Assistant
If SQL Assistant is open, then close it. In any event, open/re-open SQL Assistant. It may require 10-15 seconds, as the updated history is accessed. Prior to your logging into one of the Teradata servers, the updated history will appear, e.g. as shown below:
This is the End of Recovering SQL Assistant History Instructions