Encounter error in Session. Help!

[jlito]

Hi Guys,

I have created a mapping and session successfully. Then when I run the session, sometimes it returns an error that is:

MAPPING> TM_6180 Deadlock retry logic will not be implemented.
MAPPING> Thu May 29 09:27:04 2003
MAPPING> CMN_1038 Oracle Error
CMN_1038 [SQL Stmt : SELECT A.OBJECT_LOCK_TYPE, A.OBJECT_LOCKER_ID, A.LOCK_TIME, B.MAPPING_ID, B.LAST_SAVED, A.OBJECT_TYPE_ID, A.HOSTNAME, A.PROC_ID FROM OPB_MAPPING B, OPB_OBJECT_LOCKS A WHERE A.OBJECT_ID = B.MAPPING_ID AND B.MAPPING_ID = 82 AND A.OBJECT_TYPE_ID = 21 AND B.SUBJECT_ID = 2 AND B.VERSION_ID = 2 AND A.SUBJECT_ID = B.SUBJECT_ID AND A.VERSION_ID = B.VERSION_ID UNION SELECT A.OBJECT_LOCK_TYPE, A.OBJECT_LOCKER_ID, A.LOCK_TIME, B.OBJECT_ID, B.CREATION_TIME, A.OBJECT_TYPE_ID, A.HOSTNAME, A.PROC_ID FROM OPB_SHORTCUT B, OPB_OBJECT_LOCKS A WHERE A.OBJECT_ID = B.OBJECT_ID AND B.OBJECT_ID = 82 AND A.OBJECT_TYPE_ID = 21 AND B.SUBJECT_ID = 2 AND B.VERSION_ID = 2 AND A.SUBJECT_ID = B.SUBJECT_ID AND B.VERSION_ID = A.VERSION_ID UNION SELECT 0, 0, '', B.MAPPING_ID, B.LAST_SAVED, 21 ,'', 0 FROM OPB_MAPPING B WHERE B.MAPPING_ID = 82 AND B.SUBJECT_ID = 2 AND B.VERSION_ID = 2 UNION SELECT 0, 0, '', B.OBJECT_ID, B.CREATION_TIME, 21 ,'', 0 FROM OPB_SHORTCUT B WHERE B.OBJECT_ID = 82 AND B.OBJECT_TYPE = 21 AND B.SUBJECT_ID = 2 AND B.VERSION_ID = 2 UNION SELECT A.OBJECT_LOCK_TYPE, A.OBJECT_LOCKER_ID, A.LOCK_TIME, B.VERSIONID, B.CREATION_TIME, A.OBJECT_TYPE_ID, A.HOSTNAME, A.PROC_ID FROM OPB_SCHEMA B, OPB_OBJECT_LOCKS A WHERE A.OBJECT_ID = B.VERSIONID AND A.OBJECT_TYPE_ID = 28 AND B.SUBJ_ID = 2 AND B.VERSIONID = 2 AND A.SUBJECT_ID = B.SUBJ_ID AND B.VERSIONID = A.VERSION_ID UNION SELECT A.OBJECT_LOCK_TYPE, A.OBJECT_LOCKER_ID, A.LOCK_TIME, B.SUBJ_ID, B.CREATION_TIME, A.OBJECT_TYPE_ID, A.HOSTNAME, A.PROC_ID FROM OPB_SUBJECT B, OPB_OBJECT_LOCKS A WHERE A.OBJECT_ID = B.SUBJ_ID AND B.SUBJ_ID = 2 AND A.OBJECT_TYPE_ID = 29 AND A.SUBJECT_ID = B.SUBJ_ID UNION SELECT A.OBJECT_LOCK_TYPE, A.OBJECT_LOCKER_ID, A.LOCK_TIME, A.SUBJECT_ID, '', A.OBJECT_TYPE_ID, A.HOSTNAME, A.PROC_ID FROM OPB_OBJECT_LOCKS A WHERE A.OBJECT_ID = 0 AND A.OBJECT_TYPE_ID = 43
Function: Execute
Error: ORA-00904: invalid column name

What is the cause of this problem? What should I do next to solve this? Because sometimes I'm able to run the same session but I just need to run it several times which is very frustrating since I have to pass before my deadline.


Thanks in advance!

Rgds,
Jlito

 

[smajay]

Hi,
Could you able to find out invalid column?
Whenever you get the session error execute the above sql from sqlplus and identify the invalid column. But as you are saying that it runs somtime and not always. So it is very difficult to guess the reason unless and until you know for which column this is giving error. Also try to find out evertime whenever errror accurs that it is giving same invalid column name.


Pls. let me know after you follow above steps.

 

[blom0344]

I used your SQL through copy/paste on my DB2 repository and it parses just fine. I think the problem is not with the SQL , but perhaps with one of the tables locked during execution of the SQL. You should perhaps try to do a 'dirty read' on the rep tables for this one.........

T. Blom
Information analyst
tbl@shimano-eu.com

 

[smajay]

If the table is locked during execution, I believe the error message can not be Invalid column, if i am not wrong.

 

[blom0344]

Yes, that would appear to be so, but if the SQL sometimes parses and sometimes not, there is no doubt that the ORA error points to something else than an invalid column (assuming the table-structure stays the same..........), that is why I was suggesting a dirty-read (read uncommitted) to check if problems persists........

T. Blom
Information analyst
tbl@shimano-eu.com