User reported that new transactions are not being received and all sent transactions are changing to the error status, but the recipients have received them. On investigation we found that new incoming transaction instances had started and could be seen in Enterprise Manager, but didn't progress beyond the initial step.
Check the SOA repository database has enough free space to write new instance log data to. You will need to check the server which hosts the SOA database has enough free disc space and you should also check the datafile and tablespace usage. If you find that a datafile or tablespace used by the SOA repository is full, you will need to increase it and then restart the web services server at Operating System level.
Below is a handy script which can be run in SQLPlus to give a detailed report on datafile and tablespace usage:
SELECT Substr(df.tablespace_name,1,20) "Tablespace Name", Substr(df.file_name,1,40) "File Name", Round(df.bytes/1024/1024,2) "Size (M)", Round(e.used_bytes/1024/1024,2) "Used (M)", Round(f.free_bytes/1024/1024,2) "Free (M)", Rpad(' '|| Rpad ('X',Round(e.used_bytes*10/df.bytes,0), 'X'),11,'-') "% Used", AUTOEXTENSIBLE, Round(df.maxbytes/1024/1024,2) "MAXBYTES (M)" FROM DBA_DATA_FILES DF, (SELECT file_id, Sum(Decode(bytes,NULL,0,bytes)) used_bytes FROM dba_extents GROUP by file_id) E, (SELECT Max(bytes) free_bytes, file_id FROM dba_free_space GROUP BY file_id) f WHERE e.file_id (+) = df.file_id AND df.file_id = f.file_id (+) ORDER BY df.tablespace_name desc, df.file_name;
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!