All Forums Tools
dhvien 1 post Joined 09/14
14 Nov 2014
Teradata Meta Data Services Metaload Error

Hi,
I'm brand new to the Teradata world/forum so go easy on me!
I've been having issues with the Metaload Utility while running it with an UTF16 connection. We were able to use Metaload before when we created the MDS Views in the DBC while connecting with ASCII, but policy prefers that we avoid created the views in DBC.
Let me know if more information is needed, thanks!
http://forums.teradata.com/forum/database/meta-data- services-using-views-within-dbc#comment-6524 (Source: You don't have to have MDS Views in DBC)
Log file below:
11/14/2014 09:59:24|PID-2020|THREAD- 2480|5|GetDatabaseRegistryInfo    ENTER
11/14/2014 09:59:24|PID-2020|THREAD-2480|5|MDSDecryptPassword [Result=S_OK]
11/14/2014 09:59:24|PID-2020|THREAD- 2480|5|GetDatabaseRegistryInfo returns status=S_OK, dsn=SysDSN, user=P1MDSService, dbname=MDSp2
11/14/2014 09:59:24|PID-2020|THREAD-2480|5|CDBAccess:: DBConnect(num=1,dsn=SysDSN,user=P1MDSService,mode=1,de faultDB=MDSp2,sessionCharSet=UTF16,runQuiet=1) ENTER
11/14/2014 09:59:24|PID-2020|THREAD-2480|5|CDBAccess::DBConnect: Connecting to database (DSN, user) (SysDSN, P1MDSService)
11/14/2014 09:59:24|PID-2020|THREAD-2480|5|CDBAccess::DBConnect: Connect string = (dsn=SysDSN;uid=P1MDSService;SessionMode=Teradata; DateTimeFormat=IAA;DefaultDatabase=MDSp2; UseIntegratedSecurity=N;Reconnect=Y;CharSet=UTF16; QUIETMODE=YES;pwd=*)
11/14/2014 09:59:24|PID-2020|THREAD-2480|5|CDBAccess::DBConnect - connectionID=[2480/1/1]
11/14/2014 09:59:28|PID-2020|THREAD-2480|5|CDBAccess::DBConnect - SQLDriverConnect successful
11/14/2014 09:59:28|PID-2020|THREAD-2480|5|CDBAccess:: AllocStmtHandle: allocated statement handle = 0x027c8880, connection=0x00f3f210
11/14/2014 09:59:28|PID-2020|THREAD-2480|5|DBSetTxMode: set SQL_ATTR_AUTOCOMMIT = ON for conn=0
11/14/2014 09:59:28|PID-2020|THREAD-2480|5|CDBAccess::RunSql: Before SQLExecDirect Stmt=0x027c8880, Conn=0, ID=[2480/1/1], len=12, SQL=HELP SESSION
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess::RunSql: After SQLExecDirect
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: SetupResultsTable returns status=S_OK, 1 rows in spool file, 1 rows in result set, 1 rows per fetch, fetch UTF16=0, format=0
11/14/2014 09:59:29|PID-2020|THREAD-2480|2|CDBAccess:: GetSessionCharacterSet - could not find column 'Character Set'
11/14/2014 09:59:29|PID-2020|THREAD-2480|2|CDBAccess:: GetSessionCharacterSet returns META_E_DBACCESS_ERROR
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess::DBConnect: Database connect failed (DSN, user) (SysDSN, P1MDSService), result=8000701B
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect ENTER
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect: freeing statement# 0 for connectionID=[2480/1/1]
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect: Calling SQLDisconnect for Conn 0, connectionID = [2480/1/1]
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect [Result=S_OK]
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect   EXIT
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess::DBConnect [Result=META_E_DBACCESS_ERROR]
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect ENTER
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect   EXIT
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CMetaLoadDB:: CanRunInUnicodeMode - use Unicode=NO, status=S_OK
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess::~CDBAccess ENTER
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect ENTER
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect   EXIT
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess::~CDBAccess  EXIT
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess::~CDBAccess ENTER
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect ENTER
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect   EXIT
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CDBAccess::~CDBAccess  EXIT
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: LoadDBSchema(System=IDW_P1, InvokedByMetaMgr=No, Resync=No, ForceReeval=No, QuickLoad=Not Set)  ENTER
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: LoadDBSchema: lDataMemberCounter=8, METALOAD_DATA_MEMBER_MODIFY_COUNTER=8
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload: Kanji Process = NO, LANG = not used on Windows
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=1, calledByMM=0)
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C00440042003E000000
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C00440042003E00
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=5300590053005500440054004C00490042000000
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 5300590053005500440054004C0049004200
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CMetaLoadDB:: ExtractDatabaseNames - read DB='SYSUDTLIB'
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C002F00440042003E000000
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C002F00440042003E00
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames - name list includes SYSUDTLIB
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C00440042003E000000
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C00440042003E00
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=540044005F0053005900530046004E004C00490042000000
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 540044005F0053005900530046004E004C0049004200
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|CMetaLoadDB:: ExtractDatabaseNames - read DB='TD_SYSFNLIB'
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C002F00440042003E000000
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C002F00440042003E00
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C00440042003E000000
11/14/2014 09:59:29|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=4400420043000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 440042004300
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|CMetaLoadDB:: ExtractDatabaseNames - read DB='DBC'
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C002F00440042003E000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C002F00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C00440042003E000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=530079007300410064006D0069006E000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 530079007300410064006D0069006E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|CMetaLoadDB:: ExtractDatabaseNames - read DB='SysAdmin'
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C002F00440042003E000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C002F00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C00440042003E000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=5300790073004400420041000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 530079007300440042004100
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|CMetaLoadDB:: ExtractDatabaseNames - read DB='SysDBA'
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C002F00440042003E000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C002F00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C00440042003E000000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=5300790073005F00430061006C0065006E00640061007200 0000
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 5300790073005F00430061006C0065006E00640061007200
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|CMetaLoadDB:: ExtractDatabaseNames - read DB='Sys_Calendar'
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile - input=3C002F00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 3C002F00440042003E00
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ReadDatabaseFile(firstLine=0, calledByMM=0)
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 6 Unique DB names were found in FILE='D:\Apps\Teradata_MDS\scripts\DBCMeta.txt'
11/14/2014 09:59:30|PID-2020|THREAD-2480|5|metaload:: ExtractDatabaseNames: 0 Duplicate DB names were found in FILE='D:\Apps\Teradata_MDS\scripts\DBCMeta.txt'
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|metaload - using Unicode DLL
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CChannel::CChannel() Entering API.
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CChannel:: InitMembers() Entering API.
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CSkeletonChannel:: CSkeletonChannel(HENV)()    ENTER
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CMetaStorage:: SInitialize(verify=1,useUTF16=0,MDS Version=14.10.00) ENTER
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CMetaTransaction: STxSetDefaultLocking - setting default locking to ACCESS, conn=0
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CDBAccess:: DBSetSessionDefaultLocking(bAccess=1, conn=0)   ENTER
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CDBAccess:: DBSetSessionDefaultLocking [Result=S_OK]
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CMetaTransaction:: STxInitialize(dsn=<null>,user=<null>,RunQuiet=0,useUTF 16=0)   ENTER
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CMetaTransaction:: ConnectToDatabase(dsn=<null>,user=<null>)   ENTER
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|MDSDecryptPassword [Result=S_OK]
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CDBAccess:: DBConnect(num=2,dsn=SysDSN,user=P1MDSService,mode=1,de faultDB=MDSp2,sessionCharSet=(null),runQuiet=0) ENTER
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CDBAccess::DBConnect: Connecting to database (DSN, user) (SysDSN, P1MDSService)
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CDBAccess::DBConnect: Connect string = (dsn=SysDSN;uid=P1MDSService;SessionMode=Teradata; DateTimeFormat=IAA;DefaultDatabase=MDSp2; UseIntegratedSecurity=N;Reconnect=Y;pwd=*)
11/14/2014 09:59:31|PID-2020|THREAD-2480|5|CDBAccess::DBConnect - connectionID=[2480/3/1]
11/14/2014 09:59:33|PID-2020|THREAD-2480|5|CDBAccess::DBConnect - SQLDriverConnect successful
11/14/2014 09:59:58|PID-2020|THREAD-2480|5|CDBAccess:: AllocStmtHandle: allocated statement handle = 0x027dff60, connection=0x00f3f720
11/14/2014 09:59:58|PID-2020|THREAD-2480|5|CDBAccess:: DBSetSessionDefaultLocking(bAccess=1, conn=0)   ENTER
11/14/2014 09:59:58|PID-2020|THREAD-2480|4|CDBAccess:: GetTeradataVersion: version='14.10.0210  14.10.02.10'
11/14/2014 09:59:58|PID-2020|THREAD- 2480|5|CategorizeODBCTeradataVersion returns 141000
11/14/2014 09:59:58|PID-2020|THREAD-2480|5|CDBAccess::RunSql: Before SQLExecDirect Stmt=0x027dff60, Conn=0, ID=[2480/3/1], len=75, SQL=SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
11/14/2014 09:59:58|PID-2020|THREAD-2480|5|CDBAccess::RunSql: After SQLExecDirect
11/14/2014 09:59:58|PID-2020|THREAD-2480|5|CDBAccess:: DBSetSessionDefaultLocking [Result=S_OK]
11/14/2014 09:59:58|PID-2020|THREAD-2480|5|DBSetTxMode: set SQL_ATTR_AUTOCOMMIT = ON for conn=0
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::RunSql: Before SQLExecDirect Stmt=0x027dff60, Conn=0, ID=[2480/3/1], len=93, SQL=LOCKING ROW FOR ACCESS SEL infodata FROM DBC.dbcinfoV WHERE infokey = 'LANGUAGE SUPPORT MODE'
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::RunSql: After SQLExecDirect
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess:: SetupResultsTable returns status=S_OK, 1 rows in spool file, 1 rows in result set, 1 rows per fetch, fetch UTF16=1, format=0
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess:: GetKanjiState: bIsKanji = FALSE
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::DBConnect: Connect string = (dsn=SysDSN;uid=P1MDSService;SessionMode=Teradata; DateTimeFormat=IAA;DefaultDatabase=MDSp2; UseIntegratedSecurity=N;Reconnect=Y;pwd=*)
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::DBConnect - connectionID=[2480/3/2]
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::DBConnect - SQLDriverConnect successful
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess:: AllocStmtHandle: allocated statement handle = 0x027d7e18, connection=0x027d7b38
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|DBSetTxMode: set SQL_ATTR_AUTOCOMMIT = ON for conn=1
11/14/2014 09:59:59|PID-2020|THREAD-2480|4|CDBAccess:: GetTeradataVersion: version='14.10.0210  14.10.02.10'
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::DBConnect - PreTeradata12 = NO
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::DBConnect [Result=S_OK]
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CMetaStorage:: ConnectToDatabase [Result=S_OK]
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CMetaTransaction:: STxInitialize [Result=S_OK]
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess:: GetSessionDatabaseName returns 'MDSP2'
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CMetaStorage:: SInitialize - repository database = 'MDSP2'
11/14/2014 09:59:59|PID-2020|THREAD-2480|4|CDBAccess:: GetODBCDriverVersion: version=14.10.00.02
11/14/2014 09:59:59|PID-2020|THREAD- 2480|5|ValidateODBCDriverVersion [Result=S_OK]
11/14/2014 09:59:59|PID-2020|THREAD-2480|4|CDBAccess:: GetTeradataVersion: version='14.10.0210  14.10.02.10'
11/14/2014 09:59:59|PID-2020|THREAD- 2480|5|ReformatODBCTeradataVersion(14.10.0210  14.10.02.10) returns '14.10.0210  14.10.02.10', status=S_OK
11/14/2014 09:59:59|PID-2020|THREAD- 2480|5|CategorizeODBCTeradataVersion returns 141000
11/14/2014 09:59:59|PID-2020|THREAD- 2480|5|ValidateODBCTeradataVersion [Result=S_OK]
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CMetaStorage:: SInitialize - U& form allowed = YES
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::RunSql: Before SQLExecDirect Stmt=0x027dff60, Conn=0, ID=[2480/3/1], len=82, SQL=LOCKING ROW FOR ACCESS SEL Version, MetamigrateProgress FROM metaroot WHERE loid=1
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::RunSql: After SQLExecDirect
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess:: SetupResultsTable returns status=S_OK, 1 rows in spool file, 1 rows in result set, 1 rows per fetch, fetch UTF16=0, format=0
11/14/2014 09:59:59|PID-2020|THREAD-2480|4|CMetaStorage:: SInitialize: MDS Repository Version = 14100000
11/14/2014 09:59:59|PID-2020|THREAD-2480|5|CDBAccess::RunSql: Before SQLExecDirect Stmt=0x027dff60, Conn=0, ID=[2480/3/1], len=122, SQL=LOCKING ROW FOR ACCESS SEL VersioningSupport, RetainBusinessInformation, RepositoryUsesFallback FROM metaroot WHERE loid=1
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::RunSql: After SQLExecDirect
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: SetupResultsTable returns status=S_OK, 1 rows in spool file, 1 rows in result set, 1 rows per fetch, fetch UTF16=1, format=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|4|CMetaStorage:: SInitialize: VersioningSupport = DATA VERSIONING ACTIVE
11/14/2014 10:00:00|PID-2020|THREAD-2480|4|CMetaStorage:: SInitialize: RetainBusinessInformation = 0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SInitialize: RepositoryUsesFallback = D: default, no fallback clause on CREATE TABLE
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SCopyMetaLockorderingsTable ENTER
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|DBSetTxMode: set SQL_ATTR_AUTOCOMMIT = OFF for conn=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SCheckDatabase MainTXMode=OFF txDepth=0 chkKeepAlive=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaTransaction:: STxBegin: Opening new transaction on logical connection 0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaTransaction:: STxBegin - txDepth = 1
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::RunSql: Before SQLExecDirect Stmt=0x027dff60, Conn=0, ID=[2480/3/1], len=77, SQL=LOCKING metalockingorder FOR ACCESS SEL loid, lockorder FROM metalockingorder
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::RunSql: After SQLExecDirect
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: SetupResultsTable returns status=S_OK, 146 rows in spool file, 146 rows in result set, 146 rows per fetch, fetch UTF16=0, format=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaTransaction:: GetResultRows: # rows retrieved=146
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SCommit(error=0)   ENTER
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SCheckDatabase MainTXMode=OFF txDepth=1 chkKeepAlive=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaTransaction:: AttemptCommitRollback: Committing transaction 0 on logical connection 0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::DBCommit: SQLEndTran(Commit) successful on connection=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage::SCommit [Result=S_OK]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SCopyMetaLockorderingsTable [Result=S_OK]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::RunSql: Before SQLExecDirect Stmt=0x027dff60, Conn=0, ID=[2480/3/1], len=12, SQL=HELP SESSION
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::RunSql: After SQLExecDirect
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: SetupResultsTable returns status=S_OK, 1 rows in spool file, 1 rows in result set, 1 rows per fetch, fetch UTF16=0, format=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|2|CDBAccess:: GetSessionCharacterSet - could not find column 'Character Set'
11/14/2014 10:00:00|PID-2020|THREAD-2480|2|CDBAccess:: GetSessionCharacterSet returns META_E_DBACCESS_ERROR

11/14/2014 10:00:00|PID-2020|THREAD-2480|2|CDBAccess:: GetSessionCharacterSet - could not find column 'Character Set'
11/14/2014 10:00:00|PID-2020|THREAD-2480|2|CDBAccess:: GetSessionCharacterSet returns META_E_DBACCESS_ERROR
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SCommit(error=0)   ENTER
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage::SCommit - no existing transaction
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage::SCommit [Result=S_OK]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: SInitialize [Result=META_E_DBACCESS_ERROR]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: ~CMetaStorage  ENTER
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage::Finish ENTER
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage::Finish [Result=S_OK]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CMetaStorage:: ~CMetaStorage  EXIT
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::~CDBAccess ENTER
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect ENTER
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect: freeing statement# 0 for connectionID=[2480/3/1]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::Rollback: SQLEndTran(Rollback) called for connection=0
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess::Rollback [Result=S_OK]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect: Calling SQLDisconnect for Conn 0, connectionID = [2480/3/1]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect [Result=S_OK]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect: freeing statement# 0 for connectionID=[2480/3/2]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect: Calling SQLDisconnect for Conn 1, connectionID = [2480/3/2]
11/14/2014 10:00:00|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect [Result=S_OK]
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|CDBAccess:: DBDisconnect   EXIT
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|CDBAccess::~CDBAccess  EXIT
11/14/2014 10:00:01|PID-2020|THREAD-2480|2|CSkeletonChannel:: Setup() Could not connect to the repository - dropping engine object
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|CSkeletonChannel:: Setup()    EXIT
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|CSkeletonChannel:: CSkeletonChannel(HENV)()    EXIT
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessReferencingModifiedObjsList    ENTER
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessReferencingModifiedObjsList [Result=S_OK]
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessFunctionCallFunctions(size=0)   ENTER
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessFunctionCallFunctions   EXIT
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessUnsyncedObjectsList    ENTER
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessUnsyncedObjectsList [Result=S_OK]
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessFinalDatabasesList ENTER
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload::Final list of databases
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload::Final list of out-of-sync databases
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessDelayedAddRemoveLabel [Result=S_OK]
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: WriteSQLBuf(ML_WRITEBUF)
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ProcessFinalDatabasesList [Result=S_OK]
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ChildProcessCleanup  ENTER
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: ChildProcessCleanup returns S_OK
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload::Cleanup  ENTER
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|CSkeletonChannel:: ~CSkeletonChannel() ENTER
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|CSkeletonChannel:: ~CSkeletonChannel() EXIT
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload:: CloseLogFile
11/14/2014 10:00:01|PID-2020|THREAD-2480|5|metaload::Cleanup  EXIT

Triton 18 posts Joined 05/08
21 Jan 2015

This was identified to be a problem between the Teradata DBS 14.10.xx and the 14.10 ODBC driver for Teradata where column information returned was being truncated. A workaround is to use Release 14.00 of the ODBC Driver for Teradata if possible, but generally all TTU components should be changed as group to assure compatibility.

You must sign in to leave a comment.