copyapp problem in ingres 9.2.0 for linux

[Ballpoint]

Hello,

 

A problem has emerged when compiling ABF applications under Ingres 9.2.0 (int.lnx/143), and it occurs also in 9.1.1

 

The installations were upgraded from Ingres 9.0.4 (int.lnx/105).

 

The database was successfully reloaded into the 9.2.0 intallation from an unloaddb.

 

ABF applications were recompiled successfully.

 

But when 'copyapp in....' is subsequently used to refresh the application, imageapp returns lots of errors like:

#
Processing form 're000_menu' . . .
Forcing compilation to create object file.
Compiling '179441.c' . . .
179441.c:63: error: expected identifier or â(â before â=â token
E_AB001E Compilation failed
    The compilation of
    '/opt/Ingres/IngresII/ingres/abf/school/retrospect/179441.c' failed with
    status '1'.  This could mean either that the compiler could not be run
    or that it ran and returned an error.

 

Compilation failed.
#

If the application is changed to use non-compiled forms, then the compiles are OK and the application can be used successfully.

 

So does the newer 'copyapp in...' do something to forms on the way in, which the compiler doesn't like?

 

To further confuse things, if I create a new test database and copyapp to that, then the compiles are OK. Indeed I can copyapp out

and in as much as I like, and they are still OK.

 

But a 'copyapp out' from the test database, then back in to the production database and try to compile the production application,

then it's no go again!

 

Compiled forms are preferred, to stop users from hacking in and changing them, and enabling the distribution of just the executables.

 

As a matter of interest, I took the copyapp binary from a 9.0.4 installation, and used it in a 9.2.0 installation succesfully.

 

Can anybody suggest another way around this problem, please?

 

Thanks,

BB

[Ingres Forums]

It would be worth doing:
- use '-r' option while copyapp in, to replace existing object
and/or
- remove all objects by hand from
$ING_ABFDIR/ingres/abf/<db>/<application> and imageapp

Will these help?
Bilgihan

--
bilgihan
------------------------------------------------------------------------
bilgihan's Profile: http://community.ingres.com/forum/member.php?userid=8658
View this thread: http://community.ingres.com/forum/showthread.php?t=10763

[Bob Borbiro]

Thanks for your reply and suggestions, but I did try those, without success

BB

> _______________________________________________
> Info-Ingres mailing list
> Info-...@kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres

[Sørensen.Henrik Georg HGS]

Issue 136267 has been reported to Ingres Support by me on 30. april 2009, as a conflict starting after patch-fix for other issue early February 2009.
Our platform is by the way AXP.OSF (TRU64) on both 9.1.1 and 9.2.0.

Problem seems to arise from that the compiled form seems to pass 99999 in
Objectnumbering (first jumped from 99999 to 237xxxx, newer patch-fixes with more normal incrementation), but still an issue for imageapp.

No help with delobj and -r flag as it's the incremental numbering for new forms that's making the issue, as incremental happens when importing several apps. Except maybe by deleting all apps and forms in the database...

Example program supplied to Ingres Support with 2 applications with 2 Frames in each (no specific code other than initilize and one command with return.
One of the Frames is the shared between the 2 applications and keeps its numbering while the other jump in sequence for each additional load.

After 3599 "loads" it passes 99999 in numbering and no longer compiles.

Which of course happens a lot faster when having several apps with lot of frames.

Kind regards
Henrik Georg S�rensen, Organisator, Denmark
-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com [mailto:info-ingr...@kettleriverconsulting.com] P� vegne af Bob Borbiro
Sendt: 10. juni 2009 01:53
Til: Ingres and related product discussion forum
Emne: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Thanks for your reply and suggestions, but I did try those, without success

BB

----- Original Message -----
From: "Ingres Forums" <info-...@kettleriverconsulting.com>
Newsgroups: comp.databases.ingres
To: <info-...@kettleriverconsulting.com>
Sent: Tuesday, June 09, 2009 5:56 PM
Subject: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

>

[Bob Borbiro]

Thank you for that information, Henrick.

I can confirm that it's something to do with the number of loads.

We have many apps (20+), and about 1000 frames.
Here's what I did:

created a new database.

ran "copyapp in" for all the apps
compiled an app.

I repeated the copyapp & compile several times.
After the 4th "copyapp in", the compile failed.

Do you have any information on a fix for the issue you raised?

Bob Borbiro.

BB

>

[Sørensen.Henrik Georg HGS]

Unfortunately the speed in understanding the serious problem and how easy it is to replicate the problem is not the fastest for this issue as it use to be.

My Easy Shell-job for replicating the problem is - run this until application no longer builds:

Application 1 has 2 frames Frame1 and FrameBoth
Application 2 has 2 frames Frame2 and FrameBoth

For support issue the apps is supplied as well.

The build-proces ends in our case at number 003599 :-) when the Forms Object.id passes 100.000.

#!/bin/ksh
database=vifcopy
destroydb $database
relocatedb -new_database=$database viforg rm -f vifbug.log 2> /dev/null
for a in `echo 0 1 2 3 4 5 6 7 8 9`; do
for b in `echo 0 1 2 3 4 5 6 7 8 9`; do
for c in `echo 0 1 2 3 4 5 6 7 8 9`; do
for d in `echo 0 1 2 3 4 5 6 7 8 9`; do
for e in `echo 0 1 2 3 4 5 6 7 8 9`; do
for f in `echo 0 1 2 3 4 5 6 7 8 9`; do
echo $a$b$c$d$e$f': '`date +"%d.%m.%Y %H:%M:%S"` | tee -a vifbug.log
rm -f vifapp1.exe vifapp2.exe 2> /dev/null
delobj $database -application vifapp1| tee -a vifbug.log
copyapp in -r $database vifapp1.applic| tee -a vifbug.log
delobj $database -application vifapp2| tee -a vifbug.log
copyapp in -r $database vifapp2.applic| tee -a vifbug.log
echo 'y' | copyform -i $database formapp1| tee -a vifbug.log
echo 'y' | copyform -i $database formapp2| tee -a vifbug.log
echo 'y' | copyform -i $database formappboth| tee -a vifbug.log
mkdir -p $ING_ABFDIR/$database/vifapp1
imageapp $database vifapp1 | tee vifapp1.lis| tee -a vifbug.log
mkdir -p $ING_ABFDIR/$database/vifapp2
imageapp $database vifapp2 | tee vifapp2.lis| tee -a vifbug.log
if ! [ -r vifapp1.exe ]; then
echo 'EXE: vifapp1.exe missing'
exit 1;
elif ! [ -r vifapp2.exe ]; then
echo 'EXE: vifapp2.exe missing'
exit 1;
fi
done
done
done
done
done
done

Kind regards
Henrik Georg S�rensen

-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com [mailto:info-ingr...@kettleriverconsulting.com] P� vegne af Bob Borbiro

Sendt: 26. juni 2009 03:59

created a new database.

Bob Borbiro.

BB

>

[Sørensen.Henrik Georg HGS]

Finally it's now having an official bugnumber 122276, now awaiting a solution to be produced to be implemented in a patch.

created a new database.

Bob Borbiro.

BB

>

[Bob Borbiro]

Thanks again, Henrik.

I see that it is mentioned as a bug fix in p13411.
Hopefully the problem is resolved. I have not installed it yet.

Bob Borbiro.

created a new database.

Bob Borbiro.

BB

>

[Sørensen.Henrik Georg HGS]

Don't believe it's solved already in a patch out as latest "bugfix" is created in Ingres internal codefix last night (14. july) to be passed through for Future patches if no additional issues found.

Kind regards
Henrik Georg S�ｿｽrensen, Organisator, Denmark
-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com [mailto:info-ingr...@kettleriverconsulting.com] P�ｿｽ vegne af Bob Borbiro
Sendt: 14. juli 2009 13:48

Til: Ingres and related product discussion forum
Emne: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Thanks again, Henrik.

I see that it is mentioned as a bug fix in p13411.
Hopefully the problem is resolved. I have not installed it yet.

Bob Borbiro.

----- Original Message -----
From: "S�ｿｽrensen.Henrik Georg HGS" <H...@organisator.dk>
To: "Ingres and related product discussion forum"
<info-...@kettleriverconsulting.com>
Sent: Tuesday, July 14, 2009 1:48 AM
Subject: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Finally it's now having an official bugnumber 122276, now awaiting a
solution to be produced to be implemented in a patch.

Kind regards
Henrik Georg S�ｿｽrensen, Organisator, Denmark
-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] P�ｿｽ vegne af Bob

created a new database.

Bob Borbiro.

Kind regards
Henrik Georg S�ｿｽrensen, Organisator, Denmark
-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] P�ｿｽ vegne af Bob

Borbiro
Sendt: 10. juni 2009 01:53
Til: Ingres and related product discussion forum
Emne: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Thanks for your reply and suggestions, but I did try those, without success

BB

----- Original Message -----
From: "Ingres Forums" <info-...@kettleriverconsulting.com>
Newsgroups: comp.databases.ingres
To: <info-...@kettleriverconsulting.com>
Sent: Tuesday, June 09, 2009 5:56 PM
Subject: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

>

[Ingres Forums]

It's definitely not in patch 13411. That patch was dated 2 July, and the
highest numbered bug fix is 122217. Bug 122276 is still not marked as
"Submitted" in our internal bugs system.

--
denjo02
------------------------------------------------------------------------
denjo02's Profile: http://community.ingres.com/forum/member.php?userid=702

[Bob Borbiro]

I see that bug 122276 re copyapp problem is included in P13468 for a64.lnx
Will try it out soon, when i get a chance.
(not yet shown for 32bit linux)

Bob Borbiro.

----- Original Message -----
From: "S�rensen.Henrik Georg HGS" <H...@organisator.dk>
To: "Ingres and related product discussion forum"
<info-...@kettleriverconsulting.com>
Sent: Wednesday, July 15, 2009 5:19 PM
Subject: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Don't believe it's solved already in a patch out as latest "bugfix" is
created in Ingres internal codefix last night (14. july) to be passed
through for Future patches if no additional issues found.

Kind regards
Henrik Georg S�rensen, Organisator, Denmark
-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] Pďż˝ vegne af Bob

Borbiro
Sendt: 14. juli 2009 13:48
Til: Ingres and related product discussion forum
Emne: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Thanks again, Henrik.

I see that it is mentioned as a bug fix in p13411.
Hopefully the problem is resolved. I have not installed it yet.

Bob Borbiro.

----- Original Message -----
From: "S�rensen.Henrik Georg HGS" <H...@organisator.dk>
To: "Ingres and related product discussion forum"
<info-...@kettleriverconsulting.com>
Sent: Tuesday, July 14, 2009 1:48 AM
Subject: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Finally it's now having an official bugnumber 122276, now awaiting a
solution to be produced to be implemented in a patch.

Kind regards
Henrik Georg S�rensen, Organisator, Denmark
-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] Pďż˝ vegne af Bob

created a new database.

Bob Borbiro.

Kind regards
Henrik Georg S�rensen, Organisator, Denmark
-----Oprindelig meddelelse-----
Fra: info-ingr...@kettleriverconsulting.com
[mailto:info-ingr...@kettleriverconsulting.com] Pďż˝ vegne af Bob

Borbiro
Sendt: 10. juni 2009 01:53
Til: Ingres and related product discussion forum
Emne: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

Thanks for your reply and suggestions, but I did try those, without success

BB

----- Original Message -----
From: "Ingres Forums" <info-...@kettleriverconsulting.com>
Newsgroups: comp.databases.ingres
To: <info-...@kettleriverconsulting.com>
Sent: Tuesday, June 09, 2009 5:56 PM
Subject: Re: [Info-Ingres] copyapp problem in ingres 9.2.0 for linux

>