i am trying to insert the record into Emp table of ORCL Database and i had created the Insertnotification also which should sense the insert into ORCL Database and send that record into Emp table oF another user. but both of them are in same database. i created the service and trigger to perform this .
When i insert the record into emp table it is inserting the record into another table but not the values only null. when i checked the emp of another scheama i querry ( select count(*) from emp ) it is showing i have one record, but when i am querring this ( select * from emp ) it is displaying nothing but blanks.
i thought that integration server is not getting refereshed so i shutdown it normally and i restarted. then the problem started…
it is starting the integration server and shutting down simultaneously . not allowing me to perform any thing …
Please help me to resolve this issue.
ALL INPUTS WILL BE APPRECIATED…
Have you looked at the IS logs? It is located at <your installation base path>/IntegrationServer/logs/server<date>.log
You said that you have shut IS down ‘normally’, so I am assuming that the LOCKFILE is not dangling in the IS install directory, but it could take a peek there.
Another file that could give a hint on what is going on is the JVM stack dump. Usually you can find it under the name HOTSPOT*, but its localation depends on how you starts IS.
Hi All,
Yeah i checked for the lockfile, which i could not
find on the <i…s>/biN Directory. this means my database
was getting shutdown normally. but i am unable to understand
why it is shuttingdown… what could be the reasons
this is my server.log file which the latest …
First half of Log file is placed here and next is in next posting…
First Half
Integration Server 6.1 Build 132
2005-08-02 08:54:39 GMT+03:00 [ISS.0025.0006C] License Manager started
2005-08-02 08:54:39 GMT+03:00 [ISS.0025.0041C] FIPS mode not initialized
2005-08-02 08:54:39 GMT+03:00 [ISS.0025.0017C] Repository Manager started
2005-08-02 08:54:46 GMT+03:00 [ISS.0025.0024C] JDBC Connection Manager started
2005-08-02 08:54:48 GMT+03:00 [ISS.0025.0023C] Audit Log Manager started
2005-08-02 08:54:48 GMT+03:00 [ISS.0025.0021C] ACL Manager started
2005-08-02 08:54:48 GMT+03:00 [ISS.0025.0008C] State Manager started
2005-08-02 08:54:52 GMT+03:00 [ISS.0025.0010C] Service Manager started
2005-08-02 08:54:52 GMT+03:00 [ISS.0025.0020C] Validation Processor started
2005-08-02 08:54:52 GMT+03:00 [ISS.0025.0022C] Statistics Processor started
2005-08-02 08:54:52 GMT+03:00 [ISS.0025.0018C] Invoke Manager started
2005-08-02 08:54:53 GMT+03:00 [ISS.0025.0012C] Cache Manager started
2005-08-02 08:54:54 GMT+03:00 [ISS.0098.0026D] Document Store DefaultStore initialized
2005-08-02 08:54:55 GMT+03:00 [ISS.0098.0026D] Document Store VolatileTriggerStore initialized
2005-08-02 08:54:55 GMT+03:00 [ISS.0098.0026D] Document Store TriggerStore initialized
2005-08-02 08:54:56 GMT+03:00 [ISS.0098.0026D] Document Store ResubmitStore initialized
2005-08-02 08:54:56 GMT+03:00 [ISS.0106.0001D] Join Manager initialized
2005-08-02 08:54:56 GMT+03:00 [ISS.0025.0032C] Dispatcher initialized
2005-08-02 08:54:56 GMT+03:00 [ISS.0025.0004C] Flow Service Manager started
2005-08-02 08:54:56 GMT+03:00 [ISS.0025.0002C] Package Manager started
2005-08-02 08:54:56 GMT+03:00 [ISS.0025.0011C] Package Replicator Manager started
2005-08-02 08:54:56 GMT+03:00 [ISS.0028.0001C] Loading packages
2005-08-02 08:54:57 GMT+03:00 [ISS.0028.0006C] Unable to load WmSWIFTNetServerSample package (possibly due to circular dependencies)
2005-08-02 08:54:57 GMT+03:00 [ISS.0028.0007C] This package requires WmSWIFTNetServer package (Version 6.0.1) to load
2005-08-02 08:55:05 GMT+03:00 [ISS.0028.0005C] Loading WmRoot package
2005-08-02 08:55:13 GMT+03:00 [ISS.0028.0005C] Loading WmJBoss package
2005-08-02 08:55:22 GMT+03:00 [ISS.0028.0005C] Loading WmPublic package
2005-08-02 08:55:27 GMT+03:00 [ISS.0028.0005C] Loading WmUDDI package
2005-08-02 08:55:31 GMT+03:00 [ISS.0028.0005C] Loading WmSamples package
2005-08-02 08:55:43 GMT+03:00 [ISS.0028.0005C] Loading WmTN package
2005-08-02 08:55:47 GMT+03:00 [ISS.0028.0005C] Loading WmTNSamples package
2005-08-02 08:55:52 GMT+03:00 [ISS.0028.0005C] Loading WmBrokerAdmin package
2005-08-02 08:55:54 GMT+03:00 [ISS.0028.0005C] Loading WmFlatFile package
2005-08-02 08:55:55 GMT+03:00 [ISS.0028.0005C] Loading WmFlatFileSamples package
2005-08-02 08:55:57 GMT+03:00 [ISS.0028.0005C] Loading WmDB package
2005-08-02 08:55:58 GMT+03:00 [ISS.0028.0005C] Loading WmTomcat package
2005-08-02 08:56:00 GMT+03:00 [ISS.0028.0005C] Loading WmPRT package
2005-08-02 08:56:01 GMT+03:00 [ISS.0098.0054D] Broker not configured. Trigger:wm.prt.status:trigger will be able to receive Documents published locally only.
2005-08-02 08:56:02 GMT+03:00 [ISS.0028.0005C] Loading WmModeler package
2005-08-0
From your log file it doesn’t look like there is a problem with the presence of the LOCKFILE. Well, the file itself is supposed to be at
“C:\Program Files\webMethods6\IntegrationServer” in your instance. Another thing that I don’t think might be an issue here though is your installation directory. It includes “Program Files” which may sometimes be an issue; you know java and spaces. Just “C:\webMethods6” is preferable.
Can you first make sure that the LOCKFILE is not in “C:\Program Files\webMethods6\IntegrationServer”. And then go to command prompt. Change the directory to “C:\Program Files\webMethods6\IntegrationServer\bin”. Then type “server.bat -log none -debug 5” and execute and see what is says from there. Let’s take it from there!
2005-08-02 08:58:22 GMT+03:00 [ISS.0014.0002C] Initialization completed in 225 seconds.
2005-08-02 08:58:22 GMT+03:00 [ISS.0025.0016C] Config File Directory Saved
2005-08-02 08:58:24 GMT+03:00 [ART.0118.5046E] Adapter Runtime (Connection): Unable to get a connection to resource Test2.Connection:NewConnection. Resource not available.
2005-08-02 08:58:24 GMT+03:00 [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.311] The connection is not available for " initCallBack() ".
2005-08-02 08:58:24 GMT+03:00 [ART.0116.3038E] Adapter Runtime (Notification): Error in Notification Callback:initCallback notification Test2.Notification:InsertNotification.
2005-08-02 08:58:25 GMT+03:00 [ART.0118.5046E] Adapter Runtime (Connection): Unable to get a connection to resource Test.Connectionracle_connection. Resource not available.
2005-08-02 08:58:25 GMT+03:00 [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.311] The connection is not available for " initCallBack() ".
2005-08-02 08:58:25 GMT+03:00 [ART.0116.3038E] Adapter Runtime (Notification): Error in Notification Callback:initCallback notification Test.Trigger:InsertTrigger.
2005-08-02 08:58:26 GMT+03:00 [ART.0118.5046E] Adapter Runtime (Connection): Unable to get a connection to resource Connections:DBConnections. Resource not available.
2005-08-02 08:58:26 GMT+03:00 [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.311] The connection is not available for " initCallBack() ".
2005-08-02 08:58:26 GMT+03:00 [ART.0116.3038E] Adapter Runtime (Notification): Error in Notification Callback:initCallback notification Notifications:InsertServiceNotification.
2005-08-02 08:58:36 GMT+03:00 [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.316] Cannot execute the SQL statement “SELECT ALL t1.EMPNO,t1.ENAME,t1.JOB,t1.MGR,t1.HIREDATE,t1.SAL,t1.COMM,t1.DEPTNO,t1.wm_rowid,t1.wm_sendTime FROM WMBTest3bbo2bbr t1 WHERE (wm_rowid> ? ) ORDER BY wm_rowid”. "
(42000/942) ORA-00942: table or view does not exist
"
ORA-00942: table or view does not exist
2005-08-02 08:58:36 GMT+03:00 [ART.0116.3001E] Adapter Runtime (Notification): Notification error during execution of Notificationsrcl_Insert_Notif. Error: [ADA.1.316] Cannot execute the SQL statement “SELECT ALL t1.EMPNO,t1.ENAME,t1.JOB,t1.MGR,t1.HIREDATE,t1.SAL,t1.COMM,t1.DEPTNO,t1.wm_rowid,t1.wm_sendTime FROM WMBTest3bbo2bbr t1 WHERE (wm_rowid> ? ) ORDER BY wm_rowid”. "
(42000/942) ORA-00942: table or view does not exist
"
ORA-00942: table or view does not exist
.
2005-08-02 08:58:36 GMT+03:00 [SCC.0121.0035E] resource delisted with TMFAIL flag, transaction marked for rollback. xid = rsiddiqui/1122962305612 rxid = [FormatId=45744, GlobalId=rsiddiqui/1122962305612, BranchQual=1]
2005-08-02 08:58:36 GMT+03:00 [SCC.0121.0050I] rollback-only flag is set. rolling back transaction, xid = rsiddiqui/1122962305612
2005-08-02 08:58:46 GMT+03:00 [ART.0114.1007E] Adapter Runtime: Error Logged. See Error log for details. Error: [ADA.1.316] Cannot execute the SQL statement “SELECT ALL t1.EMPNO,t1.ENAME,t1.JOB,t1.MGR,t1.HIREDATE,t1.SAL,t1.COMM,t1.DEPTNO,t1.wm_rowid,t1.wm_sendTime FROM WMBTest3bbo2bbr t1 WHERE (wm_rowid> ? ) ORDER BY wm_rowid”. "
(42000/942
From your log file, there doesn’t seem to be a problem with your server starting up. It looks like it is already up. Can you try browsing http://localhost:5555 and see what you get.
hi Amon,
I Too didnt find any of the reason why the Integration Server is shutting down, as u said i am Starting from the command prompt, it is starting and again it is comming back to command prompt.
Please any clues in this reagard what could be other reason making integration server to fail in starting up. i was working fine till now from 6 months, i didnt find any problem but all of the sudden this starts and now i am unable to start it.
Is Installing Integration Server is the only choice, if yes how could i get back my Previos work.
install another instance of IS on the same box, different folder ofcourse. Move your packages by copying them over from oldIS to newIS. Restart your newIS and all your packages will be visible again. Make sure that you do all your configuration work in advance on new IS.
Ok Rizwan what I understand from Log and the post and I cross my fingers that I m right is your IS is starting but gets shuts down. Can you tell me after how long it shuts down. May be there is some service which gets executed that causes it to shut down, my guess is that one of the file is currupted in the config folder. You can always delete the config folder and start the IS(it creates the folder again automatically), but that would make the IS into default settings like 5555 port etc and you will lose the user groups and ACL, offcourse this is the last thing you wanna try.
hello all,
Thanks to all who help me with there views to solve my problem.
As i said in my first posting, i wana insert record into one table which will be notified and will get insert into another table of another user.
i removed that pakage manually and then i bounce the IS , then it started .
i dont know till now what was mistake i made in JDBC ADAPTOR SETTING
I will check that.
Any way thanks to all experts who helped with there valuable views
thanks again
regards
Rizwan.
racle_connection. Resource not available.