SQLA Unable to load saved DB Tree -

Tools & Utilities

SQLA Unable to load saved DB Tree -


SQLA fails to load the saved DB tree when the table description has line breaks in it.

It throws:

SQLA Version:
System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
at Teradata.SQLA.MainFrm.LoadTreeData() in F:\ttu1311_efix_snap\tdcli\qman\sqla\MainFrm.vb:line 2368

It then truncates the DBTree.data file at that line (the first time you pull the tree it saves it fine, this error occurs on loading SQLA a later time).

Looking at the error, it appears that as the first symbol on the line is not a number then this function throws the exception.

Can provide details from DBTree.data if required.