Alpha to Itanium DCL issue

[Thomson, Martyn]

Thank-you for your suggestion!

I was looking for a Powerhouse *E* type error message. Turns out it was an %RDB-E- error on a date conversion in a view.
Because the dozen QTP programs were being executed in the same QTP session, it just carries on regardless executing the others, then aborts when it exits back to DCL. Who knew!
I'll split them up into separate "$ QTP auto=" statements so DCL will error out on the right one.

Thanks again Herald.

From: Thomson, Martyn
Sent: August-24-15 11:21 AM
To: 'HERALD KAFFKA'; 'powerh-l at lists.sowder.com'
Subject: RE: Alpha to Itanium DCL issue

"com" is just a logical for the location of DCL command procedures. Used throughout the app.

I'll try your suggestion of running each procedure from command line.

From: HERALD KAFFKA [mailto:Herald.Kaffka at westfraser.com]
Sent: August-24-15 11:07 AM
To: Thomson, Martyn; 'powerh-l at lists.sowder.com'
Subject: RE: Alpha to Itanium DCL issue

RDB?  Oracle? Or straight RMS/ISAM...

About 2 years ago we went through the same process (Large Powerhouse application => Alpha->Itanium).

App was a mix of Oracle and RMS/ISAM (mostly Oracle with a few legacy RMS files hanging around...).  (No RDB).

Near Zero problems with the OS/Shell.  (Alpha by default ran a stable sort, Itanium ran a unstable sort, so if
Your quiz/qtp runs were sorting down x levels, and detail lines were at x+1, the order of the detail lines was
Undetermined.  (Subtotals were ok, ie Sort down to the level of a "parent company", (say Home Depot), then
Display sales to each individual store, subtotals/grand totals would all be good, but the order in which individual
Stores printed out was random, (oracle returns data in a random order if you don't explicitly sort, if you are using pure
RMS/ISAM you would be fine as RMS runs indexes and retrieves in order).  "I think" there was a logical you could set
To force the old behavior, but as this only affected about 4 quiz/qtp runs out of hundreds, we simply added the last sort
level to reports.  (Cleaner and easier to understand in the long run than  using an invisible logical name out at the system level...).

This was pretty much the only problem we ran into on this.  (course we had moved from various VAXes in the past, and from
VAX to Alpha, so there is/was a pretty good abstraction layer setup in logical names to hide the physical hardware...).

"@com:proc2.com";

Is the @com in the above an "inhouse" symbol/procedure to run a command file?  You might want to look at it if so, and see if it's your problem...
If your routine is not too involved, you might want to step through processing one step at a time at the DCL command line to see if something
Is getting trapped out (and/or confused) by something in the com file wrapper/driver...

Just a few random thoughts...

From: powerh-l-bounces+herald.kaffka=westfraser.com at lists.sowder.com<mailto:powerh-l-bounces+herald.kaffka=westfraser.com at lists.sowder.com> [mailto:powerh-l-bounces+herald.kaffka=westfraser.com at lists.sowder.com] On Behalf Of Thomson, Martyn
Sent: Monday, August 24, 2015 12:03 PM
To: 'powerh-l at lists.sowder.com' <powerh-l at lists.sowder.com<mailto:powerh-l at lists.sowder.com>>
Subject: Alpha to Itanium DCL issue

Moving a large PowerHouse app from Alpha to Itanium. Getting strange behaviour with a DCL procedure terminating prematurely.

DCL procedure proc1.com submitted;
Does a few things then executes proc2.com i.e. "@com:proc2.com";
Proc2.com runs a dozen QTP programs then drops out to proc1.com prematurely! The QUIZ programs don't get run; the reports aren't printed;
On returning to proc1.com it immediately exits, not executing the remainder of proc1.

All QTP/QUIZ were recompiled.

I added "on error then goto err_handler" to both procedures to display $status.  Proc2 is terminating with  %X1900802A. That's a QTP error "A file access error has been detected, but the QTP program did write to the database the number of records shown in the log. The protection on all tables it references is correct. There are no subfiles involved.

Has anyone seen this before? Very puzzled. Any insights, suggestions, etc much appreciated.

I should point out I searched the logs on the Alpha for this job. It happened once last month for the first time ever.

OpenVMS 8.4
Oracle Rdb SQL V7.3-100
PowerHouse  8.40G
Regards,
Martyn Thomson
Senior Technical Analyst, Development Services
Information Technology Services
HP Advanced Solutions Inc.
phone: 250.405.4555 | fax: 250.405.4422
email:martyn.thomson at hpadvancedsolutions.com<mailto:martyn.thomson at hpadvancedsolutions.com>
web:  www.hpadvancedsolutions.com<http://www.hpadvancedsolutions.com/>






-------------EOP---------------

This e-mail message and any attachments are confidential. Any dissemination or use of this information by a person other than the intended recipient is unauthorized. If you are not the intended recipient, please notify me by return e-mail, do not open any attachment and delete this communication and any copy.

Thank you
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20150824/06a3cb42/attachment-0001.htm>