| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Urgent: NNSY Issue on MQSI 2.1 after Upgradation of Database |
« View previous topic :: View next topic » |
| Author |
Message
|
| Manu30 |
 Posted: Tue Jun 26, 2007 8:29 am Post subject: Urgent: NNSY Issue on MQSI 2.1 after Upgradation of Database |
 |
|
Newbie
Joined: 26 Jun 2007
Posts: 7
|
Hi,
We just did the upgradation of our database from 8i to 9i. We are using MQ 5.3 and MQSI 2.1. Before upgradation it was working fine, but after upgradation all NNSY formats are not working. Whenever we pass any message through the message flow in which NNSY is involved it throws following error:
20070620141719590Z|NeonConnectionManager|55,986|2,057|Database Session|NNOT_EC_NATIVE_API_ERROR|Unknown||A database API call failed.
File: NNSqlOra8Obj.cpp
Line: 244
Call: OCIStmtExecute
Code: 933
Text: ORA-00933: SQL command not properly ended
20070620141719652Z|NeonConnectionManager|55,986|2,057|MessageProcessor|1080|Error||Database internal error. Unable to retrieve format SAP.IC.ORDERS05^1
20070620141719943Z|NeonConnectionManager|55,986|2,057|INFR|INFR|Info||Ending process.
20070620141839928Z|NeonConnectionManager|55,986|2,057|INFR|INFR|Info||Library info:
ParserException "NN111E: NEONMSG parser failed to process message. Message type : SAP.IC.ORDERS05^1 Error # : 1080 Error message : Database internal error. Unable to retrieve format SAP.IC.ORDERS05^1 When processing the message using format SAP.IC.ORDERS05^1, NNSY reported an error.The NNSY error code was 1080. The NNSY error text was Database internal error. Unable to retrieve format SAP.IC.ORDERS05^1.
I tried following approaches to troubleshoot the same but no success:
1. The same flow was working fine in QA before Upgrade and the same flow is working fine in Dev environment, so i tried pulling the latest NNFie structures from Dev Config box and importing the same in QA Broker. Still am getting the same error.
2. I tried manual parsing in QA box using NNSY VisualTester, it parses the file correctly.
3. I checked the NNSY User Manual for the above error code, it ask to run Consistency Check. We have run the consistency check and it gives no issue.
Please help.
Thanks and regards,
-Manu |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Jun 26, 2007 8:39 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Please don't double-post. 
Likely, you're out of luck entirely and will need to go back to Oracle 8.
Or do what you should have done two years ago, and upgrade.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mqperson |
| Posted: Thu Jul 12, 2007 11:29 am Post subject: |
|
|
Apprentice
Joined: 10 Jan 2006
Posts: 32
|
| Is "SAP.IC.ORDERS05^1" the name of your neon input format ? |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
