I need help to figure out what’s causing this error:
We cannot insert any documents now, anything! do you have any idea what’s this ORA-01008 means? Thanks for any help and I appreciate it.
2003-04-28 09:35:55 EDT [B2BUNKW.TRANET.0822] Inserting doc 0a2c011df70d47c9000
0322f into datastore [TRNSERV.000016.000073]
2003-04-28 09:35:56 EDT [B2BUNKW.TRANET.0176] An error occurred trying to inser
t document (doc id = 0a2c011df70d47c90000322f, sender id = 000000000000000000000
000) into the database. [TRNSERV.000007.000017]
2003-04-28 09:35:56 EDT [B2BUNKW.TRANET.9998] Exception => Couldnt insert new d
ocument
(0) java.sql.SQLException: [MERANT][SequeLink JDBC Driver][Oracle]ORA-01
008: not all variables bound
(1) java.sql.SQLException: [MERANT][SequeLink JDBC Driver][Oracle]ORA-01
008: not all variables bound
java.sql.SQLException: [MERANT][SequeLink JDBC Driver][Oracle]ORA-01008: not all
variables bound
This code relates a Oracle side issue not related to webMethods IS side.
So Just follow up with your oracle DBA folks,and also make sure that merant sequelink driver is running or not.
Or check in the TNConsole settings for the Database Setup if some body might have changed settings for connecting database and if no TN used check in the IS admin console database configuration.
thanks for your help. I spoke with our DBA and she find nothing modified on the database setup. I looked at the TNconsole also and check the server setup but i don’t see ny changes. In fact, I can see our previous transactions and I can browse the profiles. When I try to bounce the server, here is the error i got during initialization: ( this error is I guess during “Prefetching Profile Summaries”…)
2003-04-28 12:40:52 EDT [B2BUNKW.TRANET.0224] Initializing task store [TRNSERV.
000005.000022]
2003-04-28 12:40:53 EDT [B2BUNKW.TRANET.0506] Prefetching ProfileSummaries [TRN
SERV.000021.000009]
2003-04-28 12:40:53 EDT [B2BUNKW.TRANET.1445] tn.poll.ierr
2003-04-28 12:40:53 EDT [B2BUNKW.TRANET.9998] Exception => An error occurred wh
ile retrieving polling frequencies.
(0) java.sql.SQLException: [MERANT][SequeLink JDBC Driver]Conversion of
value ac141da5f70d827a0000007b at column 1 failed.
(1) java.sql.SQLException: [MERANT][SequeLink JDBC Driver]Conversion of
value ac141da5f70d827a0000007b at column 1 failed.
(2) java.sql.SQLException: java.lang.NumberFormatException: ac141da5f70d
827a0000007b
Does anyone know where I can control the logging of these TN messages labeled B2BUNKW to the server log file? I want to be able to disable them so that I dont see them in my server log file.
example log messages I want to remove:
B2BUNKW.TRANET.1073- done invoking document
B2BUNKW.TRANET.1423- no envelope queries done
B2BUNKW.TRANET.1315- inserting TN doc to database
B2BUNKW.TRANET.1244- document type cache executed