Schema definition
Posted: Tue Sep 25, 2007 11:28 am
Hi,
I am trying to import the metadata from oracle using orch schema definition from ds manager. But I got the following error messages.
Can anyone help me out with this.
** Error executing command: orchdbutil show GMCC.EX -dbtype oracle -server DEVOTD -dboptions *********
##I TFCN 000001 13:12:04(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 13:12:04(001) <main_program> The open files limit is 100; raising to 4096.
##I TCDB 000003 13:12:05(000) <main_program> Oracle: loaded
##I TCDU 000009 13:12:05(001) <main_program> Database connect options: dbname= <unspecified>, server='DEVOTD', dboptions='{user=gmcc,password=gmcc}'.
##I TCDU 000005 13:12:05(002) <main_program> Database connect options: dbname= <unspecified>, server='DEVOTD', dboptions='{user=gmcc,password=gmcc}'DB type 'oracle' presumed to be oracle.
##F TUXX 000002 13:12:15(000) <main_program> Internal Error: (colDesc):orautils.C: 1714: getColDesc failed.
Traceback: [6] APT_FatalPath::msgAssertion(0xfcfbacff, 0xffbe72a0, 0xfcfbad07, 0x6b2, 0x0, 0xccc70), at 0xfe6dad18
[7] APT_OraUtils::querySchema(0x0, 0xfcfdd2e0, 0xffbe7230, 0xffbe7380, 0xffbe738c, 0xfcfd5498), at 0xfcf23dc0
[8] APT_OraUtils::tableSchema(0xffbec9c4, 0x145180, 0xff4c0, 0xffbee664, 0x0, 0xfcf23724), at 0xfcf23644
[9] APT_ORCHESTRATE_main(0x9, 0xffbeef0c, 0x0, 0x0, 0x1003f0, 0x9), at 0x206a8
[10] APT_PMconductorMain(0x14008, 0xffbeec2c, 0x4, 0xff2138b8, 0xffbeec10, 0xffbeeae4), at 0xfedd6908
[11] APT_SharedMain(0x9, 0xffbeef30, 0x14008, 0x9, 0xf, 0xffbeee54), at 0xfee0b220
detaching from process 15298
Thanks in advance.
I am trying to import the metadata from oracle using orch schema definition from ds manager. But I got the following error messages.
Can anyone help me out with this.
** Error executing command: orchdbutil show GMCC.EX -dbtype oracle -server DEVOTD -dboptions *********
##I TFCN 000001 13:12:04(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 13:12:04(001) <main_program> The open files limit is 100; raising to 4096.
##I TCDB 000003 13:12:05(000) <main_program> Oracle: loaded
##I TCDU 000009 13:12:05(001) <main_program> Database connect options: dbname= <unspecified>, server='DEVOTD', dboptions='{user=gmcc,password=gmcc}'.
##I TCDU 000005 13:12:05(002) <main_program> Database connect options: dbname= <unspecified>, server='DEVOTD', dboptions='{user=gmcc,password=gmcc}'DB type 'oracle' presumed to be oracle.
##F TUXX 000002 13:12:15(000) <main_program> Internal Error: (colDesc):orautils.C: 1714: getColDesc failed.
Traceback: [6] APT_FatalPath::msgAssertion(0xfcfbacff, 0xffbe72a0, 0xfcfbad07, 0x6b2, 0x0, 0xccc70), at 0xfe6dad18
[7] APT_OraUtils::querySchema(0x0, 0xfcfdd2e0, 0xffbe7230, 0xffbe7380, 0xffbe738c, 0xfcfd5498), at 0xfcf23dc0
[8] APT_OraUtils::tableSchema(0xffbec9c4, 0x145180, 0xff4c0, 0xffbee664, 0x0, 0xfcf23724), at 0xfcf23644
[9] APT_ORCHESTRATE_main(0x9, 0xffbeef0c, 0x0, 0x0, 0x1003f0, 0x9), at 0x206a8
[10] APT_PMconductorMain(0x14008, 0xffbeec2c, 0x4, 0xff2138b8, 0xffbeec10, 0xffbeeae4), at 0xfedd6908
[11] APT_SharedMain(0x9, 0xffbeef30, 0x14008, 0x9, 0xf, 0xffbeee54), at 0xfee0b220
detaching from process 15298
Thanks in advance.