Hello All,

I need help me understanding the following dump of a process. This process was written in C/ProC.
Overview of the process: It is processing transactions and is doing an insert into the table. It builds an insert statement and uses ProC Embedded SQL syntax and then executes it using
EXEC SQL EXECUTE IMMEDIATE statement.

Symptom before I debug:

The process does not process any further transaction. I used dbx and showProcInfo both have give the following stack of its execution state at the point where it seems to be blocking.

The process seems to be performing a memory read? not clear if its
memory read or some other. But this read is blocking, it never returns.
Also, I was tring to see if there were any locks, the dba did not find any locks. The stack also show the

Please at the stack below:thread info. it seems to be running.

My questions : What type of read is this? The procedure in my code is called "generateAppt2ProcessEntry()", which calls the embeded sql statement which is doing an insert into the table. We don't see any locks on the table(it could be our illusion). Just give me any idea, you think of what is going on looking at the stack.

STACK and THREAD DUMP:
====================================================
0xd01868d0 (read+0x1e4) 80410014 lwz r2,0x14(r1)
thread state-k wchan state-u k-tid mode held scope function
>$t1 run running 27129 k no pro read

1 threads

=== Thread 1 ===

read(??, ??, ??) at 0xd01868d0 <----------what is this read?
snttread(??, ??, ??) at 0xd3febe04
nttrd(??, ??, ??, ??) at 0xd3fe79d0
nsprecv(??, ??, ??) at 0xd3f867f4
nsrdr(??, ??) at 0xd3f82e8c
nsdo(0x2006e350, 0x55, 0x200a0c78, 0x2006e420, 0x2ff1f6e0, 0x0, 0x3) at 0xd3f806a0
nioqrc(??, ??, ??, ??, ??) at 0xd42c3e58
ttcdrv(??, ??) at 0xd42b1040
nioqwa(??, ??, ??, ??, ??, ??) at 0xd42c6f64
upirtrc(??, ??, ??, ??, ??, ??, ??, ??) at 0xd4140670
kpurcsc(??, ??, ??, ??, ??, ??, ??, ??) at 0xd4214808
kpuexecv8(??, ??, ??, ??, ??) at 0xd4218944
kpuexec(??, ??, ??, ??, ??, ??, ??, ??) at 0xd421a324
OCIStmtExecute(??, ??, ??, ??, ??, ??, ??, ??) at 0xd41ff98c
sqlcucExecute(??, ??, ??, ??, ??, ??, ??) at 0xd4304568
sqlexet(??, ??) at 0xd4316420
sqlnst(??, ??, ??) at 0xd430351c
sqlcmex(??, ??, ??, ??, ??) at 0xd4328f24
sqlcxt(??, ??, ??, ??) at 0xd43287bc
generateAppt2ProcessEntry(patient_id = "Account:%s;\n", account = "1435036", idx = 8, cMsgType = "9; Account:1435036;\n-91516-process_CORP:in: Corp=, Pat=0851509, FC=01\n-91516-process_CORP: Corp=0862776 , Pat=0851509, FC=01\n\n-91516-tttttttORACLE error--\n-91516-Rollback occurred.\n-91516-Ending Segment Parser Processing...\n-91516-Oracle error: ORA-01403: no data found ORA-01403: no data found \nC=01\nTransaction not in schedule admit & not an A08, exiting\nCommit occurred.\nChild processing msg:1196983\n-91516-PatID[4]:0286326:\n-91516-CorpID[4,1]:0286326:\n-91516-FacCode[20]:01:\ncMsgType:A04; Patient:0286326; Account:0460057877;\n-91516-process_CORP:in: Corp=0286326, Pat=0286326, FC=01\n-91516-process_CORP: Corp=0286326, Pat=0286326, FC=01\nTransaction not in schedule admit & not an A08, exiting\nCommit occurred.\nChild processing msg:1196984\n-91516-PatID[4]:0650178:\n-91516-CorpID[4,1]:0652364:\n-91516-FacCode[20]:01:\ncMsgType:A05; Patient:0650178; Account:0507563398;\n-91516-process_CORP:in: Corp=0652364, Pat=0650178, FC=01\n-91516-process_CORP: Corp=0652364, Pat=0650178, FC=01\nTransaction not in schedule admit & not an A08, exiting\nCommit occurred.\nChild processing msg:1197015\n-91516-PatID[4]:0524311:\n-91516-CorpID[4,1]:0524311:\n-91516-FacCode[20]:01:\ncMsgType:A04; Patient:0524311; Account:0460057935;\n-91516-process_CORP:in: Corp=0524311, Pat=0524311, FC=01\n-91516-process_CORP: Corp=0524311, Pat=0524311, FC=01\nTransaction not in schedule admit & not an A08, exiting\nCommit occurred.\nChild processing msg:1196985\n-91516-PatID[4]:1509295:\n-91516-CorpID[4,1]:1509295:\n-91516-FacCode[20]:01:\ncMsgType:A08; Patient:1509295; Account:0507492150;\n-91516-process_CORP:in: Corp=1509295, Pat=1509295, FC=01\n-91516-process_CORP: Corp=1509295, Pat=1509295, FC=01\nCommit occurred.\nChild processing msg:1196986\n-91516-PatID[4]:1509295:\n-91516-CorpID[4,1]:1509295:\n-91516-FacCode[20]:01:\ncMsgType:A04; Patient:1509295; Account:0507492150;\n-91516-process_CORP:in: Corp=1509295, Pat=1509295, FC=01\n-91516-process_CORP: Corp=1509295, Pat=1509295, FC=01\nTransaction not in schedule admit & not an A08, exiting\nCommit occurred.\nChild processing msg:1196987\n-91516-PatID[4]:0851509:\n-91516-CorpID[4,1]:0862776:\n-91516-FacCode[20]:01:\ncMsgType:A08; Patient:0851509; Account:0507490782;\n-91516-process_CORP:in: Corp=0862776, Pat=0851509, FC=01\n-91516-process_CORP: Corp=0862776, Pat=0851509, FC=01\n-91516-search failed, no subfields in field\n-91516-search failed, no subfields in field\n-91516-search failed, no subfields in field\nCommit occurred.\nChild processing msg:1196988\n-91516-PatID[4]:0661590:\n-91516-CorpID[4,1]:0665725:\n-91516-FacCode[20]:01:\ncMsgType:A08; Patient:0661590; Account:0507489420;\n-91516-process_CORP:in: Corp=0665725, Pat=0661590, FC=01\n-91516-process_CORP: Corp=0665725, Pat=0661590, FC=01\nCommit occurred.\nChild processing msg:1196989\n-91516-PatID[4]:0661590:\n-91516-CorpID[4,1]:0665725:\n-91516-FacCode[20]:01:\ncMsgType:A08; Patient:0661590; Account:0507489420;\n-91516-process_CORP:in: Corp=0665725, Pat=0661590, FC=01\n-91516-process_CORP: Corp=0665725, Pat=0661590, FC=01\nCommit occurred.\nChild processing msg:1196990\n-91516-PatID[4]:1509295:\n-91516-AIEEEE... Bad search on corpID PID[4,1]. Seg#3\n-91516-CorpID[3]:1509295:\n-91516-AIEEEE... Bad search on Account (LookAt:PID[18]). Seg#3, StrPID\n-91516-AIEEEE... Bad search on Account (PID[3,2]). Seg#3, StrPID\ncMsgType:Z01; Patient:1509295; Account:984610;\n-91516-process_CORP:in: Corp=1509295, Pat=1509295, F"), line 3045 in "segparse.c"
process_segments(corp_id = "Child processing msg:%ld\n", patient_id = (invalid char ptr (0x001243c0)), account = "", cFacCode = ""), line 2186 in "segparse.c"
main(argc = 0, argv = (nil)), line 1215 in "segparse.c"
====================================================