This discussion is archived
3 Replies Latest reply: Nov 13, 2009 2:48 AM by Dermot ONeill RSS

ExtStringTemplate Warning while Converting a SQLServer DB to Oracle 10g

733900 Newbie
Currently Being Moderated
Hi everyone,

I hope this is the right Forum to ask about this. I apologize if I misplaced it

I am currently having some trouble with the migration of a MSSQL Database (2000 with all its stored Procedures) to ORACLE 10g. I am using the offline Capture Method to generate the captured Model without any errors or warnings.
But as soon as I convert the Captured Model to the ORACLE Model I get a bunch of Warning Messages that read as follows:

Oracle.dbtools.migration.parser.ext.ExtStringTemplate.setValue(ExtStringTemplate.java:134)

Clicking on Details does not give any further clues on which Object caused it during conversion.

During the last few Days I tried to find Information about this Warning Message searching several Blogs and Forums, but to no avail.

I would like to know how I could solve this problem or if it even might influence the applications later on that are supposed to work with the converted Database.

Any help with this is highly appreciated

Here some Information about the test Environment:
System specs:
Oracle runs in A Virtual Box Dev-Environment with Win2k3 as Guest OS
VirtualBox: 3.0.10 r54097
ORACLE Database 10g r 2
SQL Developer     Info
----

Oracle SQL Developer 2.1.0.62
Version 2.1.0.62
Build MAIN-62.61
Copyright © 2005, 2009, Oracle. All Rights Reserved. Alle Rechte vorbehalten.
IDE Version: 11.1.1.2.36.54.96
Product ID: oracle.sqldeveloper
Product Version: 11.1.1.62.61

Version
-------

Komponente     Version
==========     =======
Java(TM)-Plattform     1.6.0_11
Oracle-IDE     2.1.0.62.61
Versionierungsunterstützung     2.1.0.62.61

Eigenschaften
-------------

Name     Wert
====     ====
apple.laf.useScreenMenuBar     true
awt.toolkit     sun.awt.windows.WToolkit
class.load.environment     oracle.ide.boot.IdeClassLoadEnvironment
class.load.log.level     CONFIG
class.transfer     delegate
com.apple.macos.smallTabs     true
com.apple.mrj.application.apple.menu.about.name     "SQL_Developer"
com.apple.mrj.application.growbox.intrudes     false
file.encoding     Cp1252
file.encoding.pkg     sun.io
file.separator     \
ice.browser.forcegc     false
ice.pilots.html4.ignoreNonGenericFonts     true
ice.pilots.html4.tileOptThreshold     0
ide.AssertTracingDisabled     true
ide.bootstrap.start     1174433566556
ide.build     MAIN-62.61
ide.conf     C:\Programme\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
ide.config_pathname     C:\Programme\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
ide.debugbuild     false
ide.devbuild     false
ide.extension.search.path     sqldeveloper/extensions:jdev/extensions:ide/extensions
ide.firstrun     true
ide.java.minversion     1.6.0_04
ide.launcherProcessId     2636
ide.main.class     oracle.ide.boot.IdeLauncher
ide.patches.dir     ide/lib/patches
ide.pref.dir     C:\Dokumente und Einstellungen\Administrator\Anwendungsdaten\SQL Developer
ide.pref.dir.base     C:\Dokumente und Einstellungen\Administrator\Anwendungsdaten
ide.product     oracle.sqldeveloper
ide.shell.enableFileTypeAssociation     C:\Programme\sqldeveloper\sqldeveloper.exe
ide.splash.screen     splash.gif
ide.startingArg0     C:\Programme\sqldeveloper\sqldeveloper.exe
ide.startingcwd     C:\Dokumente und Einstellungen\Administrator\Desktop
ide.user.dir     C:\Dokumente und Einstellungen\Administrator\Anwendungsdaten\SQL Developer
ide.user.dir.var     IDE_USER_DIR
ide.work.dir     C:\Dokumente und Einstellungen\Administrator\Eigene Dateien\SQL Developer
ide.work.dir.base     C:\Dokumente und Einstellungen\Administrator\Eigene Dateien
java.awt.graphicsenv     sun.awt.Win32GraphicsEnvironment
java.awt.printerjob     sun.awt.windows.WPrinterJob
java.class.path     ..\..\ide\lib\ide-boot.jar
java.class.version     50.0
java.endorsed.dirs     C:\Programme\sqldeveloper\jdk\jre\lib\endorsed
java.ext.dirs     C:\Programme\sqldeveloper\jdk\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext
java.home     C:\Programme\sqldeveloper\jdk\jre
java.io.tmpdir     C:\DOKUME~1\ADMINI~1\LOKALE~1\Temp\
java.library.path     C:\Programme\sqldeveloper;.;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\oracle\product\10.2.0\db_1\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\Microsoft SQL Server\100\Tools\Binn\;C:\Programme\Microsoft SQL Server\100\DTS\Binn\;C:\Programme\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\;C:\Programme\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\;C:\WINDOWS\system32\WindowsPowerShell\v1.0
java.naming.factory.initial     oracle.javatools.jndi.LocalInitialContextFactory
java.runtime.name     Java(TM) SE Runtime Environment
java.runtime.version     1.6.0_11-b03
java.specification.name     Java Platform API Specification
java.specification.vendor     Sun Microsystems Inc.
java.specification.version     1.6
java.util.logging.config.file     logging.conf
java.vendor     Sun Microsystems Inc.
java.vendor.url     http://java.sun.com/
java.vendor.url.bug     http://java.sun.com/cgi-bin/bugreport.cgi
java.version     1.6.0_11
java.vm.info     mixed mode
java.vm.name     Java HotSpot(TM) Client VM
java.vm.specification.name     Java Virtual Machine Specification
java.vm.specification.vendor     Sun Microsystems Inc.
java.vm.specification.version     1.0
java.vm.vendor     Sun Microsystems Inc.
java.vm.version     11.0-b16
jdbc.library     /C:/Programme/sqldeveloper/jdbc/lib/ojdbc5.jar
line.separator     \r\n
oracle.home     C:\Programme\sqldeveloper
oracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG     true
oracle.jdbc.Trace     true
oracle.translated.locales     de,es,fr,it,ja,ko,pt_BR,zh_CN,zh_TW
oracle.xdkjava.compatibility.version     9.0.4
orai18n.library     /C:/Programme/sqldeveloper/jlib/orai18n.jar
os.arch     x86
os.name     Windows 2003
os.version     5.2
path.separator     ;
reserved_filenames     con,aux,prn,lpt1,lpt2,lpt3,lpt4,lpt5,lpt6,lpt7,lpt8,lpt9,com1,com2,com3,com4,com5,com6,com7,com8,com9,conin$,conout,conout$
sqldev.debug     false
sun.arch.data.model     32
sun.boot.class.path     C:\Programme\sqldeveloper\jdk\jre\lib\resources.jar;C:\Programme\sqldeveloper\jdk\jre\lib\rt.jar;C:\Programme\sqldeveloper\jdk\jre\lib\sunrsasign.jar;C:\Programme\sqldeveloper\jdk\jre\lib\jsse.jar;C:\Programme\sqldeveloper\jdk\jre\lib\jce.jar;C:\Programme\sqldeveloper\jdk\jre\lib\charsets.jar;C:\Programme\sqldeveloper\jdk\jre\classes
sun.boot.library.path     C:\Programme\sqldeveloper\jdk\jre\bin
sun.cpu.endian     little
sun.cpu.isalist     pentium_pro+mmx pentium_pro pentium+mmx pentium i486 i386 i86
sun.desktop     windows
sun.io.unicode.encoding     UnicodeLittle
sun.java2d.ddoffscreen     false
sun.jnu.encoding     Cp1252
sun.management.compiler     HotSpot Client Compiler
sun.os.patch.level     Service Pack 2
svnkit.sax.useDefault     true
user.country     DE
user.dir     C:\Programme\sqldeveloper\sqldeveloper\bin
user.home     C:\Dokumente und Einstellungen\Administrator
user.language     de
user.name     Administrator
user.timezone     Europe/Berlin
user.variant     
windows.shell.font.languages     

Erweiterungen
-------------

Name     Identifier     Version     Status
====     ==========     =======     ======
Audit     oracle.ide.audit     11.1.1.2.36.54.96     Geladen
Check For Updates     oracle.ide.webupdate     11.1.1.2.36.54.96     Geladen
Code Editor     oracle.ide.ceditor     11.1.1.2.36.54.96     Geladen
Datenbank-UI     oracle.ide.db     11.1.1.2.36.54.96     Geladen
Datenbankobjekt-Explorer     oracle.ide.db.explorer     11.1.1.2.36.54.96     Geladen
Diff/Merge     oracle.ide.diffmerge     11.1.1.2.36.54.96     Geladen
Extended IDE Platform     oracle.javacore     11.1.1.2.36.54.96     Geladen
Externe Tools     oracle.ide.externaltools     11.1.1.2.36.54.96     Geladen
File Support     oracle.ide.files     11.1.1.2.36.54.96     Geladen
File System Navigator     oracle.sqldeveloper.filenavigator     11.1.1.62.61     Geladen
Help System     oracle.ide.help     11.1.1.2.36.54.96     Geladen
Import/Export Support     oracle.ide.importexport     11.1.1.2.36.54.96     Geladen
Index Migrator support     oracle.ideimpl.indexing-migrator     11.1.1.2.36.54.96     Geladen
JDeveloper Runner     oracle.jdeveloper.runner     11.1.1.2.36.54.96     Geladen
Log Window     oracle.ide.log     11.1.1.2.36.54.96     Geladen
Navigator     oracle.ide.navigator     11.1.1.2.36.54.96     Geladen
Object Viewer     oracle.sqldeveloper.oviewer     11.1.1.62.61     Geladen
Objektgalerie     oracle.ide.gallery     11.1.1.2.36.54.96     Geladen
Oracle Data Modeler Reports     oracle.sqldeveloper.datamodeler_reports     11.1.1.62.61     Geladen
Oracle Database Browser     oracle.sqldeveloper.thirdparty.browsers     11.1.1.62.61     Geladen
Oracle IDE     oracle.ide     11.1.1.2.36.54.96     Geladen
Oracle SQL Developer     oracle.sqldeveloper     11.1.1.62.61     Geladen
Oracle SQL Developer Data Modeler Viewer     oracle.datamodeler     2.0.0.574     Geladen
Oracle SQL Developer Extras     oracle.sqldeveloper.extras     1.1.1.62.61     Geladen
Oracle SQL Developer Migrations     oracle.sqldeveloper.migration     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - Antlr3 Translation Core     oracle.sqldeveloper.migration.translation.core_antlr3     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - DB2     oracle.sqldeveloper.migration.db2     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - Microsoft Access     oracle.sqldeveloper.migration.msaccess     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - MySQL     oracle.sqldeveloper.migration.mysql     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - SQLServer     oracle.sqldeveloper.migration.sqlserver     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - Sybase     oracle.sqldeveloper.migration.sybase     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - Teradata     oracle.sqldeveloper.migration.teradata     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - Translation Core     oracle.sqldeveloper.migration.translation.core     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - Translation Db2     oracle.sqldeveloper.migration.translation.db2     11.1.1.62.61     Geladen
Oracle SQL Developer Migrations - Translation UI     oracle.sqldeveloper.migration.translation.gui     11.1.1.62.61     Geladen
Oracle SQL Developer Reports     oracle.sqldeveloper.report     11.1.1.62.61     Geladen
Oracle SQL Developer SearchBar     oracle.sqldeveloper.searchbar     11.1.1.62.61     Geladen
Oracle SQL Developer TimesTen     oracle.sqldeveloper.timesten     2.0.0.62.61     Geladen
Oracle SQL Developer Unit Test     oracle.sqldeveloper.unit_test     11.1.1.62.61     Geladen
Oracle SQL Developer Worksheet     oracle.sqldeveloper.worksheet     11.1.1.62.61     Geladen
Oracle XML Schema Support     oracle.sqldeveloper.xmlschema     11.1.1.62.61     Geladen
PROBE Debugger     oracle.jdeveloper.db.debug.probe     11.1.1.2.36.54.96     Geladen
Peek     oracle.ide.peek     11.1.1.2.36.54.96     Geladen
Persistent Storage     oracle.ide.persistence     11.1.1.2.36.54.96     Geladen
QuickDiff     oracle.ide.quickdiff     11.1.1.2.36.54.96     Geladen
Replace With     oracle.ide.replace     11.1.1.2.36.54.96     Geladen
Runner     oracle.ide.runner     11.1.1.2.36.54.96     Geladen
Snippet Window     oracle.sqldeveloper.snippet     11.1.1.62.61     Geladen
Sql Monitoring Project     oracle.sqldeveloper.sqlmonitor     11.1.1.62.61     Geladen
Tuning     oracle.sqldeveloper.tuning     11.1.1.62.61     Geladen
Unterstützung von Datenbankverbindungen     oracle.jdeveloper.db.connection     11.1.1.2.36.54.96     Geladen
Unterstützung von Historie     oracle.jdeveloper.history     11.1.1.2.36.54.96     Geladen
VHV     oracle.ide.vhv     11.1.1.2.36.54.96     Geladen
Versionierungsunterstützung     oracle.jdeveloper.vcs     11.1.1.2.36.54.96     Geladen
Versionierungsunterstützung für Subversion     oracle.jdeveloper.subversion     11.1.1.2.36.54.96     Geladen
Virtual File System     oracle.ide.vfs     11.1.1.2.36.54.96     Geladen
Web Browser and Proxy     oracle.ide.webbrowser     11.1.1.2.36.54.96     Geladen
oracle.ide.indexing     oracle.ide.indexing     11.1.1.2.36.54.96     Geladen
  • 1. Re: ExtStringTemplate Warning while Converting a SQLServer DB to Oracle 10g
    Dermot ONeill Journeyer
    Currently Being Moderated
    Hi <please supply your name>,


    "Oracle.dbtools.migration.parser.ext.ExtStringTemplate.setValue(ExtStringTemplate.java:134)" is an internal warning when we are generating the stored procedure,function,view or trigger PL/SQL code.
    It will manifest itself possibly as a incorrectly converted statement/clause in the oracle model.
    Some times it doesn't manifest as an issue at all, and causes no issues.
    Either way its a bug, but I need a bit more detail to replicate.

    Does this stop your Oracle Model from being converted?
    Is there anymore to the Exception ? Is there a "details" button that can be clicked to view the entire exception stack trace?
    Can you skim through some of your converted procedures to see if anything stands out. If so could you provide a small example of the SQL Server procedure.


    If your Oracle Mode is generated and looks reasonably OK, the process would be to move on, as you will have to test the converted procedures anyway and you will pick up on any issues this caused then.

    Regards,
    Dermot O'Neill
    SQL Developer Team
  • 2. Re: ExtStringTemplate Warning while Converting a SQLServer DB to Oracle 10g
    733900 Newbie
    Currently Being Moderated
    Thank you very much for your Reply.

    Sorry that I couldn't write earlier.

    --Does this stop your Oracle Model from being converted?
    The conversion process completes with a few errors that I'm going to fix by hand.


    --Is there anymore to the Exception ?
    Concerning the Details button: When I click Details it only shows the same exception Message as posted above. Unfortunatly no stacktrace. But maybe there is some kind of logfile outside the IDE which I am not aware of yet, since I am rather new to working with sql developer. If you could point me to the stacktrace I will be happy to post it here.

    --Can you skim through some of your converted procedures to see if anything stands out
    I did as you suggested. There was a strange behaviour in a Procedure where there was a construct like N'<somestring>' in the original Transact SQL. Somehow every SQL statement that follows is recognized as a String, hence the code is not compiling at all.
    There are also some Prcedures which exit with the message: "unexpected end of Subtree"

    Edited by: gWahl on 13.11.2009 00:43
  • 3. Re: ExtStringTemplate Warning while Converting a SQLServer DB to Oracle 10g
    Dermot ONeill Journeyer
    Currently Being Moderated
    Hi,

    OK I would suggest ignoring that warning , it shouldn't happen , and I will keep an eye out for it in the future.


    " There was a strange behavior in a Procedure where there was a construct like N'<somestring>' in the original Transact SQL. Somehow every SQL statement that follows is recognized as a String, hence the code is not compiling at all."
    Can you give me the T-SQL example of this?
    Note, that I think there is a problem with the color highlighting. In that N'<something>' does mess up the color highlighting. But the SQL is fine.

    Regards,
    Dermot.
    SQL Developer Team

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points