TERs and Deployments

DBohner-(db)

Legendary Poster
I have made some modifications to Table Event Rules - and compiled them cleanly. They work as designed on my workstation.

But... then comes deployment...

We are XE 14.2. I check in the table, and promote the package to the next environment. I do an ER Compare to make sure the TER is identicle to what I sent to the next environment.

The CNC folk package and deploy... or so goes the process....

But, the TERs don't get compiled into DLLs - and don't get pushed out the the clients...

What is it I need to tell them to do with the new TERs - to get the modifications pushed out the the clients? I don't know what is getting missed. I don't know enough about the CNC arena to be able to tell them that they need to be compiled and pushed out to the clients and what that means in their 'instruction'.

Help???

Daniel Bohner
[email protected]
www.existinglight.net
JDE - XE & AS/400
JDE - B7331 & MS SQL 7x
 
Hi Daniel,

I amn't also a CNC guy but have an idea.
There is (should be?) somewhere a Check-Box that says "Generate Source for NER and TER" where you setup the DLL rebuilds for the Package. Hopefully this remained unchecked it caused the problem.
Please, let us know your results anyway. Thanks!

Regards,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Hi Daniel,

Yeah, we found the same problem. After a bit of experimenting, we discovered
that the table event-rule code isn't compiled with a partial package, but
*is* compiled with a full package. So I guess the answer (or at least *an*
answer) is "get 'em to do a full package" :)

Cheers,
Mark
 
Re: RE: TERs and Deployments

Mark,

I would like to ask for some furher information:

1.) Do you mean only "partial" package or "update" package or both?
2.) Does this happen for client or server or both package?
3.) What kind of release(s) and SP(s) have you experienced this on?

Thanks you answer in advance,
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
RE: RE: TERs and Deployments

Hi Zoltan,

1) Sorry, I was being rather loose with my terminology. Our CNC folks tell
me we don't do "partial" packages here - only "full" or "update" - so I
guess I should've said that "update" packages don't do the compile of the
table logic.

2) Seems to be both client and server.

3) We're on B7332, SP13.3

Does that help?

Mark
 
RE: RE: TERs and Deployments

Do you have created TER on a new table or an a standard table ?
I've done this and it works with update package. Are you sure that TER are
not compiled into DLL, or these TER isn't called ?
Do you have suppress global table to test if it works ? Is there any message
in the log files ? Do you have created your package with the include object
specification or not ?

Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 63
E-mail : [email protected]

Current Version : OneWorld B7332 Oracle , RS600, SP 15
Work on :
Oneworld B7321, B7331, B7332, XE
Platform, UNIX, AS400, NT
Database : Oracle, SQL, DB2




-----Message d'origine-----
De : [email protected] [mailto:eek:[email protected]]De la
part de m_brereton
Envoyé : jeudi 18 octobre 2001 18:43
À : [email protected]
Objet : RE: RE: TERs and Deployments


Hi Zoltan,

1) Sorry, I was being rather loose with my terminology. Our CNC folks tell
me we don't do "partial" packages here - only "full" or "update" - so I
guess I should've said that "update" packages don't do the compile of the
table logic.

2) Seems to be both client and server.

3) We're on B7332, SP13.3

Does that help?

Mark





--------------------------


Franck BLETTNER
Service Informatique RAVATE
Tel : 02 62 90 40 48
E-mail : [email protected]
 
Hi Daniel, Mark, Franck and Everybody,

I have also opened a thread on the other XE Forum with the "Table Event Rule Deployment" subject at 10/18/01 10:54 AM.
Please, check sometimes that thread too in this issue.
I recently checked again and currently there isn't any reply on it but I have got a reply on my private e-mail from Gerd Renz. Thank you Gerd. I have tried to reply this e-mail more times asking Gerd to place his valuable reply onto the Forum too but without success, because I have got always MAILAER-DAEMON response that my post wasn't delivered. Hope, if Gerd will read this post, he will do it. Also hope, that won't be angry that I copy his reply here for you.

NOTE: We haven't already tested it (I believe Gerd that does it work), but will be welcome to share of your experiences too how does it work on different versions and SPs. Thanks.
Here comes Gerd's post:
====================Gerd's post Started===============================
Zoltán,

I had the problem once when I checked for spec build only in the package build options. I then checked the BSFN build option as well and it worked.
When you check spec build only it will compile the triggers, merge the object code into the dll, but will not deploy it. All that is a long time ago, but I remember I got it working.

Good luck and let me know, Gerd

About Update2: there are 18 Fxyz.C files in the Update2/source directory. I understand that those are triggers (table event rules).

====================Gerd's post Ended=================================
Thank you Gerd again.

P.S.: The last sentence in Gerd's post is an answer for an other issue that I opened also.



B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Back
Top