| Oracle migration work bench SQL Server2000 to Oracle 8 [message #55722] |
Wed, 12 February 2003 07:06  |
justin
Messages: 10
Registered: November 2000
|
Junior Member |
|
|
I have encountered the following problems while creating the oracle
model from Microsoft SQL Server 2000 to Oracle8 Personal Edition for
Windows NT.
I have Oracle8 Personal Edition for Windows NT installed in one
system and i have another system where Migration Workbench installed
from where i am trying to migrate data. Connection level everything
is fine.
I have the following error messages which is given down.
1) null : Table. Owner name is NULL. Use the SQL Server 2000
sp_changedbowner/sp_changeobjectowner procedure to assign a valid
login as owner of the table.
2)EXCEPTION : failed to map trigger : TGINT.null.null;
oracle.mtg.migration.MigrationSQLException: ORA-01400: cannot insert
NULL
into
("EDI"."OM_OBJ_KEY_INFO"."OBJ_OWNER")
:ORA-01400: cannot insert NULL
into
("EDI"."OM_OBJ_KEY_INFO"."OBJ_OWNER")
Here TGINT : is the SQL Server2000 database
EDI : is the Oracle user Id
3) EXCEPTION:
SQLServer2kSoucreModelMap.mapStoredProcedures():.;java;lang.StringIndexOutofBoundsException:StringIndex
out of range : 0
4) failed to map user privilege:unknown; User "" was unable
to grant a "EXECUTE" privilege to "EDI" for a
"PROCEDURE" in the "TGINT" database
EDI is the user id in the SQLServer as well as in the Oracle Database
also
These are the errors which i am getting whenever i try to create the
oracle model of the stored procedurs and triggers. I created the
tables manually in the Oracle Database.
I am sending the error log file also with this mail
Kindly send me the solutions to these problems
Justin
** Oracle Migration Workbench
** Release 9.2.0.1.2 Production
** ( Build 20020910 )
** ORACLE_HOME: d:oracleora92
** user language: en
** user region: US
** user timezone:
** file encoding: Cp1252
** java version: 1.3.1_01
** java vendor: Sun Microsystems Inc.
** o.s. arch: x86
** o.s. name: Windows 98
** o.s. version: 4.10
** Classpath:
d:oracleora92OmwboliteOlite40.jar;C:Program
FilesOraclejre1.3.1librt.jar;C:Program
FilesOraclejre1.3.1libi18n.jar;d:oracleora92Omwbjlib;d:oracleora92OmwbjlibOmwb.jar;d:oracleora92Omwbjlibxdb.jar;d:oracleora92Omwbjliboembase-9_2_0.jar;d:oracleora92OmwbpluginsSQLServer6.jar;d:oracleora92OmwbpluginsSQLServer7.jar;d:oracleora92OmwbpluginsSQLServer2K.jar;d:oracleora92OmwbpluginsSybase11.jar;d:oracleora92OmwbpluginsSybase12.jar;d:oracleora92OmwbpluginsMSAccess.jar;d:oracleora92OmwbpluginsMySQL.jar;d:oracleora92Omwbdriversmm.mysql.jdbc-1.2a;d:oracleora92OmwbpluginsInformix7.jar;d:oracleora92OmwbpluginsInformix9.jar;d:oracleora92OmwbjlibInformix7Core.jar;d:oracleora92OmwbjlibInformix9Core.jar;d:oracleora92Omwbdriversifxjdbc.jar;d:oracleora92Omwbpluginsdb2400v4r5.jar;d:oracleora92Omwbdriversjt400.jar;d:oracleora92Omwbdriversdb2java.zip;d:oracleora92OmwbpluginsUDB6.jar;d:oracleora92OmwbjlibUDB6Core.jar;d:oracleora92OmwbpluginsUDB7.jar;d:oracleora92OmwbjlibUDB7Core.jar;d:oracleora92libxmlparserv2.jar;d:oracleora92rdbmsjlibxsu12.jar;d:oracleora92jdbclibclasses12.jar;d:oracleora92jdbclibnls_charset12.jar;d:oracleora92libvbjorb.jar;d:oracleora92Omwbjlibnetcfg.jar;d:oracleora92jlibewt3.jar;d:oracleora92Omwbjlibewtcompat-3_3_15.jar;d:oracleora92jlibshare.jar;d:oracleora92jlibhelp3.jar;d:oracleora92jliboracle_ice5.jar;d:oracleora92jlibkodiak.jar
** Started : Wed Feb 12 18:37:35 IST 2003
****** Operating System Information ********
name : Windows 98
version : 4.10
*************************************************
** Workbench Repository : Oracle8 Personal Edition Release 8.0.4.0.0
- Production
PL/SQL Release 8.0.4.0.0 - Production
Repository Connection URL: jdbc:oracle:thin:@s4ntb60:1521:orcl
** The following plugins are installed:
** Microsoft SQLServer 2000 Plugin, Release 9.2.0.1.3 Production
** Active Plugin : SQLServer2K
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
java.sql.SQLException: ORA-01418: specified index does not exist
Invalid CollisionInfo object created:
_oracleID : 0
_oracleModifiedObjectName : null
_oracleObjectName : null
_oracleObjectOwner : null
_oracleObjectType : null
_oracleNameSpaceType : null
_collisionCount : 0
java.lang.Exception
at
oracle.mtg.oracleModel.server.CollisionInfo.<init>(CollisionInfo.java:50)
at
oracle.mtg.oracleModel.server.CollisionManager.addObjectName(CollisionManager.java:465)
at
oracle.mtg.oracleModel.server.CollisionManager.getCollisionFreeName(CollisionManager.java:1225)
at
oracle.mtg.oracleModel.server.OracleModelImpl.getCollisionFreeName(OracleModelImpl.java:188)
at
oracle.mtg.oracleModel.server.ParserIntelligence.getCollisionFreeName(ParserIntelligence.java:1111)
at oracle.mtg.sqlserver2k.parser.Sp72.procName(Sp72.java:3288)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:3157)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseTriggerText(SQLServer2KParser.java:141)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapTriggers(SQLServer2KSourceModelMap.java:1249)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:411)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
at
oracle.mtg.migrationUI.ActionMenuHandler.run(ActionMenuHandler.java:103)
at oracle.mtg.migration.WorkerThread.run(Worker.java:269)
CollisionManager.addObjectName
java.lang.StringIndexOutOfBoundsException: String index out of range:
0
Invalid CollisionInfo object created:
_oracleID : 0
_oracleModifiedObjectName : null
_oracleObjectName : null
_oracleObjectOwner : null
_oracleObjectType : null
_oracleNameSpaceType : null
_collisionCount : 0
java.lang.Exception
at
oracle.mtg.oracleModel.server.CollisionInfo.<init>(CollisionInfo.java:50)
at
oracle.mtg.oracleModel.server.CollisionManager.addObjectName(CollisionManager.java:465)
at
oracle.mtg.oracleModel.server.CollisionManager.getCollisionFreeName(CollisionManager.java:1225)
at
oracle.mtg.oracleModel.server.OracleModelImpl.getCollisionFreeName(OracleModelImpl.java:188)
at
oracle.mtg.oracleModel.server.ParserIntelligence.getCollisionFreeName(ParserIntelligence.java:1111)
at oracle.mtg.sqlserver2k.parser.Sp72.procName(Sp72.java:3288)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:3157)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseTriggerText(SQLServer2KParser.java:141)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapTriggers(SQLServer2KSourceModelMap.java:1249)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:411)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
at
oracle.mtg.migrationUI.ActionMenuHandler.run(ActionMenuHandler.java:103)
at oracle.mtg.migration.WorkerThread.run(Worker.java:269)
CollisionManager.addObjectName
java.lang.StringIndexOutOfBoundsException: String index out of range:
0
Invalid CollisionInfo object created:
_oracleID : 0
_oracleModifiedObjectName : null
_oracleObjectName : null
_oracleObjectOwner : null
_oracleObjectType : null
_oracleNameSpaceType : null
_collisionCount : 0
java.lang.Exception
at
oracle.mtg.oracleModel.server.CollisionInfo.<init>(CollisionInfo.java:50)
at
oracle.mtg.oracleModel.server.CollisionManager.addObjectName(CollisionManager.java:465)
at
oracle.mtg.oracleModel.server.CollisionManager.getCollisionFreeName(CollisionManager.java:1225)
at
oracle.mtg.oracleModel.server.OracleModelImpl.getCollisionFreeName(OracleModelImpl.java:188)
at
oracle.mtg.oracleModel.server.ParserIntelligence.getCollisionFreeName(ParserIntelligence.java:1111)
at oracle.mtg.sqlserver2k.parser.Sp72.procName(Sp72.java:3288)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:3157)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseTriggerText(SQLServer2KParser.java:141)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapTriggers(SQLServer2KSourceModelMap.java:1249)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:411)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
at
oracle.mtg.migrationUI.ActionMenuHandler.run(ActionMenuHandler.java:103)
at oracle.mtg.migration.WorkerThread.run(Worker.java:269)
CollisionManager.addObjectName
java.lang.StringIndexOutOfBoundsException: String index out of range:
0
Invalid CollisionInfo object created:
_oracleID : 0
_oracleModifiedObjectName : null
_oracleObjectName : null
_oracleObjectOwner : null
_oracleObjectType : null
_oracleNameSpaceType : null
_collisionCount : 0
java.lang.Exception
at
oracle.mtg.oracleModel.server.CollisionInfo.<init>(CollisionInfo.java:50)
at
oracle.mtg.oracleModel.server.CollisionManager.addObjectName(CollisionManager.java:465)
at
oracle.mtg.oracleModel.server.CollisionManager.getCollisionFreeName(CollisionManager.java:1225)
at
oracle.mtg.oracleModel.server.OracleModelImpl.getCollisionFreeName(OracleModelImpl.java:188)
at
oracle.mtg.oracleModel.server.ParserIntelligence.getCollisionFreeName(ParserIntelligence.java:1111)
at oracle.mtg.sqlserver2k.parser.Sp72.procName(Sp72.java:3288)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:3157)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseTriggerText(SQLServer2KParser.java:141)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapTriggers(SQLServer2KSourceModelMap.java:1249)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:411)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
at
oracle.mtg.migrationUI.ActionMenuHandler.run(ActionMenuHandler.java:103)
at oracle.mtg.migration.WorkerThread.run(Worker.java:269)
CollisionManager.addObjectName
java.lang.StringIndexOutOfBoundsException: String index out of range:
0
Parsing:SPSELRESTARTLOG
Parsing:SPINSEDIXMLTPDETAILS
Parsing:SPGENERRHANDLER
Parsing:SPSELSECPRGS
Parsing:SPINSEDIXMLTPGROUP
Parsing:SPSELSEGMENTS
Parsing:SPINSEDIXMLTPGROUPMAPID
Parsing:SPSELSTATUSREP
Parsing:SPINSEDIXMLTPMAPID
Parsing:SPSELSTOPTASKLIST
Parsing:SPINSEDIXMLTPSETTING
Parsing:SPSELTASKLIST
Parsing:SPINSEDIXMLTRANSACTION
Parsing:SPSELTASKLOG
Parsing:SPINSERRLOG
Parsing:SPSELTASKREQ
Parsing:SPINSGROUPCODE
Parsing:SPSELTEMPLATE
Parsing:SPINSKEYELEMENT
Parsing:SPSELTEMPLATERULES
Parsing:SPINSMAPGENLOG
Oops
Parse error at line 2, column 1. Encountered: <EOF>
oracle.mtg.sqlserver2k.parser.ParseException: Parse error at line 2,
column 1. Encountered: <EOF>
at
oracle.mtg.sqlserver2k.parser.Sp72.generateParseException(Sp72.java:38769)
at
oracle.mtg.sqlserver2k.parser.Sp72.jj_consume_token(Sp72.java:38725)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:3206)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseStoredProcedure(SQLServer2KParser.java:89)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapStoredProcedures(SQLServer2KSourceModelMap.java:645)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:433)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
at
oracle.mtg.migrationUI.ActionMenuHandler.run(ActionMenuHandler.java:103)
at oracle.mtg.migration.WorkerThread.run(Worker.java:269)
Parsing:SPSELTEMPLATES
Parsing:SPINSNEWTPXEF
Oops
Parse error at line 2, column 1. Encountered: <EOF>
oracle.mtg.sqlserver2k.parser.ParseException: Parse error at line 2,
column 1. Encountered: <EOF>
at
oracle.mtg.sqlserver2k.parser.Sp72.generateParseException(Sp72.java:38769)
at
oracle.mtg.sqlserver2k.parser.Sp72.jj_consume_token(Sp72.java:38725)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:3206)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseStoredProcedure(SQLServer2KParser.java:89)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapStoredProcedures(SQLServer2KSourceModelMap.java:645)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:433)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
at
oracle.mtg.migrationUI.ActionMenuHandler.run(ActionMenuHandler.java:103)
at oracle.mtg.migration.WorkerThread.run(Worker.java:269)
Parsing:SPSELTXNLOGREP
Parsing:SPINSPROGID
Oops
Parse error at line 2, column 1. Encountered: <EOF>
oracle.mtg.sqlserver2k.parser.ParseException: Parse error at line 2,
column 1. Encountered: <EOF>
at
oracle.mtg.sqlserver2k.parser.Sp72.generateParseException(Sp72.java:38769)
at
oracle.mtg.sqlserver2k.parser.Sp72.jj_consume_token(Sp72.java:38725)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:3206)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseStoredProcedure(SQLServer2KParser.java:89)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapStoredProcedures(SQLServer2KSourceModelMap.java:645)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:433)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
at
oracle.mtg.migrationUI.ActionMenuHandler.run(ActionMenuHandler.java:103)
at oracle.mtg.migration.WorkerThread.run(Worker.java:269)
Parsing:SPSELUSER
Parsing:SPINSPURGELOG
poss dbowner: poss dbid24 return string:sa
Parsing:SPSENDSYSERR
Parsing:SPINSTASKLOG
Parsing:SPINSRELDATA
Parsing:SPSENDTASKLOG
Parsing:SPINSSECPRGS
Parsing:SPSETOUTBNDSPLIT
Parsing:SPINSSTOPTASK
Parsing:SPSETRELIND
Parsing:SPINSTASKDET
Parsing:SPSETRESTARTLOG
Parsing:SPSTOPTASK
Parsing:SPUPDEDIPROCHDRSTATUS
Parsing:SPINSTASKREQ
Parsing:SPUPDEDIXML997PROCHDR
Parsing:SPDELCTRLHDR
Parsing:SPUPDEDIXML997PROCHDRMAIN
Parsing:SPINSTEMPLATERULES
Parsing:SPDELCTRLDTL
Parsing:SPUPDEDIXML997PROCSPLITSTATUS
Parsing:SPDELCONTROL
Parsing:SPUPDEDIXMLCOMPANY
Parsing:SPINSTEMPLATES
Parsing:SPDELPROGRAM
Parsing:SPDELHELPHDR
Parsing:SPUPDEDIXMLCOMPMNT
Parsing:SPINSCTRLDTL
Parsing:SPUPDEDIXMLCTRLNBR
Parsing:SPINSUSER
Parsing:SPINSCTRLHDR
Parsing:SPUPDEDIXMLELTDETAILS
Parsing:SPINS_INBOUND_OUTPUT_MAP
Parsing:SPINSHELPHDR
Parsing:SPUPDEDIXMLLOGHDR
Parsing:SPINS_INBOUND_OUTPUT_MAP1
Parsing:SPSELCTRLDTL
Parsing:SPUPDEDIXMLLOOPDETAILS
Parsing:SPPURGE837LOGDTLDATA
Parsing:SPSELHELPHDR
Parsing:SPUPDEDIXMLLOOPPOS
Parsing:SPPURGECLNPROCHDR
Parsing:SPSELHELPDTL
Parsing:SPUPDEDIXMLOUTLOOPDET
Parsing:SPPURGEDATA
Oops
String index out of range: 0
java.lang.StringIndexOutOfBoundsException: String index out of range:
0
at java.lang.String.charAt(Unknown Source)
at oracle.mtg.sqlserver2k.parser.Sp72.insertStatement(Sp72.java:8854)
at
oracle.mtg.sqlserver2k.parser.Sp72.manipulativeStatement(Sp72.java:7630)
at oracle.mtg.sqlserver2k.parser.Sp72.sql(Sp72.java:7592)
at oracle.mtg.sqlserver2k.parser.Sp72.procContents(Sp72.java:3700)
at oracle.mtg.sqlserver2k.parser.Sp72.procBody(Sp72.java:3633)
at oracle.mtg.sqlserver2k.parser.Sp72.procedureStmt(Sp72.java:2740)
at oracle.mtg.sqlserver2k.parser.Sp72.beginProcedure(Sp72.java:2453)
at oracle.mtg.sqlserver2k.parser.Sp72.Start(Sp72.java:2417)
at oracle.mtg.sqlserver2k.parser.Sp72.parse(Sp72.java:269)
at
oracle.mtg.sqlserver2k.parser.SQLServer2KParser.parseStoredProcedure(SQLServer2KParser.java:89)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapStoredProcedures(SQLServer2KSourceModelMap.java:645)
at
oracle.mtg.sqlserver2k.server.SQLServer2KSourceModelMap.mapSourceModel(SQLServer2KSourceModelMap.java:433)
at
oracle.mtg.sqlserver2k.ui.SQLServer2KCaptureWizard.map(SQLServer2KCaptureWizard.java:556)
at
oracle.mtg.migrationUI.ActionMenuHandler._mapSourceModel(ActionMenuHandler.java:465)
|
|
|
|
| Re: Oracle migration work bench SQL Server2000 to Oracle 8 [message #55781 is a reply to message #55722] |
Sat, 15 February 2003 04:15  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
Hello all,
To be frank i dint go through the complete alert file.. :)
While migrating the database, provide the Owner name of the SQL Server database as the user name you will use to Login into sql server. also, make sure that the user has got DATABASE OWNER privileges assigned to him..then i am sure u will not have that problem..
Now whats next ? :))
sai
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
