Subscribe via RSS
13Aug/190

Usui Pass Railway Heritage Park – May, 2019

The Usui Pass Railway Heritage Park (Poppo Town!) is located at the end of a valley in the south-west of Gunma Prefecture. The location is significant as it's the start of the Usui Pass, a now-closed (operated between 1883 and 1997) difficult mountain pass between Yokokawa Station, Gunma and Karuizawa Station, Nagano. The pass was no longer needed once tunnels (and then Shinkansen) were built.

If you look at the article on wikipedia, you can see that the site used to be a much simpler open-air park. Fortunately, some investment has seen it turn into a fully-featured tourist attraction! You can even drive an EF63!

Getting there...

It's an easy day-trip from Tokyo, but not so much from Osaka. Fortunately, after mastering the ordering of Sunrise Seto/Izumo tickets, I'd worked out that catching the midnight Sunrise to Tokyo would work perfectly. Arriving (as long as we kept to schedule) at 0708 in the morning would allow for an easy transfer to a Nagano-bound Shinkansen.

DSC09600

DSC09601 DSC09602

The sunrise arrived perfectly on-time to Osaka and I made it into my Solo apartment. Unlike the previous 'Single' apartment, the Solos are a much more cramped experience.

Well, it's really only the entry that's cramped. As you can see, if you don't duck, you'll smack straight into the wooden frame up top. That wooden area is actually the footwell of the apartment above. The apartments are really efficient built together into the railway carriage!

Due to already knowing that there was no buffet car, no time was spent searching. It was already midnight, so I just passed out and proceeded on a very uneventful trip to Tokyo.

DSC09604

A quick bit of shopping and tranfering from the standard lines to the Shinkansen lines (make sure you enter the Tohoku gates and not the Tokaido gates!) allowed a smooth transition to this beauty...

DSC09605

I remember when the E7 Series was just released. The E7 series was built in conjuction with the W7 Series, which was built for the Hokuriku Shinkansen. It was exciting to know that the new Shinkansen line via Nagano and Toyama was getting closer to Osaka. But back to the actual vehicle, the style and colour are just fantastic. It's amazing how many of them are in operation now and how they're just seen as run-of-the-mill. Taking things for granted is such a painful human tendency.

Anwyay, where were we? The next transfer was at Takasaki Station. If you were actually wanting to go through the pass, stay on the train... you'll bolt through the tunnel and pop out at Karuizawa Station... Maybe you're searching for the Terrace House Set? But that's no good for us... we want to stay on this side and switch to the Zairaisen (在来線, conventional lines). Takasaki Station doesn't disappoint when it comes to a variety of EMUs!

DSC09606

DSC09608 DSC09610 DSC09612

Yessss! A Super Hitachi! Wait... Akagi? They've been relegated off the old service since the new E657 series EMU came in. This is one of my favourite designs.

DSC09618

DSC09615 DSC09616 DSC09617

DSC09614

Anyway... that boring EMU in front was ours... we were going on the now-underused commuter local line up to Yokokawa. Previously, this line used to use beautiful express EMUs that received banking locos before the pass, but that's all a thing of the past now!

Usui Pass Railway Heritage Park

From the station, it's a quick walk to the park. Turn left out of the station and walk through the carpark towards the red brick wall and beautiful mountain valley. For some reason I didn't take a photo of the front gate! I need to remember to properly survey sites when I'm on holidays! So here's a shot from inside the park with a beautiful 485 Series.

DSC09619

And from here, I'm just going to dump photos of everything I saw (and touched! Finally my ultra-ultra-favourite EF58 was in reach!) But first, here's a map of the site. From the map, there's a 'torokko' railway line that forms the perimeter. Inside, up the back of the town, is a smaller 9" ride-on railway. Both were still warming up when I was there, so I didn't check them out.

DSC09666

From here, it's just a matter of wandering through and checking everything out...

DSC09621

DSC09620 DSC09622 DSC09623

DSC09625 DSC09626 DSC09627

DSC09628

DSC09630 DSC09632 DSC09634

DSC09635

Right up the back was this very tired-looking Asama. I believe this was actually part of the previous EMU fleet that ran through the pass. I'm sure it'll be next on the list for refurbishment. There was quite a lot of work already being undertaken.

DSC09633 DSC09636 DSC09637 DSC09638 DSC09640

DSC09639

DSC09641

I really really wish there was functional EF58 running tours. I can't believe they've all been stuffed-and-mounted.

DSC09644

DSC09642 DSC09645 DSC09646

DSC09649 DSC09650 DSC09651

DSC09652

Model Railway Diorama

Once you've conquered the outside area, it's time to head inside and check out the displays. You'll find two floors of information on everything from track-laying to signalling. Unfortunately, very little English is available. I didn't check if there was an English audio guide.

DSC09653

That's the building to enter. Inside you'll find the following...

DSC09654

DSC09655 DSC09663 DSC09662

DSC09660 DSC09664 DSC09665

Those electro-mechanical displays above are fantastic. They'll show you the power routing through an electric locomotive.

DSC09667

There was also a cute infrastructure evaluation vehicle mounted out the front. Maybe from the Shinkansen depot?

Drive your own train!

The park offers guests a full course to learn to drive an EF63 locomotive. To do this, there's a one-off day course valued at 30,000 yen. You then pay 5,000 yen per drive.
You'll find more information on their site.

DSC09629

You'll find the driving experience on the northern side of the park. The line runs up into the valley, as it's actually the original Usui Pass line! I think you get to travel all the way to the tunnel entrance? That loco above was actually being driven by a guest when I was there.

Back to Takasaki

What was next? A freight yard! But before that, a 'quick' 'walk' (aka spirited job) across Takasaki City in the blistering heat to:

DSC09668

Hahaha... Many treasures found. And then... another 'quick' 'walk' to the freight yards. You'll find these to the south-east of Takasaki Station. For fellow otakus, there's a road that passes through the middle of the depot, providing some fantastic vantage points.

DSC09669 DSC09670 DSC09671

DSC09674

DSC09672 DSC09676 DSC09677

DSC09678

DSC09679 DSC09681 DSC09684

DSC09683

DSC09686 DSC09691 DSC09692

DSC09693

DSC09696 DSC09697 DSC09699

DSC09698

From here, it was a slow crawl back to the station. It's a fair 30-minute walk... which gets exponentially longer in the summer heat. Make sure you bounce from the shade to the nearest convenience store along the way!

DSC09701

There's actually a great shaded path under the Shinkansen tracks!

Filed under: JPN No Comments
8Aug/190

SL Yamaguchi – May 2019

A trip to Japan is never complete without seeing at least one Steam Locomotive. This time round I nearly missed out due to a well-needed sleep-in, but, thanks to the beautiful Shinkansen timetable, I was able to leave hours-upon-hours late and still see this majestic creature in action! A quick trip was made from Shin-Osaka to Shin-Yamaguchi on the Hikari.

Shin-Yamaguchi is one of those non-central Shinkansen stations that act as a transfer point to train lines that'll actually take you into the town the station is named after. Does that make sense? probably not. If you see 'Shin-' prepended to a station name, it means it's either a new standard train line station in the town where an existing non-'Shin-' station already existed, or it's a Shinkansen connection that was built away from the center of the town. Usually the later is done if the path for the Shinkansen line was going to be too destructive, expensive or inefficient.

DSC09560

Anwyay... the main point? I had to transfer to that beautiful 'Persimmon' KIHA above, which would then take me through to Miyano, just north of Yamaguchi Station. It's actually a relatively short point and quite a lot of the services terminate here.

DSC09563

DSC09564 DSC09565 DSC09566

DSC09567

DSC09569 DSC09571 DSC09572

It was a really beautiful station... very summery... nice weather too, if not slightly overcast! There's a 7-11 Konbini just down the road too, if you're hungry. Locals were having a BBQ in the apartment carpark just next to the station and the kids were mucking around playing sports. Every so often they'd yell out "hello foreigner" and smile... hah... the parents were a little embarrassed.

Before-long, the main event occurred.

DSC09573 DSC09574 DSC09581

DSC09579

An afternoon well spent! But of course... there's always a familiar shop... somewhere nearby! This time it was just north of Shin-Yamaguchi Station. First step, back on the DMU.

DSC09585

DSC09582 DSC09583 DSC09584

DSC09587

And a light-hearted jog through town... it had just started to spit...

DSC09588

Success! Meanwhile, back at the Shinkansen station... it's a great spot to view freight on the lower lines...

DSC09599

And passing bullets on the above-lines...

DSC09589

I'm sure I took a video-or-two of them... time to search the card(s).

Filed under: JPN No Comments
2Aug/190

MS Access: Error 6 – Overflow

A quick break between posts of the recent trip to Japan: I was distracted at work by a user who was experiencing a bug in an Access Database. Now, my team has never built access databases, but we're still the first-point-of-call for technical support on internally developed applications; even if not developed by us, nor in this decade!

We'd also just recently migrated a SQL server from one Windows VM to another, so there was a high chance that a user had been orphaned in the process... either way, I dug in.

First step: Reproduce locally!

I had the user screen-share over Skype so I could see what was going on. There was a very quick path to reproduction, so I took a copy of the database and brought it over to my machine. In no time I had the following:

Error 6 Overflow

Time to find the code?

Unlocking an Access DB

To get into the backend code, you need to unlock all the menus. Hit the File menu and then choose Privacy Options.

2019-08-02 10 57 04-Window

From here... make sure the following items are checked. Allow Special Keys is required for breakpoints to trigger in the VBA script!

options

Close the database and open it again.

Hacking the code

You'll now have the navigation pain on the left-hand side. Somewhere down the bottom you should have one or more modules containing the code throwing errors.

2019-08-02 11 17 03-

Double-clicking Module1 presenting me with the following... of course, like any good organisation, we had the passwords well-documented!

2019-08-02 11 02 45-Window

Once in... breakpoints were set and code was tested. The breakpoints didn't initially trigger, as I hadn't set the Allow Special Keys option. The name really doesn't make sense, but it's required if you want to debug! Once going though, I found that the code wouldn't hit another breakpoint inside the following function...

Public Sub RetrieveTestNamesFromSpecs(iBulkID As Integer)
        Dim RCountDB As DAO.Database
        Set RCountDB = CurrentDb
        ...
        ...
End Sub

Nothing really special! But the Overflow error was happening before the function started. A breakpoint on the 'Set' line would never get hit. I looked at the line before the function call and didn't see anything incriminating. I then checked the value of the variable being passed in as iBulkdID. It was 32790. That's a pretty ominous number for anyone who understands bytes... or variable sizes. It turns out that an Access Database Integer only supports the value range of -32768 to 32768. Our ID had surpassed this and was therefore not 'fitting in' to the variable.

Changing this to a Long fixed the issue! I handed the DB back to the user and dusted my hands.

More Casting!

Before long I had the DB back on my desk as there was a new Overflow Error. I quickly dug into the code and found that the error was happening when executing the following SQL.

        strSQL = "SELECT * FROM [TblName] where [CName] = " & Me.Variable & " Order By CInt(CName) Asc"
        Set rs = RCountDB.OpenRecordset(strSQL)

Anyone playing at home will see the error straight-away, but I wasn't used to Access SQL syntax. Long-story-short, that CInt is trying to cast the value as an Integer, and we already know that it doesn't fit! A quick conversion to CLng fixed this error as well!

I then scoured the rest of the code for crappy Integer references...