Re: Run SQL Scripts fails to start...

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Found the following:
Document Number:	387681872

Document Title
Run SQL Scripts Will Not Start in iSeries Navigator

Document Description
If attempting to use the Run SQL Scripts function of IBM® iSeries®
Navigator results in a message box containing only a red X and an OK
button, do the following to correct the problem:

Note: These instructions might correct other error messages that occur
when starting the Run SQL Scripts function.
1	Close iSeries Navigator.
2	Open Microsoft® Windows® Explorer.
3	Navigate to the following path:

C:\Documents and Settings\All Users\Documents\IBM\Client Access\Config
4	Delete or rename the OpNav.Java.User.ser file. This file saves the
settings for the JDBC driver, and it will be re-created the next time
the Run SQL Scripts function is used.

tried this, but it didn't seem to help... (though now that I found it
I remember having it work in the past)

But, the file hasn't been recreated either....thinking it might be
cached, so I'm going to try a reboot...

If that fails will probably contact IBM.

Charles

On Mon, Jun 13, 2011 at 2:44 PM,  <rob@xxxxxxxxx> wrote:
> I'd call IBM.
>
>
> Rob Berendt
> --
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>          Garrett, IN 46738
> Ship to:  Dock 108
>          6928N 400E
>          Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Charles Wilt <charles.wilt@xxxxxxxxx>
> To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:   06/13/2011 02:25 PM
> Subject:        Run SQL Scripts fails to start...
> Sent by:        midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> All,
>
> Recently, I started getting a message "Exception - An unknown error
> has occurred" when trying to start the Run SQL Scripts component of
> iNav.
>
> This was using 7.1 of System i Access for Windows.
>
> Google lead me to a recommendation to uninstall and reinstall...
>
> The uninstall seemed to hang at the end; the program was gone from the
> start menu and the Add/Remove programs tool...but I manually deleted
> the C:\Program Files\IBM\Client Access folder and clean up some
> registry entries.
>
> Trying to reinstall 7.1 (multiple times), the install kept failing
> saying that a couple different DLL's failed to register...
>
> I tried installing v5r4 (from our iSeries), but the setup just seemed to
> hang...
>
> So I tried installing 6.1.  Finally, the install completed
> successfully as did the installation of the latest service pack.
>
> Of course, when I try to start Run SQL Scripts, I get... "Exception -
> An unknown error has occurred"  :0  ....what a waste of a morning...
>
> I'm running WinXP Pro with SP 3...
>
> Any thoughts?
>
> Thanks!
> Charles
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.