08.13.09
Weblogic WLI Error Resolution
UPDATE!
Before you try to run the scripts, there’s a simple resolution: try restarting the DB instance. Maybe that’s what is causing this error. Sometimes there is some issue with the TNS Listener and that might throw this error.
After a loooooong time spent debugging this issue, i have found the solution.
So the situation is this. you are trying to start up the Weblogic Integration domain and it just won’t start up. It was working fine the last time you looked at it. You didn’t change a thing. No deployments, no config changes, no nothing. But now when it is starting, you get some weird errors like this:
<000000>
com.bea.wli.init.WLIDBCreateException: Could not execute (possibly among others) CREATE statement for INDEX IX_WLI_MESSA
GE_BROKER_DYNAMIC: CREATE INDEX IX_WLI_MESSAGE_BROKER_DYNAMIC ON WLI_MESSAGE_BROKER_DYNAMIC( HASH_ID)
at com.bea.wli.init.WLIDBCreate$WLIDataSource.createDBObjects(WLIDBCreate.java:671)
at com.bea.wli.init.WLIDBCreate.init(WLIDBCreate.java:1008)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Truncated. see log file for complete stacktrace
Your boss won't believe you when you say that you didn't change a thing, but shit like this happens.
You try debugging the shit outta this WLIDBCreate.class file (after you spend hours searching where the shitty jar file is in which it is sitting pretty... btw, it is jpd.jar, located in weblogic92/server/lib in your weblogic 9.2 install location).
okay, i get it. i'm getting to the damn resolution.
The thing is, it is the DB that's messed up. How? i have no idea. But it has.
So if you run this sql file that i have compiled, you should be all set and ready to hit the ground running.
Obv. you are running this at your own risk, as defined in my disclaimer section (conveniently worded).
but this shit works.
In case you are wondering how i debugged it, i should say it wasn't all that simple.
but to cut a long story short, when i tried to create a new domain, i used the 'Run Scripts' command located just after the screen where you configure your datasources. I let it use the default pointbase server, then i copied the sql commands it ran, cleaned the shit out from it, tweaked it so that it runs on oracle, and then finally ran it to restore it to its former glory.
So there goes nothing... best of luck!
