Hello Everyone...

Problem:
Getting "unknown reference error" (see attachment) while opening session Display Inventory Transaction By Item {tdinv1501m000}. Getting this for all users including baan. No problem while opening or working with Enter Inventory Transaction by Item or Print Inventory Transaction by Item...

Solutions tried so far..
Ran Remove User Defaults.
Ran Reorganize Tables for tables tdinv001, tdinv100 and tiitm001..
Checked the items existing in inv100 with that of itm001 and found that all were accounted for and that the item reference does exist...

Anything else i can try out to fix this problem?

sk

Hi Sukesh,

Can you check server error log.

If you meant the Event log on the server, then there wasnt anything new reported other than what was already reported in the error message (attached earlier). Here is the description of the only event (Categorized as a bshell error) that was logged when i got the error message:

Env baan4c4 (d:\Baan4c4)
Prog bshell file \logic\mir\mir\bdb_fun.c # 1101
Keyword DB error
Username baan type S language 2
Process 0x6061c
Lasterror 0
Errno 0
bdberrno 301 (Query not correct)
Message Error 301 (Query not correct) on SELECT

sk

Hi Sukesh,

edit or display the session form and look at the field data for "item description" (tiitm001.dsca). In property field "Inp./ref. Express." is should be the following default entry: "tdinv100.cmbg,tiitm100.item". If this is missing then the Standard Programm doesn't know how to retrieve the item description.

Hi Vahdani,
To start off, the session (forms) has never been customized but still i checked out the standard version and found out that both the "tdinv100.cmbg & tiitm100.item" were present in the Input/Ref Expression field of tiitm001.dsca.

Since this problem is only at one of our sites (company), i did a comparison of fields between the sites. On the problematic site i found out that there was an extra field listed in the Maintain Form Fields. The field in question is tiitm001.czed (Containerized) and the interesting part is that its not used on the form. In the Input/Ref Expression of this field, the value tdinv100.item is present. I tried changing it to either 0 or 1 (since deleting option is greyed out) but it gave me different errors while opening the Display Inventory Transaction By Item session.. (Not sure if this is the reason behind the Unknown Reference error)

As far as the difference goes, other than the extra field the problematic site is on SP 18 while the others are on SP19. Could this (also) be a factor? If so, is there any way to fix this without applying SP19?
Last but not least i thought of taking an object dump of this session (from other sites) and restore it in a customized VRC at the current site but then if the field is used in the script then i could be in a spot of bother.. so awaiting further suggestions before taking that attempt..

Any suggestion is welcome...


sk

I can't really tell from your description if it's a data error or a session error
so

if you suspect a data error try:
1. run the failing session with the following in your BW config:
-- -set DBSLOG=01570 <session code>

_The file will be big_

In windows it's in $BSE/tmp in unix it's probably in your home directory.

2. vi the file and from the bottom up search for 606 (i think that's reference does not exist, i don't have the errors in-front of me) you could also look for 303.

basically though, just read backwards, you should find the record it's looking for.

Plan B is to
1. run a -- -dbgobj -keeplog -logfile /tmp/bla.txt <session>
2. compare the objects from that output and make sure they are where you expect them to be... (frequently you'll find an object in your custom VRC that you didn't expect and it's blocking a newly patched object)



Dave

Hi Friends,

I am also facing the same problem.

Has anyone found any solution for this fatal error.


Thanks and Kind Regards,
Rahul