TERS - that Insert to No-Where-Land

[DBohner-(db)]

Howdy,

I have sets of TERs that insert to an Interface table. Several days ago the interface table stopped incrementing (this is odd).

I tried the activating the TERS in other environments, and they continued to work. However, when I run the same set of applications in production - the interface table does not recieve its inserts.

I put a FAT client in debug mode - and reviewed the log. I found where OW does the Insert that it is supposed to - and claims the insert is successful. However, no data ever showed up in the targeted table.

I am suspect that OCM is hosed or that something else might be awry. It was suggested that the SQL Packages might be defunct, also. I can UTB to the table - but I haven't tried building any reports to it - or building an application over it ( to test the mapping in application modes).

Yes! I do find this puzzling - and interesting... Anyone that can forward any suggestions??? I'd be willing to fedex a Mt. Dew and Cheetos (to the solution provider, only)....

Thanks!

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

 

[AKOCH1]

Daniel,=20

If this problem is on your AS/400 install, then you might want to check =
the
interface file.
Check with DSPFD and look for the Member size parameter. I had a file =
once
with a record limitation and it stopped populating after the max was
reached. Change the parameter to *NOMAX and the insert will work again.

Andr=E9 Koch
[email protected]

JDE Xe coex with A7.3 c11, AS/400, CO on SQL

 

[Zoltan_Gyimesi]

Hi Daniel,

Just some thought, question.

1.) If your interface table resides in a separate data source then check its table space, maybe it is already out of space. If it is set to work in "auto increment" mode and it is already "auto incrementing" then try to increase the table space to do not let to work the auto increment.

2.) Do you use any Next Number in your interface insertation? If yes then check the current value of this next number

3.) "Get" the spec of your interface table from the production path code and check with TER Designer that does your ER logic there or not.

4.) Have your application ever worked on your production environment?

Good luck,

Zoltán

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

 

[DBohner-(db)]

Zoltan,

1.) Interface table resides in the same datasource (default) as other
tables... shouldn't be a datasource issue. The Increment is set to no-max -
I haven't tried changing this.

2.) We do use Next Numbers. I have checked the next numbers (56/9) and
they do increment as expected.

3.) I have reviewed the TER in Production - and ERCompared against the
working environments... it is identical. We even went as far as to move the
object from a working environment then do a full package build... nada.

4.) The TERs functioned (nearly flawlessly) for the past six months.
Suddenly, on 2/28/2 at 14:34, the inserts into the table stopped working. I
haven't been able to find any logs that show abnormal activity was taking
place at the time the Inserts stopped working.

We have deleted and regenerated the table and its logicals(indexes)...
still no luck.

This issue has been logged with JDE - I'll update you if it gets resolved
from their end.

And the final thought... one of our consultants mentioned that sometimes
the SQL Packages on the AS/400 get a bit whacked... and need to be
deleted...

hummmmmmmmm



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

 

[DBohner-(db)]

The limitation on the table is *Nomax.

See - I am trying to stay at least one step ahead of the questions...



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

 

[DBohner-(db)]

OK we have a resolution...

From the jdedebug.log - there was no error message.
Within the jde.log - there was an error message that stated a numeric value
was too big for the field.

I looked at the field - we use Next Numbering to generate the key - the NN
was 1,000,000+ but the field was only 6-numeric. I reset the NN and our
TER Inserts are working again.

Thanks for all your patience...





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

 

[TRathjen]

Re: RE: TERS - that Insert to No-Where-Land

Daniel,

Thanks for posting the resolution to your problem.
You are the only person having this problem NOW, but I'm sure other developers will come across this in the future. Or maybe we won't because we'll have filed for future use - next number in custom table, check on field size! And you will have helped us look like the geniuses we are.

Note to other posters: let us know your resolutions also. They are one of the things that make this forum so great.

Tim Rathjen
B7332 SP16 Oracle 8.1.6 Intel/NT OptioDCS 6.3.6

 

[Zoltan_Gyimesi]

Re: RE: TERS - that Insert to No-Where-Land

Daniel,

First of all, I am glad to read that you found the resolution and I would like to thank your update to let us know.

On the other hand, what about my #2 suggestion of my reply in this thread:
=================
2.) Do you use any Next Number in your interface insertation? If yes then check the current value of this next number
=================
and at last but not least, what about your statement in your originator post:
=================
I'd be willing to fedex a Mt. Dew and Cheetos (to the solution provider, only)
=================
)))))
(just kidding)

Best regards,

Zoltán

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

 

[DBohner-(db)]

RE: RE: TERS - that Insert to No-Where-Land

Zotan,

Would you prefer Mt Dew or J(z)olt?

Where do I send your lottery winnings?

Thanks!



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

 

[Zoltan_Gyimesi]

Re: RE: RE: TERS - that Insert to No-Where-Land

First to the List. Excuse me this off-topic reply but I amn't able to stop me. Thanks!
======
Hey Daniel,

I am living and working not too far off you.
Please, fedex the Mt. Dew and Cheetos to Budapest city of Hungary (Middle Europe). It's just s(ome)miles ) ))

(just kidding again)

Funny regards,

Zoltán

P.S.: My name correctly is Zoltán or Zoltan instead of Zotan. Never mind the miss-spelling. No problem.

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

 

[BBritain]

RE: RE: RE: TERS - that Insert to No-Where-Land

A deals a deal, Zoltan (can't get the ' over the A) should give his address and Daniel should send the goodies. That's my vote!

Ben again

 

[DBohner-(db)]

RE: RE: RE: TERS - that Insert to No-Where-Land

Zoltan,

I checked with FEDEX. They said it would cost me about thirty US Dollars to
send it over... They weren't so sure that the 'product(s)' would be in
eatable or drinkable conditions... maybe a little of both.

I could FAX? Or, should I just set your winnings out by the front swing -
and have you pick it up, yourself?

So, where in Hungary do I send?

Big-huge-grins





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