Wednesday, April 21, 2010

Integration Broker - Errors

Schema Validation Tester Error:

Fatal Error: ( line: 0 column: 0 ) An exception occurred! Type:NetAccessorException, Message:Could not open file: http://machname:portno/PSIGW/PeopleSoftServiceListeningConnector?Operation=GetSchema&xsd=KAB_IB_TST_MSG.Version_1Error: ( line: 2 column: 17 ) Unknown element 'KAB_IB_TST_MSG'Error: ( line: 3 column: 15 ) Unknown element 'FieldTypes'Error: ( line: 4 column: 32 ) Unknown element 'KAB_TEST_IB_REC'Error: ( line: 4 column: 32 ) Attribute 'class' is not declared for element 'KAB_TEST_IB_REC'Error: ( line: 5 column: 27 ) Unknown element 'OPRID'Error: ( line: 5 column: 27 ) Attribute 'type' is not declared for element 'OPRID'Error: ( line: 6 column: 33 ) Unknown element 'OPRDEFNDESC'Error: ( line: 6 column: 33 ) Attribute 'type' is not declared for element 'OPRDEFNDESC'Error: ( line: 8 column: 23 ) Unknown element 'PSCAMA'Error: ( line: 8 column: 23 ) Attribute 'class' is not declared for element 'PSCAMA'Error: ( line: 9 column: 33 ) Unknown element 'LANGUAGE_CD'Error: ( line: 9 column: 33 ) Attribute 'type' is not declared for element 'LANGUAGE_CD'Error: ( line: 10 column: 32 ) Unknown element 'AUDIT_ACTN'Error: ( line: 10 column: 32 ) Attribute 'type' is not declared for element 'AUDIT_ACTN'Error: ( line: 11 column: 38 ) Unknown element 'BASE_LANGUAGE_CD'Error: ( line: 11 column: 38 ) Attribute 'type' is not declared for element 'BASE_LANGUAGE_CD'Error: ( line: 12 column: 33 ) Unknown element 'MSG_SEQ_FLG'Error: ( line: 12 column: 33 ) Attribute 'type' is not declared for element 'MSG_SEQ_FLG'Error: ( line: 13 column: 40 ) Unknown element 'PROCESS_INSTANCE'Error: ( line: 13 column: 40 ) Attribute 'type' is not declared for element 'PROCESS_INSTANCE'Error: ( line: 14 column: 37 ) Unknown element 'PUBLISH_RULE_ID'Error: ( line: 14 column: 37 ) Attribute 'type' is not declared for element 'PUBLISH_RULE_ID'Error: ( line: 15 column: 33 ) Unknown element 'MSGNODENAME'Error: ( line: 15 column: 33 ) Attribute 'type' is not declared for element 'MSGNODENAME'Error: ( line: 18 column: 12 ) Unknown element 'MsgData'Error: ( line: 19 column: 18 ) Unknown element 'Transaction'Error: ( line: 20 column: 34 ) Unknown element 'KAB_TEST_IB_REC'Error: ( line: 20 column: 34 ) Attribute 'class' is not declared for element 'KAB_TEST_IB_REC'Error: ( line: 21 column: 30 ) Unknown element 'OPRID'Error: ( line: 21 column: 30 ) Attribute 'IsChanged' is not declared for element 'OPRID'Error: ( line: 22 column: 36 ) Unknown element 'OPRDEFNDESC'Error: ( line: 22 column: 36 ) Attribute 'IsChanged' is not declared for element 'OPRDEFNDESC'Error: ( line: 24 column: 25 ) Unknown element 'PSCAMA'Error: ( line: 24 column: 25 ) Attribute 'class' is not declared for element 'PSCAMA'Error: ( line: 25 column: 22 ) Unknown element 'LANGUAGE_CD'Error: ( line: 26 column: 21 ) Unknown element 'AUDIT_ACTN'Error: ( line: 27 column: 27 ) Unknown element 'BASE_LANGUAGE_CD'Error: ( line: 28 column: 23 ) Unknown element 'MSG_SEQ_FLG'Error: ( line: 29 column: 27 ) Unknown element 'PROCESS_INSTANCE'Error: ( line: 30 column: 27 ) Unknown element 'PUBLISH_RULE_ID'Error: ( line: 31 column: 23 ) Unknown element 'MSGNODENAME'

1) Copy the url in to the address bar of the browser:
http://machine:portno/PSIGW/PeopleSoftServiceListeningConnector?Operation=GetSchema&xsd=KAB_IB_TST_MSG.Version_1

2) Got the following error:


-
-
-
SOAP-ENV:Server
null
-
-
Integration Broker Response
20
505
-
-








3) Solution:
Check if GETROUTINGS Service Operation is Active.

GETROUTINGS Service Operation was not Active.

4) Copy the url in to the address bar of the browser:
http://machname:portno/PSIGW/PeopleSoftServiceListeningConnector?Operation=GetSchema&xsd=KAB_IB_TST_MSG.Version_1

Result: Should be able to view the XSD.

-----------------------------------------------------------------
Deadlock Exception
Msg: Exception message: ORA-00060: deadlock detected while waiting for resource
Solution:
Resubmit all the failed messages and clear the integration broker. The failed messages should be resubmitted one at a time to resolve the deadlock issue.

No comments: