Unable to register delivery service

Guest · November 6, 2002, 12:28am

Hello,

I have just installed IS46 and TN46 with a connectJDBC driver. IS46 works fine but I cannot start TN because of the following message:
“Unable to register delivery service Primary HTTP - SQLException inserting new delivery service Primary HTTP: [DataDirect][Oracle JDBC Driver][Oracle]ORA-01722: invalid number”

I tested the driver and I can log to the db fine. Has anyone face the same problem?

Thanks.

theo1 · November 6, 2002, 6:23am

Did you initialize the TN db by importing init.xml?

Guest · November 6, 2002, 2:13pm

No, but I can’t access the console because of the error. So I’m stuck. I created the TN db via a SQL script given by webMethods.

theo1 · November 7, 2002, 12:27am

You can try initializing from the command line. Go to the \IntegrationServer4\packages\WmTN\bin dorectory.

type this:
tnimport -xml init.xml -db

What happens?

sonam · November 7, 2002, 6:19am

Dai - Try initing the DB as Theo says. Also. this a google search on the “ORA-01722” error above returns:

[url=“http://www.orafaq.com/error/ora-01722.htm”]http://www.orafaq.com/error/ora-01722.htm[/url]

You may find this useful.