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:
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:
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.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.
--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"
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.