KBI 311317 Export Master Control Information Fails With Could Not Export ODBC Table
Version
Argent AT – All Versions
Date
Tuesday, 1 December 2015
Summary
With an Argent Architecture of Mother – Daughter the ‘Export Master Control Information’ may fail with ‘Could Not Export ODBC Table’ causing the Control Information not to update to Daughter Engine
Technical Background
When the ‘Export Master Control Information’ fails with:
Export program fails with exit code 1 (Could not export ODBC table ‘ARGSOFT_ARGENT_GUARDIAN_ULTRA_MONITOR_RULE’ to XML file)
It is found that a Rule has data larger than the value specified in the Windows Registry key ODBC_TXTBUF_IN_KB, default 32 (Kbytes)
To confirm the exception is infact data truncation, run the following command
Executing: ARGSOFT_ARGENT_GUARDIAN_ULTRA_MOTHER_EXPORT.EXE
From directory: C:\ARGENT\ARGENTGUARDIANULTRA
Outputs:
***** ERROR ***** An error condition has been detected by ArgSoft_DAL_XML.cpp (D6350_Dump_Table_RS) at line 1062: DAL could not successfully export the record set. Microsoft Error Code = Data truncated..
Could not dump out ODBC table ‘ARGSOFT_ARGENT_GUARDIAN_ULTRA_MONITOR_RULE’ to XML file ‘C:\Argent\ArgentGuardianUltra\DATA\XML\ARGSOFT_ARGENT_GUARDIAN_ULTRA_MONITOR_RULE.xml’
Could not export ODBC table ‘ARGSOFT_ARGENT_GUARDIAN_ULTRA_MONITOR_RULE’ to XML file
Resolution
Increase the Windows Registry key ODBC_TXTBUF_IN_KB from the default 32 to a larger value, 128 to 512 would be fine
In version 3.1A-1501-A and above, the key is in HKLM\SOFTWARE\ARGENT\COMMON
Before that the key can be found in:
HKLM\SOFTWARE\Wow6432Node\Argent\ARGENT_GUARDIAN_ULTRA
Or
HKLM\SOFTWARE\Argent\ARGENT_GUARDIAN_ULTRA
Refer:
KBI 311128 New Feature: Single Argent AT Global System Registry For SQL Server Parameters