Teradata Meta Data Services Metaload Error

Tools
N/A

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,defaultDB=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=5300790073005F00430061006C0065006E006400610072000000

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,useUTF16=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,defaultDB=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

1 REPLY
Teradata Employee

Re: Teradata Meta Data Services Metaload Error

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.